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 438: -- l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

434: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
435: l_msg_count NUMBER;
436: l_msg_data VARCHAR2(2000);
437: -- l_formula_amount NUMBER := 0;
438: -- l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
439: l_last_int_calc_date DATE;
440: l_next_int_calc_date DATE;
441: l_khr_start_date DATE;
442: l_period_start_date DATE;

Line 1028: x_acc_gen_primary_key_tbl OUT NOCOPY Okl_Account_Dist_Pub.acc_gen_primary_key) IS

1024:
1025: PROCEDURE GET_ACCOUNT_GEN_DETAILS(
1026: p_contract_id IN NUMBER,
1027: x_return_status OUT NOCOPY VARCHAR2,
1028: x_acc_gen_primary_key_tbl OUT NOCOPY Okl_Account_Dist_Pub.acc_gen_primary_key) IS
1029:
1030: -- Get Contract Salesperson
1031: -- 30-Apr-2004. Bug 3596651. Cursor provided by Sarvanan.
1032: CURSOR l_salesperson_csr (cp_chr_id IN NUMBER) IS

Line 1496: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

1492: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;
1493: --START: change by nikshah, for SLA Uptake Bug 5705866
1494: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;
1495: --END: change by nikshah, for SLA Uptake Bug 5705866
1496: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
1497: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
1498: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
1499: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;
1500: x_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;

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

2004: WRITE_TO_LOG('l_dist_info_tbl(i).contract_id :'||l_dist_info_tbl(i).contract_id);
2005: WRITE_TO_LOG('l_dist_info_tbl(i).contract_line_id :'||l_dist_info_tbl(i).contract_line_id);
2006: END LOOP;
2007:
2008: -- Call Okl_Account_Dist_Pub API to create accounting entries for this transaction
2009: --Call new accounting signature
2010: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
2011: p_api_version => p_api_version,
2012: p_init_msg_list => p_init_msg_list,

Line 3343: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

3339: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'ACCRUAL';
3340: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
3341: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3342: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3343: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3344: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3345: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3346: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
3347: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

Line 3344: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;

3340: l_non_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'NON-ACCRUAL';
3341: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3342: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3343: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3344: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3345: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3346: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
3347: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
3348: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

Line 3345: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

3341: l_reversal_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE := 'REVERSAL';
3342: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3343: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3344: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3345: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3346: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
3347: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
3348: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3349: l_accrual_rec accrual_rec_type;

Line 3346: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

3342: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
3343: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3344: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3345: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3346: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
3347: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
3348: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3349: l_accrual_rec accrual_rec_type;
3350: l_stream_tbl stream_tbl_type;

Line 3347: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

3343: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
3344: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3345: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3346: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
3347: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
3348: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3349: l_accrual_rec accrual_rec_type;
3350: l_stream_tbl stream_tbl_type;
3351: l_count NUMBER := 1;

Line 3348: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

3344: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
3345: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
3346: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
3347: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
3348: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3349: l_accrual_rec accrual_rec_type;
3350: l_stream_tbl stream_tbl_type;
3351: l_count NUMBER := 1;
3352: i NUMBER := 1;

Line 4144: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

4140: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
4141: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4142: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4143: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4144: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4145: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4146: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4147: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4148: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

Line 4145: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;

4141: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
4142: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4143: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4144: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4145: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4146: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4147: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4148: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4149: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

Line 4146: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

4142: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
4143: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4144: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4145: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4146: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4147: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4148: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4149: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4150: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;

Line 4147: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

4143: l_source_id_tbl Okl_Reversal_Pub.source_id_tbl_type;
4144: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4145: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4146: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4147: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4148: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4149: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4150: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
4151: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';

Line 4148: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

4144: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4145: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4146: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4147: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4148: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4149: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4150: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
4151: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
4152: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';

Line 4149: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

4145: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4146: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4147: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4148: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4149: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4150: l_catchup_trx_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
4151: l_tcn_type OKL_TRX_CONTRACTS.TCN_TYPE%TYPE := 'ACL';
4152: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE := 'ACL';
4153: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED

Line 4488: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,

4484: x_msg_data OUT NOCOPY VARCHAR2,
4485: x_tcnv_rec OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tcnv_rec_type,
4486: x_tclv_tbl OUT NOCOPY OKL_TRX_CONTRACTS_PUB.tclv_tbl_type,
4487: p_accrual_rec IN accrual_rec_type,
4488: p_ctxt_val_tbl IN Okl_Account_dist_Pub.ctxt_val_tbl_type,
4489: p_representation_type IN VARCHAR2 DEFAULT 'PRIMARY') IS --MGAAP 7263041
4490:
4491:
4492: --Added by kthiruva on 14-May-2007

Line 4525: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

4521: l_tcl_type OKL_TXL_CNTRCT_LNS.TCL_TYPE%TYPE;
4522: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4523: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4524: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4525: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4526: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4527: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4528: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4529: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

Line 4526: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;

4522: --Fixed Bug 5707866 SLA Uptake Project by nikshah, changed tsu_code to PROCESSED from ENTERED
4523: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4524: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4525: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4526: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4527: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4528: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4529: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4530: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

Line 4527: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

4523: l_tsu_code_ent OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
4524: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4525: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4526: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4527: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4528: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4529: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4530: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4531: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;

Line 4528: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

4524: l_source_table OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
4525: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4526: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4527: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4528: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4529: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4530: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4531: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4532: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;

Line 4529: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

4525: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
4526: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4527: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4528: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4529: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4530: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4531: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4532: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
4533: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;

Line 4530: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

4526: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
4527: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
4528: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
4529: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
4530: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
4531: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4532: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
4533: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4534: x_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;

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

4625: l_tmpl_identify_rec.factoring_synd_flag := l_fact_sync_code;
4626: l_tmpl_identify_rec.investor_code := l_inv_acct_code;
4627:
4628: -- added parameter p_validity_date for bug 2902876.
4629: Okl_Account_Dist_Pub.GET_TEMPLATE_INFO(p_api_version => p_api_version,
4630: p_init_msg_list => p_init_msg_list,
4631: x_return_status => x_return_status,
4632: x_msg_count => x_msg_count,
4633: x_msg_data => x_msg_data,

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

4882: WRITE_TO_LOG('l_dist_info_tbl(i).contract_id :'||l_dist_info_tbl(i).contract_id);
4883: WRITE_TO_LOG('l_dist_info_tbl(i).contract_line_id :'||l_dist_info_tbl(i).contract_line_id);
4884: END LOOP;
4885:
4886: -- Call Okl_Account_Dist_Pub API to create accounting entries for this transaction
4887: --Call new signature
4888: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
4889: p_api_version => p_api_version,
4890: p_init_msg_list => p_init_msg_list,

Line 5266: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

5262: l_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5263: l_can_tcnv_tbl Okl_Trx_Contracts_Pub.tcnv_tbl_type;
5264: l_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5265: l_can_tclv_tbl Okl_Trx_Contracts_Pub.tclv_tbl_type;
5266: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
5267: l_accrual_rec accrual_rec_type;
5268: l_reverse_rec accrual_rec_type;
5269: l_catchup_rec accrual_rec_type;
5270: -- commenting for bug# 2388940