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 FND_APPLICATION

Line 424: fnd.application_short_name

420: * Get the application name of the calling app. This
421: * will be used in the callout.
422: */
423: SELECT
424: fnd.application_short_name
425: INTO
426: l_app_short_name
427: FROM
428: FND_APPLICATION fnd,

Line 428: FND_APPLICATION fnd,

424: fnd.application_short_name
425: INTO
426: l_app_short_name
427: FROM
428: FND_APPLICATION fnd,
429: IBY_DOCS_PAYABLE_ALL doc
430: WHERE
431: fnd.application_id = doc.calling_app_id AND
432: doc.document_payable_id = p_doc_id

Line 431: fnd.application_id = doc.calling_app_id AND

427: FROM
428: FND_APPLICATION fnd,
429: IBY_DOCS_PAYABLE_ALL doc
430: WHERE
431: fnd.application_id = doc.calling_app_id AND
432: doc.document_payable_id = p_doc_id
433: ;
434:
435: /*

Line 724: distinct fnd.application_short_name

720: * payable succeeded.
721: */
722:
723: SELECT
724: distinct fnd.application_short_name
725: INTO
726: l_app_short_name
727: FROM
728: FND_APPLICATION fnd,

Line 728: FND_APPLICATION fnd,

724: distinct fnd.application_short_name
725: INTO
726: l_app_short_name
727: FROM
728: FND_APPLICATION fnd,
729: IBY_DOCS_PAYABLE_ALL doc
730: WHERE
731: fnd.application_id = doc.calling_app_id AND
732: doc.rejected_docs_group_id = l_rejection_id

Line 731: fnd.application_id = doc.calling_app_id AND

727: FROM
728: FND_APPLICATION fnd,
729: IBY_DOCS_PAYABLE_ALL doc
730: WHERE
731: fnd.application_id = doc.calling_app_id AND
732: doc.rejected_docs_group_id = l_rejection_id
733: ;
734:
735: /*

Line 1017: fnd.application_short_name

1013: * Get the application name of the calling app. This
1014: * will be used in the callout.
1015: */
1016: SELECT
1017: fnd.application_short_name
1018: INTO
1019: l_app_short_name
1020: FROM
1021: FND_APPLICATION fnd,

Line 1021: FND_APPLICATION fnd,

1017: fnd.application_short_name
1018: INTO
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

Line 1025: fnd.application_id = req.calling_app_id AND

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
1028: ;
1029:

Line 1712: fnd.application_short_name

1708: * Get the application name of the calling app. This
1709: * will be used in the callout.
1710: */
1711: SELECT
1712: fnd.application_short_name
1713: INTO
1714: l_app_short_name
1715: FROM
1716: FND_APPLICATION fnd,

Line 1716: FND_APPLICATION fnd,

1712: fnd.application_short_name
1713: INTO
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

Line 1720: fnd.application_id = req.calling_app_id AND

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
1723: ;
1724:

Line 2877: fnd.application_short_name

2873: * Get the application name of the calling app. This
2874: * will be used in the callout.
2875: */
2876: SELECT
2877: fnd.application_short_name
2878: INTO
2879: l_app_short_name
2880: FROM
2881: FND_APPLICATION fnd,

Line 2881: FND_APPLICATION fnd,

2877: fnd.application_short_name
2878: INTO
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

Line 2885: fnd.application_id = req.calling_app_id AND

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
2888: ;
2889:

Line 3158: fnd.application_short_name

3154: * Get the application name of the calling app. This
3155: * will be used in the callout.
3156: */
3157: SELECT
3158: fnd.application_short_name
3159: INTO
3160: l_app_short_name
3161: FROM
3162: FND_APPLICATION fnd,

Line 3162: FND_APPLICATION fnd,

3158: fnd.application_short_name
3159: INTO
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

Line 3166: fnd.application_id = req.calling_app_id AND

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
3169: ;
3170:

Line 4529: fnd.application_short_name

4525: */
4526: CURSOR c_app_names (p_instr_id NUMBER)
4527: IS
4528: SELECT DISTINCT
4529: fnd.application_short_name
4530: FROM
4531: FND_APPLICATION fnd,
4532: IBY_PAYMENTS_ALL pmt,
4533: IBY_PAY_SERVICE_REQUESTS req,

Line 4531: FND_APPLICATION fnd,

4527: IS
4528: SELECT DISTINCT
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

Line 4538: fnd.application_id = req.calling_app_id AND

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
4538: fnd.application_id = req.calling_app_id AND
4539: ins.payment_instruction_id = p_instr_id
4540: ;
4541:
4542: /*

Line 4549: fnd.application_id

4545: */
4546: CURSOR c_app_ids (p_instr_id NUMBER)
4547: IS
4548: SELECT
4549: fnd.application_id
4550: FROM
4551: FND_APPLICATION fnd,
4552: IBY_PAYMENTS_ALL pmt,
4553: IBY_PAY_SERVICE_REQUESTS req,

Line 4551: FND_APPLICATION fnd,

4547: IS
4548: SELECT
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

Line 4558: fnd.application_id = req.calling_app_id AND

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
4558: fnd.application_id = req.calling_app_id AND
4559: ins.payment_instruction_id = p_instr_id
4560: ;
4561:
4562: /*

Line 5798: fnd.application_short_name

5794: * Get the application name of the calling app. This
5795: * will be used in the callout.
5796: */
5797: SELECT
5798: fnd.application_short_name
5799: INTO
5800: l_app_short_name
5801: FROM
5802: FND_APPLICATION fnd,

Line 5802: FND_APPLICATION fnd,

5798: fnd.application_short_name
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

Line 5805: fnd.application_id = req.calling_app_id AND

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: ;
5808:
5809: /*

Line 8991: fnd.application_short_name

8987: */
8988: CURSOR c_app_names (p_instr_id NUMBER)
8989: IS
8990: SELECT DISTINCT
8991: fnd.application_short_name
8992: INTO
8993: l_app_short_name
8994: FROM
8995: FND_APPLICATION fnd,

Line 8995: FND_APPLICATION fnd,

8991: fnd.application_short_name
8992: INTO
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

Line 9002: fnd.application_id = req.calling_app_id AND

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
9002: fnd.application_id = req.calling_app_id AND
9003: ins.payment_instruction_id = p_instr_id
9004: ;
9005:
9006: /*

Line 9013: fnd.application_id

9009: */
9010: CURSOR c_app_ids (p_instr_id NUMBER)
9011: IS
9012: SELECT
9013: fnd.application_id
9014: FROM
9015: FND_APPLICATION fnd,
9016: IBY_PAYMENTS_ALL pmt,
9017: IBY_PAY_SERVICE_REQUESTS req,

Line 9015: FND_APPLICATION fnd,

9011: IS
9012: SELECT
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

Line 9022: fnd.application_id = req.calling_app_id AND

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
9022: fnd.application_id = req.calling_app_id AND
9023: ins.payment_instruction_id = p_instr_id
9024: ;
9025:
9026: /* EFT Paper Document Generation Begin*/