DBA Data[Home] [Help]

APPS.FND_FLEX_LOADER_APIS dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 86: SUBTYPE dff_seg_type IS fnd_descr_flex_column_usages%ROWTYPE;

82: SUBTYPE dff_flx_tl_type IS fnd_descriptive_flexs_tl%ROWTYPE;
83: SUBTYPE dff_ref_type IS fnd_default_context_fields%ROWTYPE;
84: SUBTYPE dff_ctx_type IS fnd_descr_flex_contexts%ROWTYPE;
85: SUBTYPE dff_ctx_tl_type IS fnd_descr_flex_contexts_tl%ROWTYPE;
86: SUBTYPE dff_seg_type IS fnd_descr_flex_column_usages%ROWTYPE;
87: SUBTYPE dff_seg_tl_type IS fnd_descr_flex_col_usage_tl%ROWTYPE;
88:
89: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;
90: SUBTYPE kff_flq_type IS fnd_segment_attribute_types%ROWTYPE;

Line 2145: FROM fnd_descr_flex_column_usages

2141: BEGIN
2142: l_func_name := g_api_name || 'get_dff_seg(F)';
2143: SELECT *
2144: INTO x_dff_seg
2145: FROM fnd_descr_flex_column_usages
2146: WHERE application_id = p_dff_ctx.application_id
2147: AND descriptive_flexfield_name = p_dff_ctx.descriptive_flexfield_name
2148: AND descriptive_flex_context_code = p_dff_ctx.descriptive_flex_context_code
2149: AND application_column_name = p_application_column_name;

Line 5901: FROM fnd_descr_flex_column_usages

5897: WHERE application_id = l_app.application_id
5898: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
5899:
5900: DELETE
5901: FROM fnd_descr_flex_column_usages
5902: WHERE application_id = l_app.application_id
5903: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
5904:
5905: DELETE

Line 5950: UPDATE fnd_descr_flex_column_usages

5946: SET descriptive_flexfield_name = p_descriptive_flexfield_name
5947: WHERE application_id = l_app.application_id
5948: AND descriptive_flexfield_name = g_srs_loader_flex_name;
5949:
5950: UPDATE fnd_descr_flex_column_usages
5951: SET descriptive_flexfield_name = p_descriptive_flexfield_name
5952: WHERE application_id = l_app.application_id
5953: AND descriptive_flexfield_name = g_srs_loader_flex_name;
5954:

Line 6119: FROM fnd_descr_flex_column_usages

6115: p_descriptive_flexfield_name IN VARCHAR2,
6116: p_descriptive_flex_context_cod IN VARCHAR2)
6117: IS
6118: SELECT *
6119: FROM fnd_descr_flex_column_usages
6120: WHERE application_id = p_application_id
6121: AND descriptive_flexfield_name = p_descriptive_flexfield_name
6122: AND descriptive_flex_context_code = p_descriptive_flex_context_cod
6123: ORDER BY application_column_name;

Line 7525: FROM fnd_descr_flex_column_usages fdfcu,

7521: l_ctx_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;
7522: BEGIN
7523: SELECT fdfc.descriptive_flex_context_code
7524: INTO l_ctx_code
7525: FROM fnd_descr_flex_column_usages fdfcu,
7526: fnd_descr_flex_contexts fdfc
7527: WHERE fdfcu.application_column_name = p_application_column_name
7528: AND fdfcu.descriptive_flex_context_code = fdfc.descriptive_flex_context_code
7529: AND fdfcu.descriptive_flexfield_name = fdfc.descriptive_flexfield_name