APPS.FND_CONC_PP dependencies on FND_APPLICATION

Line 71: RETURN fnd_application.application_id%TYPE

67: --
68: -- get the application id, given the name (or short name)
69: --
70: FUNCTION application_id_f(application_name_in IN VARCHAR2)
71: RETURN fnd_application.application_id%TYPE
72: IS
73: application_id_ret fnd_application.application_id%TYPE;
74: BEGIN
75: IF(application_name_in IS NULL) THEN

Line 73: application_id_ret fnd_application.application_id%TYPE;

69: --
70: FUNCTION application_id_f(application_name_in IN VARCHAR2)
71: RETURN fnd_application.application_id%TYPE
72: IS
73: application_id_ret fnd_application.application_id%TYPE;
74: BEGIN
75: IF(application_name_in IS NULL) THEN
76: message_add('A null application_name was specified.');
77: RAISE bad_parameter;

Line 82: FROM fnd_application

78: END IF;
79: /* Check the short name first. */
80: SELECT application_id
81: INTO application_id_ret
82: FROM fnd_application
83: WHERE application_short_name = application_name_in;
84: RETURN application_id_ret;
85: EXCEPTION
86: WHEN no_data_found THEN /* Try the translated name. */

Line 90: FROM fnd_application_tl

86: WHEN no_data_found THEN /* Try the translated name. */
87: BEGIN
88: SELECT application_id
89: INTO application_id_ret
90: FROM fnd_application_tl
91: WHERE application_name = application_name_in
92: AND rownum = 1;
93: RETURN application_id_ret;
94: EXCEPTION

Line 314: from FND_APPLICATION

310:
311: begin
312: select Application_short_name
313: into app_short_name
314: from FND_APPLICATION
315: where application_id = app_id;
316: exception
317: when NO_DATA_FOUND then
318: message_add('Bad Application ID');

Line 321: message_add('Error while querying fnd_application.');

317: when NO_DATA_FOUND then
318: message_add('Bad Application ID');
319: return(-1);
320: when others then
321: message_add('Error while querying fnd_application.');
322: return(-1);
323: end;
324:
325: begin