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 704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO');

700: l_tmpl_identify_rec.memo_yn := 'N';
701: l_tmpl_identify_rec.prior_year_yn := 'N';
702:
703: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO');
705: END IF;
706:
707: OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO(p_api_version => l_api_version,
708: p_init_msg_list => p_init_msg_list,

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

703: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO');
705: END IF;
706:
707: OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO(p_api_version => l_api_version,
708: p_init_msg_list => p_init_msg_list,
709: x_return_status => l_return_status,
710: x_msg_count => x_msg_count,
711: x_msg_data => x_msg_data,

Line 717: 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);

713: x_template_tbl => l_template_tbl,
714: p_validity_date => l_valid_gl_date); -- SGIYER-12/08/08.
715:
716: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
717: 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);
718: END IF;
719: -- Raise an error if template is not found.
720:
721: IF (l_template_tbl.COUNT = 0) THEN

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

873:
874: END LOOP;
875:
876: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
877: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');
878: END IF;
879:
880: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(
881: p_api_version => l_api_version,

Line 880: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(

876: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
877: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');
878: END IF;
879:
880: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(
881: p_api_version => l_api_version,
882: p_init_msg_list => p_init_msg_list,
883: x_return_status => l_return_status,
884: x_msg_count => x_msg_count,

Line 895: 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);

891: x_amount_tbl => x_amount_out_tbl,
892: p_trx_header_id => x_sec_trx_tcnv_tbl(1).id);
893:
894: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
895: 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);
896: END IF;
897:
898: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1091:
1092: END LOOP;
1093:
1094: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1095: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');
1096: END IF;
1097:
1098: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(
1099: p_api_version => l_api_version,

Line 1098: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(

1094: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1095: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');
1096: END IF;
1097:
1098: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(
1099: p_api_version => l_api_version,
1100: p_init_msg_list => p_init_msg_list,
1101: x_return_status => l_return_status,
1102: x_msg_count => x_msg_count,

Line 1113: 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);

1109: x_amount_tbl => x_amount_out_tbl,
1110: p_trx_header_id => x_sec_trx_tcnv_tbl(1).id);
1111:
1112: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1113: 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);
1114: END IF;
1115:
1116: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1117: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;