12.2 Account On Boarding (POST)
Below mentioned table has element name which indicates which type of custom data is passed in that enclosing the name and its value in key name and key value respectively.
Table 12-3 Account On Boarding
Element name | Sub Element | Data Type |
---|---|---|
StringData | KeyName | String |
KeyValue | String | |
NumberData | KeyName | String |
KeyValue | Number (Double) | |
DateData | KeyName | String |
KeyValue | Date(YYYY-MM-DDTHH:MM:SS) |
<Custom>
<StringData>
<KeyName>Middle Name</KeyName>
<KeyValue>Singh</KeyValue>
</StringData>
<NumberData>
<KeyName>Age</KeyName>
<KeyValue>25</KeyValue>
</NumberData>
<DateData>
<KeyName>FiestPmtDate</KeyName>
<KeyValue>2016-07-14T11:53:40</KeyValue>
</DateData>
</Custom>
acxprc_ew_100_01.acxprc_ew_100_01 (iv_app_rec IN OUT NOCOPY acx_acc_rec_t, ov_res_rec IN OUT NOCOPY acx_res_rec_t);
acxprc_em_100_01.process_account (iv_app_rec IN OUT NOCOPY acx_acc_rec_t, ov_res_rec IN OUT NOCOPY acx_res_rec_t);
Lookup Validations- involves the following packages related to
acxapp_en_100_01.chk_app(iv_app_rec.app_rec,ov_res_rec);
acxapl_en_100_01.chk_apl(iv_app_rec.app_apl(j),ov_res_rec);
acxapl_en_100_01.chk_apa(iv_app_rec.app_apl(j).apl_apa(k), ov_res_rec);
acxapl_en_100_01.chk_ape(iv_app_rec.app_apl(j).apl_ape(k), ov_res_rec);
acxapl_en_100_01.chk_apt(iv_app_rec.app_apl(j).apl_apt(k), ov_res_rec);
acxafi_en_100_01.chk_afi(iv_app_rec.app_apl(j).apl_afi(k),ov_res_rec);
acxbsd_en_100_01.chk_bsd(iv_app_rec.app_bsd,ov_res_rec);
acxbsd_en_100_01.chk_bsl(iv_app_rec.app_bsd.bsd_bsl(i), ov_res_rec);
acxbsd_en_100_01.chk_bsp(iv_app_rec.app_bsd.bsd_bsp(i), ov_res_rec);
acxbsd_en_100_01.chk_bsa(iv_app_rec.app_bsd.bsd_bsa(i), ov_res_rec);
acxbsd_en_100_01.chk_bst(iv_app_rec.app_bsd.bsd_bst(i), ov_res_rec);
acxase_en_100_01.chk_ase(iv_app_rec.app_ase(i),ov_res_rec,lv_axn_rec);
acxase_en_100_01.chk_avl(iv_app_rec.app_ase(i).ase_avl(j),ov_res_rec);
acxase_en_100_01.chk_atr(iv_app_rec.app_ase(i).ase_avl(j).atr(k),ov_res_rec);
acxase_en_100_01.chk_atk(iv_app_rec.app_ase(i).ase_atk(j),ov_res_rec);
acxsdi_en_100_01.chk_sdi(iv_app_rec.app_sdi(i),ov_res_rec);
acxsdi_en_100_01.chk_sda(iv_app_rec.app_sdi(i).sda(j),ov_res_rec);
acxsdi_en_100_01.chk_sda(iv_app_rec.app_sdi(i).sda(j),ov_res_rec);
acxcon_en_100_01.chk_acs(iv_app_rec.app_con.con_rpmt.app_acs(i),ov_res_rec);
acxcon_en_100_01.chk_apd(iv_app_rec.app_con.con_apd(i), ov_res_rec)
acxcon_en_100_01.chk_asn(iv_app_rec.app_con.con_asn(i), ov_res_rec)
acxcon_en_100_01.chk_aac(iv_app_rec.app_con.con_aac(i), ov_res_rec);
acxcon_en_100_01.chk_pdc(iv_app_rec.app_con.con_pdc(i), ov_res_rec);
acxcon_en_100_01.chk_aar(iv_app_rec.app_con.con_aar(i), ov_res_rec);
acxcon_en_100_01.chk_ins(iv_app_rec.app_con.con_ins(i), ov_res_rec);
acxcon_en_100_01.chk_aro(iv_app_rec.app_con.con_rpmt.app_aro, ov_res_rec);
acxcon_en_100_01.chk_recourse(iv_app_rec.app_con.con_rec,ov_res_rec);
acxsel_el_100_01.select_product( iv_app_rec.app_rec.app_prd_product,lv_prd_rec);
acxsel_en_111_01.sel_con_dtls ( iv_app_rec.app_con, lv_prd_rec);
acxsel_en_112_01.sel_con_dtls ( iv_app_rec.app_con, lv_prd_rec);
acxsel_en_121_01.sel_con_dtls ( iv_app_rec.app_con, lv_prd_rec);
acxins_en_100_01.ins(iv_app_rec, ov_res_rec, lv_axn_rec,iv_app_rec.str_attr , iv_app_rec.num_attr,iv_app_rec.date_attr);
aceval_ew_100_01.aceval_ew_100_01(lv_app_rec ,lv_edi_rec);
acraai_ew_100_01.acraai_ew_100_01(lv_con_rec);
acxprc_el_100_01.insert_error(ov_res_rec , lv_axn_rec);
acxprc_em_100_01
acxprc_em_100_01. CV_PROCESS_ACCOUNT_BFR = cmncon_cl_000_01.CUSTOMIZED THEN
acxprc_ex_100_01.process_account_bfr(iv_app_rec ,ov_res_rec);
acxprc_ex_100_01.CV_PROCESS_ACCOUNT_REP = cmncon_cl_000_01.CUSTOMIZED THEN
acxprc_ex_100_01.process_account_bfr(iv_app_rec ,ov_res_rec);
acxprc_ex_100_01.CV_PROCESS_ACCOUNT_AFR = cmncon_cl_000_01.CUSTOMIZED THEN
acxprc_ex_100_01.process_account_afr(iv_app_rec,ov_res_rec);
acxins_en_100_01
For this package, all the procedures are having the before, replace and after exit points:-
The procedures are:-
ins(iv_app_rec IN OUT NOCOPY acx_acc_rec_t ,ov_res_rec IN OUT NOCOPY acx_res_rec_t ,iv_axn_rec IN acx_axn_evw%ROWTYPE ,iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t ,iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t ,iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_app(iv_app_rec IN OUT NOCOPY acx_app_rec_t,iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_apl(iv_apl_rec IN OUT NOCOPY acx_apl_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_apt(iv_apt_rec IN OUT NOCOPY acx_apt_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_apa(iv_apa_rec IN OUT NOCOPY acx_apa_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_ape(iv_ape_rec IN OUT NOCOPY acx_ape_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_alt(iv_alt_rec IN OUT NOCOPY acx_alt_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_bsd(iv_bsd_rec IN OUT NOCOPY acx_bsd_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_bsl(iv_bsl_rec IN OUT NOCOPY acx_bsl_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_bsp(iv_bsp_rec IN OUT NOCOPY acx_bsp_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_bsa(iv_bsa_rec IN OUT NOCOPY acx_bsa_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_bst(iv_bst_rec IN OUT NOCOPY acx_bst_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_ase(iv_ase_rec IN OUT NOCOPY acx_ase_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_avl(iv_avl_rec IN OUT NOCOPY acx_avl_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_atr(iv_atr_rec IN OUT NOCOPY acx_atr_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_atk(iv_atk_rec IN OUT NOCOPY acx_atk_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_ata(iv_ata_rec IN OUT NOCOPY acx_ata_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_sdi(iv_sdi_rec IN OUT NOCOPY acx_sdi_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, _ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_sda(iv_sda_rec IN OUT NOCOPY acx_sda_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_apc(iv_apc_rec IN OUT NOCOPY acx_apc_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_acs(iv_acs_rec IN OUT NOCOPY acx_acs_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, _ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_acd(iv_acd_rec IN OUT NOCOPY acx_acd_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, _ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_acd_ins(iv_app_rec IN OUT NOCOPY acx_acc_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_ins(iv_ins_rec IN OUT NOCOPY acx_ins_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_apd(iv_apd_rec IN OUT NOCOPY acx_apd_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_asn(iv_asn_rec IN OUT NOCOPY acx_asn_rec_t, ov_res_rec IN OUT NOCOPY acx_res_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_asl(iv_asl_rec IN OUT NOCOPY acx_asl_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_aac(iv_aac_rec IN OUT NOCOPY acx_aac_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_pdc(iv_pdc_rec IN OUT NOCOPY acx_pdc_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_aar(iv_aar_rec IN OUT NOCOPY acx_aar_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_afe(iv_afe_rec IN OUT NOCOPY acx_afe_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_acm(iv_acm_rec IN OUT NOCOPY acx_acm_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
update_con(iv_con_rec IN OUT NOCOPY acx_con_rec_t, iv_aro_rec IN OUT NOCOPY acx_aro_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_aat(iv_aat_rec IN OUT NOCOPY acx_aat_rec_t, iv_ext_rec_str IN OUT NOCOPY xws_att_str_tab_t, iv_ext_rec_num IN OUT NOCOPY xws_att_num_tab_t, iv_ext_rec_dt IN OUT NOCOPY xws_att_date_tab_t);
insert_afd(iv_afd_rec IN OUT NOCOPY acx_afd_rec_t);
insert_afd(iv_afd_rec IN OUT NOCOPY acx_afd_rec_t);
acxsel_en_111_01 (LOAN)
acxsel_ex_111_01.CV_SEL_CON_DTLS_BFR = cmncon_cl_000_01.CUSTOMIZED THEN
acxsel_ex_111_01.sel_con_dtls_bfr (iv_con_rec,iv_prd_rec);
acxsel_ex_111_01.CV_SEL_CON_DTLS_REP = cmncon_cl_000_01.CUSTOMIZED THEN
acxsel_ex_111_01.sel_con_dtls_rep (iv_con_rec,iv_prd_rec);
acxsel_ex_111_01.CV_SEL_CON_DTLS_AFR = cmncon_cl_000_01.CUSTOMIZED THEN
acxsel_ex_111_01.sel_con_dtls_afr (iv_con_rec,iv_prd_rec);
Similarly the exit points have been added for the line and lease products also for selecting contract details in acxsel_en_112_01 and acxsel_en_121_01
Acraai_en_111_01 (LOAN)
acraai_ex_111_01.CV_CREATE_ACCOUNT_BFR = cmncon_cl_000_01.CUSTOMIZED THEN
acraai_ex_111_01.create_account_bfr (iv_con_rec);
acraai_ex_111_01.CV_CREATE_ACCOUNT_REP = cmncon_cl_000_01.CUSTOMIZED THEN
acraai_ex_111_01.create_account_rep (iv_con_rec);
acraai_ex_111_01.CV_CREATE_ACCOUNT_AFR = cmncon_cl_000_01.CUSTOMIZED THEN
acraai_ex_111_01.create_account_afr (iv_con_rec);
acraai_ex_111_01.CV_SET_ACC_NBR_BFR = cmncon_cl_000_01.CUSTOMIZED THEN
acraai_ex_111_01.set_acc_nbr_bfr (iv_con_rec,iv_acc_aad_id,iv_acc_nbr);
acraai_ex_111_01.CV_SET_ACC_NBR_REP = cmncon_cl_000_01.CUSTOMIZED THEN
acraai_ex_111_01.set_acc_nbr_rep (iv_con_rec,iv_acc_aad_id,iv_acc_nbr);
acraai_ex_111_01.CV_SET_ACC_NBR_AFR = cmncon_cl_000_01.CUSTOMIZED THEN
acraai_ex_111_01.set_acc_nbr_afr (iv_con_rec,iv_acc_aad_id,iv_acc_nbr);
acraai_en_111_02
acraai_ex_111_01.CV_LOAD_CURRENT_ACC_BFR = cmncon_cl_000_01.CUSTOMIZED THEN
acraai_ex_111_01.load_current_acc_bfr (iv_con_rec,iv_acc_aad_id);
acraai_ex_111_01.CV_LOAD_CURRENT_ACC_REP = cmncon_cl_000_01.CUSTOMIZED THEN
acraai_ex_111_01.load_current_acc_rep (iv_con_rec,iv_acc_aad_id);
acraai_ex_111_01.CV_LOAD_CURRENT_ACC_AFR = cmncon_cl_000_01.CUSTOMIZED THEN
acraai_ex_111_01.load_current_acc_afr (iv_con_rec,iv_acc_aad_id);
acraai_ex_111_01.cv_convert_new_acc_bfr = cmncon_cl_000_01.CUSTOMIZED THEN
acraai_ex_111_01.convert_new_acc_bfr (iv_con_rec,iv_acc_aad_id);
acraai_ex_111_01.cv_convert_new_acc_rep = cmncon_cl_000_01.CUSTOMIZED THEN
acraai_ex_111_01.convert_new_acc_rep (iv_con_rec,iv_acc_aad_id);
acraai_ex_111_01.cv_convert_new_acc_afr = cmncon_cl_000_01.CUSTOMIZED THEN
acraai_ex_111_01.convert_new_acc_afr (iv_con_rec,iv_acc_aad_id);
Similarly the exit points have been added for the line and lease products also for inserting the account details in acraai_en_112_01,acraai_en_112_02 and acxsel_en_121_01,acraai_en_121_02.
Extensible parameters are Tab Type object
CREATE OR REPLACE TYPE xws_att_date_rec_t AS OBJECT
(
ext_key_name VARCHAR2(30),
ext_key_value DATE
);
/
CREATE OR REPLACE TYPE xws_att_num_rec_t AS OBJECT
(
ext_key_name VARCHAR2(30),
ext_key_value NUMBER
);
/
CREATE OR REPLACE TYPE xws_att_str_rec_t AS OBJECT
(
ext_key_name VARCHAR2(30),
ext_key_value VARCHAR2(4000)
);
/
Parent topic: RESTful Web Services Extensibility