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_MULTIGAAP_ENGINE_PVT dependencies on OKL_ACCOUNT_DIST_PVT

Line 454: p_ctxt_val_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE,

450: X_MSG_COUNT OUT NOCOPY NUMBER,
451: X_MSG_DATA OUT NOCOPY VARCHAR2,
452: P_TCNV_REC OKL_TCN_PVT.TCNV_REC_TYPE,
453: P_TCLV_TBL OKL_TCL_PVT.TCLV_TBL_TYPE,
454: p_ctxt_val_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE,
455: p_acc_gen_primary_key_tbl OKL_ACCOUNT_DIST_PVT.acc_gen_primary_key --SGIYER
456: ) IS
457:
458: l_api_version NUMBER := 1.0;

Line 455: p_acc_gen_primary_key_tbl OKL_ACCOUNT_DIST_PVT.acc_gen_primary_key --SGIYER

451: X_MSG_DATA OUT NOCOPY VARCHAR2,
452: P_TCNV_REC OKL_TCN_PVT.TCNV_REC_TYPE,
453: P_TCLV_TBL OKL_TCL_PVT.TCLV_TBL_TYPE,
454: p_ctxt_val_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE,
455: p_acc_gen_primary_key_tbl OKL_ACCOUNT_DIST_PVT.acc_gen_primary_key --SGIYER
456: ) IS
457:
458: l_api_version NUMBER := 1.0;
459: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SEC_REP_TRX';

Line 509: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;

505:
506: l_valid_gl_date date;
507:
508: -- get template infofor acc dist
509: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;
510: l_template_tbl Okl_Account_Dist_Pvt.AVLV_TBL_TYPE;
511:
512: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
513: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_TYPE;

Line 510: l_template_tbl Okl_Account_Dist_Pvt.AVLV_TBL_TYPE;

506: l_valid_gl_date date;
507:
508: -- get template infofor acc dist
509: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;
510: l_template_tbl Okl_Account_Dist_Pvt.AVLV_TBL_TYPE;
511:
512: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
513: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_TYPE;
514: l_ctxt_val_tbl OKL_ACCOUNT_DIST_PVT.CTXT_VAL_TBL_TYPE;

Line 512: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;

508: -- get template infofor acc dist
509: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;
510: l_template_tbl Okl_Account_Dist_Pvt.AVLV_TBL_TYPE;
511:
512: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
513: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_TYPE;
514: l_ctxt_val_tbl OKL_ACCOUNT_DIST_PVT.CTXT_VAL_TBL_TYPE;
515: l_acc_gen_tbl Okl_Account_Dist_Pvt.acc_gen_tbl_type; --SGIYER := p_acc_gen_primary_key_tbl;
516: x_template_tbl Okl_Account_Dist_Pvt.AVLV_OUT_TBL_TYPE;

Line 513: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_TYPE;

509: l_tmpl_identify_rec Okl_Account_Dist_Pvt.tmpl_identify_rec_type;
510: l_template_tbl Okl_Account_Dist_Pvt.AVLV_TBL_TYPE;
511:
512: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
513: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_TYPE;
514: l_ctxt_val_tbl OKL_ACCOUNT_DIST_PVT.CTXT_VAL_TBL_TYPE;
515: l_acc_gen_tbl Okl_Account_Dist_Pvt.acc_gen_tbl_type; --SGIYER := p_acc_gen_primary_key_tbl;
516: x_template_tbl Okl_Account_Dist_Pvt.AVLV_OUT_TBL_TYPE;
517: x_amount_out_tbl Okl_Account_Dist_Pvt.AMOUNT_OUT_TBL_TYPE;

Line 514: l_ctxt_val_tbl OKL_ACCOUNT_DIST_PVT.CTXT_VAL_TBL_TYPE;

510: l_template_tbl Okl_Account_Dist_Pvt.AVLV_TBL_TYPE;
511:
512: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
513: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_TYPE;
514: l_ctxt_val_tbl OKL_ACCOUNT_DIST_PVT.CTXT_VAL_TBL_TYPE;
515: l_acc_gen_tbl Okl_Account_Dist_Pvt.acc_gen_tbl_type; --SGIYER := p_acc_gen_primary_key_tbl;
516: x_template_tbl Okl_Account_Dist_Pvt.AVLV_OUT_TBL_TYPE;
517: x_amount_out_tbl Okl_Account_Dist_Pvt.AMOUNT_OUT_TBL_TYPE;
518:

