APPS.FND_FLEX_DIAGNOSE dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 31: SUBTYPE dff_seg_type IS fnd_descr_flex_column_usages%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;
35: SUBTYPE kff_seg_type IS fnd_id_flex_segments%ROWTYPE;

Line 453: FROM fnd_descr_flex_column_usages

449: IS
450: BEGIN
451: SELECT *
452: INTO x_dff_seg
453: FROM fnd_descr_flex_column_usages
454: WHERE application_id = p_dff_ctx.application_id
455: AND descriptive_flexfield_name = p_dff_ctx.descriptive_flexfield_name
456: AND descriptive_flex_context_code =p_dff_ctx.descriptive_flex_context_code
457: AND application_column_name = p_application_column_name;

Line 461: x_message := msg_uts('FND_DESCR_FLEX_COLUMN_USAGES',

457: AND application_column_name = p_application_column_name;
458: RETURN(TRUE);
459: EXCEPTION
460: WHEN OTHERS THEN
461: x_message := msg_uts('FND_DESCR_FLEX_COLUMN_USAGES',
462: 'application_id', p_dff_ctx.application_id,
463: 'descriptive_flexfield_name', p_dff_ctx.descriptive_flexfield_name,
464: 'descriptive_flex_context_code', p_dff_ctx.descriptive_flex_context_code,
465: 'application_column_name', p_application_column_name);

Line 3198: FROM fnd_descr_flex_column_usages dfcu

3194: -- Segments without DFF Context.
3195: --
3196: BEGIN
3197: DELETE
3198: FROM fnd_descr_flex_column_usages dfcu
3199: WHERE application_id = p_application_id
3200: AND descriptive_flexfield_name = p_descriptive_flexfield_name
3201: AND descriptive_flex_context_code = p_descriptive_flex_context_cod
3202: AND application_column_name = p_application_column_name

Line 3214: 'Unable to delete from FND_DESCR_FLEX_COLUMN_USAGES. ' ||Sqlerrm;

3210: GOTO return_success;
3211: EXCEPTION
3212: WHEN OTHERS THEN
3213: x_message :=
3214: 'Unable to delete from FND_DESCR_FLEX_COLUMN_USAGES. ' ||Sqlerrm;
3215: GOTO return_error;
3216: END;
3217: END IF;
3218:

Line 3293: UPDATE fnd_descr_flex_column_usages SET

3289: GOTO return_error;
3290: END IF;
3291:
3292: BEGIN
3293: UPDATE fnd_descr_flex_column_usages SET
3294: flex_value_set_id = NULL,
3295: last_update_date = Sysdate,
3296: last_updated_by = 1
3297: WHERE application_id = l_dff_seg.application_id

Line 3306: 'Unable to update FND_DESCR_FLEX_COLUMN_USAGES. ' || Sqlerrm;

3302: GOTO return_success;
3303: EXCEPTION
3304: WHEN OTHERS THEN
3305: x_message :=
3306: 'Unable to update FND_DESCR_FLEX_COLUMN_USAGES. ' || Sqlerrm;
3307: GOTO return_error;
3308: END;
3309: END IF;
3310:

Line 3346: UPDATE fnd_descr_flex_column_usages SET

3342: l_dff_seg.security_enabled_flag := 'N';
3343: END IF;
3344:
3345: BEGIN
3346: UPDATE fnd_descr_flex_column_usages SET
3347: default_type = l_dff_seg.default_type,
3348: enabled_flag = l_dff_seg.enabled_flag,
3349: display_flag = l_dff_seg.display_flag,
3350: range_code = l_dff_seg.range_code,

Line 3364: 'Unable to update FND_DESCR_FLEX_COLUMN_USAGES. ' || Sqlerrm;

3360: GOTO return_success;
3361: EXCEPTION
3362: WHEN OTHERS THEN
3363: x_message :=
3364: 'Unable to update FND_DESCR_FLEX_COLUMN_USAGES. ' || Sqlerrm;
3365: GOTO return_error;
3366: END;
3367: END IF;
3368: