DBA Data[Home] [Help]

APPS.OKL_LOSS_PROV_PVT dependencies on OKL_ACCOUNT_DIST_PUB

Line 144: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

140: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
141: l_msg_count NUMBER;
142: l_msg_data VARCHAR2(2000);
143: l_net_invest_value NUMBER := 0;
144: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
145:
146: BEGIN
147:
148: l_ctxt_val_tbl(1).NAME := 'p_provision_date';

Line 502: x_acc_gen_primary_key_tbl OUT NOCOPY Okl_Account_Dist_Pub.acc_gen_primary_key) IS

498:
499: PROCEDURE GET_ACCOUNT_GEN_DETAILS(
500: p_contract_id IN NUMBER,
501: x_return_status OUT NOCOPY VARCHAR2,
502: x_acc_gen_primary_key_tbl OUT NOCOPY Okl_Account_Dist_Pub.acc_gen_primary_key) IS
503:
504: -- Get Contract Salesperson
505: -- 30-Apr-2004. Bug 3596651. Cursor provided by Sarvanan.
506: CURSOR l_salesperson_csr (cp_chr_id IN NUMBER) IS

Line 650: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

646:
647: --local variables
648: l_api_name VARCHAR2(20) := 'CREATE_GEN_LOSS_TRX';
649: l_api_version CONSTANT NUMBER := 1.0;
650: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
651: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
652: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
653: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
654: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

Line 651: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;

647: --local variables
648: l_api_name VARCHAR2(20) := 'CREATE_GEN_LOSS_TRX';
649: l_api_version CONSTANT NUMBER := 1.0;
650: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
651: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
652: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
653: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
654: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
655: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';

Line 652: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

648: l_api_name VARCHAR2(20) := 'CREATE_GEN_LOSS_TRX';
649: l_api_version CONSTANT NUMBER := 1.0;
650: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
651: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
652: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
653: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
654: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
655: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
656: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

Line 653: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

649: l_api_version CONSTANT NUMBER := 1.0;
650: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
651: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
652: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
653: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
654: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
655: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
656: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
657: --START: Added by nikshah 19-Feb-2007 for SLA Uptake, Bug #5707866

Line 654: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

650: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
651: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
652: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
653: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
654: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
655: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
656: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
657: --START: Added by nikshah 19-Feb-2007 for SLA Uptake, Bug #5707866
658: l_tcn_id NUMBER;

Line 656: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

652: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
653: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
654: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
655: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
656: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
657: --START: Added by nikshah 19-Feb-2007 for SLA Uptake, Bug #5707866
658: l_tcn_id NUMBER;
659: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
660: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_type;

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

755: l_dist_info_tbl(i).gl_reversal_flag := 'N';
756:
757: END LOOP;
758:
759: -- Call Okl_Account_Dist_Pub API to create accounting entries for this transaction
760: -- Call new signature
761: Okl_Account_Dist_Pvt.CREATE_ACCOUNTING_DIST(
762: p_api_version => p_api_version,
763: p_init_msg_list => p_init_msg_list,

Line 2329: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;

2325: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2326: x_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2327: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2328: l_lprv_rec OKL_REV_LOSS_PROV_PUB.lprv_rec_type;
2329: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
2330: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
2331: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
2332: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
2333: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

Line 2330: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;

2326: x_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
2327: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2328: l_lprv_rec OKL_REV_LOSS_PROV_PUB.lprv_rec_type;
2329: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
2330: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
2331: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
2332: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
2333: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
2334: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

Line 2331: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;

2327: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
2328: l_lprv_rec OKL_REV_LOSS_PROV_PUB.lprv_rec_type;
2329: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
2330: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
2331: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
2332: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
2333: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
2334: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
2335:

Line 2332: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;

2328: l_lprv_rec OKL_REV_LOSS_PROV_PUB.lprv_rec_type;
2329: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
2330: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
2331: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
2332: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
2333: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
2334: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
2335:
2336: --Added by dpsingh for LE Uptake

Line 2333: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;

2329: l_tmpl_identify_rec Okl_Account_Dist_Pub.tmpl_identify_rec_type;
2330: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
2331: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
2332: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
2333: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
2334: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
2335:
2336: --Added by dpsingh for LE Uptake
2337: l_legal_entity_id NUMBER;

Line 2334: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

2330: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_rec_type;
2331: l_ctxt_val_tbl Okl_Account_Dist_Pub.ctxt_val_tbl_type;
2332: l_template_tbl Okl_Account_Dist_Pub.avlv_tbl_type;
2333: l_amount_tbl Okl_Account_Dist_Pub.amount_tbl_type;
2334: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
2335:
2336: --Added by dpsingh for LE Uptake
2337: l_legal_entity_id NUMBER;
2338: