DBA Data[Home] [Help]

APPS.FND_FLEX_LOADER_APIS dependencies on FND_DEFAULT_CONTEXT_FIELDS

Line 83: SUBTYPE dff_ref_type IS fnd_default_context_fields%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;
87: SUBTYPE dff_seg_tl_type IS fnd_descr_flex_col_usage_tl%ROWTYPE;

Line 2014: FROM fnd_default_context_fields

2010: BEGIN
2011: l_func_name := g_api_name || 'get_dff_ref(F)';
2012: SELECT *
2013: INTO x_dff_ref
2014: FROM fnd_default_context_fields
2015: WHERE application_id = p_dff_flx.application_id
2016: AND descriptive_flexfield_name = p_dff_flx.descriptive_flexfield_name
2017: AND default_context_field_name = p_default_context_field_name;
2018: RETURN TRUE;

Line 7056: UPDATE fnd_default_context_fields SET

7052: --
7053: IF (g_debug_on) THEN
7054: debug(l_func_name, 'Translating DFF_REF_FIELD.(non-MLS)');
7055: END IF;
7056: UPDATE fnd_default_context_fields SET
7057: last_updated_by = l_file_who.last_updated_by,
7058: last_update_date = l_file_who.last_update_date,
7059: last_update_login = l_file_who.last_update_login,
7060: description = Nvl(p_description, description)

Line 7090: UPDATE fnd_default_context_fields SET

7086:
7087: IF (g_debug_on) THEN
7088: debug(l_func_name, 'Updating DFF_REF_FIELD.(non-MLS)');
7089: END IF;
7090: UPDATE fnd_default_context_fields SET
7091: last_updated_by = l_file_who.last_updated_by,
7092: last_update_date = l_file_who.last_update_date,
7093: last_update_login = l_file_who.last_update_login,
7094: description = p_description

Line 7103: INSERT INTO fnd_default_context_fields

7099: IF (SQL%notfound) THEN
7100: IF (g_debug_on) THEN
7101: debug(l_func_name, 'Inserting DFF_REF_FIELD.(non-MLS)');
7102: END IF;
7103: INSERT INTO fnd_default_context_fields
7104: (
7105: application_id,
7106: descriptive_flexfield_name,
7107: default_context_field_name,