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_DESCR_FLEX_CONTEXTS

Line 30: SUBTYPE dff_ctx_type IS fnd_descr_flex_contexts%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;
34: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;

Line 430: FROM fnd_descr_flex_contexts

426: IS
427: BEGIN
428: SELECT *
429: INTO x_dff_ctx
430: FROM fnd_descr_flex_contexts
431: WHERE application_id = p_dff_flx.application_id
432: AND descriptive_flexfield_name = p_dff_flx.descriptive_flexfield_name
433: AND descriptive_flex_context_code = p_descriptive_flex_context_cod;
434: RETURN(TRUE);

Line 437: x_message := msg_uts('FND_DESCR_FLEX_CONTEXTS',

433: AND descriptive_flex_context_code = p_descriptive_flex_context_cod;
434: RETURN(TRUE);
435: EXCEPTION
436: WHEN OTHERS THEN
437: x_message := msg_uts('FND_DESCR_FLEX_CONTEXTS',
438: 'application_id', p_dff_flx.application_id,
439: 'descriptive_flexfield_name', p_dff_flx.descriptive_flexfield_name,
440: 'descriptive_flex_context_code', p_descriptive_flex_context_cod);
441: RETURN(FALSE);

Line 2468: FROM fnd_descr_flex_contexts_vl

2464: enabled_flag || '/' ||
2465: descriptive_flex_context_name || '/' ||
2466: Nvl(description, '')
2467: INTO l_return
2468: FROM fnd_descr_flex_contexts_vl
2469: WHERE application_id = p_application_id
2470: AND descriptive_flexfield_name = p_descriptive_flexfield_name
2471: AND descriptive_flex_context_code = p_descriptive_flex_context_cod;
2472: RETURN(line_return(l_return));

Line 2780: FROM fnd_descr_flex_contexts

2776: -- Global Context doesn't exist.
2777: --
2778: SELECT COUNT(*)
2779: INTO l_count
2780: FROM fnd_descr_flex_contexts
2781: WHERE application_id = l_dff_flx.application_id
2782: AND descriptive_flexfield_name = l_dff_flx.descriptive_flexfield_name
2783: AND global_flag = 'Y';
2784:

Line 2801: fnd_descr_flex_contexts_pkg.insert_row

2797: x_message)) THEN
2798: --
2799: -- GDE doesn't exist, insert it.
2800: --
2801: fnd_descr_flex_contexts_pkg.insert_row
2802: (x_rowid => l_rowid,
2803: x_application_id => l_dff_flx.application_id,
2804: x_descriptive_flexfield_name => l_dff_flx.descriptive_flexfield_name,
2805: x_descriptive_flex_context_cod => 'Global Data Elements',

Line 2822: UPDATE fnd_descr_flex_contexts SET

2818: --
2819: -- GDE exists but is not marked as global.
2820: --
2821: BEGIN
2822: UPDATE fnd_descr_flex_contexts SET
2823: global_flag = 'Y',
2824: last_update_date = Sysdate,
2825: last_updated_by = 1
2826: WHERE application_id = l_dff_flx.application_id

Line 2834: 'Unable to update FND_DESCR_FLEX_CONTEXTS. ' || Sqlerrm;

2830: GOTO return_success;
2831: EXCEPTION
2832: WHEN OTHERS THEN
2833: x_message :=
2834: 'Unable to update FND_DESCR_FLEX_CONTEXTS. ' || Sqlerrm;
2835: GOTO return_error;
2836: END;
2837: END IF;
2838: END IF;

Line 3031: FROM fnd_descr_flex_contexts dfc

3027: -- Contexts without DFF.
3028: --
3029: BEGIN
3030: DELETE
3031: FROM fnd_descr_flex_contexts dfc
3032: WHERE application_id = p_application_id
3033: AND descriptive_flexfield_name = p_descriptive_flexfield_name
3034: AND descriptive_flex_context_code = p_descriptive_flex_context_cod
3035: AND NOT EXISTS

Line 3045: 'Unable to delete from FND_DESCR_FLEX_CONTEXTS. ' || Sqlerrm;

3041: GOTO return_success;
3042: EXCEPTION
3043: WHEN OTHERS THEN
3044: x_message :=
3045: 'Unable to delete from FND_DESCR_FLEX_CONTEXTS. ' || Sqlerrm;
3046: GOTO return_error;
3047: END;
3048: END IF;
3049:

Line 3070: FROM fnd_descr_flex_contexts

3066: -- There are more than one global context.
3067: --
3068: SELECT COUNT(*)
3069: INTO l_count
3070: FROM fnd_descr_flex_contexts
3071: WHERE application_id = l_dff_ctx.application_id
3072: AND descriptive_flexfield_name = l_dff_ctx.descriptive_flexfield_name
3073: AND global_flag = 'Y';
3074:

Line 3086: UPDATE fnd_descr_flex_contexts SET

3082: GOTO return_error;
3083: END IF;
3084:
3085: BEGIN
3086: UPDATE fnd_descr_flex_contexts SET
3087: global_flag = 'N',
3088: last_update_date = Sysdate,
3089: last_updated_by = 1
3090: WHERE application_id = l_dff_ctx.application_id

Line 3099: 'Unable to update FND_DESCR_FLEX_CONTEXTS. ' || Sqlerrm;

3095: GOTO return_success;
3096: EXCEPTION
3097: WHEN OTHERS THEN
3098: x_message :=
3099: 'Unable to update FND_DESCR_FLEX_CONTEXTS. ' || Sqlerrm;
3100: GOTO return_error;
3101: END;
3102: END IF;
3103:

Line 3119: UPDATE fnd_descr_flex_contexts SET

3115: GOTO return_error;
3116: END IF;
3117:
3118: BEGIN
3119: UPDATE fnd_descr_flex_contexts SET
3120: enabled_flag = 'Y',
3121: last_update_date = Sysdate,
3122: last_updated_by = 1
3123: WHERE application_id = l_dff_ctx.application_id

Line 3132: 'Unable to update FND_DESCR_FLEX_CONTEXTS. ' || Sqlerrm;

3128: GOTO return_success;
3129: EXCEPTION
3130: WHEN OTHERS THEN
3131: x_message :=
3132: 'Unable to update FND_DESCR_FLEX_CONTEXTS. ' || Sqlerrm;
3133: GOTO return_error;
3134: END;
3135: END IF;
3136:

Line 3152: UPDATE fnd_descr_flex_contexts SET

3148: l_dff_ctx.enabled_flag := 'N';
3149: END IF;
3150:
3151: BEGIN
3152: UPDATE fnd_descr_flex_contexts SET
3153: global_flag = l_dff_ctx.global_flag,
3154: enabled_flag = l_dff_ctx.enabled_flag,
3155: last_update_date = Sysdate,
3156: last_updated_by = 1

Line 3165: 'Unable to update FND_DESCR_FLEX_CONTEXTS. ' || Sqlerrm;

3161: GOTO return_success;
3162: EXCEPTION
3163: WHEN OTHERS THEN
3164: x_message :=
3165: 'Unable to update FND_DESCR_FLEX_CONTEXTS. ' || Sqlerrm;
3166: GOTO return_error;
3167: END;
3168: END IF;
3169:

Line 3205: FROM fnd_descr_flex_contexts dfc

3201: AND descriptive_flex_context_code = p_descriptive_flex_context_cod
3202: AND application_column_name = p_application_column_name
3203: AND NOT EXISTS
3204: (SELECT null
3205: FROM fnd_descr_flex_contexts dfc
3206: WHERE dfc.application_id = dfcu.application_id
3207: AND dfc.descriptive_flexfield_name =dfcu.descriptive_flexfield_name
3208: AND dfc.descriptive_flex_context_code = dfcu.descriptive_flex_context_code);
3209: x_message := SQL%rowcount || ' row(s) deleted.';