78: SUBTYPE vst_val_tl_type IS fnd_flex_values_tl%ROWTYPE;
79: SUBTYPE vst_vlh_type IS fnd_flex_value_norm_hierarchy%ROWTYPE;
80:
81: SUBTYPE dff_flx_type IS fnd_descriptive_flexs%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;
1984: BEGIN
1985: l_func_name := g_api_name || 'get_dff_flx_tl(F)';
1986: SELECT *
1987: INTO x_dff_flx_tl
1988: FROM fnd_descriptive_flexs_tl
1989: WHERE application_id = p_dff_flx.application_id
1990: AND descriptive_flexfield_name = p_dff_flx.descriptive_flexfield_name
1991: AND language = p_language;
1992: RETURN TRUE;
5882: WHERE application_id = l_app.application_id
5883: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
5884:
5885: DELETE
5886: FROM fnd_descriptive_flexs_tl
5887: WHERE application_id = l_app.application_id
5888: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
5889:
5890: DELETE
5930: SET descriptive_flexfield_name = p_descriptive_flexfield_name
5931: WHERE application_id = l_app.application_id
5932: AND descriptive_flexfield_name = g_srs_loader_flex_name;
5933:
5934: UPDATE fnd_descriptive_flexs_tl
5935: SET descriptive_flexfield_name = p_descriptive_flexfield_name,
5936: title = p_title
5937: WHERE application_id = l_app.application_id
5938: AND descriptive_flexfield_name = g_srs_loader_flex_name;