DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_ACCOUNT_DIST_PUB

Line 490: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;

486: FROM OKC_K_HEADERS_B
487: WHERE ID = P_khr_ID ;
488:
489:
490: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
491: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
492: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
493: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
494:

Line 491: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

487: WHERE ID = P_khr_ID ;
488:
489:
490: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
491: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
492: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
493: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
494:
495:

Line 492: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;

488:
489:
490: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
491: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
492: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
493: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
494:
495:
496: CURSOR c_app_info IS

Line 493: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;

489:
490: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
491: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
492: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
493: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
494:
495:
496: CURSOR c_app_info IS
497: SELECT APPLICATION_ID

Line 813: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;

809: FROM OKC_K_HEADERS_B -- Changed to table
810: WHERE ID = P_khr_ID ;
811:
812:
813: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
814: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
815: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
816: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
817:

Line 814: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

810: WHERE ID = P_khr_ID ;
811:
812:
813: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
814: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
815: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
816: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
817:
818:

Line 815: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;

811:
812:
813: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
814: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
815: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
816: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
817:
818:
819: CURSOR c_app_info IS

Line 816: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;

812:
813: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
814: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
815: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
816: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
817:
818:
819: CURSOR c_app_info IS
820: SELECT APPLICATION_ID

Line 3300: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;

3296: x_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type ;
3297: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
3298: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
3299:
3300: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
3301: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3302: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
3303: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
3304:

Line 3301: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

3297: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
3298: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
3299:
3300: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
3301: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3302: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
3303: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
3304:
3305: End Bug#5955320

Line 3302: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;

3298: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
3299:
3300: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
3301: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3302: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
3303: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
3304:
3305: End Bug#5955320
3306: */

Line 3303: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;

3299:
3300: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
3301: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3302: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
3303: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
3304:
3305: End Bug#5955320
3306: */
3307: -- Start Bug#5955320

Line 3354: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;

3350: SELECT khr.pdt_id pdt_id
3351: FROM okl_k_headers_v khr
3352: WHERE khr.ID = p_khr_id;
3353:
3354: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
3355: l_acct_call_rec l_acc_dtls_csr%ROWTYPE;
3356: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
3357:
3358: -- gboomina Bug 4622198 - Added for Investor Special Accounting Codes - Start

Line 3356: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;

3352: WHERE khr.ID = p_khr_id;
3353:
3354: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
3355: l_acct_call_rec l_acc_dtls_csr%ROWTYPE;
3356: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
3357:
3358: -- gboomina Bug 4622198 - Added for Investor Special Accounting Codes - Start
3359: l_fact_sync_code VARCHAR2(2000);
3360: l_inv_acct_code VARCHAR2(2000);

Line 3686: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

3682: l_dist_info_rec.CURRENCY_CONVERSION_DATE := l_currency_conversion_date;
3683: l_dist_info_rec.CONTRACT_ID := l_ipyv_rec.KHR_ID ;
3684: l_dist_info_rec.CONTRACT_LINE_ID := l_ipyv_rec.KLE_ID;
3685: IF (l_adjustment_amount > 0 )THEN
3686: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
3687: IF(IS_DEBUG_PROCEDURE_ON) THEN
3688: BEGIN
3689: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
3690: END;

Line 3689: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

