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_PAY_SERVICE_REQUESTS

Line 224: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

220: l_msg_count NUMBER;
221: l_msg_data VARCHAR2(4000);
222:
223: l_payreq_status VARCHAR2 (100);
224: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
225: l_req_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
226: l_is_duplicate BOOLEAN := TRUE;
227:
228: l_profile_attribs profileProcessAttribs;

Line 225: l_req_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

221: l_msg_data VARCHAR2(4000);
222:
223: l_payreq_status VARCHAR2 (100);
224: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
225: l_req_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
226: l_is_duplicate BOOLEAN := TRUE;
227:
228: l_profile_attribs profileProcessAttribs;
229: l_pmtInstrTab IBY_PAYINSTR_PUB.pmtInstrTabType;

Line 245: l_create_instrs_flag IBY_PAY_SERVICE_REQUESTS.

241:
242: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
243: '.submit_payment_process_request';
244:
245: l_create_instrs_flag IBY_PAY_SERVICE_REQUESTS.
246: create_pmt_instructions_flag%TYPE;
247:
248: l_payment_doc_id IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE;
249:

Line 248: l_payment_doc_id IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE;

244:
245: l_create_instrs_flag IBY_PAY_SERVICE_REQUESTS.
246: create_pmt_instructions_flag%TYPE;
247:
248: l_payment_doc_id IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE;
249:
250: /*
251: * This flag indicates to the payment re-creation flow whether
252: * payments were just created in the payment creation flow.

Line 499: * Insert payment request into IBY_PAY_SERVICE_REQUESTS

495:
496: /*
497: * STEP 1:
498: *
499: * Insert payment request into IBY_PAY_SERVICE_REQUESTS
500: * table and generate payment request id.
501: */
502: BEGIN
503:

Line 733: FROM iby_pay_service_requests

729: /* 7492186 */
730: BEGIN
731: SELECT payment_service_request_id
732: INTO l_req_id
733: FROM iby_pay_service_requests
734: WHERE payment_service_request_id = l_payreq_id
735: AND payment_service_request_status = l_payreq_status
736: FOR UPDATE SKIP LOCKED;
737:

Line 833: FROM iby_pay_service_requests

829: /* 7492186 */
830: BEGIN
831: SELECT payment_service_request_id
832: INTO l_req_id
833: FROM iby_pay_service_requests
834: WHERE payment_service_request_id = l_payreq_id
835: AND payment_service_request_status = l_payreq_status
836: FOR UPDATE SKIP LOCKED;
837:

Line 1088: FROM iby_pay_service_requests

1084: /* 7492186 */
1085: BEGIN
1086: SELECT payment_service_request_id
1087: INTO l_req_id
1088: FROM iby_pay_service_requests
1089: WHERE payment_service_request_id = l_payreq_id
1090: AND payment_service_request_status = l_payreq_status
1091: FOR UPDATE SKIP LOCKED;
1092:

Line 1235: IBY_PAY_SERVICE_REQUESTS

1231: * Update the request status in the database so that
1232: * it is visible to the payment creation module.
1233: */
1234: UPDATE
1235: IBY_PAY_SERVICE_REQUESTS
1236: SET
1237: payment_service_request_status =
1238: REQ_STATUS_RETRY_PMT_CREAT
1239: WHERE

Line 1404: IBY_PAY_SERVICE_REQUESTS

1400: * allowed it to proceed. No need to revalidate. Simply
1401: * change the request status to CREATED and exit.
1402: */
1403: UPDATE
1404: IBY_PAY_SERVICE_REQUESTS
1405: SET
1406: payment_service_request_status = REQ_STATUS_PMT_CRTD
1407: WHERE
1408: payment_service_request_id = l_payreq_id;

Line 1510: * we have to check the IBY_PAY_SERVICE_REQUESTS to get the

