APPS.FNDCP_SCH dependencies on FND_APPLICATION

Line 113: RETURN fnd_application.application_id%TYPE

109: --
110: -- get the application id, given the name (or short name)
111: --
112: FUNCTION application_id_f(application_name_in IN VARCHAR2)
113: RETURN fnd_application.application_id%TYPE
114: IS
115: application_id_ret fnd_application.application_id%TYPE;
116: BEGIN
117: IF(application_name_in IS NULL) THEN

Line 115: application_id_ret fnd_application.application_id%TYPE;

111: --
112: FUNCTION application_id_f(application_name_in IN VARCHAR2)
113: RETURN fnd_application.application_id%TYPE
114: IS
115: application_id_ret fnd_application.application_id%TYPE;
116: BEGIN
117: IF(application_name_in IS NULL) THEN
118: message('A null application_name was specified.');
119: RAISE bad_parameter;

Line 124: FROM fnd_application

120: END IF;
121: /* Check the short name first. */
122: SELECT application_id
123: INTO application_id_ret
124: FROM fnd_application
125: WHERE application_short_name = application_name_in;
126: RETURN application_id_ret;
127: EXCEPTION
128: WHEN no_data_found THEN /* Try the translated name. */

Line 132: FROM fnd_application_tl

128: WHEN no_data_found THEN /* Try the translated name. */
129: BEGIN
130: SELECT application_id
131: INTO application_id_ret
132: FROM fnd_application_tl
133: WHERE application_name = application_name_in
134: AND rownum = 1;
135: RETURN application_id_ret;
136: EXCEPTION