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

Line 813: IBY_PAY_SERVICE_REQUESTS req

809: l_app_short_name
810: FROM
811: FND_APPLICATION fnd,
812: IBY_PAYMENTS_ALL pmt,
813: IBY_PAY_SERVICE_REQUESTS req
814: WHERE
815: fnd.application_id = req.calling_app_id AND
816: req.payment_service_request_id = pmt.payment_service_request_id AND
817: pmt.payment_id = p_pmt_id

Line 1136: CURSOR c_docs (p_payreq_id IBY_PAY_SERVICE_REQUESTS.

1132: /*
1133: * Cursor to get list of documents along with their statuses for
1134: * the given payment service request.
1135: */
1136: CURSOR c_docs (p_payreq_id IBY_PAY_SERVICE_REQUESTS.
1137: payment_service_request_id%TYPE)
1138: IS
1139: SELECT
1140: doc.document_payable_id,

Line 1466: IBY_PAY_SERVICE_REQUESTS req

1462: l_app_short_name
1463: FROM
1464: FND_APPLICATION fnd,
1465: IBY_PAYMENTS_ALL pmt,
1466: IBY_PAY_SERVICE_REQUESTS req
1467: WHERE
1468: fnd.application_id = req.calling_app_id AND
1469: req.payment_service_request_id = pmt.payment_service_request_id AND
1470: pmt.payment_id = p_pmt_id

Line 2485: IBY_PAY_SERVICE_REQUESTS req

2481: l_app_short_name
2482: FROM
2483: FND_APPLICATION fnd,
2484: IBY_PAYMENTS_ALL pmt,
2485: IBY_PAY_SERVICE_REQUESTS req
2486: WHERE
2487: fnd.application_id = req.calling_app_id AND
2488: req.payment_service_request_id = pmt.payment_service_request_id AND
2489: pmt.payment_id = p_pmt_id

Line 2742: IBY_PAY_SERVICE_REQUESTS req

2738: l_app_short_name
2739: FROM
2740: FND_APPLICATION fnd,
2741: IBY_PAYMENTS_ALL pmt,
2742: IBY_PAY_SERVICE_REQUESTS req
2743: WHERE
2744: fnd.application_id = req.calling_app_id AND
2745: req.payment_service_request_id = pmt.payment_service_request_id AND
2746: pmt.payment_id = p_pmt_id

Line 3679: IBY_PAY_SERVICE_REQUESTS req,

3675: fnd.application_short_name
3676: FROM
3677: FND_APPLICATION fnd,
3678: IBY_PAYMENTS_ALL pmt,
3679: IBY_PAY_SERVICE_REQUESTS req,
3680: IBY_PAY_INSTRUCTIONS_ALL ins
3681: WHERE
3682: pmt.payment_instruction_id = ins.payment_instruction_id AND
3683: req.payment_service_request_id = pmt.payment_service_request_id AND

Line 3699: IBY_PAY_SERVICE_REQUESTS req,

3695: fnd.application_id
3696: FROM
3697: FND_APPLICATION fnd,
3698: IBY_PAYMENTS_ALL pmt,
3699: IBY_PAY_SERVICE_REQUESTS req,
3700: IBY_PAY_INSTRUCTIONS_ALL ins
3701: WHERE
3702: pmt.payment_instruction_id = ins.payment_instruction_id AND
3703: req.payment_service_request_id = pmt.payment_service_request_id AND

Line 4481: iby_pay_service_requests

4477: *
4478: * Set the request status to TERMINATED.
4479: */
4480: UPDATE
4481: iby_pay_service_requests
4482: SET
4483: payment_service_request_status = REQ_STATUS_TERMINATED
4484: WHERE
4485: payment_service_request_id = p_req_id

Line 4661: IBY_PAY_SERVICE_REQUESTS req

4657: INTO
4658: l_app_short_name
4659: FROM
4660: FND_APPLICATION fnd,
4661: IBY_PAY_SERVICE_REQUESTS req
4662: WHERE
4663: fnd.application_id = req.calling_app_id AND
4664: req.payment_service_request_id = p_req_id
4665: ;

Line 4861: l_req_attribs IBY_PAY_SERVICE_REQUESTS%ROWTYPE;

4857:
4858: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME
4859: || '.resubmit_pmt_request';
4860:
4861: l_req_attribs IBY_PAY_SERVICE_REQUESTS%ROWTYPE;
4862: l_ret_status VARCHAR2(200);
4863:
4864: l_icx_numeric_characters VARCHAR2(30); -- Bug 6411356
4865: l_bool_val boolean; -- Bug 6411356

Line 4934: IBY_PAY_SERVICE_REQUESTS

4930: request_id
4931: INTO
4932: l_req_attribs
4933: FROM
4934: IBY_PAY_SERVICE_REQUESTS
4935: WHERE
4936: PAYMENT_SERVICE_REQUEST_ID = p_payreq_id
4937: ;
4938:

Line 7778: IBY_PAY_SERVICE_REQUESTS req,

7774: l_app_short_name
7775: FROM
7776: FND_APPLICATION fnd,
7777: IBY_PAYMENTS_ALL pmt,
7778: IBY_PAY_SERVICE_REQUESTS req,
7779: IBY_PAY_INSTRUCTIONS_ALL ins
7780: WHERE
7781: pmt.payment_instruction_id = ins.payment_instruction_id AND
7782: req.payment_service_request_id = pmt.payment_service_request_id AND

Line 7798: IBY_PAY_SERVICE_REQUESTS req,

7794: fnd.application_id
7795: FROM
7796: FND_APPLICATION fnd,
7797: IBY_PAYMENTS_ALL pmt,
7798: IBY_PAY_SERVICE_REQUESTS req,
7799: IBY_PAY_INSTRUCTIONS_ALL ins
7800: WHERE
7801: pmt.payment_instruction_id = ins.payment_instruction_id AND
7802: req.payment_service_request_id = pmt.payment_service_request_id AND

Line 9767: IBY_PAY_SERVICE_REQUESTS req

9763: */
9764: IF (p_object_type = 'PAYMENT_REQUEST') THEN
9765:
9766: UPDATE
9767: IBY_PAY_SERVICE_REQUESTS req
9768: SET
9769: req.request_id = l_conc_request_id
9770: WHERE
9771: req.payment_service_request_id = p_object_id

Line 9944: IBY_PAY_SERVICE_REQUESTS req

9940: */
9941: IF (p_object_type = 'PAYMENT_REQUEST') THEN
9942:
9943: UPDATE
9944: IBY_PAY_SERVICE_REQUESTS req
9945: SET
9946: req.request_id = NULL
9947: WHERE
9948: req.payment_service_request_id = p_object_id

Line 10823: IBY_PAY_SERVICE_REQUESTS req

10819: (
10820: SELECT
10821: req.payment_service_request_id
10822: FROM
10823: IBY_PAY_SERVICE_REQUESTS req
10824: WHERE
10825: req.payment_service_request_id = p_object_id
10826: AND
10827: req.request_id IS NOT NULL