1506: *
1507: * If this is a re-run of the build program (e.g., after
1508: * user has reviewed proposed payments, the create
1509: * instructions flag would not be again passed in; instead
1510: * we have to check the IBY_PAY_SERVICE_REQUESTS to get the
1511: * original value for this flag).
1512: *
1513: * Use the retrieved value to determine whether to kick off
1514: * the PICP (Fix for bug 4746624).

Line 1529: IBY_PAY_SERVICE_REQUESTS

1525: NVL(create_pmt_instructions_flag, 'N')
1526: INTO
1527: l_create_instrs_flag
1528: FROM
1529: IBY_PAY_SERVICE_REQUESTS
1530: WHERE
1531: PAYMENT_SERVICE_REQUEST_ID = l_payreq_id
1532: ;
1533:

Line 1577: * we have to check the IBY_PAY_SERVICE_REQUESTS to get the

1573: *
1574: * If this is a re-run of the build program (e.g., after
1575: * user has reviewed proposed payments, the payment doc
1576: * id would not be again passed in; instead
1577: * we have to check the IBY_PAY_SERVICE_REQUESTS to get the
1578: * original value for this param).
1579: */
1580: IF (p_payment_document_id IS NULL) THEN
1581:

Line 1593: IBY_PAY_SERVICE_REQUESTS

1589: payment_document_id
1590: INTO
1591: l_payment_doc_id
1592: FROM
1593: IBY_PAY_SERVICE_REQUESTS
1594: WHERE
1595: PAYMENT_SERVICE_REQUEST_ID = l_payreq_id
1596: ;
1597:

Line 2334: p_status IN IBY_PAY_SERVICE_REQUESTS.PAYMENT_SERVICE_REQUEST_STATUS%type)

2330: | NOTES:
2331: |
2332: *---------------------------------------------------------------------*/
2333: FUNCTION get_payreq_list (
2334: p_status IN IBY_PAY_SERVICE_REQUESTS.PAYMENT_SERVICE_REQUEST_STATUS%type)
2335: RETURN payreq_tbl_type
2336: IS
2337:
2338: payreq_list payreq_tbl_type;

Line 2342: c_status IN IBY_PAY_SERVICE_REQUESTS.PAYMENT_SERVICE_REQUEST_STATUS%type)

2338: payreq_list payreq_tbl_type;
2339: l_module_name VARCHAR2(200) := G_PKG_NAME || '.get_payreq_list';
2340:
2341: CURSOR c_pay_req_list (
2342: c_status IN IBY_PAY_SERVICE_REQUESTS.PAYMENT_SERVICE_REQUEST_STATUS%type)
2343: IS
2344: SELECT
2345: payment_service_request_id
2346: FROM

Line 2347: IBY_PAY_SERVICE_REQUESTS

2343: IS
2344: SELECT
2345: payment_service_request_id
2346: FROM
2347: IBY_PAY_SERVICE_REQUESTS
2348: WHERE
2349: payment_service_request_status=c_status;
2350:
2351: BEGIN

Line 2386: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)

2382: | NOTES:
2383: |
2384: *---------------------------------------------------------------------*/
2385: FUNCTION get_payreq_status (
2386: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
2387: RETURN VARCHAR2
2388: IS
2389:
2390: l_payreq_status VARCHAR2(100);

Line 2401: IBY_PAY_SERVICE_REQUESTS

2397: payment_service_request_status
2398: INTO
2399: l_payreq_status
2400: FROM
2401: IBY_PAY_SERVICE_REQUESTS
2402: WHERE
2403: payment_service_request_id = l_payreq_id;
2404:
2405: RETURN l_payreq_status;

Line 2442: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)

2438: | NOTES:
2439: |
2440: *---------------------------------------------------------------------*/
2441: FUNCTION checkIfPmtsInModifiedStatus(
2442: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
2443: RETURN BOOLEAN
2444: IS
2445:
2446: l_ret_flag BOOLEAN := FALSE;

Line 2525: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)

