Application Comment (GET/POST)

12.14 Application Comment (GET/POST)

Below mentioned are the custom fields. These fields will be part of response in case of GET method and will be part of request in case of POST method.

Table 12-14 Application Comment

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

Sample 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 JSON

{
    "Custom": {
        "CustomUserDefinedStringData": {
            "KeyName": "StringName",
            "KeyValue": "StringValue"
        },
        "CustomUserDefinedNumberData": {
            "KeyName": "NumberName",
            "KeyValue": "NumberValue"
        },
        "CustomUserDefinedDateData": {
            "KeyName": "DateName",
            "KeyValue": "DateValue"
        }
    }
}

Below are the package details for application comment web service

Wrapper Engine package: -

xaexcm_ew_100_01. xaexcm_ew_100_01 (iv_req_rec_t IN xae_acm_req_t, iv_res_rec_t IN OUT xae_acm_res_rec_t);

Main Engine package:-

xaexcm_em_100_01. xaexcm_em_100_01 (iv_req_rec_t IN xae_acm_req_t,iv_res_rec_t IN OUT xae_acm_res_rec_t);

Below are the Exit point package details for xaexcm_em_100_01.xaexcm_em_100_01();

BEFORE:-

xaexcm_ex_100_01.cv_xaexcm_bfr = cmncon_cl_000_01.CUSTOMIZED THEN
    xaexcm_ex_100_01.xaexcm_em_100_01_bfr(iv_req_rec_t, iv_res_rec_t);

REPLACE:-

xaexcm_ex_100_01.cv_xaexcm_rep = cmncon_cl_000_01.CUSTOMIZED THEN
    xaexcm_ex_100_01.xaexcm_em_100_01_rep(iv_req_rec_t, iv_res_rec_t);

AFTER:-

xaexcm_ex_100_01.cv_xaexcm_afr = cmncon_cl_000_01.CUSTOMIZED THEN
    xaexcm_ex_100_01.xaexcm_em_100_01_afr(iv_req_rec_t, iv_res_rec_t);

Extensible parameters are Tab Type object

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

Parent topic: RESTful Web Services Extensibility