APPS.GMD_API_GRP dependencies on FND_APPLICATION

Line 134: FROM fnd_application

130: l_exists VARCHAR2 (1);
131:
132: CURSOR cur_get_appl_id IS
133: SELECT application_id
134: FROM fnd_application
135: WHERE application_short_name = 'GMD';
136:
137: CURSOR cur_get_cont_name (
138: v_flex_field_name VARCHAR2

Line 365: l_appl_id FND_APPLICATION.application_id%TYPE;

361: ) IS
362: l_field_value VARCHAR2 (240);
363: l_storage_value VARCHAR2 (240);
364: l_flex_name FND_DESCRIPTIVE_FLEXS.descriptive_flexfield_name%TYPE;
365: l_appl_id FND_APPLICATION.application_id%TYPE;
366: l_appl_name FND_APPLICATION.application_short_name%TYPE;
367:
368: /* Exception declaration */
369: validation_failure EXCEPTION;

Line 366: l_appl_name FND_APPLICATION.application_short_name%TYPE;

362: l_field_value VARCHAR2 (240);
363: l_storage_value VARCHAR2 (240);
364: l_flex_name FND_DESCRIPTIVE_FLEXS.descriptive_flexfield_name%TYPE;
365: l_appl_id FND_APPLICATION.application_id%TYPE;
366: l_appl_name FND_APPLICATION.application_short_name%TYPE;
367:
368: /* Exception declaration */
369: validation_failure EXCEPTION;
370: flexfield_not_found_exception EXCEPTION;

Line 380: FROM fnd_application

376: WHERE application_table_name = vTable_name;
377:
378: CURSOR get_appl_short_name(vAppl_id NUMBER) IS
379: SELECT application_short_name
380: FROM fnd_application
381: WHERE application_id = vAppl_id;
382:
383: BEGIN
384: /* Set return status to success initially */