3685: IF (l_adjustment_amount > 0 )THEN
3686: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
3687: IF(IS_DEBUG_PROCEDURE_ON) THEN
3688: BEGIN
3689: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
3690: END;
3691: END IF;
3692:
3693: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(

Line 3693: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(

3689: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
3690: END;
3691: END IF;
3692:
3693: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(
3694: p_api_version => p_api_version
3695: ,p_init_msg_list => p_init_msg_list
3696: ,x_return_status => x_return_status
3697: ,x_msg_count => x_msg_count

Line 3708: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

3704: ,x_amount_tbl => l_amount_tbl);
3705:
3706: IF(IS_DEBUG_PROCEDURE_ON) THEN
3707: BEGIN
3708: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
3709: END;
3710: END IF;
3711: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
3712: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3711: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

3707: BEGIN
3708: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
3709: END;
3710: END IF;
3711: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
3712: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3713: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3714: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3715: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3758: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

3754: l_stream_tbl(0).stream_element_id := NULL;
3755: l_stream_tbl(0).stream_amount := l_adjustment_amount;
3756: l_stream_tbl(0).kle_id := l_ipyv_rec.KLE_ID;
3757:
3758: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
3759: IF(IS_DEBUG_PROCEDURE_ON) THEN
3760: BEGIN
3761: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_GENERATE_ACCRUALS_PVT.ADJUST_ACCRUALS ');
3762: END;

Line 3780: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

3776: BEGIN
3777: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call OKL_GENERATE_ACCRUALS_PVT.ADJUST_ACCRUALS ');
3778: END;
3779: END IF;
3780: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
3781: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3782: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3783: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3784: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3822: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

3818: l_stream_tbl(0).stream_element_id := NULL;
3819: l_stream_tbl(0).stream_amount := l_adjustment_amount_rep;
3820: l_stream_tbl(0).kle_id := l_ipyv_rec.KLE_ID;
3821:
3822: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
3823: IF(IS_DEBUG_PROCEDURE_ON) THEN
3824: BEGIN
3825: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call OKL_GENERATE_ACCRUALS_PVT.ADJUST_ACCRUALS ');
3826: END;

Line 3937: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;

3933: x_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type ;
3934: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
3935: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
3936:
3937: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
3938: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3939: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
3940: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
3941:

Line 3938: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

3934: l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
3935: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
3936:
3937: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
3938: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3939: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
3940: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
3941:
3942: End Bug#5955320

Line 3939: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;

3935: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
3936:
3937: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
3938: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3939: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
3940: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
3941:
3942: End Bug#5955320
3943: */

Line 3940: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;

3936:
3937: l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
3938: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
3939: l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
3940: l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
3941:
3942: End Bug#5955320
3943: */
3944:

Line 4008: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;

4004: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
4005: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
4006: l_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
4007:
4008: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
4009: --l_acct_call_rec l_acc_dtls_csr%ROWTYPE;
4010: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
4011: -- gboomina Bug 4622198 - Added for Investor Special Accounting Codes - Start
4012: l_fact_sync_code VARCHAR2(2000);

Line 4010: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;

4006: l_curr_code GL_LEDGERS_PUBLIC_V.CURRENCY_CODE%TYPE;
4007:
4008: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
4009: --l_acct_call_rec l_acc_dtls_csr%ROWTYPE;
4010: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
4011: -- gboomina Bug 4622198 - Added for Investor Special Accounting Codes - Start
4012: l_fact_sync_code VARCHAR2(2000);
4013: l_inv_acct_code VARCHAR2(2000);
4014: -- gboomina Bug 4622198 - Added for Investor Special Accounting Codes - End

Line 4322: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

4318: l_dist_info_rec.CONTRACT_ID := l_ipyv_rec.KHR_ID ;
4319: l_dist_info_rec.CONTRACT_LINE_ID := l_ipyv_rec.KLE_ID;
4320: IF ( l_adjustment_amount > 0) THEN
4321:
4322: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
4323: IF(IS_DEBUG_PROCEDURE_ON) THEN
4324: BEGIN
4325: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
4326: END;

Line 4325: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

4321:
4322: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
4323: IF(IS_DEBUG_PROCEDURE_ON) THEN
4324: BEGIN
4325: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
4326: END;
4327: END IF;
4328: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(
4329: p_api_version => p_api_version

Line 4328: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(

4324: BEGIN
4325: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
4326: END;
4327: END IF;
4328: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(
4329: p_api_version => p_api_version
4330: ,p_init_msg_list => p_init_msg_list
4331: ,x_return_status => x_return_status
4332: ,x_msg_count => x_msg_count

Line 4342: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

4338: ,x_template_tbl => l_template_tbl
4339: ,x_amount_tbl => l_amount_tbl);
4340: IF(IS_DEBUG_PROCEDURE_ON) THEN
4341: BEGIN
4342: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
4343: END;
4344: END IF;
4345: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
4346: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4345: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

4341: BEGIN
4342: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
4343: END;
4344: END IF;
4345: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
4346: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4347: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4348: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4349: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 4413: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

4409: ,p_stream_tbl => l_stream_tbl);
4410:
4411: IF(IS_DEBUG_PROCEDURE_ON) THEN
4412: BEGIN
4413: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
4414: END;
4415: END IF;
4416: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
4417: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4416: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

4412: BEGIN
4413: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
4414: END;
4415: END IF;
4416: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
4417: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4418: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
4419: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4420: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 5884: -- l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;

5880: -- l_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type ;
5881: -- x_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type ;
5882: -- l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
5883: -- x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
5884: -- l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
5885: -- l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
5886: -- l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
5887: -- l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
5888: */

Line 5885: -- l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;

5881: -- x_tcnv_rec_in OKL_TRX_CONTRACTS_PUB.tcnv_rec_type ;
5882: -- l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
5883: -- x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
5884: -- l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
5885: -- l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
5886: -- l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
5887: -- l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
5888: */
5889: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

Line 5886: -- l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;

5882: -- l_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
5883: -- x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
5884: -- l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
5885: -- l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
5886: -- l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
5887: -- l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
5888: */
5889: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5890: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 5887: -- l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;

5883: -- x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type ;
5884: -- l_ctxt_val_tbl Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE;
5885: -- l_acc_gen_primary_key_tbl Okl_Account_Dist_Pub.acc_gen_primary_key;
5886: -- l_template_tbl Okl_Account_Dist_Pub.AVLV_TBL_TYPE;
5887: -- l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
5888: */
5889: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5890: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5891: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;

Line 5891: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;

5887: -- l_amount_tbl Okl_Account_Dist_Pub.AMOUNT_TBL_TYPE;
5888: */
5889: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5890: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5891: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
5892: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
5893:
5894: -- gboomina Bug 4622198 - Added for Investor Special Accounting Codes - Start
5895: l_fact_sync_code VARCHAR2(2000);

Line 5892: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;

5888: */
5889: l_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
5890: l_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
5891: l_dist_info_rec Okl_Account_Dist_Pub.dist_info_REC_TYPE;
5892: l_tmpl_identify_rec Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE;
5893:
5894: -- gboomina Bug 4622198 - Added for Investor Special Accounting Codes - Start
5895: l_fact_sync_code VARCHAR2(2000);
5896: l_inv_acct_code VARCHAR2(2000);

Line 6522: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

6518:
6519:
6520:
6521:
6522: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
6523: IF(IS_DEBUG_PROCEDURE_ON) THEN
6524: BEGIN
6525: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
6526: END;

Line 6525: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

6521:
6522: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
6523: IF(IS_DEBUG_PROCEDURE_ON) THEN
6524: BEGIN
6525: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
6526: END;
6527: END IF;
6528:
6529:

Line 6532: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(

6528:
6529:
6530:
6531:
6532: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(
6533: p_api_version => p_api_version
6534: ,p_init_msg_list => p_init_msg_list
6535: ,x_return_status => x_return_status
6536: ,x_msg_count => x_msg_count

Line 6546: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

6542: ,x_template_tbl => l_template_tbl
6543: ,x_amount_tbl => l_amount_tbl);
6544: IF(IS_DEBUG_PROCEDURE_ON) THEN
6545: BEGIN
6546: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
6547: END;
6548: END IF;
6549: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
6550:

Line 6549: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

6545: BEGIN
6546: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
6547: END;
6548: END IF;
6549: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
6550:
6551:
6552:
6553: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 6743: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

6739:
6740: IF ( l_adjustment_amount > 0) THEN
6741:
6742:
6743: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
6744: IF(IS_DEBUG_PROCEDURE_ON) THEN
6745: BEGIN
6746: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
6747: END;

Line 6746: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

6742:
6743: -- Start of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
6744: IF(IS_DEBUG_PROCEDURE_ON) THEN
6745: BEGIN
6746: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
6747: END;
6748: END IF;
6749: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(
6750: p_api_version => p_api_version

Line 6749: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(

6745: BEGIN
6746: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
6747: END;
6748: END IF;
6749: Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST(
6750: p_api_version => p_api_version
6751: ,p_init_msg_list => p_init_msg_list
6752: ,x_return_status => x_return_status
6753: ,x_msg_count => x_msg_count

Line 6763: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');

6759: ,x_template_tbl => l_template_tbl
6760: ,x_amount_tbl => l_amount_tbl);
6761: IF(IS_DEBUG_PROCEDURE_ON) THEN
6762: BEGIN
6763: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
6764: END;
6765: END IF;
6766: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
6767:

Line 6766: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST

6762: BEGIN
6763: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST ');
6764: END;
6765: END IF;
6766: -- End of wraper code generated automatically by Debug code generator for Okl_Account_Dist_Pub.CREATE_ACCOUNTING_DIST
6767:
6768:
6769:
6770: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN