Account Detail (GET)

12.4 Account Detail (GET)

Below mentioned table has element name which indicates which type of custom data is passed in that enclosing the name and its value in name and value respectively.

Table 12-5 Account Detail

Element name	Sub Element	Data Type
CustomerAttributes	Name	String
	Value	String
CustomElements	Name	String
	CustomData
CustomData	UniqueId	Number (Double)
	CustomAttributes
CustomAttributes	Name	String
	Value	String
AccountAttributes	Name	String
	Value	String
AddressAttributes	Name	String
	Value	String
BusinessAttributes	Name	String
	Value	String
TelecomAttributes	Name	String
	Value	String
AffiliateAttributes	Name	String
	Value	String
PartnersAttributes	Name	String
	Value	String
BusinessAddressAttributes	Name	String
	Value	String
TransactionAttributes	Name	String
	Value	String
AllocationsAttributes	Name	String
	Value	String
CollateralAttributes	Name	String
	Value	String
DetailsAttributes	Name	String
	Value	String
StatementAttributes	Name	String
	Value	String
StatementMessagesAttributes	Name	String
	Value	String
AchAttributes	Name	String
	Value	String
CreditCardAttributes	Name	String
	Value	String

Sample XML

<CustomerDetails>
    <CustomerID>1001</CustomerID>
    <FirstName>METRO</FirstName>
    <LastName>FILE</LastName>
    <CustomerAttributes>
        <name>Last Name</name>
        <value>kulkarni</value>
    </CustomerAttributes>
</CustomerDetails>

Below are the package details for Account Details

xcsprc_ew_100_01( iv_usr_code IN VARCHAR2,
            iv_acc_nbr IN accounts.acc_nbr%TYPE,
            iv_action IN VARCHAR2,
            iv_acc IN OUT NOCOPY xcs_acc_rec_t
            )
xcsprc_em_100_01.get_account_information (iv_usr_code IN VARCHAR2,
            iv_acc_nbr IN accounts.acc_nbr%TYPE,
            iv_action IN VARCHAR2,
            iv_acc IN OUT NOCOPY xcs_acc_rec_t
            )
xcsacc_en_100_01.get_account_details(iv_acc_nbr IN accounts.acc_nbr%TYPE,
            iv_action IN VARCHAR2,
            iv_acc IN OUT NOCOPY xcs_acc_rec_t
            )
xcsacc_el_100_01.populate_account_response(iv_acc IN OUT NOCOPY xcs_acc_rec_t)

You can do the customization on xcsacc_en_100_01.get_account_details();

BEFORE:-

IF xcsprc_ex_100_01.cv_get_account_details_bfr = cmncon_cl_000_01.CUSTOMIZED THEN
    xcsprc_ex_100_01.get_account_details_bfr(iv_acc_nbr, iv_action, iv_acc);
END IF;

REPLACE

IF xcsprc_ex_100_01.cv_get_account_details_rep = cmncon_cl_000_01.CUSTOMIZED THEN
    xcsprc_ex_100_01.get_account_details_rep(iv_acc_nbr, iv_action, iv_acc);
ELSE

AFTER

IF xcsprc_ex_100_01.cv_get_account_details_afr = cmncon_cl_000_01.CUSTOMIZED
THEN
    xcsprc_ex_100_01.get_account_details_afr (iv_acc_nbr, iv_action, iv_acc);
END IF;

You can do the customization on xcsprc_em_100_01.get_account_information ();

BEFORE

IF xcsprc_ex_100_01.cv_get_account_information_bfr = cmncon_cl_000_01.CUSTOMIZED THEN
    xcsprc_ex_100_01.get_account_information_bfr (iv_acc_nbr, iv_action, iv_acc);
END IF;

REPLACE

IF xcsprc_ex_100_01.cv_get_account_information_rep = cmncon_cl_000_01.CUSTOMIZED THEN
    xcsprc_ex_100_01.get_account_information_rep (iv_acc_nbr, iv_action, iv_acc);
ELSE

AFTER

IF xcsprc_ex_100_01.cv_get_account_information_afr = cmncon_cl_000_01.CUSTOMIZED THEN
    xcsprc_ex_100_01.get_account_information_afr (iv_acc_nbr, iv_action, iv_acc);
END IF;

Extensible parameters are tab type object

xws_custom_rec_t AS OBJECT(
    TAB_NAME      VARCHAR2(80),
    TAB_DATA      xws_custom_tab2_t);
xws_custom_rec2_t AS OBJECT(
    CUSTOM_ID     NUMBER,
    CUSTOM_DATA   xws_att_str_tab_t);
xws_att_str_rec_t AS OBJECT (
    ATT_NAME      VARCHAR2(30)
    , ATT_VALUE   VARCHAR2(4000));

Parent topic: RESTful Web Services Extensibility