DBA Data[Home] [Help]

APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on FND_APPLICATION

Line 396: fnd.application_short_name

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,

Line 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

Line 403: fnd.application_id = doc.calling_app_id AND

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: /*

Line 807: fnd.application_short_name

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,

Line 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

Line 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:

Line 1460: fnd.application_short_name

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,

Line 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

Line 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:

Line 2479: fnd.application_short_name

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,

Line 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

Line 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:

Line 2736: fnd.application_short_name

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,

Line 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

Line 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:

Line 3675: fnd.application_short_name

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,

Line 3677: FND_APPLICATION fnd,

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

Line 3684: fnd.application_id = req.calling_app_id AND

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: /*

Line 3695: fnd.application_id

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,

Line 3697: FND_APPLICATION fnd,

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

Line 3704: fnd.application_id = req.calling_app_id AND

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: /*

Line 4656: fnd.application_short_name

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,

Line 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

Line 4663: fnd.application_id = req.calling_app_id AND

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: /*

Line 7772: fnd.application_short_name

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,

Line 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

Line 7783: fnd.application_id = req.calling_app_id AND

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: /*

Line 7794: fnd.application_id

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,

Line 7796: FND_APPLICATION fnd,

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

Line 7803: fnd.application_id = req.calling_app_id AND

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: /*