DBA Data[Home] [Help]

APPS.OKL_INTERNAL_BILLING_PVT dependencies on OKL_ACCOUNT_DIST_PVT

Line 79: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;

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;

Line 80: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_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;

Line 81: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_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;

Line 82: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;

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);

Line 83: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;

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:

Line 84: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_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:
88: BEGIN

Line 142: --- populate the tables for passing to Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST

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:

Line 169: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(

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,

Line 1760: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;

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;

Line 1761: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_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;

Line 1762: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_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;

Line 1763: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;

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);

Line 1764: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;

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

Line 1765: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_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
1769:

Line 2136: --- populate the tables for passing to Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST

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:

Line 2162: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(

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,

Line 2306: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.TMPL_IDENTIFY_TBL_TYPE;

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;

Line 2307: l_dist_info_tbl Okl_Account_Dist_Pvt.DIST_INFO_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;

Line 2308: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_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;

Line 2309: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;

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);

Line 2310: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;

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

Line 2311: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_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
2315: begin

Line 2671: --- populate the tables for passing to Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST

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:

Line 2698: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(

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,