Line 515: l_acc_gen_tbl Okl_Account_Dist_Pvt.acc_gen_tbl_type; --SGIYER := p_acc_gen_primary_key_tbl;

511:
512: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
513: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_TYPE;
514: l_ctxt_val_tbl OKL_ACCOUNT_DIST_PVT.CTXT_VAL_TBL_TYPE;
515: l_acc_gen_tbl Okl_Account_Dist_Pvt.acc_gen_tbl_type; --SGIYER := p_acc_gen_primary_key_tbl;
516: x_template_tbl Okl_Account_Dist_Pvt.AVLV_OUT_TBL_TYPE;
517: x_amount_out_tbl Okl_Account_Dist_Pvt.AMOUNT_OUT_TBL_TYPE;
518:
519: l_acc_gen_primary_key_tbl OKL_ACCOUNT_DIST_PVT.acc_gen_primary_key := p_acc_gen_primary_key_tbl; --SGIYER

Line 516: x_template_tbl Okl_Account_Dist_Pvt.AVLV_OUT_TBL_TYPE;

512: l_tmpl_identify_tbl Okl_Account_Dist_Pvt.tmpl_identify_tbl_type;
513: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_TYPE;
514: l_ctxt_val_tbl OKL_ACCOUNT_DIST_PVT.CTXT_VAL_TBL_TYPE;
515: l_acc_gen_tbl Okl_Account_Dist_Pvt.acc_gen_tbl_type; --SGIYER := p_acc_gen_primary_key_tbl;
516: x_template_tbl Okl_Account_Dist_Pvt.AVLV_OUT_TBL_TYPE;
517: x_amount_out_tbl Okl_Account_Dist_Pvt.AMOUNT_OUT_TBL_TYPE;
518:
519: l_acc_gen_primary_key_tbl OKL_ACCOUNT_DIST_PVT.acc_gen_primary_key := p_acc_gen_primary_key_tbl; --SGIYER
520: l_amount_tbl Okl_Account_Dist_Pvt.AMOUNT_TBL_TYPE;

Line 517: x_amount_out_tbl Okl_Account_Dist_Pvt.AMOUNT_OUT_TBL_TYPE;

513: l_dist_info_tbl Okl_Account_Dist_Pvt.dist_info_tbl_TYPE;
514: l_ctxt_val_tbl OKL_ACCOUNT_DIST_PVT.CTXT_VAL_TBL_TYPE;
515: l_acc_gen_tbl Okl_Account_Dist_Pvt.acc_gen_tbl_type; --SGIYER := p_acc_gen_primary_key_tbl;
516: x_template_tbl Okl_Account_Dist_Pvt.AVLV_OUT_TBL_TYPE;
517: x_amount_out_tbl Okl_Account_Dist_Pvt.AMOUNT_OUT_TBL_TYPE;
518:
519: l_acc_gen_primary_key_tbl OKL_ACCOUNT_DIST_PVT.acc_gen_primary_key := p_acc_gen_primary_key_tbl; --SGIYER
520: l_amount_tbl Okl_Account_Dist_Pvt.AMOUNT_TBL_TYPE;
521: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;

Line 519: l_acc_gen_primary_key_tbl OKL_ACCOUNT_DIST_PVT.acc_gen_primary_key := p_acc_gen_primary_key_tbl; --SGIYER

515: l_acc_gen_tbl Okl_Account_Dist_Pvt.acc_gen_tbl_type; --SGIYER := p_acc_gen_primary_key_tbl;
516: x_template_tbl Okl_Account_Dist_Pvt.AVLV_OUT_TBL_TYPE;
517: x_amount_out_tbl Okl_Account_Dist_Pvt.AMOUNT_OUT_TBL_TYPE;
518:
519: l_acc_gen_primary_key_tbl OKL_ACCOUNT_DIST_PVT.acc_gen_primary_key := p_acc_gen_primary_key_tbl; --SGIYER
520: l_amount_tbl Okl_Account_Dist_Pvt.AMOUNT_TBL_TYPE;
521: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
522:
523: CURSOR l_contract_currency_csr IS

