eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_ACCOUNT_DIST_PUB

Line 485: -- l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

481: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
482: l_msg_count NUMBER;
483: l_msg_data VARCHAR2(2000);
484: -- l_formula_amount NUMBER := 0;
485: -- l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
486: l_last_int_calc_date DATE;
487: l_next_int_calc_date DATE;
488: l_khr_start_date DATE;
489: l_period_start_date DATE;

Line 1138: x_acc_gen_primary_key_tbl OUT NOCOPY Okl_Account_Dist_Pub.acc_gen_primary_key) IS

1134:
1135: PROCEDURE GET_ACCOUNT_GEN_DETAILS(
1136: p_contract_id IN NUMBER,
1137: x_return_status OUT NOCOPY VARCHAR2,
1138: x_acc_gen_primary_key_tbl OUT NOCOPY Okl_Account_Dist_Pub.acc_gen_primary_key) IS
1139:
1140: -- Get Contract Salesperson
1141: -- 30-Apr-2004. Bug 3596651. Cursor provided by Sarvanan.
1142: CURSOR l_salesperson_csr (cp_chr_id IN NUMBER) IS

Line 1606: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

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;
1609: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;
1610: x_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;

Line 2121: -- Call Okl_Account_Dist_Pub API to create accounting entries for this transaction

2117: WRITE_TO_LOG('l_dist_info_tbl(i).contract_id :'||l_dist_info_tbl(i).contract_id);
2118: WRITE_TO_LOG('l_dist_info_tbl(i).contract_line_id :'||l_dist_info_tbl(i).contract_line_id);
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,

Line 3589: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

3585: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'ACCRUAL';
3586: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
3587: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3588: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3589: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3590: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3591: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3592: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
3593: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

Line 3590: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;

3586: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
3587: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3588: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3589: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3590: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3591: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3592: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
3593: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
3594: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

Line 3591: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

3587: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3588: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3589: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3590: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3591: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3592: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
3593: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
3594: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3595: l_accrual_rec accrual_rec_type;

Line 3592: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

3588: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3589: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3590: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3591: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3592: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
3593: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
3594: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3595: l_accrual_rec accrual_rec_type;
3596: l_stream_tbl stream_tbl_type;

Line 3593: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

3589: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3590: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3591: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3592: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
3593: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
3594: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3595: l_accrual_rec accrual_rec_type;
3596: l_stream_tbl stream_tbl_type;
3597: l_count NUMBER := 1;

Line 3594: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

3590: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3591: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3592: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
3593: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
3594: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3595: l_accrual_rec accrual_rec_type;
3596: l_stream_tbl stream_tbl_type;
3597: l_count NUMBER := 1;
3598: i NUMBER := 1;

Line 4390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

4386: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4387: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4388: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4389: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

Line 4391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;

4387: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4388: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4389: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

Line 4392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

4388: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4389: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4396: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;

Line 4393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

4389: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4396: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
4397: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';

Line 4394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

4390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4396: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
4397: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
4398: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';

Line 4395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

4391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4396: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
4397: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
4398: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
4399: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED

Line 4736: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,

4732: x_msg_data OUT NOCOPY VARCHAR2,
4733: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
4734: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4735: p_accrual_rec IN accrual_rec_type,
4736: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,
4737: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041
4738:
4739: --Added by kthiruva on 14-May-2007
4740: --cursor to fetch the contract dff information for SLA Uptake

Line 4772: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

4768: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
4769: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4770: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4771: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4772: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4773: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4774: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4775: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4776: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

Line 4773: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;

4769: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4770: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4771: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4772: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4773: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4774: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4775: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4776: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4777: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

Line 4774: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

4770: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4771: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4772: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4773: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4774: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4775: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4776: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4777: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4778: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;

Line 4775: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

4771: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4772: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4773: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4774: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4775: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4776: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4777: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4778: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4779: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;

Line 4776: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

4772: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4773: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4774: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4775: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4776: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4777: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4778: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4779: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
4780: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;

Line 4777: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

4773: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4774: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4775: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4776: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4777: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4778: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4779: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
4780: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4781: x_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;

Line 4889: Okl_Account_Dist_Pub.GET_TEMPLATE_INFO(p_api_version => p_api_version,

4885: l_tmpl_identify_rec.factoring_synd_flag := l_fact_sync_code;
4886: l_tmpl_identify_rec.investor_code := l_inv_acct_code;
4887:
4888: -- added parameter p_validity_date for bug 2902876.
4889: Okl_Account_Dist_Pub.GET_TEMPLATE_INFO(p_api_version => p_api_version,
4890: p_init_msg_list => p_init_msg_list,
4891: x_return_status => x_return_status,
4892: x_msg_count => x_msg_count,
4893: x_msg_data => x_msg_data,

Line 5168: -- Call Okl_Account_Dist_Pub API to create accounting entries for this transaction

5164: WRITE_TO_LOG('l_dist_info_tbl(i).contract_id :'||l_dist_info_tbl(i).contract_id);
5165: WRITE_TO_LOG('l_dist_info_tbl(i).contract_line_id :'||l_dist_info_tbl(i).contract_line_id);
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,

Line 5353: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,

5349: x_msg_data OUT NOCOPY VARCHAR2,
5350: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
5351: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
5352: p_accrual_rec IN accrual_rec_type,
5353: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,
5354: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041
5355:
5356:
5357: --Added by kthiruva on 14-May-2007

Line 5390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

5386: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
5387: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
5388: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
5389: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
5390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
5391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
5392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
5394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

Line 5391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;

5387: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
5388: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
5389: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
5390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
5391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
5392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
5394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
5395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

Line 5392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

5388: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
5389: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
5390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
5391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
5392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
5394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
5395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
5396: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;

Line 5393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

5389: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
5390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
5391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
5392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
5394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
5395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
5396: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
5397: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;

Line 5394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

5390: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
5391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
5392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
5394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
5395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
5396: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
5397: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
5398: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;

Line 5395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

5391: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
5392: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5393: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
5394: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
5395: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
5396: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
5397: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
5398: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;
5399: x_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;

Line 5494: Okl_Account_Dist_Pub.GET_TEMPLATE_INFO(p_api_version => p_api_version,

5490: l_tmpl_identify_rec.factoring_synd_flag := l_fact_sync_code;
5491: l_tmpl_identify_rec.investor_code := l_inv_acct_code;
5492:
5493: -- added parameter p_validity_date for bug 2902876.
5494: Okl_Account_Dist_Pub.GET_TEMPLATE_INFO(p_api_version => p_api_version,
5495: p_init_msg_list => p_init_msg_list,
5496: x_return_status => x_return_status,
5497: x_msg_count => x_msg_count,
5498: x_msg_data => x_msg_data,

Line 5763: -- Call Okl_Account_Dist_Pub API to create accounting entries for this transaction

5759: WRITE_TO_LOG('l_dist_info_tbl(i).contract_id :'||l_dist_info_tbl(i).contract_id);
5760: WRITE_TO_LOG('l_dist_info_tbl(i).contract_line_id :'||l_dist_info_tbl(i).contract_line_id);
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,

Line 6145: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

6141: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
6142: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
6143: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6144: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
6145: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
6146: l_accrual_rec accrual_rec_type;
6147: l_reverse_rec accrual_rec_type;
6148: l_catchup_rec accrual_rec_type;
6149: -- commenting for bug# 2388940