DBA Data[Home] [Help]

APPS.FND_FLEX_LOADER_APIS dependencies on FND_DESCR_FLEX_COL_USAGE_TL

Line 87: SUBTYPE dff_seg_tl_type IS fnd_descr_flex_col_usage_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;
91: SUBTYPE kff_sgq_type IS fnd_value_attribute_types%ROWTYPE;

Line 2200: FROM fnd_descr_flex_col_usage_tl

2196: BEGIN
2197: l_func_name := g_api_name || 'get_dff_seg_tl(F)';
2198: SELECT *
2199: INTO x_dff_seg_tl
2200: FROM fnd_descr_flex_col_usage_tl
2201: WHERE application_id = p_dff_seg.application_id
2202: AND descriptive_flexfield_name = p_dff_seg.descriptive_flexfield_name
2203: AND descriptive_flex_context_code = p_dff_seg.descriptive_flex_context_code
2204: AND application_column_name = p_dff_seg.application_column_name

Line 5906: FROM fnd_descr_flex_col_usage_tl

5902: WHERE application_id = l_app.application_id
5903: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
5904:
5905: DELETE
5906: FROM fnd_descr_flex_col_usage_tl
5907: WHERE application_id = l_app.application_id
5908: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
5909:
5910: EXCEPTION

Line 5955: UPDATE fnd_descr_flex_col_usage_tl

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:
5955: UPDATE fnd_descr_flex_col_usage_tl
5956: SET descriptive_flexfield_name = p_descriptive_flexfield_name
5957: WHERE application_id = l_app.application_id
5958: AND descriptive_flexfield_name = g_srs_loader_flex_name;
5959: