12.24 Asset Sub Types (GET)

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

Table 12-22 Asset Sub Types

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 asset sub types web service

Wrapper Engine package:-
xsbprc_ew_100_01.xsbprc_ew_100_01 (iv_req_rec_t IN xsb_req_rec_t, iv_res_rec_t IN OUT xsb_resp_rec_t);
Main Engine package:-
xstprc_em_100_01. get_asset_sub_types (iv_req_rec_t IN xsb_req_rec_t, iv_res_rec_t IN OUT xsb_resp_rec_t);

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

BEFORE:-
xsbprc_ex_100_01.cv_get_asset_sub_types_bfr = cmncon_cl_000_01.CUSTOMIZED THEN
    xsbprc_ex_100_01.get_asset_sub_types_bfr (iv_req_rec_t, iv_res_rec_t);
REPLACE:-
xsbprc_ex_100_01.cv_get_asset_sub_types_rep = cmncon_cl_000_01.CUSTOMIZED THEN
    xsbprc_ex_100_01.get_asset_sub_types_rep (iv_req_rec_t, iv_res_rec_t);
AFTER:-
xsbprc_ex_100_01.cv_get_asset_sub_types_afr = cmncon_cl_000_01.CUSTOMIZED THEN
    xsbprc_ex_100_01.get_asset_sub_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    ARCHAR2(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 );