2521: | NOTES:
2522: |
2523: *---------------------------------------------------------------------*/
2524: FUNCTION checkIfPmtsInModBankAccStatus(
2525: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
2526: RETURN BOOLEAN
2527: IS
2528:
2529: l_ret_flag BOOLEAN := FALSE;

Line 2607: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

2603: | NOTES:
2604: |
2605: *---------------------------------------------------------------------*/
2606: FUNCTION insert_payreq (
2607: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
2608: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
2609: call_app_pay_service_req_code%TYPE,
2610: p_internal_bank_account_id
2611: IN IBY_PAY_SERVICE_REQUESTS.

Line 2608: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

2604: |
2605: *---------------------------------------------------------------------*/
2606: FUNCTION insert_payreq (
2607: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
2608: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
2609: call_app_pay_service_req_code%TYPE,
2610: p_internal_bank_account_id
2611: IN IBY_PAY_SERVICE_REQUESTS.
2612: internal_bank_account_id%TYPE,

Line 2611: IN IBY_PAY_SERVICE_REQUESTS.

2607: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
2608: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
2609: call_app_pay_service_req_code%TYPE,
2610: p_internal_bank_account_id
2611: IN IBY_PAY_SERVICE_REQUESTS.
2612: internal_bank_account_id%TYPE,
2613: p_payment_profile_id
2614: IN IBY_PAY_SERVICE_REQUESTS.
2615: payment_profile_id%TYPE,

Line 2614: IN IBY_PAY_SERVICE_REQUESTS.

2610: p_internal_bank_account_id
2611: IN IBY_PAY_SERVICE_REQUESTS.
2612: internal_bank_account_id%TYPE,
2613: p_payment_profile_id
2614: IN IBY_PAY_SERVICE_REQUESTS.
2615: payment_profile_id%TYPE,
2616: p_allow_zero_payments_flag
2617: IN IBY_PAY_SERVICE_REQUESTS.
2618: allow_zero_payments_flag%TYPE,

Line 2617: IN IBY_PAY_SERVICE_REQUESTS.

2613: p_payment_profile_id
2614: IN IBY_PAY_SERVICE_REQUESTS.
2615: payment_profile_id%TYPE,
2616: p_allow_zero_payments_flag
2617: IN IBY_PAY_SERVICE_REQUESTS.
2618: allow_zero_payments_flag%TYPE,
2619: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
2620: maximum_payment_amount%TYPE,
2621: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.

Line 2619: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.

2615: payment_profile_id%TYPE,
2616: p_allow_zero_payments_flag
2617: IN IBY_PAY_SERVICE_REQUESTS.
2618: allow_zero_payments_flag%TYPE,
2619: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
2620: maximum_payment_amount%TYPE,
2621: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
2622: minimum_payment_amount%TYPE,
2623: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.

Line 2621: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.

2617: IN IBY_PAY_SERVICE_REQUESTS.
2618: allow_zero_payments_flag%TYPE,
2619: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
2620: maximum_payment_amount%TYPE,
2621: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
2622: minimum_payment_amount%TYPE,
2623: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
2624: document_rejection_level_code%TYPE,
2625: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.

Line 2623: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.

2619: p_maximum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
2620: maximum_payment_amount%TYPE,
2621: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
2622: minimum_payment_amount%TYPE,
2623: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
2624: document_rejection_level_code%TYPE,
2625: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
2626: payment_rejection_level_code%TYPE,
2627: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.

Line 2625: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.

2621: p_minimum_payment_amount IN IBY_PAY_SERVICE_REQUESTS.
2622: minimum_payment_amount%TYPE,
2623: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
2624: document_rejection_level_code%TYPE,
2625: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
2626: payment_rejection_level_code%TYPE,
2627: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
2628: require_prop_pmts_review_flag%TYPE,
2629: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.

Line 2627: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.

2623: p_doc_rej_level IN IBY_PAY_SERVICE_REQUESTS.
2624: document_rejection_level_code%TYPE,
2625: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
2626: payment_rejection_level_code%TYPE,
2627: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
2628: require_prop_pmts_review_flag%TYPE,
2629: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
2630: create_pmt_instructions_flag%TYPE,
2631: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.

Line 2629: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.

2625: p_pmt_rej_level IN IBY_PAY_SERVICE_REQUESTS.
2626: payment_rejection_level_code%TYPE,
2627: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
2628: require_prop_pmts_review_flag%TYPE,
2629: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
2630: create_pmt_instructions_flag%TYPE,
2631: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
2632: payment_document_id%TYPE,
2633: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.

Line 2631: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.

2627: p_revw_prop_pmts_flag IN IBY_PAY_SERVICE_REQUESTS.
2628: require_prop_pmts_review_flag%TYPE,
2629: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
2630: create_pmt_instructions_flag%TYPE,
2631: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
2632: payment_document_id%TYPE,
2633: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
2634: attribute_category%TYPE,
2635: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.

Line 2633: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.

2629: p_create_instrs_flag IN IBY_PAY_SERVICE_REQUESTS.
2630: create_pmt_instructions_flag%TYPE,
2631: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
2632: payment_document_id%TYPE,
2633: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
2634: attribute_category%TYPE,
2635: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
2636: attribute1%TYPE,
2637: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.

Line 2635: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.

2631: p_payment_document_id IN IBY_PAY_SERVICE_REQUESTS.
2632: payment_document_id%TYPE,
2633: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
2634: attribute_category%TYPE,
2635: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
2636: attribute1%TYPE,
2637: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
2638: attribute2%TYPE,
2639: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.

Line 2637: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.

2633: p_attribute_category IN IBY_PAY_SERVICE_REQUESTS.
2634: attribute_category%TYPE,
2635: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
2636: attribute1%TYPE,
2637: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
2638: attribute2%TYPE,
2639: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
2640: attribute3%TYPE,
2641: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.

Line 2639: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.

2635: p_attribute1 IN IBY_PAY_SERVICE_REQUESTS.
2636: attribute1%TYPE,
2637: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
2638: attribute2%TYPE,
2639: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
2640: attribute3%TYPE,
2641: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
2642: attribute4%TYPE,
2643: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.

Line 2641: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.

2637: p_attribute2 IN IBY_PAY_SERVICE_REQUESTS.
2638: attribute2%TYPE,
2639: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
2640: attribute3%TYPE,
2641: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
2642: attribute4%TYPE,
2643: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
2644: attribute5%TYPE,
2645: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.

Line 2643: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.

2639: p_attribute3 IN IBY_PAY_SERVICE_REQUESTS.
2640: attribute3%TYPE,
2641: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
2642: attribute4%TYPE,
2643: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
2644: attribute5%TYPE,
2645: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
2646: attribute6%TYPE,
2647: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.

Line 2645: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.

2641: p_attribute4 IN IBY_PAY_SERVICE_REQUESTS.
2642: attribute4%TYPE,
2643: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
2644: attribute5%TYPE,
2645: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
2646: attribute6%TYPE,
2647: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
2648: attribute7%TYPE,
2649: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.

Line 2647: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.

2643: p_attribute5 IN IBY_PAY_SERVICE_REQUESTS.
2644: attribute5%TYPE,
2645: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
2646: attribute6%TYPE,
2647: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
2648: attribute7%TYPE,
2649: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
2650: attribute8%TYPE,
2651: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.

Line 2649: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.

2645: p_attribute6 IN IBY_PAY_SERVICE_REQUESTS.
2646: attribute6%TYPE,
2647: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
2648: attribute7%TYPE,
2649: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
2650: attribute8%TYPE,
2651: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
2652: attribute9%TYPE,
2653: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.

Line 2651: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.

2647: p_attribute7 IN IBY_PAY_SERVICE_REQUESTS.
2648: attribute7%TYPE,
2649: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
2650: attribute8%TYPE,
2651: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
2652: attribute9%TYPE,
2653: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
2654: attribute10%TYPE,
2655: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.

Line 2653: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.

2649: p_attribute8 IN IBY_PAY_SERVICE_REQUESTS.
2650: attribute8%TYPE,
2651: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
2652: attribute9%TYPE,
2653: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
2654: attribute10%TYPE,
2655: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
2656: attribute11%TYPE,
2657: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.

Line 2655: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.

2651: p_attribute9 IN IBY_PAY_SERVICE_REQUESTS.
2652: attribute9%TYPE,
2653: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
2654: attribute10%TYPE,
2655: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
2656: attribute11%TYPE,
2657: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
2658: attribute12%TYPE,
2659: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.

Line 2657: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.

2653: p_attribute10 IN IBY_PAY_SERVICE_REQUESTS.
2654: attribute10%TYPE,
2655: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
2656: attribute11%TYPE,
2657: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
2658: attribute12%TYPE,
2659: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
2660: attribute13%TYPE,
2661: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.

Line 2659: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.

2655: p_attribute11 IN IBY_PAY_SERVICE_REQUESTS.
2656: attribute11%TYPE,
2657: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
2658: attribute12%TYPE,
2659: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
2660: attribute13%TYPE,
2661: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
2662: attribute14%TYPE,
2663: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.

Line 2661: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.

2657: p_attribute12 IN IBY_PAY_SERVICE_REQUESTS.
2658: attribute12%TYPE,
2659: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
2660: attribute13%TYPE,
2661: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
2662: attribute14%TYPE,
2663: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.
2664: attribute15%TYPE
2665: )

Line 2663: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.

2659: p_attribute13 IN IBY_PAY_SERVICE_REQUESTS.
2660: attribute13%TYPE,
2661: p_attribute14 IN IBY_PAY_SERVICE_REQUESTS.
2662: attribute14%TYPE,
2663: p_attribute15 IN IBY_PAY_SERVICE_REQUESTS.
2664: attribute15%TYPE
2665: )
2666: RETURN NUMBER
2667: IS

Line 2669: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

2665: )
2666: RETURN NUMBER
2667: IS
2668:
2669: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
2670: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.insert_payreq';
2671:
2672: BEGIN
2673:

