Application Search (GET)

12.7 Application Search (GET)

Below mentioned table has element name which indicates In response which type of custom data is passed by enclosing the name and its value in KeyName and KeyValue respectively.

Table 12-8 Application Search

Element name	Sub element	Data type
CustomUserDefinedStringData	KeyName	String
	KeyValue	String
CustomUserDefinedNumberData	KeyName	String
	KeyValue	Number (Double)
CustomUserDefinedDateData	KeyName	String
	KeyValue	Date (YYYY-MM-DDTHH:MM:SS)

Sample Response XML

<Custom>
    <CustomUserDefinedStringData>
        <KeyName>Middle Name</KeyName>
        <KeyValue>Oracle</KeyValue>
    </CustomUserDefinedStringData>
    <CustomUserDefinedNumberData>
        <KeyName>Age</KeyName>
        <KeyValue>27</KeyValue>
    </CustomUserDefinedNumberData>
    <CustomUserDefinedDateData>
        <KeyName>FirstPmtDate</KeyName>
        <KeyValue>2016-07-14</KeyValue>
    </CustomUserDefinedDateData>
</Custom>

Sample Response JSON

{
    "Custom": {
        "CustomUserDefinedStringData": {
            "KeyName": "Middle Name",
            "KeyValue": "Oracle"
        },
        "CustomUserDefinedNumberData": {
            "KeyName": "Age",
            "KeyValue": "27"
        },
        "CustomUserDefinedDateData": {
            "KeyName": "FirstPmtDate",
            "KeyValue": "2016-07-14"
        }
    }
}

Below are the package details for ApplicationSearch web service

xaeque_ew_100_01 (iv_que_rec     IN     xae_que_rec_t,iv_response_tab OUT NOCOPY xae_que_resp_tab_t)
xaeque_em_100_01.get_application_summary (iv_que_rec IN     xae_que_rec_t,iv_response_tab  OUT NOCOPY xae_que_resp_tab_t)
xaeque_en_100_01.get_apl_search_summary(iv_que_rec IN     xae_que_rec_t,iv_response_tab OUT NOCOPY xae_que_resp_tab_t)

You can do the customization on xaeque_en_100_01.get_apl_search_summary();

BEFORE:-

IF xaeque_ex_100_01.cv_get_apl_search_summary_bfr = cmncon_cl_000_01.CUSTOMIZED THEN
    xaeque_ex_100_01.get_apl_search_summary_bfr (iv_que_rec, iv_response_tab);
END IF;

REPLACE:-

IF xaeque_ex_100_01.cv_get_apl_search_summary_rep = cmncon_cl_000_01.CUSTOMIZED THEN
    xaeque_ex_100_01.get_apl_search_summary_rep (iv_que_rec, iv_response_tab);
ELSE

AFTER:-

IF xaeque_ex_100_01.cv_get_apl_search_summary_afr = cmncon_cl_000_01.CUSTOMIZED THEN
    xaeque_ex_100_01.get_apl_search_summary_afr (iv_que_rec, iv_response_tab);
END IF;

You can also do the customization on xaeque_em_100_01.get_application_summary();

BEFORE:-

IF xaeque_ex_100_01.cv_get_application_summary_bfr = cmncon_cl_000_01.CUSTOMIZED THEN
    xaeque_ex_100_01.get_application_summary_bfr (iv_que_rec, iv_response_tab);
END IF;

REPLACE:-

IF xaeque_ex_100_01.cv_get_application_summary_rep = cmncon_cl_000_01.CUSTOMIZED THEN
    xaeque_ex_100_01.get_application_summary_rep (iv_que_rec, iv_response_tab);
ELSE

AFTER:-

IF xaeque_ex_100_01.cv_get_application_summary_afr = cmncon_cl_000_01.CUSTOMIZED THEN
    xaeque_ex_100_01.get_application_summary_afr (iv_que_rec, iv_response_tab);
END IF;

Extensible parameters are rec type objects

xws_att_str_rec_t AS OBJECT (
    ATT_NAME         VARCHAR2(30)
    , ATT_VALUE      VARCHAR2(4000));
xws_att_num_rec_t AS OBJECT (
    ATT_NAME         VARCHAR2(30)
    , ATT_VALUE      NUMBER);
xws_att_date_rec_t AS OBJECT (
    ATT_NAME         VARCHAR2(30)
    , ATT_VALUE      DATE);

Parent topic: RESTful Web Services Extensibility