75: l_dist_info_rec Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE;
76: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
77: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
78:
79: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
80: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
81: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
82: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
83: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
76: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
77: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
78:
79: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
80: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
81: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
82: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
83: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
84: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
77: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
78:
79: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
80: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
81: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
82: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
83: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
84: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
85: l_tcn_id NUMBER;
78:
79: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
80: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
81: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
82: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
83: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
84: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
85: l_tcn_id NUMBER;
86: l_trx_header_tbl Varchar2(50);
79: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
80: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
81: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
82: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
83: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
84: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
85: l_tcn_id NUMBER;
86: l_trx_header_tbl Varchar2(50);
87:
80: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
81: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
82: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
83: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
84: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
85: l_tcn_id NUMBER;
86: l_trx_header_tbl Varchar2(50);
87:
88: BEGIN
138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
139: END IF;
140:
141: --debug_proc('Vipp 333...p_bpd_acc_rec.id '||p_bpd_acc_rec.id );
142: --- populate the tables for passing to Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST
143:
144: l_acc_gen_tbl(l_tld_loop_cnt).acc_gen_key_tbl := l_acc_gen_primary_key_tbl;
145: l_acc_gen_tbl(l_tld_loop_cnt).source_id := l_dist_info_rec.source_id;
146:
165: l_trx_header_tbl:= 'OKL_TRX_AR_INVOICES_B';
166: l_trx_header_id := p_tai_id;
167: --Call accounting with new signature
168:
169: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
170: p_api_version => p_api_version,
171: p_init_msg_list => p_init_msg_list,
172: x_return_status => x_return_status,
173: x_msg_count => x_msg_count,
1756: l_dist_info_rec Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE;
1757: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
1758: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
1759:
1760: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
1761: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
1762: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
1763: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1764: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
1757: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
1758: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
1759:
1760: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
1761: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
1762: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
1763: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1764: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
1765: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
1758: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
1759:
1760: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
1761: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
1762: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
1763: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1764: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
1765: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
1766: l_trx_header_id NUMBER;
1759:
1760: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
1761: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
1762: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
1763: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1764: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
1765: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
1766: l_trx_header_id NUMBER;
1767: l_trx_header_tbl VARCHAR2(50);
1760: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
1761: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
1762: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
1763: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1764: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
1765: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
1766: l_trx_header_id NUMBER;
1767: l_trx_header_tbl VARCHAR2(50);
1768: ---- End Added by Vpanwar --- Code for new accounting API uptake
1761: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
1762: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
1763: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1764: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
1765: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
1766: l_trx_header_id NUMBER;
1767: l_trx_header_tbl VARCHAR2(50);
1768: ---- End Added by Vpanwar --- Code for new accounting API uptake
1769:
2132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2133: END IF;
2134:
2135:
2136: --- populate the tables for passing to Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST
2137:
2138: l_acc_gen_tbl(l_tld_loop_cnt).acc_gen_key_tbl := l_acc_gen_primary_key_tbl;
2139: l_acc_gen_tbl(l_tld_loop_cnt).source_id := l_dist_info_rec.source_id;
2140:
2158: ---- Added by Vpanwar --- Code for new accounting API uptake
2159: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';
2160: l_trx_header_id := lx_taiv_rec.id;
2161: --Call accounting with new signature
2162: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
2163: p_api_version => p_api_version,
2164: p_init_msg_list => p_init_msg_list,
2165: x_return_status => x_return_status,
2166: x_msg_count => x_msg_count,
2302: l_dist_info_rec Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE;
2303: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
2304: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
2305:
2306: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
2307: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
2308: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
2309: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
2310: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
2303: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
2304: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
2305:
2306: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
2307: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
2308: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
2309: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
2310: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
2311: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
2304: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY;
2305:
2306: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
2307: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
2308: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
2309: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
2310: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
2311: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
2312: l_trx_header_id NUMBER;
2305:
2306: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
2307: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
2308: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
2309: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
2310: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
2311: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
2312: l_trx_header_id NUMBER;
2313: l_trx_header_tbl VARCHAR2(50);
2306: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;
2307: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
2308: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
2309: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
2310: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
2311: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
2312: l_trx_header_id NUMBER;
2313: l_trx_header_tbl VARCHAR2(50);
2314: ---- End Added by Vpanwar --- Code for new accounting API uptake
2307: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_TBL_TYPE;
2308: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
2309: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
2310: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
2311: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
2312: l_trx_header_id NUMBER;
2313: l_trx_header_tbl VARCHAR2(50);
2314: ---- End Added by Vpanwar --- Code for new accounting API uptake
2315: begin
2667: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2668: END IF;
2669:
2670:
2671: --- populate the tables for passing to Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST
2672:
2673: l_acc_gen_tbl(l_tld_loop_cnt).acc_gen_key_tbl := l_acc_gen_primary_key_tbl;
2674: l_acc_gen_tbl(l_tld_loop_cnt).source_id := l_dist_info_rec.source_id;
2675:
2694: ---- Added by Vpanwar --- Code for new accounting API uptake
2695: l_trx_header_tbl:= 'okl_trx_ar_invoices_b';
2696: l_trx_header_id := lx_taiv_rec.id;
2697: --Call accounting with new signature
2698: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
2699: p_api_version => p_api_version,
2700: p_init_msg_list => p_init_msg_list,
2701: x_return_status => x_return_status,
2702: x_msg_count => x_msg_count,