APPS.FND_FLEX_DIAGNOSE dependencies on FND_APPLICATION

Line 13: SUBTYPE app_type IS fnd_application%ROWTYPE;

9: g_line_size NUMBER := 75;
10: g_text_size NUMBER := 1950;
11: g_newline VARCHAR2(10);
12:
13: SUBTYPE app_type IS fnd_application%ROWTYPE;
14: SUBTYPE tbl_type IS fnd_tables%ROWTYPE;
15: SUBTYPE col_type IS fnd_columns%ROWTYPE;
16: SUBTYPE rsp_type IS fnd_responsibility%ROWTYPE;
17:

Line 880: FROM fnd_application_vl

876: SELECT To_char(application_id) || '/' ||
877: application_short_name || '/' ||
878: application_name
879: INTO l_return
880: FROM fnd_application_vl
881: WHERE application_id = p_application_id;
882: RETURN(line_return(l_return));
883: EXCEPTION
884: WHEN no_data_found THEN

Line 2163: FROM fnd_application a

2159: AND application_id = l_vst_scu.application_id
2160: AND responsibility_id = l_vst_scu.responsibility_id
2161: AND NOT EXISTS
2162: (SELECT null
2163: FROM fnd_application a
2164: WHERE a.application_id = fvru.application_id);
2165: x_message := SQL%rowcount || ' row(s) deleted.';
2166: GOTO return_success;
2167: EXCEPTION

Line 2524: FROM fnd_application_vl avl, fnd_descriptive_flexs df

2520: SELECT To_char(avl.application_id) || '/' ||
2521: avl.application_short_name || '/' ||
2522: avl.application_name
2523: INTO l_return
2524: FROM fnd_application_vl avl, fnd_descriptive_flexs df
2525: WHERE avl.application_id = df.table_application_id
2526: AND df.application_id = p_application_id
2527: AND df.descriptive_flexfield_name = p_descriptive_flexfield_name;
2528: RETURN(line_return(l_return));

Line 2695: FROM fnd_application aa

2691: WHERE application_id = p_application_id
2692: AND descriptive_flexfield_name = p_descriptive_flexfield_name
2693: AND NOT EXISTS
2694: (SELECT null
2695: FROM fnd_application aa
2696: WHERE aa.application_id = df.application_id);
2697: x_message := SQL%rowcount || ' row(s) deleted.';
2698: GOTO return_success;
2699: EXCEPTION

Line 3703: FROM fnd_application_vl avl, fnd_id_flexs idf

3699: SELECT To_char(avl.application_id) || '/' ||
3700: avl.application_short_name || '/' ||
3701: avl.application_name
3702: INTO l_return
3703: FROM fnd_application_vl avl, fnd_id_flexs idf
3704: WHERE avl.application_id = idf.table_application_id
3705: AND idf.application_id = p_application_id
3706: AND idf.id_flex_code = p_id_flex_code;
3707: RETURN(line_return(l_return));

Line 4174: FROM fnd_application aa

4170: WHERE application_id = p_application_id
4171: AND id_flex_code = p_id_flex_code
4172: AND NOT EXISTS
4173: (SELECT null
4174: FROM fnd_application aa
4175: WHERE aa.application_id = idf.application_id);
4176: x_message := SQL%rowcount || ' row(s) deleted.';
4177: GOTO return_success;
4178: EXCEPTION