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_SINGLE_PMT_PKG dependencies on IBY_PAY_SERVICE_REQUESTS

Line 361: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

357: l_return_message VARCHAR2 (3000);
358: l_ret_status NUMBER;
359:
360: l_payreq_status VARCHAR2 (100);
361: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
362: l_is_duplicate BOOLEAN := TRUE;
363: l_module_name VARCHAR2(200) := G_PKG_NAME ||
364: '.submit_single_payment';
365:

Line 432: IBY_PAY_SERVICE_REQUESTS prq

428: err.transaction_error_id
429: FROM
430: IBY_TRANSACTION_ERRORS err,
431: IBY_DOCS_PAYABLE_ALL doc,
432: IBY_PAY_SERVICE_REQUESTS prq
433: WHERE
434: err.transaction_id = doc.document_payable_id AND
435: err.transaction_type = TRXN_TYPE_DOC AND
436: doc.payment_service_request_id = prq.payment_service_request_id AND

Line 452: IBY_PAY_SERVICE_REQUESTS prq

448: err.transaction_error_id
449: FROM
450: IBY_TRANSACTION_ERRORS err,
451: IBY_PAYMENTS_ALL pmt,
452: IBY_PAY_SERVICE_REQUESTS prq
453: WHERE
454: err.transaction_id = pmt.payment_id AND
455: err.transaction_type = TRXN_TYPE_PMT AND
456: pmt.payment_service_request_id = prq.payment_service_request_id AND

Line 473: IBY_PAY_SERVICE_REQUESTS prq

469: FROM
470: IBY_TRANSACTION_ERRORS err,
471: IBY_PAYMENTS_ALL pmt,
472: IBY_PAY_INSTRUCTIONS_ALL ins,
473: IBY_PAY_SERVICE_REQUESTS prq
474: WHERE
475: err.transaction_id = ins.payment_instruction_id AND
476: err.transaction_type = TRXN_TYPE_INS AND
477: pmt.payment_service_request_id = prq.payment_service_request_id AND

Line 577: * Insert payment request into IBY_PAY_SERVICE_REQUESTS

573:
574: /*
575: * STEP 1:
576: *
577: * Insert payment request into IBY_PAY_SERVICE_REQUESTS
578: * table and generate payment request id.
579: */
580: BEGIN
581:

Line 2194: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

2190: | NOTES:
2191: |
2192: *---------------------------------------------------------------------*/
2193: FUNCTION insert_payreq (
2194: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
2195: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
2196: call_app_pay_service_req_code%TYPE,
2197: p_internal_bank_account_id
2198: IN IBY_PAY_SERVICE_REQUESTS.

Line 2195: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

2191: |
2192: *---------------------------------------------------------------------*/
2193: FUNCTION insert_payreq (
2194: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
2195: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
2196: call_app_pay_service_req_code%TYPE,
2197: p_internal_bank_account_id
2198: IN IBY_PAY_SERVICE_REQUESTS.
2199: internal_bank_account_id%TYPE,

Line 2198: IN IBY_PAY_SERVICE_REQUESTS.

2194: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
2195: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
2196: call_app_pay_service_req_code%TYPE,
2197: p_internal_bank_account_id
2198: IN IBY_PAY_SERVICE_REQUESTS.
2199: internal_bank_account_id%TYPE,
2200: p_pay_process_profile_id
2201: IN IBY_PAY_SERVICE_REQUESTS.
2202: payment_profile_id%TYPE,

Line 2201: IN IBY_PAY_SERVICE_REQUESTS.

2197: p_internal_bank_account_id
2198: IN IBY_PAY_SERVICE_REQUESTS.
2199: internal_bank_account_id%TYPE,
2200: p_pay_process_profile_id
2201: IN IBY_PAY_SERVICE_REQUESTS.
2202: payment_profile_id%TYPE,
2203: p_is_manual_payment_flag IN VARCHAR2
2204: )
2205: RETURN NUMBER

Line 2208: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

2204: )
2205: RETURN NUMBER
2206: IS
2207:
2208: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
2209: l_module_name VARCHAR2(200) := G_PKG_NAME || '.insert_payreq';
2210:
2211: BEGIN
2212:

Line 2221: * Insert the payment request into IBY_PAY_SERVICE_REQUESTS

2217: print_debuginfo(l_module_name, 'Generated payment request id: '
2218: || l_payreq_id);
2219:
2220: /*
2221: * Insert the payment request into IBY_PAY_SERVICE_REQUESTS
2222: * table. Supply defaults for values not provided by the
2223: * calling app.
2224: */
2225: INSERT INTO IBY_PAY_SERVICE_REQUESTS (

Line 2225: INSERT INTO IBY_PAY_SERVICE_REQUESTS (

2221: * Insert the payment request into IBY_PAY_SERVICE_REQUESTS
2222: * table. Supply defaults for values not provided by the
2223: * calling app.
2224: */
2225: INSERT INTO IBY_PAY_SERVICE_REQUESTS (
2226: CALLING_APP_ID,
2227: CREATED_BY,
2228: CREATION_DATE,
2229: LAST_UPDATED_BY,

Line 2301: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

2297: | This method is only meant for single payments flow.
2298: |
2299: *---------------------------------------------------------------------*/
2300: PROCEDURE populateOutParams(
2301: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
2302: payment_service_request_id%TYPE,
2303: p_processing_type IN IBY_PAYMENT_PROFILES.processing_type%TYPE,
2304: x_num_printed_docs OUT NOCOPY NUMBER,
2305: x_payment_id OUT NOCOPY IBY_PAYMENTS_ALL.

Line 2539: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

2535: | NOTES:
2536: |
2537: *---------------------------------------------------------------------*/
2538: PROCEDURE retrieve_transaction_errors(
2539: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
2540: payment_service_request_id%TYPE,
2541: x_trxnErrorIdsTab IN OUT NOCOPY trxnErrorIdsTab
2542: )
2543: IS

Line 2557: IBY_PAY_SERVICE_REQUESTS prq

2553: err.transaction_error_id
2554: FROM
2555: IBY_TRANSACTION_ERRORS err,
2556: IBY_DOCS_PAYABLE_ALL doc,
2557: IBY_PAY_SERVICE_REQUESTS prq
2558: WHERE
2559: err.transaction_id = doc.document_payable_id AND
2560: err.transaction_type = TRXN_TYPE_DOC AND
2561: doc.payment_service_request_id = prq.payment_service_request_id AND

Line 2577: IBY_PAY_SERVICE_REQUESTS prq

2573: err.transaction_error_id
2574: FROM
2575: IBY_TRANSACTION_ERRORS err,
2576: IBY_PAYMENTS_ALL pmt,
2577: IBY_PAY_SERVICE_REQUESTS prq
2578: WHERE
2579: err.transaction_id = pmt.payment_id AND
2580: err.transaction_type = TRXN_TYPE_PMT AND
2581: pmt.payment_service_request_id = prq.payment_service_request_id AND

Line 2598: IBY_PAY_SERVICE_REQUESTS prq

2594: FROM
2595: IBY_TRANSACTION_ERRORS err,
2596: IBY_PAYMENTS_ALL pmt,
2597: IBY_PAY_INSTRUCTIONS_ALL ins,
2598: IBY_PAY_SERVICE_REQUESTS prq
2599: WHERE
2600: err.transaction_id = ins.payment_instruction_id AND
2601: err.transaction_type = TRXN_TYPE_INS AND
2602: pmt.payment_service_request_id = prq.payment_service_request_id AND