Asset Valuation (GET/PUT/POST)

12.23 Asset Valuation (GET/PUT/POST)

Below mentioned are the custom fields. These fields will be part of response for GET/PUT/POST services.

Table 12-21 Asset Valuation

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> StringName </KeyName>
        <KeyValue> StringValue </KeyValue>
    </ StringData>
    <NumberData>
        <KeyName> NumberName </KeyName>
        <KeyValue> NumberValue </KeyValue>
    </NumberData>
    <DateData>
        <KeyName> DateName </KeyName>
        <KeyValue> DateValue</KeyValue>
    </DateData>
</Custom>

Sample JSON

"Custom": {
    "StringData": [
        {
         "KeyName": " StringName ",
         "KeyValue": " StringValue "
        }
    ],
    "NumberData": [
        {
         "KeyName": " NumberName ",
         "KeyValue": NumberValue
        }
    ],
    "DateData": [
        {
         "KeyName": " DateName ",
         "KeyValue": " DateValue"
        }
    ]
}

Below are the package details for assets valuation web service

Wrapper Engine package:-

xcsase_ew_100_01.xcsase_ew_100_01(iv_xcs_ase_rec IN OUT xcs_ase_req_tab_t)

Main Engine package:-

xcsase_em_100_01.xcsase_em_100_01(iv_xcs_ase_rec IN OUT xcs_ase_req_tab_t)

Main Engine package calls below procedures as per service type:

GET: get_ase_avl(iv_xcs_ase_rec);
PUT: put_ase_avl(iv_xcs_ase_rec);
POST: post_ase_avl(iv_xcs_ase_rec);

Below are the Exit point package details for xcsase_em_100_01.xcsase_em_100_01:

BEFORE:-

xcsase_ex_100_01.CV_xcsase_ex_100_01_BFR= cmncon_cl_000_01.CUSTOMIZED THEN
xcsase_ex_100_01.xcsase_ex_100_01_bfr (iv_xcs_ase_rec IN OUT xcs_ase_req_rec_t);

REPLACE:-

xcsase_ex_100_01.CV_xcsase_ex_100_01_REP= cmncon_cl_000_01.CUSTOMIZED THEN
xcsase_ex_100_01.xcsase_ex_100_01_rep (iv_xcs_ase_rec IN OUT xcs_ase_req_rec_t);

AFTER:-

xcsase_ex_100_01.CV_xcsase_ex_100_01_AFR= cmncon_cl_000_01.CUSTOMIZED THEN
xcsase_ex_100_01.xcsase_ex_100_01_afr (iv_xcs_ase_rec IN OUT xcs_ase_req_rec_t);

Below are the Exit point package details for GET:

BEFORE:-

xcsase_ex_100_01.CV_get_ase_avl_BFR= cmncon_cl_000_01.CUSTOMIZED THEN
xcsase_ex_100_01.get_ase_avl_bfr (iv_xcs_ase_rec IN OUT xcs_ase_req_tab_t)

REPLACE:-

xcsase_ex_100_01.CV_get_ase_avl_REP= cmncon_cl_000_01.CUSTOMIZED THEN
xcsase_ex_100_01.get_ase_avl_rep (iv_xcs_ase_rec IN OUT xcs_ase_req_tab_t)

AFTER:-

xcsase_ex_100_01.CV_get_ase_avl_AFR= cmncon_cl_000_01.CUSTOMIZED THEN
xcsase_ex_100_01.get_ase_avl_afr (iv_xcs_ase_rec IN OUT xcs_ase_req_tab_t)

Below are the Exit point package details for PUT:

BEFORE:-

xcsase_ex_100_01.CV_put_ase_avl_BFR= cmncon_cl_000_01.CUSTOMIZED THEN
xcsase_ex_100_01.put_ase_avl_bfr (iv_xcs_ase_rec IN OUT xcs_ase_req_tab_t)

REPLACE:-

xcsase_ex_100_01.CV_put_ase_avl_REP= cmncon_cl_000_01.CUSTOMIZED THEN
xcsase_ex_100_01.put_ase_avl_rep (iv_xcs_ase_rec IN OUT xcs_ase_req_tab_t)

AFTER:-

xcsase_ex_100_01.CV_put_ase_avl_AFR= cmncon_cl_000_01.CUSTOMIZED THEN
xcsase_ex_100_01.put_ase_avl_afr (iv_xcs_ase_rec IN OUT xcs_ase_req_tab_t)

Below are the Exit point package details for POST:

BEFORE:-

xcsase_ex_100_01.CV_post_ase_avl_BFR= cmncon_cl_000_01.CUSTOMIZED THEN
xcsase_ex_100_01.post_ase_avl_bfr (iv_xcs_ase_rec IN OUT xcs_ase_req_tab_t)

REPLACE:-

xcsase_ex_100_01.CV_post_ase_avl_REP= cmncon_cl_000_01.CUSTOMIZED THEN
xcsase_ex_100_01.post_ase_avl_rep (iv_xcs_ase_rec IN OUT xcs_ase_req_tab_t)

AFTER:-

xcsase_ex_100_01.CV_post_ase_avl_AFR= cmncon_cl_000_01.CUSTOMIZED THEN
xcsase_ex_100_01.post_ase_avl_afr (iv_xcs_ase_rec IN OUT xcs_ase_req_tab_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