[Home] [Help]
1019: l_app_short_name
1020: FROM
1021: FND_APPLICATION fnd,
1022: IBY_PAYMENTS_ALL pmt,
1023: IBY_PAY_SERVICE_REQUESTS req
1024: WHERE
1025: fnd.application_id = req.calling_app_id AND
1026: req.payment_service_request_id = pmt.payment_service_request_id AND
1027: pmt.payment_id = p_pmt_id
1374: /*
1375: * Cursor to get list of documents along with their statuses for
1376: * the given payment service request.
1377: */
1378: CURSOR c_docs (p_payreq_id IBY_PAY_SERVICE_REQUESTS.
1379: payment_service_request_id%TYPE)
1380: IS
1381: SELECT
1382: doc.document_payable_id,
1714: l_app_short_name
1715: FROM
1716: FND_APPLICATION fnd,
1717: IBY_PAYMENTS_ALL pmt,
1718: IBY_PAY_SERVICE_REQUESTS req
1719: WHERE
1720: fnd.application_id = req.calling_app_id AND
1721: req.payment_service_request_id = pmt.payment_service_request_id AND
1722: pmt.payment_id = p_pmt_id
2879: l_app_short_name
2880: FROM
2881: FND_APPLICATION fnd,
2882: IBY_PAYMENTS_ALL pmt,
2883: IBY_PAY_SERVICE_REQUESTS req
2884: WHERE
2885: fnd.application_id = req.calling_app_id AND
2886: req.payment_service_request_id = pmt.payment_service_request_id AND
2887: pmt.payment_id = p_pmt_id
3160: l_app_short_name
3161: FROM
3162: FND_APPLICATION fnd,
3163: IBY_PAYMENTS_ALL pmt,
3164: IBY_PAY_SERVICE_REQUESTS req
3165: WHERE
3166: fnd.application_id = req.calling_app_id AND
3167: req.payment_service_request_id = pmt.payment_service_request_id AND
3168: pmt.payment_id = p_pmt_id
4529: fnd.application_short_name
4530: FROM
4531: FND_APPLICATION fnd,
4532: IBY_PAYMENTS_ALL pmt,
4533: IBY_PAY_SERVICE_REQUESTS req,
4534: IBY_PAY_INSTRUCTIONS_ALL ins
4535: WHERE
4536: pmt.payment_instruction_id = ins.payment_instruction_id AND
4537: req.payment_service_request_id = pmt.payment_service_request_id AND
4549: fnd.application_id
4550: FROM
4551: FND_APPLICATION fnd,
4552: IBY_PAYMENTS_ALL pmt,
4553: IBY_PAY_SERVICE_REQUESTS req,
4554: IBY_PAY_INSTRUCTIONS_ALL ins
4555: WHERE
4556: pmt.payment_instruction_id = ins.payment_instruction_id AND
4557: req.payment_service_request_id = pmt.payment_service_request_id AND
5517:
5518: END IF;
5519:
5520: SELECT CREATE_PMT_INSTRUCTIONS_FLAG INTO l_straight_thr_proc
5521: FROM IBY_PAY_SERVICE_REQUESTS
5522: WHERE PAYMENT_SERVICE_REQUEST_ID = p_req_id;
5523:
5524: /* If instructions are not created for this batch alone,
5525: * this ppr cannot be terminated.
5601: *
5602: * Set the request status to TERMINATED.
5603: */
5604: UPDATE
5605: iby_pay_service_requests
5606: SET
5607: payment_service_request_status = REQ_STATUS_TERMINATED,
5608: last_update_date = sysdate,
5609: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
5799: INTO
5800: l_app_short_name
5801: FROM
5802: FND_APPLICATION fnd,
5803: IBY_PAY_SERVICE_REQUESTS req
5804: WHERE
5805: fnd.application_id = req.calling_app_id AND
5806: req.payment_service_request_id = p_req_id
5807: ;
6020:
6021: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME
6022: || '.resubmit_pmt_request';
6023:
6024: l_req_attribs IBY_PAY_SERVICE_REQUESTS%ROWTYPE;
6025: l_ret_status VARCHAR2(200);
6026:
6027: l_icx_numeric_characters VARCHAR2(30); -- Bug 6411356
6028: l_bool_val boolean; -- Bug 6411356
6095: request_id
6096: INTO
6097: l_req_attribs
6098: FROM
6099: IBY_PAY_SERVICE_REQUESTS
6100: WHERE
6101: PAYMENT_SERVICE_REQUEST_ID = p_payreq_id
6102: ;
6103:
8993: l_app_short_name
8994: FROM
8995: FND_APPLICATION fnd,
8996: IBY_PAYMENTS_ALL pmt,
8997: IBY_PAY_SERVICE_REQUESTS req,
8998: IBY_PAY_INSTRUCTIONS_ALL ins
8999: WHERE
9000: pmt.payment_instruction_id = ins.payment_instruction_id AND
9001: req.payment_service_request_id = pmt.payment_service_request_id AND
9013: fnd.application_id
9014: FROM
9015: FND_APPLICATION fnd,
9016: IBY_PAYMENTS_ALL pmt,
9017: IBY_PAY_SERVICE_REQUESTS req,
9018: IBY_PAY_INSTRUCTIONS_ALL ins
9019: WHERE
9020: pmt.payment_instruction_id = ins.payment_instruction_id AND
9021: req.payment_service_request_id = pmt.payment_service_request_id AND
9759: if l_incomplete_pmts = 0 then
9760: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
9761: print_debuginfo(l_module_name, 'Changing Status of PPR ::'||l_pprIdsTab(i)||' as COMPLETED');
9762: END IF;
9763: update iby_pay_service_requests
9764: set payment_service_request_status = REQ_STATUS_COMPLETED,
9765: last_update_date = sysdate,
9766: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
9767: LAST_UPDATE_LOGIN = NVL(FND_GLOBAL.login_id, -1)
11385: */
11386: IF (p_object_type = 'PAYMENT_REQUEST') THEN
11387:
11388: UPDATE
11389: IBY_PAY_SERVICE_REQUESTS req
11390: SET
11391: req.request_id = l_conc_request_id,
11392: last_update_date = sysdate,
11393: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
11614: */
11615: IF (p_object_type = 'PAYMENT_REQUEST') THEN
11616:
11617: UPDATE
11618: IBY_PAY_SERVICE_REQUESTS req
11619: SET
11620: req.request_id = NULL,
11621: last_update_date = sysdate,
11622: LAST_UPDATED_BY = NVL(FND_GLOBAL.user_id,-1),
12640: (
12641: SELECT
12642: req.payment_service_request_id
12643: FROM
12644: IBY_PAY_SERVICE_REQUESTS req
12645: WHERE
12646: req.payment_service_request_id = p_object_id
12647: AND
12648: req.request_id IS NOT NULL