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.IBY_PAYGROUP_PUB dependencies on IBY_DOCS_IN_PMT_GT

Line 5412: INSERT INTO iby_docs_in_pmt_gt

5408: END IF;
5409:
5410: END LOOP; -- for documents cursor
5411: FORALL l_trx_line_index IN nvl(iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code.FIRST,0) .. nvl(iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code.LAST,-99)
5412: INSERT INTO iby_docs_in_pmt_gt
5413: (
5414: pay_proc_trxn_type_code,
5415: calling_app_id,
5416: document_payable_id,

Line 9514: USING iby_docs_in_pmt_gt idpt ON(idpt.document_payable_id = idpa.document_payable_id)

9510: */
9511: MERGE
9512: INTO iby_docs_payable_all idpa
9513: /* Oracle 10gR2 doesn't require WHEN NOT MATCHED */
9514: USING iby_docs_in_pmt_gt idpt ON(idpt.document_payable_id = idpa.document_payable_id)
9515: WHEN MATCHED THEN UPDATE
9516: SET idpa.payment_id = idpt.payment_id,
9517: idpa.formatting_payment_id = idpt.payment_id,
9518: idpa.document_status = idpt.document_status,

Line 12316: FROM iby_docs_in_pmt_gt src, iby_hook_payments_t ihpt

12312: src.LAST_UPDATED_BY,
12313: src.LAST_UPDATE_DATE,
12314: src.LAST_UPDATE_LOGIN,
12315: src.OBJECT_VERSION_NUMBER
12316: FROM iby_docs_in_pmt_gt src, iby_hook_payments_t ihpt
12317: WHERE src.payment_id = ihpt.payment_id
12318: AND src.document_status = DOC_STATUS_PAY_CREATED;
12319:
12320: l_DocsInPmtCount := SQL%ROWCOUNT;

Line 13003: FROM iby_docs_in_pmt_gt idpt

12999: idpt.calling_app_doc_unique_ref5,
13000: idpt.pay_proc_trxn_type_code,
13001: idpt.document_amount,
13002: idpt.payment_grouping_number
13003: FROM iby_docs_in_pmt_gt idpt
13004: WHERE idpt.document_payable_id in (SELECT idpa.document_payable_id from iby_hook_docs_in_pmt_t idpa
13005: WHERE idpa.dont_pay_flag = 'Y');
13006: CURSOR c_failed_documents
13007: IS

Line 13012: FROM iby_hook_docs_in_pmt_t ihdp, iby_docs_in_pmt_gt idip

13008: SELECT ihdp.document_payable_id,
13009: ihdp.document_amount,
13010: ihdp.amount_withheld,
13011: ihdp.dont_pay_flag
13012: FROM iby_hook_docs_in_pmt_t ihdp, iby_docs_in_pmt_gt idip
13013: WHERE ihdp.document_payable_id = idip.document_payable_id
13014: AND (ihdp.document_amount <> idip.document_amount
13015: OR ihdp.amount_withheld <> idip.amount_withheld
13016: OR ihdp.dont_pay_flag <> idip.dont_pay_flag);

Line 13280: FROM iby_docs_in_pmt_gt

13276:
13277: l_docsingt_count :=0;
13278: SELECT COUNT(*)
13279: INTO l_docsingt_count
13280: FROM iby_docs_in_pmt_gt
13281: WHERE document_status = DOC_STATUS_PAY_CREATED;
13282: IF (l_DocsInPmtCount <> l_docsingt_count) THEN
13283:
13284:

Line 13524: INTO iby_docs_in_pmt_gt idpa

13520: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13521: print_debuginfo(l_module_name, 'Before merge.. ' );
13522: END IF;
13523: MERGE
13524: INTO iby_docs_in_pmt_gt idpa
13525: USING iby_hook_docs_in_pmt_t idpt ON(idpt.document_payable_id = idpa.document_payable_id)
13526: WHEN MATCHED THEN UPDATE
13527: SET idpa.document_amount = idpt.document_amount,
13528: idpa.amount_withheld = idpt.amount_withheld,

Line 13541: UPDATE iby_docs_in_pmt_gt idpa

13537: */
13538: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13539: print_debuginfo(l_module_name, 'Before updating the GT table' );
13540: END IF;
13541: UPDATE iby_docs_in_pmt_gt idpa
13542: SET idpa.document_status = DOC_STATUS_CA_FAILED
13543: WHERE idpa.document_payable_id IN (SELECT document_payable_id from iby_hook_docs_in_pmt_t idpt
13544: WHERE idpt.dont_pay_flag = 'Y');
13545:

Line 13853: FROM iby_docs_in_pmt_gt idpt

13849: idpt.calling_app_doc_unique_ref5,
13850: idpt.pay_proc_trxn_type_code,
13851: idpt.document_amount,
13852: idpt.payment_grouping_number
13853: FROM iby_docs_in_pmt_gt idpt
13854: WHERE idpt.payment_grouping_number IS NOT NULL
13855: AND idpt.document_status <> DOC_STATUS_RELN_FAIL
13856: AND EXISTS (SELECT 1 FROM iby_docs_in_pmt_gt idpit WHERE idpit.payment_grouping_number IS NOT NULL
13857: AND idpit.payment_grouping_number = idpt.payment_grouping_number

Line 13856: AND EXISTS (SELECT 1 FROM iby_docs_in_pmt_gt idpit WHERE idpit.payment_grouping_number IS NOT NULL

13852: idpt.payment_grouping_number
13853: FROM iby_docs_in_pmt_gt idpt
13854: WHERE idpt.payment_grouping_number IS NOT NULL
13855: AND idpt.document_status <> DOC_STATUS_RELN_FAIL
13856: AND EXISTS (SELECT 1 FROM iby_docs_in_pmt_gt idpit WHERE idpit.payment_grouping_number IS NOT NULL
13857: AND idpit.payment_grouping_number = idpt.payment_grouping_number
13858: AND idpit.document_status <> DOC_STATUS_PAY_CREATED
13859: AND idpit.document_status <> DOC_STATUS_RELN_FAIL)
13860: ORDER BY idpt.payment_grouping_number, idpt.payment_id;

Line 13914: UPDATE iby_docs_in_pmt_gt idipt

13910: END IF;
13911:
13912: IF(l_fail_dop_tbl(j).payment_grouping_number <> l_prev_payment_grp_num) THEN
13913:
13914: UPDATE iby_docs_in_pmt_gt idipt
13915: SET idipt.document_status = DOC_STATUS_RELN_FAIL
13916: WHERE idipt.payment_grouping_number = l_fail_dop_tbl(j).payment_grouping_number
13917: AND idipt.document_status = DOC_STATUS_PAY_CREATED;
13918: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 14082: FROM iby_docs_in_pmt_gt idpt

14078: idpt.calling_app_doc_unique_ref5,
14079: idpt.pay_proc_trxn_type_code,
14080: idpt.document_amount,
14081: idpt.payment_grouping_number
14082: FROM iby_docs_in_pmt_gt idpt
14083: WHERE idpt.payment_grouping_number IS NOT NULL
14084: AND idpt.document_status <> DOC_STATUS_RELN_FAIL
14085: AND EXISTS (SELECT 1 FROM iby_docs_in_pmt_gt idpit WHERE idpit.payment_grouping_number IS NOT NULL
14086: AND idpit.payment_grouping_number = idpt.payment_grouping_number

Line 14085: AND EXISTS (SELECT 1 FROM iby_docs_in_pmt_gt idpit WHERE idpit.payment_grouping_number IS NOT NULL

14081: idpt.payment_grouping_number
14082: FROM iby_docs_in_pmt_gt idpt
14083: WHERE idpt.payment_grouping_number IS NOT NULL
14084: AND idpt.document_status <> DOC_STATUS_RELN_FAIL
14085: AND EXISTS (SELECT 1 FROM iby_docs_in_pmt_gt idpit WHERE idpit.payment_grouping_number IS NOT NULL
14086: AND idpit.payment_grouping_number = idpt.payment_grouping_number
14087: AND idpit.document_status <> DOC_STATUS_PAY_CREATED
14088: AND idpit.document_status <> DOC_STATUS_RELN_FAIL)
14089: ORDER BY idpt.payment_grouping_number, idpt.payment_id;

Line 14125: UPDATE iby_docs_in_pmt_gt idipt

14121: END IF;
14122:
14123: IF(l_fail_dop_tbl(j).payment_grouping_number <> l_prev_payment_grp_num) THEN
14124:
14125: UPDATE iby_docs_in_pmt_gt idipt
14126: SET idipt.document_status = DOC_STATUS_RELN_FAIL
14127: WHERE idipt.payment_grouping_number = l_fail_dop_tbl(j).payment_grouping_number
14128: AND idipt.document_status = DOC_STATUS_PAY_CREATED;
14129:

Line 15718: FROM iby_docs_in_pmt_gt idpt

15714: idpt.calling_app_doc_unique_ref5,
15715: idpt.pay_proc_trxn_type_code,
15716: idpt.document_amount,
15717: idpt.payment_grouping_number
15718: FROM iby_docs_in_pmt_gt idpt
15719: WHERE idpt.payment_id = p_paymentId;
15720:
15721: BEGIN
15722:

Line 15750: UPDATE iby_docs_in_pmt_gt

15746: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
15747: print_debuginfo(l_module_name, 'Condition satisfied');
15748: END IF;
15749:
15750: UPDATE iby_docs_in_pmt_gt
15751: SET document_status = p_docStatus
15752: WHERE document_payable_id = l_fail_dop_tbl(j).document_payable_id;
15753:
15754: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 16532: FROM iby_docs_in_pmt_gt

16528: l_successDocCountRec.success_docs_count := 0;
16529:
16530: SELECT count(*)
16531: INTO l_successDocCountRec.success_docs_count
16532: FROM iby_docs_in_pmt_gt
16533: WHERE payment_id = x_paymentTab(i).payment_id
16534: AND document_status = DOC_STATUS_PAY_CREATED;
16535:
16536: /*

Line 20851: from iby_docs_in_pmt_gt

20847:
20848: BEGIN
20849: select min(discount_date)
20850: into l_temp_discount_date
20851: from iby_docs_in_pmt_gt
20852: where payment_id = IBY_PAYGROUP_PUB.pmtTable.payment_id(p_trx_mat_index)
20853: AND discount_date is not null
20854: AND discount_date >= IBY_PAYGROUP_PUB.pmtTable.payment_date(p_trx_mat_index);
20855: EXCEPTION

Line 20893: into l_temp_due_date from iby_docs_in_pmt_gt

20889: IF (l_maturity_date_set_flag = FALSE) THEN
20890:
20891: BEGIN
20892: select min(payment_due_date)
20893: into l_temp_due_date from iby_docs_in_pmt_gt
20894: where payment_id = IBY_PAYGROUP_PUB.pmtTable.payment_id(p_trx_mat_index)
20895: AND payment_due_date is not null
20896: AND payment_due_date >= IBY_PAYGROUP_PUB.pmtTable.payment_date(p_trx_mat_index);
20897: EXCEPTION

Line 22885: INSERT INTO iby_docs_in_pmt_gt(

22881: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
22882: print_debuginfo(l_module_name, 'ENTER');
22883: END IF;
22884:
22885: INSERT INTO iby_docs_in_pmt_gt(
22886: payment_id,
22887: document_payable_id,
22888: calling_app_id,
22889: calling_app_doc_unique_ref1,

Line 23023: FROM iby_docs_in_pmt_gt

23019:
23020:
23021: l_pmt_amount := 0;
23022: SELECT SUM(document_amount) into l_pmt_amount
23023: FROM iby_docs_in_pmt_gt
23024: WHERE payment_id = l_paymentTab(i).payment_id;
23025:
23026:
23027: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN