12.21 Assets (GET)

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

Table 12-19 Assets

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> StringName </KeyName>
        <KeyValue> StringValue </KeyValue>
    </CustomUserDefinedStringData>
    <CustomUserDefinedNumberData>
        <KeyName> NumberName </KeyName>
        <KeyValue> NumberValue </KeyValue>
    </CustomUserDefinedNumberData>
    <CustomUserDefinedDateData>
        <KeyName> DateName </KeyName>
        <KeyValue> DateValue</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 assets web service

Wrapper Engine package:-
xstprc_ew_100_01.xstprc_ew_100_01 (iv_req_rec_t IN xst_req_rec_t, iv_res_rec_t IN OUT xst_resp_rec_t);
Main Engine package:-
xstprc_em_100_01. get_asset_types (iv_req_rec_t IN xst_req_rec_t, iv_res_rec_t IN OUT xst_resp_rec_t);

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

BEFORE:-
xstprc_ex_100_01.cv_get_asset_types_bfr = cmncon_cl_000_01.CUSTOMIZED THEN
    xstprc_ex_100_01.get_asset_types_bfr (iv_req_rec_t, iv_res_rec_t);
REPLACE:-
xstprc_ex_100_01.cv_get_asset_types_rep = cmncon_cl_000_01.CUSTOMIZED THEN
    xstprc_ex_100_01.get_asset_types_rep (iv_req_rec_t, iv_res_rec_t);
AFTER:-
xstprc_ex_100_01.cv_get_asset_types_afr = cmncon_cl_000_01.CUSTOMIZED THEN
    xstprc_ex_100_01.get_asset_types_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 );