APPS.EGO_PUB_WS_UTIL dependencies on FND_APPLICATION

Line 631: FROM FND_APPLICATION

627:
628: --retrieving responsibility_appl_name
629: SELECT APPLICATION_SHORT_NAME
630: INTO l_responsibility_appl_name
631: FROM FND_APPLICATION
632: WHERE application_id = l_application_id;
633:
634: /*INSERT INTO tr_temp (Session_id, message)
635: values (p_session_id, 'RESPONSIBILITY_APPL_NAME:' || l_responsibility_appl_name);*/

Line 749: FROM FND_APPLICATION

745:
746: --retrieving application id from application name
747: SELECT APPLICATION_ID
748: INTO x_resp_appl_id
749: FROM FND_APPLICATION
750: WHERE APPLICATION_SHORT_NAME = p_resp_appl_name;
751:
752: RETURN TRUE;
753:

Line 2197: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;

2193: END Write_Errors_ToBatFwk;
2194:
2195: FUNCTION Get_Application_id(p_appl_short_name IN VARCHAR2) RETURN NUMBER
2196: IS
2197: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
2198: BEGIN
2199: BEGIN
2200: SELECT application_id
2201: INTO l_application_id

Line 2202: FROM fnd_application

2198: BEGIN
2199: BEGIN
2200: SELECT application_id
2201: INTO l_application_id
2202: FROM fnd_application
2203: WHERE application_short_name=p_appl_short_name;
2204: EXCEPTION
2205: WHEN No_Data_Found THEN
2206: RETURN -1;