DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_ACCOUNT_DIST_PVT

Line 1602: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;

1598: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
1599: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE;
1600: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
1601: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
1602: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;
1603: --START: change by nikshah, for SLA Uptake Bug 5705866
1604: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
1605: --END: change by nikshah, for SLA Uptake Bug 5705866
1606: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

Line 1604: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;

1600: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
1601: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
1602: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;
1603: --START: change by nikshah, for SLA Uptake Bug 5705866
1604: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
1605: --END: change by nikshah, for SLA Uptake Bug 5705866
1606: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
1607: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
1608: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;

Line 1624: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;

1620: l_inv_acct_code VARCHAR2(2000);
1621: l_scs_code VARCHAR2(2000) := 'LEASE';
1622: --START: Added by nikshah 20-Feb-2007 for SLA Uptake, Bug #5707866
1623: l_tcn_id NUMBER;
1624: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
1625: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
1626: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1627: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
1628: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;

Line 1625: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;

1621: l_scs_code VARCHAR2(2000) := 'LEASE';
1622: --START: Added by nikshah 20-Feb-2007 for SLA Uptake, Bug #5707866
1623: l_tcn_id NUMBER;
1624: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
1625: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
1626: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1627: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
1628: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
1629: --END: Added by nikshah 20-Feb-2007 for SLA Uptake, Bug #5707866

Line 1626: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;

1622: --START: Added by nikshah 20-Feb-2007 for SLA Uptake, Bug #5707866
1623: l_tcn_id NUMBER;
1624: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
1625: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
1626: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1627: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
1628: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
1629: --END: Added by nikshah 20-Feb-2007 for SLA Uptake, Bug #5707866
1630:

Line 1627: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;

1623: l_tcn_id NUMBER;
1624: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
1625: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
1626: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1627: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
1628: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
1629: --END: Added by nikshah 20-Feb-2007 for SLA Uptake, Bug #5707866
1630:
1631:

Line 1628: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;

1624: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
1625: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
1626: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1627: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
1628: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
1629: --END: Added by nikshah 20-Feb-2007 for SLA Uptake, Bug #5707866
1630:
1631:
1632: TYPE selv_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 2123: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(

2119: END LOOP;
2120:
2121: -- Call Okl_Account_Dist_Pub API to create accounting entries for this transaction
2122: --Call new accounting signature
2123: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
2124: p_api_version => p_api_version,
2125: p_init_msg_list => p_init_msg_list,
2126: x_return_status => x_return_status,
2127: x_msg_count => x_msg_count,

Line 4792: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;

4788: --Added by dpsingh for LE Uptake
4789: l_legal_entity_id NUMBER;
4790: --START: Added by nikshah 21-Feb-2007 for SLA Uptake, Bug #5707866
4791: l_tcn_id NUMBER;
4792: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
4793: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
4794: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
4795: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
4796: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;

Line 4793: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;

4789: l_legal_entity_id NUMBER;
4790: --START: Added by nikshah 21-Feb-2007 for SLA Uptake, Bug #5707866
4791: l_tcn_id NUMBER;
4792: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
4793: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
4794: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
4795: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
4796: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
4797: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;

Line 4794: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;

4790: --START: Added by nikshah 21-Feb-2007 for SLA Uptake, Bug #5707866
4791: l_tcn_id NUMBER;
4792: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
4793: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
4794: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
4795: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
4796: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
4797: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
4798: l_count NUMBER;

Line 4795: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;

4791: l_tcn_id NUMBER;
4792: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
4793: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
4794: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
4795: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
4796: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
4797: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
4798: l_count NUMBER;
4799: --END: Added by nikshah 21-Feb-2007 for SLA Uptake, Bug #5707866

Line 4796: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;

4792: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
4793: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
4794: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
4795: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
4796: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
4797: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
4798: l_count NUMBER;
4799: --END: Added by nikshah 21-Feb-2007 for SLA Uptake, Bug #5707866
4800:

Line 4797: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;

4793: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
4794: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
4795: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
4796: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
4797: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
4798: l_count NUMBER;
4799: --END: Added by nikshah 21-Feb-2007 for SLA Uptake, Bug #5707866
4800:
4801: --Added by bkatraga for bug 13447258

Line 5170: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(

5166: END LOOP;
5167:
5168: -- Call Okl_Account_Dist_Pub API to create accounting entries for this transaction
5169: --Call new signature
5170: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
5171: p_api_version => p_api_version,
5172: p_init_msg_list => p_init_msg_list,
5173: x_return_status => x_return_status,
5174: x_msg_count => x_msg_count,

Line 5410: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;

5406: --Added by dpsingh for LE Uptake
5407: l_legal_entity_id NUMBER;
5408: --START: Added by nikshah 21-Feb-2007 for SLA Uptake, Bug #5707866
5409: l_tcn_id NUMBER;
5410: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
5411: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
5412: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
5413: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
5414: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;

Line 5411: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;

5407: l_legal_entity_id NUMBER;
5408: --START: Added by nikshah 21-Feb-2007 for SLA Uptake, Bug #5707866
5409: l_tcn_id NUMBER;
5410: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
5411: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
5412: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
5413: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
5414: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
5415: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;

Line 5412: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;

5408: --START: Added by nikshah 21-Feb-2007 for SLA Uptake, Bug #5707866
5409: l_tcn_id NUMBER;
5410: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
5411: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
5412: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
5413: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
5414: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
5415: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
5416: l_count NUMBER;

Line 5413: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;

5409: l_tcn_id NUMBER;
5410: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
5411: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
5412: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
5413: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
5414: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
5415: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
5416: l_count NUMBER;
5417: --END: Added by nikshah 21-Feb-2007 for SLA Uptake, Bug #5707866

Line 5414: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;

5410: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
5411: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
5412: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
5413: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
5414: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
5415: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
5416: l_count NUMBER;
5417: --END: Added by nikshah 21-Feb-2007 for SLA Uptake, Bug #5707866
5418:

Line 5415: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;

5411: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
5412: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
5413: l_acc_gen_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
5414: l_template_out_tbl Okl_Account_Dist_Pvt.avlv_out_tbl_type;
5415: l_amount_out_tbl Okl_Account_Dist_Pvt.amount_out_tbl_type;
5416: l_count NUMBER;
5417: --END: Added by nikshah 21-Feb-2007 for SLA Uptake, Bug #5707866
5418:
5419:

Line 5765: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(

5761: END LOOP;
5762:
5763: -- Call Okl_Account_Dist_Pub API to create accounting entries for this transaction
5764: --Call new signature
5765: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
5766: p_api_version => p_api_version,
5767: p_init_msg_list => p_init_msg_list,
5768: x_return_status => x_return_status,
5769: x_msg_count => x_msg_count,