1. Extensibility Guide
  2. RESTful Web Services Extensibility
  3. Application Decision Fetch Service (GET/PUT)

12.49 Application Decision Fetch Service (GET/PUT)

Below mentioned are the custom fields. These fields will be part of both request/response.

Table 12-42 Application Decision Fetch Service

Element name Sub element Data type
StringData KeyName String
  KeyValue String
NumberData KeyName String
  KeyValue Number (Decimal)
DateData KeyName String
  KeyValue Date (YYYY-MM-DDTHH:MM:SS)
Sample XML
<Custom>
    <StringData>
        <KeyName>OrgName</KeyName>
        <KeyValue>Oracle</KeyValue>
    </StringData>
    <NumberData>
        <KeyName>BusinessPhoneNumber</KeyName>
        <KeyValue>1234.01</KeyValue>
    </NumberData>
    <DateData>
        <KeyName>CreationDate</KeyName>
        <KeyValue>2017-12-18T00:00:00</KeyValue>
    </DateData>
</Custom>
Sample JSON
"Custom": {
    "StringData": [
    {
     "KeyName": "OrgName",
     "KeyValue": "Oracle"
    }
 ],
    "NumberData": [
    {
     "KeyName": "BusinessPhoneNumber",
     "KeyValue": 1234.01
    }
 ],
    "DateData": [
    {
     "KeyName": "CreationDate",
     "KeyValue": "2017-12-18T00:00:00"
    }
 ]
}
}

Table 12-43 Package Details

Service name Wrapper Package Main Package Exit Point Packages
Before Replace After
Application Decision Service (GET) 
XAEADC_EW_100_01.XAEADC_EW_100_01 (iv_auto_dec_rec_t IN OUT xae_auto_dec_rec_t)
 
XAEADC_EM_100_01. XAEADC_EM_100_01
 
XAEADC_EX_100_01
 
XAEADC_EX_100_01_BFR
 
XAEADC_EX_100_01_REP
 
XAEADC_EX_100_01_AFR
    
XAEADC_EW_100_01.CREATE_ADC_DECISION
 
CREATE_ADC_DECISION_BFR
 
CREATE_ADC_DECISION_REP
 
CREATE_ADC_DECISION_AFR
    
XAEADC_EW_100_01. CREATE_OFFER
 
XAEADC_EW_100_01. CREATE_OFFER_BFR
 
XAEADC_EW_100_01. CREATE_OFFER_REP
 
XAEADC_EW_100_01. CREATE_OFFER_AFR
    
XAEADC_EW_100_01. SELECT_PRICING
 
XAEADC_EW_100_01. SELECT_PRICING_BFR
 
XAEADC_EW_100_01. SELECT_PRICING_REP
 
XAEADC_EW_100_01. SELECT_PRICING_AFR
    
XAEADC_EW_100_01. CREATE_MULTIPLE_OFFERS
 
XAEADC_EW_100_01. CREATE_MULTIPLE_OFFERS_BFR
 
XAEADC_EW_100_01. CREATE_MULTIPLE_OFFERS_REP
 
XAEADC_EW_100_01. CREATE_MULTIPLE_OFFERS_AFR
Application Decision Service (PUT) 
XAEADC_EW_100_01.XAEADC_EW_100_01 (iv_auto_dec_rec_t IN OUT xae_auto_dec_rec_t)
 
XAEADC_EW_100_01. UPDATE_ADC_DECISION
 
XAEADC_EX_100_01
 
UPDATE_ADC_DECISION_BFR
 
UPDATE_ADC_DECISION_REP
 
UPDATE_ADC_DECISION_AFR
    
XAEADC_EW_100_01. POPULATE_OFF_RESPONSE
 
POPULATE_OFF_RESPONSE_BFR
 
POPULATE_OFF_RESPONSE_REP
 
POPULATE_OFF_RESPONSE_AFR
    
XAEADC_EW_100_01.POPULATE_ADC_RESPONSE
 
XAEADC_EW_100_01.POPULATE_ADC_RESPONSE_BFR
 
XAEADC_EW_100_01.POPULATE_ADC_RESPONSE_REP
 
XAEADC_EW_100_01.POPULATE_ADC_RESPONSE_AFR
The following types are have been created as a part of development for the service.
CREATE OR REPLACE TYPE xae_adc_off_rec_t FORCE AS OBJECT
    (
    ade_prp_pricing     VARCHAR2(30)
    ,ade_term     NUMBER
    ,ade_rate     NUMBER
    ,ade_pmt_amt     NUMBER
    ,ade_index_type_cd     VARCHAR2(30)
    ,ade_index_rate     NUMBER
    ,ade_mrate     NUMBER
    ,ade_maturity_index_type_cd VARCHAR2(30)
    ,ade_maturity_mrate     NUMBER
    ,ade_accepted_ind     VARCHAR2(30)
    ,ade_adc_current_ind     VARCHAR2(30)
    ,str_attr     xws_att_str_tab_t
    ,num_attr     xws_att_num_tab_t
    ,date_attr     xws_att_date_tab_t
    );
    /
CREATE OR REPLACE TYPE xae_adc_prc_rec_t FORCE AS OBJECT
    (
    adc_prp_pricing     VARCHAR2(30)
    ,adc_current_ind     VARCHAR2(30)
    ,adc_app_status_cd     VARCHAR2(30)
    ,adc_app_sub_status_cd  VARCHAR2(30)
    ,adc_decision_dt     DATE
    ,adc_underwriter_usr_code VARCHAR2(30)
    ,adc_term     NUMBER
    ,adc_pmt_amt     NUMBER
    ,adc_index_type_cd  VARCHAR2(30)
    ,adc_index_rate     NUMBER
    ,adc_mrate     NUMBER
    ,adc_rate_buy_pricing  NUMBER
    ,adc_rate_buy NUMBER
    ,adc_down_pmt_per     NUMBER
    ,adc_down_pmt_amt     NUMBER
    ,adc_adv_per     NUMBER
    ,adc_adv_amt     NUMBER
    ,adc_loan_per     NUMBER
    ,adc_loan_amt     NUMBER
    ,adc_maturity_index_type_cd VARCHAR2(30)
    ,adc_maturity_mrate     NUMBER
    ,adc_balloon_amt     NUMBER
    ,adc_apr     NUMBER
    ,adc_first_crb_source_cd VARCHAR2(30)
    ,adc_second_crb_source_cd VARCHAR2(30)
    ,adc_third_crb_source_cd VARCHAR2(30)
    ,adc_cr_grade_cd     VARCHAR2(30)
    ,adc_cr_score     NUMBER
    ,adc_avl_total_val  NUMBER
    ,adc_ltv1     NUMBER
    ,adc_ltv2     NUMBER
    ,adc_comment     VARCHAR2(4000)
    ,adc_cap_cost     NUMBER
    ,adc_residual_per  NUMBER
    ,adc_cap_cost_adj  NUMBER
    ,adc_cr_lmt     NUMBER
    ,adc_prm_code     VARCHAR2(30)
    ,adc_draw_term     NUMBER
    ,adc_repmt_term     NUMBER
    ,app_offers     xae_adc_off_tab_t
    ,str_attr     xws_att_str_tab_t
    ,num_attr     xws_att_num_tab_t
    ,date_attr     xws_att_date_tab_t
    );
    /

Parent topic: RESTful Web Services Extensibility