3493: * Get the shortname of the calling app from the calling
3494: * app id.
3495: */
3496: SELECT
3497: fnd.application_short_name
3498: INTO
3499: l_app_short_name
3500: FROM
3501: FND_APPLICATION fnd
3497: fnd.application_short_name
3498: INTO
3499: l_app_short_name
3500: FROM
3501: FND_APPLICATION fnd
3502: WHERE
3503: fnd.application_id = p_calling_app_id;
3504:
3505: print_debuginfo(l_module_name, 'Calling app short name: '
3499: l_app_short_name
3500: FROM
3501: FND_APPLICATION fnd
3502: WHERE
3503: fnd.application_id = p_calling_app_id;
3504:
3505: print_debuginfo(l_module_name, 'Calling app short name: '
3506: || l_app_short_name);
3507:
4840: * Get the application name of the calling app. This
4841: * will be used in the callout.
4842: */
4843: SELECT
4844: fnd.application_short_name
4845: INTO
4846: l_app_short_name
4847: FROM
4848: FND_APPLICATION fnd,
4844: fnd.application_short_name
4845: INTO
4846: l_app_short_name
4847: FROM
4848: FND_APPLICATION fnd,
4849: IBY_PAY_SERVICE_REQUESTS req
4850: WHERE
4851: fnd.application_id = req.calling_app_id AND
4852: req.payment_service_request_id = p_payreq_id
4847: FROM
4848: FND_APPLICATION fnd,
4849: IBY_PAY_SERVICE_REQUESTS req
4850: WHERE
4851: fnd.application_id = req.calling_app_id AND
4852: req.payment_service_request_id = p_payreq_id
4853: ;
4854:
4855: print_debuginfo(l_module_name, 'Calling app short name: '