DBA Data[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_ACCOUNT_DIST_PVT

Line 2975: ,p_acc_gen_tbl IN OUT NOCOPY okl_account_dist_pvt.ACC_GEN_TBL_TYPE

2971: p_api_version IN NUMBER
2972: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2973: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type
2974: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type
2975: ,p_acc_gen_tbl IN OUT NOCOPY okl_account_dist_pvt.ACC_GEN_TBL_TYPE
2976: ,p_tmpl_identify_tbl IN OUT NOCOPY okl_account_dist_pvt.tmpl_identify_tbl_type
2977: ,p_dist_info_tbl IN OUT NOCOPY okl_account_dist_pvt.dist_info_tbl_type
2978: ,x_return_status OUT NOCOPY VARCHAR2
2979: ,x_msg_count OUT NOCOPY NUMBER

Line 2976: ,p_tmpl_identify_tbl IN OUT NOCOPY okl_account_dist_pvt.tmpl_identify_tbl_type

2972: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2973: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type
2974: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type
2975: ,p_acc_gen_tbl IN OUT NOCOPY okl_account_dist_pvt.ACC_GEN_TBL_TYPE
2976: ,p_tmpl_identify_tbl IN OUT NOCOPY okl_account_dist_pvt.tmpl_identify_tbl_type
2977: ,p_dist_info_tbl IN OUT NOCOPY okl_account_dist_pvt.dist_info_tbl_type
2978: ,x_return_status OUT NOCOPY VARCHAR2
2979: ,x_msg_count OUT NOCOPY NUMBER
2980: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 2977: ,p_dist_info_tbl IN OUT NOCOPY okl_account_dist_pvt.dist_info_tbl_type

2973: ,p_trxh_out_rec IN Okl_Trx_Contracts_Pvt.tcnv_rec_type
2974: ,p_tclv_tbl IN okl_trx_contracts_pvt.tclv_tbl_type
2975: ,p_acc_gen_tbl IN OUT NOCOPY okl_account_dist_pvt.ACC_GEN_TBL_TYPE
2976: ,p_tmpl_identify_tbl IN OUT NOCOPY okl_account_dist_pvt.tmpl_identify_tbl_type
2977: ,p_dist_info_tbl IN OUT NOCOPY okl_account_dist_pvt.dist_info_tbl_type
2978: ,x_return_status OUT NOCOPY VARCHAR2
2979: ,x_msg_count OUT NOCOPY NUMBER
2980: ,x_msg_data OUT NOCOPY VARCHAR2)
2981: IS

Line 3029: l_acc_gen_primary_key_tbl okl_account_dist_pvt.acc_gen_primary_key;

3025:
3026: l_custBillTo_rec custBillTo_csr%ROWTYPE;
3027:
3028: -- Cursors plucked from OKL_LA_JE_PVT for a/c - END
3029: l_acc_gen_primary_key_tbl okl_account_dist_pvt.acc_gen_primary_key;
3030: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
3031: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
3032:
3033: account_data_exception EXCEPTION;

Line 3043: l_acc_gen_primary_key_tbl1 okl_account_dist_pvt.acc_gen_primary_key;

3039: FROM okc_k_lines_b
3040: WHERE id = p_cle_id;
3041:
3042: l_assetBillTo_rec assetBillTo_csr%ROWTYPE;
3043: l_acc_gen_primary_key_tbl1 okl_account_dist_pvt.acc_gen_primary_key;
3044:
3045: BEGIN
3046:
3047: okl_debug_pub.logmessage('OKL: populate_account_data : START');

Line 3540: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;

3536: l_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3537: x_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3538:
3539:
3540: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;
3541: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
3542: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3543: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3544: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;

Line 3541: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;

3537: x_tclv_tbl okl_trx_contracts_pvt.tclv_tbl_type;
3538:
3539:
3540: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;
3541: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
3542: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3543: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3544: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3545: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;

Line 3542: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;

3538:
3539:
3540: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;
3541: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
3542: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3543: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3544: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3545: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3546: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;

Line 3543: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;

3539:
3540: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;
3541: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
3542: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3543: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3544: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3545: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3546: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;
3547: l_acc_gen_tbl okl_account_dist_pvt.ACC_GEN_TBL_TYPE;

Line 3544: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;

