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_DISBURSE_SUBMIT_PUB_PKG dependencies on IBY_DOCS_PAYABLE_ALL

Line 329: FROM iby_docs_payable_all

325: l_pmts_invalid_pdoc NUMBER;
326:
327: CURSOR get_distinct_ppps(l_payrequest_id NUMBER) IS
328: SELECT DISTINCT payment_profile_id, internal_bank_account_id /*Internal Bank Account ID Added for Bug 14122666*/
329: FROM iby_docs_payable_all
330: WHERE payment_service_request_id = l_payrequest_id;
331:
332: /*
333: * Implementing the callout is optional for the calling app.

Line 716: * IBY_DOCS_PAYABLE_ALL table.

712: /*
713: * STEP 2:
714: *
715: * Insert the documents of this payment request into the
716: * IBY_DOCS_PAYABLE_ALL table.
717: */
718:
719: BEGIN
720:

Line 1139: IBY_DOCS_PAYABLE_ALL

1135: || l_payreq_id);
1136:
1137: END IF;
1138: UPDATE
1139: IBY_DOCS_PAYABLE_ALL
1140: SET
1141: document_status = DOC_STATUS_RDY_FOR_VAL
1142: WHERE
1143: payment_service_request_id = l_payreq_id AND

Line 2106: FROM iby_docs_payable_all

2102: SELECT COUNT(*) distinct_ppp_count
2103: INTO l_distinct_ppp_count
2104: FROM
2105: ( SELECT DISTINCT payment_profile_id
2106: FROM iby_docs_payable_all
2107: WHERE payment_service_request_id = l_payreq_id
2108: ) distinctppp;
2109:
2110: -- If single distinct PPP found, we stamp it on the PPR header

Line 2121: FROM iby_docs_payable_all

2117:
2118: -- Pick a sample PPP, this should be the single distinct PPP.
2119: SELECT payment_profile_id
2120: INTO l_distinct_ppp
2121: FROM iby_docs_payable_all
2122: WHERE payment_service_request_id = l_payreq_id
2123: AND ROWNUM = 1 ;
2124:
2125: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4324: || 'IBY_DOCS_PAYABLE_ALL_S.nextval, '

4320: || 'calling_app_doc_unique_ref4, '
4321: || 'calling_app_doc_unique_ref5, '
4322: || 'calling_app_doc_ref_number, '
4323: || 'call_app_pay_service_req_code, '
4324: || 'IBY_DOCS_PAYABLE_ALL_S.nextval, '
4325: || 'payment_function, '
4326: || 'payment_date, '
4327: || 'document_date, '
4328: || 'document_type, '

Line 4570: * IBY_DOCS_PAYABLE_ALL into a PLSQL record structure.

4566:
4567: END IF;
4568: /*
4569: * Populate rest of the document attributes required in the table
4570: * IBY_DOCS_PAYABLE_ALL into a PLSQL record structure.
4571: * We will use this structure in doing a bulk insert into the
4572: * IBY_DOCS_PAYABLE_ALL table.
4573: */
4574: iby_disburse_submit_pub_pkg.docspayTab.payment_service_request_id(l_trx_line_index)

Line 4572: * IBY_DOCS_PAYABLE_ALL table.

4568: /*
4569: * Populate rest of the document attributes required in the table
4570: * IBY_DOCS_PAYABLE_ALL into a PLSQL record structure.
4571: * We will use this structure in doing a bulk insert into the
4572: * IBY_DOCS_PAYABLE_ALL table.
4573: */
4574: iby_disburse_submit_pub_pkg.docspayTab.payment_service_request_id(l_trx_line_index)
4575: := p_payreq_id;
4576: -- iby_disburse_submit_pub_pkg.docspayTab.document_payable_id

Line 4580: -- into the IBY_DOCS_PAYABLE_ALL table.

