392: * Get the application name of the calling app. This
393: * will be used in the callout.
394: */
395: SELECT
396: fnd.application_short_name
397: INTO
398: l_app_short_name
399: FROM
400: FND_APPLICATION fnd,
396: fnd.application_short_name
397: INTO
398: l_app_short_name
399: FROM
400: FND_APPLICATION fnd,
401: IBY_DOCS_PAYABLE_ALL doc
402: WHERE
403: fnd.application_id = doc.calling_app_id AND
404: doc.document_payable_id = p_doc_id
399: FROM
400: FND_APPLICATION fnd,
401: IBY_DOCS_PAYABLE_ALL doc
402: WHERE
403: fnd.application_id = doc.calling_app_id AND
404: doc.document_payable_id = p_doc_id
405: ;
406:
407: /*
803: * Get the application name of the calling app. This
804: * will be used in the callout.
805: */
806: SELECT
807: fnd.application_short_name
808: INTO
809: l_app_short_name
810: FROM
811: FND_APPLICATION fnd,
807: fnd.application_short_name
808: INTO
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
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
818: ;
819:
1456: * Get the application name of the calling app. This
1457: * will be used in the callout.
1458: */
1459: SELECT
1460: fnd.application_short_name
1461: INTO
1462: l_app_short_name
1463: FROM
1464: FND_APPLICATION fnd,
1460: fnd.application_short_name
1461: INTO
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
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
1471: ;
1472:
2475: * Get the application name of the calling app. This
2476: * will be used in the callout.
2477: */
2478: SELECT
2479: fnd.application_short_name
2480: INTO
2481: l_app_short_name
2482: FROM
2483: FND_APPLICATION fnd,
2479: fnd.application_short_name
2480: INTO
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
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
2490: ;
2491:
2732: * Get the application name of the calling app. This
2733: * will be used in the callout.
2734: */
2735: SELECT
2736: fnd.application_short_name
2737: INTO
2738: l_app_short_name
2739: FROM
2740: FND_APPLICATION fnd,
2736: fnd.application_short_name
2737: INTO
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
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
2747: ;
2748:
3671: */
3672: CURSOR c_app_names (p_instr_id NUMBER)
3673: IS
3674: SELECT DISTINCT
3675: fnd.application_short_name
3676: FROM
3677: FND_APPLICATION fnd,
3678: IBY_PAYMENTS_ALL pmt,
3679: IBY_PAY_SERVICE_REQUESTS req,
3673: IS
3674: SELECT DISTINCT
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
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
3684: fnd.application_id = req.calling_app_id AND
3685: ins.payment_instruction_id = p_instr_id
3686: ;
3687:
3688: /*
3691: */
3692: CURSOR c_app_ids (p_instr_id NUMBER)
3693: IS
3694: SELECT
3695: fnd.application_id
3696: FROM
3697: FND_APPLICATION fnd,
3698: IBY_PAYMENTS_ALL pmt,
3699: IBY_PAY_SERVICE_REQUESTS req,
3693: IS
3694: SELECT
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
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
3704: fnd.application_id = req.calling_app_id AND
3705: ins.payment_instruction_id = p_instr_id
3706: ;
3707:
3708: /*
4652: * Get the application name of the calling app. This
4653: * will be used in the callout.
4654: */
4655: SELECT
4656: fnd.application_short_name
4657: INTO
4658: l_app_short_name
4659: FROM
4660: FND_APPLICATION fnd,
4656: fnd.application_short_name
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
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: ;
4666:
4667: /*
7768: */
7769: CURSOR c_app_names (p_instr_id NUMBER)
7770: IS
7771: SELECT DISTINCT
7772: fnd.application_short_name
7773: INTO
7774: l_app_short_name
7775: FROM
7776: FND_APPLICATION fnd,
7772: fnd.application_short_name
7773: INTO
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
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
7783: fnd.application_id = req.calling_app_id AND
7784: ins.payment_instruction_id = p_instr_id
7785: ;
7786:
7787: /*
7790: */
7791: CURSOR c_app_ids (p_instr_id NUMBER)
7792: IS
7793: SELECT
7794: fnd.application_id
7795: FROM
7796: FND_APPLICATION fnd,
7797: IBY_PAYMENTS_ALL pmt,
7798: IBY_PAY_SERVICE_REQUESTS req,
7792: IS
7793: SELECT
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
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
7803: fnd.application_id = req.calling_app_id AND
7804: ins.payment_instruction_id = p_instr_id
7805: ;
7806:
7807: /*