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)
Sample XML
<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>
Below are the package details for Account on Boarding
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

Application details 
acxapp_en_100_01.chk_app(iv_app_rec.app_rec,ov_res_rec);
Applicant details 
acxapl_en_100_01.chk_apl(iv_app_rec.app_apl(j),ov_res_rec);
Application Address details 
acxapl_en_100_01.chk_apa(iv_app_rec.app_apl(j).apl_apa(k), ov_res_rec);
Applicant Employment details 
acxapl_en_100_01.chk_ape(iv_app_rec.app_apl(j).apl_ape(k), ov_res_rec);
Applicant Telecoms details 
acxapl_en_100_01.chk_apt(iv_app_rec.app_apl(j).apl_apt(k), ov_res_rec);
Applicant Field investigation 
acxafi_en_100_01.chk_afi(iv_app_rec.app_apl(j).apl_afi(k),ov_res_rec);
Business Applicant details 
acxbsd_en_100_01.chk_bsd(iv_app_rec.app_bsd,ov_res_rec);
Business Applicant Affiliates 
acxbsd_en_100_01.chk_bsl(iv_app_rec.app_bsd.bsd_bsl(i), ov_res_rec);
Business Applicant Partners 
acxbsd_en_100_01.chk_bsp(iv_app_rec.app_bsd.bsd_bsp(i), ov_res_rec);
Business Applicant Address 
acxbsd_en_100_01.chk_bsa(iv_app_rec.app_bsd.bsd_bsa(i), ov_res_rec);
Business Applicant Telecoms 
acxbsd_en_100_01.chk_bst(iv_app_rec.app_bsd.bsd_bst(i), ov_res_rec);
Assets 
acxase_en_100_01.chk_ase(iv_app_rec.app_ase(i),ov_res_rec,lv_axn_rec);
Asset Valuation 
acxase_en_100_01.chk_avl(iv_app_rec.app_ase(i).ase_avl(j),ov_res_rec);
Asset Attributes 
acxase_en_100_01.chk_atr(iv_app_rec.app_ase(i).ase_avl(j).atr(k),ov_res_rec);
Asset Tracking 
acxase_en_100_01.chk_atk(iv_app_rec.app_ase(i).ase_atk(j),ov_res_rec);
Seller details 
acxsdi_en_100_01.chk_sdi(iv_app_rec.app_sdi(i),ov_res_rec);
Seller details Address 
acxsdi_en_100_01.chk_sda(iv_app_rec.app_sdi(i).sda(j),ov_res_rec);
Contract details 
acxsdi_en_100_01.chk_sda(iv_app_rec.app_sdi(i).sda(j),ov_res_rec);
Repayment Change Schedule 
acxcon_en_100_01.chk_acs(iv_app_rec.app_con.con_rpmt.app_acs(i),ov_res_rec);
Trade In 
acxcon_en_100_01.chk_apd(iv_app_rec.app_con.con_apd(i), ov_res_rec)
Subvention 
acxcon_en_100_01.chk_asn(iv_app_rec.app_con.con_asn(i), ov_res_rec)
ACH 
acxcon_en_100_01.chk_aac(iv_app_rec.app_con.con_aac(i), ov_res_rec);
PDC 
acxcon_en_100_01.chk_pdc(iv_app_rec.app_con.con_pdc(i), ov_res_rec);
References 
acxcon_en_100_01.chk_aar(iv_app_rec.app_con.con_aar(i), ov_res_rec);
Insurances 
acxcon_en_100_01.chk_ins(iv_app_rec.app_con.con_ins(i), ov_res_rec);
Repayment Options 
acxcon_en_100_01.chk_aro(iv_app_rec.app_con.con_rpmt.app_aro, ov_res_rec);
Recourse 
acxcon_en_100_01.chk_recourse(iv_app_rec.app_con.con_rec,ov_res_rec);
Deriving the product data 
acxsel_el_100_01.select_product( iv_app_rec.app_rec.app_prd_product,lv_prd_rec);
Deriving the contract data 
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);
Insertion in to the iTables 
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);
Edits Validation 
aceval_ew_100_01.aceval_ew_100_01(lv_app_rec ,lv_edi_rec);
Account Creation 
acraai_ew_100_01.acraai_ew_100_01(lv_con_rec);
Any error occurs in the process 
acxprc_el_100_01.insert_error(ov_res_rec , lv_axn_rec);
You can do the customization on the following packages
acxprc_em_100_01
BEFORE:
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);
REPLACE:
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);
AFTER:
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:-

Main procedure that calls other procedures to insert the payload data:-
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);
Procedure to insert the application details:-
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);
Procedure to insert the applicant details:-
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);
Procedure to insert the applicant telecoms details:-
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);
Procedure to insert the applicant address details:-
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);
Procedure to insert the applicant employment details:-
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);
Procedure to insert the applicant tracking details:-
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);
Procedure to insert the business details details:-
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);
Procedure to insert the business affiliates details:-
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);
Procedure to insert the business partners details:-
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);
Procedure to insert the business address details:-
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);
Procedure to insert the business telecoms details:-
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);
Procedure to insert the application assets details:-
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);
Procedure to insert the application asset valuations details:-
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);
Procedure to insert the application asset attributes details:-
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);
Procedure to insert the application asset tracking details:-
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);
Procedure to insert the application asset tracking attribute details:-
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);
Procedure to insert the application seller details:-
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);
Procedure to insert the application seller address details:-
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);
Procedure to insert the application repayment schedule details:-
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);
Procedure to insert the application payment change schedule details:-
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);
Procedure to insert the application contract details:-
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);
Procedure to insert the application contract insurance details:-
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);
Procedure to insert the application insurance details:-
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);
Procedure to insert the application tradein details:-
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);
Procedure to insert the application subvention details:-
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);
Procedure to insert the application subvention_details details:-
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);
Procedure to insert the application ach details:-
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);
Procedure to insert the application post dated check details:-
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);
Procedure to insert the application references details:-
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);
Procedure to insert the application contract fees details:-
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);
Procedure to insert the application comment details:-
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);
Procedure to update the application details:-
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);
Procedure to insert the application tracking attribute details:-
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);
Procedure to insert the applicant field investigation details:-
insert_afd(iv_afd_rec IN OUT NOCOPY acx_afd_rec_t);
Procedure to insert the applicant field investigation_details details:-
insert_afd(iv_afd_rec IN OUT NOCOPY acx_afd_rec_t);

acxsel_en_111_01 (LOAN)

BEFORE
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);
REPLACE
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);
AFTER
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)

BEFORE
acraai_ex_111_01.CV_CREATE_ACCOUNT_BFR = cmncon_cl_000_01.CUSTOMIZED THEN
    acraai_ex_111_01.create_account_bfr (iv_con_rec);
REPLACE
acraai_ex_111_01.CV_CREATE_ACCOUNT_REP = cmncon_cl_000_01.CUSTOMIZED THEN
    acraai_ex_111_01.create_account_rep (iv_con_rec);
AFTER
acraai_ex_111_01.CV_CREATE_ACCOUNT_AFR = cmncon_cl_000_01.CUSTOMIZED THEN
    acraai_ex_111_01.create_account_afr (iv_con_rec);
BEFORE
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);
REPLACE
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);
AFTER
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

BEFORE
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);
REPLACE
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);
AFTER
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);
BEFORE
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);
REPLACE
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);
AFTER
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)
);
/