3540: l_tmpl_identify_rec okl_account_dist_pvt.tmpl_identify_rec_type;
3541: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
3542: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3543: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3544: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3545: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3546: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;
3547: l_acc_gen_tbl okl_account_dist_pvt.ACC_GEN_TBL_TYPE;
3548: l_ctxt_tbl okl_account_dist_pvt.CTXT_TBL_TYPE;

Line 3545: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;

3541: l_tmpl_identify_tbl okl_account_dist_pvt.tmpl_identify_tbl_type;
3542: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3543: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3544: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3545: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3546: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;
3547: l_acc_gen_tbl okl_account_dist_pvt.ACC_GEN_TBL_TYPE;
3548: l_ctxt_tbl okl_account_dist_pvt.CTXT_TBL_TYPE;
3549:

Line 3546: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;

3542: l_template_tbl okl_account_dist_pvt.avlv_tbl_type;
3543: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3544: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3545: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3546: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;
3547: l_acc_gen_tbl okl_account_dist_pvt.ACC_GEN_TBL_TYPE;
3548: l_ctxt_tbl okl_account_dist_pvt.CTXT_TBL_TYPE;
3549:
3550: counter NUMBER := 0;

Line 3547: l_acc_gen_tbl okl_account_dist_pvt.ACC_GEN_TBL_TYPE;

3543: l_dist_info_tbl okl_account_dist_pvt.dist_info_tbl_type;
3544: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3545: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3546: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;
3547: l_acc_gen_tbl okl_account_dist_pvt.ACC_GEN_TBL_TYPE;
3548: l_ctxt_tbl okl_account_dist_pvt.CTXT_TBL_TYPE;
3549:
3550: counter NUMBER := 0;
3551: j NUMBER := 0;

Line 3548: l_ctxt_tbl okl_account_dist_pvt.CTXT_TBL_TYPE;

3544: l_template_out_tbl okl_account_dist_pvt.avlv_out_tbl_type;
3545: l_amount_tbl okl_account_dist_pvt.amount_out_tbl_type;
3546: l_ctxt_val_tbl okl_account_dist_pvt.CTXT_VAL_TBL_TYPE;
3547: l_acc_gen_tbl okl_account_dist_pvt.ACC_GEN_TBL_TYPE;
3548: l_ctxt_tbl okl_account_dist_pvt.CTXT_TBL_TYPE;
3549:
3550: counter NUMBER := 0;
3551: j NUMBER := 0;
3552: l_trx_id NUMBER;

Line 3925: okl_account_dist_pvt.create_accounting_dist(

3921: ,G_MODULE
3922: ,'OKL: create_upfront_tax_accounting Procedure: Calling Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST');
3923: END IF;
3924:
3925: okl_account_dist_pvt.create_accounting_dist(
3926: p_api_version => 1.0,
3927: p_init_msg_list => p_init_msg_list,
3928: x_return_status => x_return_status,
3929: x_msg_count => x_msg_count,

Line 4163: okl_debug_pub.logmessage('OKL: UPF A/C : before calling okl_account_dist_pvt');

4159: ,G_MODULE
4160: ,'OKL: create_upfront_tax_accounting Procedure: Calling Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST');
4161: END IF;
4162:
4163: okl_debug_pub.logmessage('OKL: UPF A/C : before calling okl_account_dist_pvt');
4164:
4165: -- Call Accounting API to create distributions
4166: okl_account_dist_pvt.create_accounting_dist(
4167: p_api_version => 1.0,

Line 4166: okl_account_dist_pvt.create_accounting_dist(

4162:
4163: okl_debug_pub.logmessage('OKL: UPF A/C : before calling okl_account_dist_pvt');
4164:
4165: -- Call Accounting API to create distributions
4166: okl_account_dist_pvt.create_accounting_dist(
4167: p_api_version => 1.0,
4168: p_init_msg_list => p_init_msg_list,
4169: x_return_status => x_return_status,
4170: x_msg_count => x_msg_count,

Line 4180: okl_debug_pub.logmessage('OKL: UPF A/C : after calling okl_account_dist_pvt : '|| x_return_status);

4176: x_template_tbl => l_template_out_tbl,
4177: x_amount_tbl => l_amount_tbl,
4178: p_trx_header_id => l_trxh_out_rec.id);
4179:
4180: okl_debug_pub.logmessage('OKL: UPF A/C : after calling okl_account_dist_pvt : '|| x_return_status);
4181:
4182: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS)
4183: THEN
4184: RAISE upfront_tax_acct_exception;