Line 520: l_amount_tbl Okl_Account_Dist_Pvt.AMOUNT_TBL_TYPE;

516: x_template_tbl Okl_Account_Dist_Pvt.AVLV_OUT_TBL_TYPE;
517: x_amount_out_tbl Okl_Account_Dist_Pvt.AMOUNT_OUT_TBL_TYPE;
518:
519: l_acc_gen_primary_key_tbl OKL_ACCOUNT_DIST_PVT.acc_gen_primary_key := p_acc_gen_primary_key_tbl; --SGIYER
520: l_amount_tbl Okl_Account_Dist_Pvt.AMOUNT_TBL_TYPE;
521: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
522:
523: CURSOR l_contract_currency_csr IS
524: SELECT currency_code,

Line 521: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;

517: x_amount_out_tbl Okl_Account_Dist_Pvt.AMOUNT_OUT_TBL_TYPE;
518:
519: l_acc_gen_primary_key_tbl OKL_ACCOUNT_DIST_PVT.acc_gen_primary_key := p_acc_gen_primary_key_tbl; --SGIYER
520: l_amount_tbl Okl_Account_Dist_Pvt.AMOUNT_TBL_TYPE;
521: l_ctxt_tbl Okl_Account_Dist_Pvt.CTXT_TBL_TYPE;
522:
523: CURSOR l_contract_currency_csr IS
524: SELECT currency_code,
525: currency_conversion_rate,

Line 718: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO');

714: l_tmpl_identify_rec.memo_yn := 'N';
715: l_tmpl_identify_rec.prior_year_yn := 'N';
716:
717: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
718: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO');
719: END IF;
720:
721: OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO(p_api_version => l_api_version,
722: p_init_msg_list => p_init_msg_list,

Line 721: OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO(p_api_version => l_api_version,

717: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
718: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO');
719: END IF;
720:
721: OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO(p_api_version => l_api_version,
722: p_init_msg_list => p_init_msg_list,
723: x_return_status => l_return_status,
724: x_msg_count => x_msg_count,
725: x_msg_data => x_msg_data,

Line 731: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO, the return status is :'||l_return_status);

727: x_template_tbl => l_template_tbl,
728: p_validity_date => l_valid_gl_date); -- SGIYER-12/08/08.
729:
730: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
731: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO, the return status is :'||l_return_status);
732: END IF;
733: -- Raise an error if template is not found.
734:
735: IF (l_template_tbl.COUNT = 0) THEN

Line 891: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');

887:
888: END LOOP;
889:
890: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
891: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');
892: END IF;
893:
894: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(
895: p_api_version => l_api_version,

Line 894: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(

890: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
891: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');
892: END IF;
893:
894: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(
895: p_api_version => l_api_version,
896: p_init_msg_list => p_init_msg_list,
897: x_return_status => l_return_status,
898: x_msg_count => x_msg_count,

Line 909: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST :'||l_return_status);

905: x_amount_tbl => x_amount_out_tbl,
906: p_trx_header_id => x_sec_trx_tcnv_tbl(1).id);
907:
908: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
909: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST :'||l_return_status);
910: END IF;
911:
912: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
913: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1117: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');

1113:
1114: END LOOP;
1115:
1116: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1117: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');
1118: END IF;
1119:
1120: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(
1121: p_api_version => l_api_version,

Line 1120: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(

1116: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1117: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');
1118: END IF;
1119:
1120: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(
1121: p_api_version => l_api_version,
1122: p_init_msg_list => p_init_msg_list,
1123: x_return_status => l_return_status,
1124: x_msg_count => x_msg_count,

Line 1135: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST :'||l_return_status);

1131: x_amount_tbl => x_amount_out_tbl,
1132: p_trx_header_id => x_sec_trx_tcnv_tbl(1).id);
1133:
1134: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1135: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST :'||l_return_status);
1136: END IF;
1137:
1138: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1139: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;