eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_DIAGNOSE dependencies on FND_DESCRIPTIVE_FLEXS

Line 29: SUBTYPE dff_flx_type IS fnd_descriptive_flexs%ROWTYPE;

25: SUBTYPE vst_val_type IS fnd_flex_values%ROWTYPE;
26: SUBTYPE vst_fvn_type IS fnd_flex_value_norm_hierarchy%ROWTYPE;
27: SUBTYPE vst_fvh_type IS fnd_flex_value_hierarchies%ROWTYPE;
28:
29: SUBTYPE dff_flx_type IS fnd_descriptive_flexs%ROWTYPE;
30: SUBTYPE dff_ctx_type IS fnd_descr_flex_contexts%ROWTYPE;
31: SUBTYPE dff_seg_type IS fnd_descr_flex_column_usages%ROWTYPE;
32:
33: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;

Line 409: FROM fnd_descriptive_flexs

405: IS
406: BEGIN
407: SELECT *
408: INTO x_dff_flx
409: FROM fnd_descriptive_flexs
410: WHERE application_id = p_application_id
411: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
412: RETURN(TRUE);
413: EXCEPTION

Line 415: x_message := msg_uts('FND_DESCRIPTIVE_FLEXS',

411: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
412: RETURN(TRUE);
413: EXCEPTION
414: WHEN OTHERS THEN
415: x_message := msg_uts('FND_DESCRIPTIVE_FLEXS',
416: 'application_id', p_application_id,
417: 'descriptive_flexfield_name', p_descriptive_flexfield_name);
418: RETURN(FALSE);
419: END fetch_dff_flx;

Line 2441: FROM fnd_descriptive_flexs_vl

2437: l_return VARCHAR2(2000);
2438: BEGIN
2439: SELECT descriptive_flexfield_name || '/' || title
2440: INTO l_return
2441: FROM fnd_descriptive_flexs_vl
2442: WHERE application_id = p_application_id
2443: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
2444: RETURN(line_return(l_return));
2445: 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 2547: FROM user_synonyms us, fnd_tables ft, fnd_descriptive_flexs df

2543: SELECT us.table_owner || '/' ||
2544: ft.table_name || '/' ||
2545: To_char(table_id)
2546: INTO l_return
2547: FROM user_synonyms us, fnd_tables ft, fnd_descriptive_flexs df
2548: WHERE us.synonym_name = df.application_table_name
2549: AND ft.application_id = df.table_application_id
2550: AND ft.table_name = df.application_table_name
2551: AND df.application_id = p_application_id

Line 2577: FROM fnd_columns fc, fnd_tables ft, fnd_descriptive_flexs df

2573: fc.flexfield_usage_code || '/' ||
2574: Nvl(To_char(fc.flexfield_application_id), '') || '/' ||
2575: Nvl(fc.flexfield_name, '')
2576: INTO l_return
2577: FROM fnd_columns fc, fnd_tables ft, fnd_descriptive_flexs df
2578: WHERE df.application_id = p_application_id
2579: AND df.descriptive_flexfield_name = p_descriptive_flexfield_name
2580: AND ft.application_id = df.table_application_id
2581: AND ft.table_name = df.application_table_name

Line 2690: FROM fnd_descriptive_flexs df

2686: -- DFF with invalid APPLICATION_ID.
2687: --
2688: BEGIN
2689: DELETE
2690: FROM fnd_descriptive_flexs df
2691: WHERE application_id = p_application_id
2692: AND descriptive_flexfield_name = p_descriptive_flexfield_name
2693: AND NOT EXISTS
2694: (SELECT null

Line 2702: 'Unable to delete from FND_DESCRIPTIVE_FLEXS. ' || Sqlerrm;

2698: GOTO return_success;
2699: EXCEPTION
2700: WHEN OTHERS THEN
2701: x_message :=
2702: 'Unable to delete from FND_DESCRIPTIVE_FLEXS. ' || Sqlerrm;
2703: GOTO return_error;
2704: END;
2705: END IF;
2706:

Line 2718: FROM fnd_descriptive_flexs df

2714: WHERE application_id = p_application_id
2715: AND descriptive_flexfield_name = p_descriptive_flexfield_name
2716: AND NOT EXISTS
2717: (SELECT null
2718: FROM fnd_descriptive_flexs df
2719: WHERE df.application_id = cdf.application_id
2720: AND df.descriptive_flexfield_name =cdf.descriptive_flexfield_name);
2721: x_message := SQL%rowcount || ' row(s) deleted.';
2722: GOTO return_success;

Line 2861: UPDATE fnd_descriptive_flexs SET

2857: END IF;
2858: END IF;
2859:
2860: BEGIN
2861: UPDATE fnd_descriptive_flexs SET
2862: default_context_value = NULL,
2863: last_update_date = Sysdate,
2864: last_updated_by = 1
2865: WHERE application_id = l_dff_flx.application_id

Line 2871: x_message := 'Unable to update FND_DESCRIPTIVE_FLEXS. ' || Sqlerrm;

2867: x_message := SQL%rowcount || ' row(s) updated.';
2868: GOTO return_success;
2869: EXCEPTION
2870: WHEN OTHERS THEN
2871: x_message := 'Unable to update FND_DESCRIPTIVE_FLEXS. ' || Sqlerrm;
2872: GOTO return_error;
2873: END;
2874: END IF;
2875:

Line 2915: UPDATE fnd_descriptive_flexs SET

2911: l_dff_flx.context_default_value := NULL;
2912: END IF;
2913:
2914: BEGIN
2915: UPDATE fnd_descriptive_flexs SET
2916: context_required_flag = l_dff_flx.context_required_flag,
2917: context_user_override_flag = l_dff_flx.context_user_override_flag,
2918: freeze_flex_definition_flag = l_dff_flx.freeze_flex_definition_flag,
2919: protected_flag = l_dff_flx.protected_flag,

Line 2930: x_message := 'Unable to update FND_DESCRIPTIVE_FLEXS. ' || Sqlerrm;

2926: x_message := SQL%rowcount || ' row(s) updated.';
2927: GOTO return_success;
2928: EXCEPTION
2929: WHEN OTHERS THEN
2930: x_message := 'Unable to update FND_DESCRIPTIVE_FLEXS. ' || Sqlerrm;
2931: GOTO return_error;
2932: END;
2933: END IF;
2934:

Line 2952: UPDATE fnd_descriptive_flexs SET

2948: GOTO return_error;
2949: END IF;
2950:
2951: BEGIN
2952: UPDATE fnd_descriptive_flexs SET
2953: context_override_value_set_id = NULL,
2954: last_update_date = Sysdate,
2955: last_updated_by = 1
2956: WHERE application_id = l_dff_flx.application_id

Line 2962: x_message := 'Unable to update FND_DESCRIPTIVE_FLEXS. ' || Sqlerrm;

2958: x_message := SQL%rowcount || ' row(s) updated.';
2959: GOTO return_success;
2960: EXCEPTION
2961: WHEN OTHERS THEN
2962: x_message := 'Unable to update FND_DESCRIPTIVE_FLEXS. ' || Sqlerrm;
2963: GOTO return_error;
2964: END;
2965: END IF;
2966:

Line 2994: FROM fnd_descriptive_flexs df

2990: AND descriptive_flexfield_name = p_descriptive_flexfield_name
2991: AND default_context_field_name = p_default_context_field_name
2992: AND NOT EXISTS
2993: (SELECT null
2994: FROM fnd_descriptive_flexs df
2995: WHERE df.application_id = dcf.application_id
2996: AND df.descriptive_flexfield_name =dcf.descriptive_flexfield_name);
2997: x_message := SQL%rowcount || ' row(s) deleted.';
2998: GOTO return_success;

Line 3037: FROM fnd_descriptive_flexs df

3033: AND descriptive_flexfield_name = p_descriptive_flexfield_name
3034: AND descriptive_flex_context_code = p_descriptive_flex_context_cod
3035: AND NOT EXISTS
3036: (SELECT null
3037: FROM fnd_descriptive_flexs df
3038: WHERE df.application_id = dfc.application_id
3039: AND df.descriptive_flexfield_name =dfc.descriptive_flexfield_name);
3040: x_message := SQL%rowcount || ' row(s) deleted.';
3041: GOTO return_success;