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 362: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

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

Line 435: IBY_PAY_SERVICE_REQUESTS prq

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

Line 455: IBY_PAY_SERVICE_REQUESTS prq

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

Line 476: IBY_PAY_SERVICE_REQUESTS prq

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

Line 588: * Insert payment request into IBY_PAY_SERVICE_REQUESTS

584: END IF;
585: /*
586: * STEP 1:
587: *
588: * Insert payment request into IBY_PAY_SERVICE_REQUESTS
589: * table and generate payment request id.
590: */
591: BEGIN
592:

Line 2415: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

2411: | NOTES:
2412: |
2413: *---------------------------------------------------------------------*/
2414: FUNCTION insert_payreq (
2415: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
2416: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
2417: call_app_pay_service_req_code%TYPE,
2418: p_internal_bank_account_id
2419: IN IBY_PAY_SERVICE_REQUESTS.

Line 2416: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

2412: |
2413: *---------------------------------------------------------------------*/
2414: FUNCTION insert_payreq (
2415: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
2416: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
2417: call_app_pay_service_req_code%TYPE,
2418: p_internal_bank_account_id
2419: IN IBY_PAY_SERVICE_REQUESTS.
2420: internal_bank_account_id%TYPE,

Line 2419: IN IBY_PAY_SERVICE_REQUESTS.

2415: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
2416: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
2417: call_app_pay_service_req_code%TYPE,
2418: p_internal_bank_account_id
2419: IN IBY_PAY_SERVICE_REQUESTS.
2420: internal_bank_account_id%TYPE,
2421: p_pay_process_profile_id
2422: IN IBY_PAY_SERVICE_REQUESTS.
2423: payment_profile_id%TYPE,

Line 2422: IN IBY_PAY_SERVICE_REQUESTS.

2418: p_internal_bank_account_id
2419: IN IBY_PAY_SERVICE_REQUESTS.
2420: internal_bank_account_id%TYPE,
2421: p_pay_process_profile_id
2422: IN IBY_PAY_SERVICE_REQUESTS.
2423: payment_profile_id%TYPE,
2424: p_is_manual_payment_flag IN VARCHAR2
2425: )
2426: RETURN NUMBER

Line 2429: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

2425: )
2426: RETURN NUMBER
2427: IS
2428:
2429: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
2430: l_module_name VARCHAR2(200) := G_PKG_NAME || '.insert_payreq';
2431:
2432: BEGIN
2433:

Line 2446: * Insert the payment request into IBY_PAY_SERVICE_REQUESTS

2442: || l_payreq_id);
2443:
2444: END IF;
2445: /*
2446: * Insert the payment request into IBY_PAY_SERVICE_REQUESTS
2447: * table. Supply defaults for values not provided by the
2448: * calling app.
2449: */
2450: INSERT INTO IBY_PAY_SERVICE_REQUESTS (

Line 2450: INSERT INTO IBY_PAY_SERVICE_REQUESTS (

2446: * Insert the payment request into IBY_PAY_SERVICE_REQUESTS
2447: * table. Supply defaults for values not provided by the
2448: * calling app.
2449: */
2450: INSERT INTO IBY_PAY_SERVICE_REQUESTS (
2451: CALLING_APP_ID,
2452: CREATED_BY,
2453: CREATION_DATE,
2454: LAST_UPDATED_BY,

Line 2532: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

2528: | This method is only meant for single payments flow.
2529: |
2530: *---------------------------------------------------------------------*/
2531: PROCEDURE populateOutParams(
2532: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
2533: payment_service_request_id%TYPE,
2534: p_processing_type IN IBY_PAYMENT_PROFILES.processing_type%TYPE,
2535: x_num_printed_docs OUT NOCOPY NUMBER,
2536: x_payment_id OUT NOCOPY IBY_PAYMENTS_ALL.

Line 2794: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

2790: | NOTES:
2791: |
2792: *---------------------------------------------------------------------*/
2793: PROCEDURE retrieve_transaction_errors(
2794: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
2795: payment_service_request_id%TYPE,
2796: x_trxnErrorIdsTab IN OUT NOCOPY trxnErrorIdsTab
2797: )
2798: IS

Line 2812: IBY_PAY_SERVICE_REQUESTS prq

2808: err.transaction_error_id
2809: FROM
2810: IBY_TRANSACTION_ERRORS err,
2811: IBY_DOCS_PAYABLE_ALL doc,
2812: IBY_PAY_SERVICE_REQUESTS prq
2813: WHERE
2814: err.transaction_id = doc.document_payable_id AND
2815: err.transaction_type = TRXN_TYPE_DOC AND
2816: doc.payment_service_request_id = prq.payment_service_request_id AND

Line 2832: IBY_PAY_SERVICE_REQUESTS prq

2828: err.transaction_error_id
2829: FROM
2830: IBY_TRANSACTION_ERRORS err,
2831: IBY_PAYMENTS_ALL pmt,
2832: IBY_PAY_SERVICE_REQUESTS prq
2833: WHERE
2834: err.transaction_id = pmt.payment_id AND
2835: err.transaction_type = TRXN_TYPE_PMT AND
2836: pmt.payment_service_request_id = prq.payment_service_request_id AND

Line 2853: IBY_PAY_SERVICE_REQUESTS prq

2849: FROM
2850: IBY_TRANSACTION_ERRORS err,
2851: IBY_PAYMENTS_ALL pmt,
2852: IBY_PAY_INSTRUCTIONS_ALL ins,
2853: IBY_PAY_SERVICE_REQUESTS prq
2854: WHERE
2855: err.transaction_id = ins.payment_instruction_id AND
2856: err.transaction_type = TRXN_TYPE_INS AND
2857: pmt.payment_service_request_id = prq.payment_service_request_id AND