Line 2682: * Insert the payment request into IBY_PAY_SERVICE_REQUESTS

2678: print_debuginfo(l_module_name, 'Generated payment request id: '
2679: || l_payreq_id);
2680:
2681: /*
2682: * Insert the payment request into IBY_PAY_SERVICE_REQUESTS
2683: * table. Supply defaults for values not provided by the
2684: * calling app.
2685: */
2686: INSERT INTO IBY_PAY_SERVICE_REQUESTS (

Line 2686: INSERT INTO IBY_PAY_SERVICE_REQUESTS (

2682: * Insert the payment request into IBY_PAY_SERVICE_REQUESTS
2683: * table. Supply defaults for values not provided by the
2684: * calling app.
2685: */
2686: INSERT INTO IBY_PAY_SERVICE_REQUESTS (
2687: CALLING_APP_ID,
2688: CREATED_BY,
2689: CREATION_DATE,
2690: LAST_UPDATED_BY,

Line 2809: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

2805: | NOTES:
2806: |
2807: *---------------------------------------------------------------------*/
2808: FUNCTION checkIfDuplicate(
2809: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
2810: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
2811: call_app_pay_service_req_code%TYPE
2812: )
2813: RETURN NUMBER

Line 2810: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

2806: |
2807: *---------------------------------------------------------------------*/
2808: FUNCTION checkIfDuplicate(
2809: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
2810: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
2811: call_app_pay_service_req_code%TYPE
2812: )
2813: RETURN NUMBER
2814: IS

Line 2815: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

2811: call_app_pay_service_req_code%TYPE
2812: )
2813: RETURN NUMBER
2814: IS
2815: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
2816: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.checkIfDuplicate';
2817: BEGIN
2818:
2819: print_debuginfo(l_module_name, 'ENTER');

Line 2828: IBY_PAY_SERVICE_REQUESTS

2824: */
2825: SELECT
2826: payment_service_request_id INTO l_payreq_id
2827: FROM
2828: IBY_PAY_SERVICE_REQUESTS
2829: WHERE
2830: calling_app_id = p_calling_app_id
2831: AND
2832: call_app_pay_service_req_code = p_calling_app_payreq_cd;

Line 3428: SELECT IBY_PAY_SERVICE_REQUESTS_S.nextval INTO l_payreq_id

3424: l_payreq_id NUMBER(15);
3425:
3426: BEGIN
3427:
3428: SELECT IBY_PAY_SERVICE_REQUESTS_S.nextval INTO l_payreq_id
3429: FROM DUAL;
3430:
3431: RETURN l_payreq_id;
3432:

Line 3456: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

3452: | NOTES:
3453: |
3454: *---------------------------------------------------------------------*/
3455: FUNCTION insert_payreq_documents (
3456: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
3457: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
3458: call_app_pay_service_req_code%TYPE,
3459: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
3460: payment_service_request_id%TYPE

Line 3457: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

3453: |
3454: *---------------------------------------------------------------------*/
3455: FUNCTION insert_payreq_documents (
3456: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
3457: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
3458: call_app_pay_service_req_code%TYPE,
3459: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
3460: payment_service_request_id%TYPE
3461: )

Line 3459: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

3455: FUNCTION insert_payreq_documents (
3456: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
3457: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
3458: call_app_pay_service_req_code%TYPE,
3459: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
3460: payment_service_request_id%TYPE
3461: )
3462: RETURN NUMBER
3463: IS

Line 4230: IBY_PAY_SERVICE_REQUESTS

4226: * If the documents were inserted successfully, update the
4227: * status of the payment request to 'submitted'.
4228: */
4229: UPDATE
4230: IBY_PAY_SERVICE_REQUESTS
4231: SET
4232: payment_service_request_status = REQ_STATUS_SUBMITTED
4233: WHERE
4234: payment_service_request_id = p_payreq_id;

Line 4772: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

4768: | NOTES:
4769: |
4770: *---------------------------------------------------------------------*/
4771: PROCEDURE launchPPRStatusReport(
4772: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
4773: payment_service_request_id%TYPE
4774: )
4775: IS
4776: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 4783: l_ca_payreq_cd IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE;

4779: l_report_format IBY_INTERNAL_PAYERS_ALL.ppr_report_format%TYPE;
4780: l_report_flag IBY_INTERNAL_PAYERS_ALL.automatic_ppr_report_submit%TYPE;
4781:
4782: l_app_short_name VARCHAR2(200);
4783: l_ca_payreq_cd IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE;
4784: l_ca_id IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE;
4785: l_conc_req_id NUMBER(15);
4786:
4787: l_bool_val BOOLEAN; -- Bug 6411356

Line 4784: l_ca_id IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE;

4780: l_report_flag IBY_INTERNAL_PAYERS_ALL.automatic_ppr_report_submit%TYPE;
4781:
4782: l_app_short_name VARCHAR2(200);
4783: l_ca_payreq_cd IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE;
4784: l_ca_id IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE;
4785: l_conc_req_id NUMBER(15);
4786:
4787: l_bool_val BOOLEAN; -- Bug 6411356
4788:

Line 4849: IBY_PAY_SERVICE_REQUESTS req

4845: INTO
4846: l_app_short_name
4847: FROM
4848: FND_APPLICATION fnd,
4849: IBY_PAY_SERVICE_REQUESTS req
4850: WHERE
4851: fnd.application_id = req.calling_app_id AND
4852: req.payment_service_request_id = p_payreq_id
4853: ;