4576: -- iby_disburse_submit_pub_pkg.docspayTab.document_payable_id
4577: -- := getNextDocumentPayableID();
4578: --
4579: -- Set document status ot 'submitted' when docs are first inserted
4580: -- into the IBY_DOCS_PAYABLE_ALL table.
4581: --
4582: iby_disburse_submit_pub_pkg.docspayTab.document_status(l_trx_line_index) := DOC_STATUS_SUBMITTED;
4583:
4584: iby_disburse_submit_pub_pkg.docspayTab.exclusive_payment_flag(l_trx_line_index)

Line 4657: * Insert document info in IBY_DOCS_PAYABLE_ALL

4653:
4654: END LOOP; -- for limited set of documents fetched
4655:
4656: /*
4657: * Insert document info in IBY_DOCS_PAYABLE_ALL
4658: */
4659: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4660: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4661: print_debuginfo(l_module_name, 'Before insert ' );

Line 4793: INSERT INTO IBY_DOCS_PAYABLE_ALL

4789: END IF;
4790: /* CHANGE FOR BUG : 14348326 - START */
4791: 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) SAVE EXCEPTIONS
4792: /* CHANGE FOR BUG : 14348326 - END */
4793: INSERT INTO IBY_DOCS_PAYABLE_ALL
4794: (
4795: pay_proc_trxn_type_code,
4796: calling_app_id,
4797: calling_app_doc_ref_number,

Line 5044: || ' documents into IBY_DOCS_PAYABLE_ALL'

5040: );
5041:
5042: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5043: print_debuginfo(l_module_name, 'Finished inserting'
5044: || ' documents into IBY_DOCS_PAYABLE_ALL'
5045: || ' table');
5046:
5047: END IF;
5048: EXIT WHEN l_docs_cursor%NOTFOUND;

Line 5177: l_docPayID IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;

5173: FUNCTION getNextDocumentPayableID
5174: RETURN NUMBER
5175: IS
5176:
5177: l_docPayID IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
5178:
5179: BEGIN
5180:
5181: SELECT IBY_DOCS_PAYABLE_ALL_S.nextval INTO l_docPayID

Line 5181: SELECT IBY_DOCS_PAYABLE_ALL_S.nextval INTO l_docPayID

5177: l_docPayID IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
5178:
5179: BEGIN
5180:
5181: SELECT IBY_DOCS_PAYABLE_ALL_S.nextval INTO l_docPayID
5182: FROM DUAL;
5183:
5184: RETURN l_docPayID;
5185:

Line 5242: p_payreq_id IN IBY_DOCS_PAYABLE_ALL.payment_service_request_id

5238: | NOTES:
5239: |
5240: *---------------------------------------------------------------------*/
5241: PROCEDURE deriveDistinctAccessTypsForReq(
5242: p_payreq_id IN IBY_DOCS_PAYABLE_ALL.payment_service_request_id
5243: %TYPE,
5244: p_pmt_function IN IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
5245: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
5246: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

Line 5244: p_pmt_function IN IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,

5240: *---------------------------------------------------------------------*/
5241: PROCEDURE deriveDistinctAccessTypsForReq(
5242: p_payreq_id IN IBY_DOCS_PAYABLE_ALL.payment_service_request_id
5243: %TYPE,
5244: p_pmt_function IN IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
5245: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
5246: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
5247: x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
5248: x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab

Line 5245: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

5241: PROCEDURE deriveDistinctAccessTypsForReq(
5242: p_payreq_id IN IBY_DOCS_PAYABLE_ALL.payment_service_request_id
5243: %TYPE,
5244: p_pmt_function IN IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
5245: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
5246: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
5247: x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
5248: x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab
5249: )

Line 5246: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

5242: p_payreq_id IN IBY_DOCS_PAYABLE_ALL.payment_service_request_id
5243: %TYPE,
5244: p_pmt_function IN IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
5245: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
5246: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
5247: x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
5248: x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab
5249: )
5250: IS