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 7050: UPDATE fnd_default_context_fields SET

7046: --
7047: IF (g_debug_on) THEN
7048: debug(l_func_name, 'Translating DFF_REF_FIELD.(non-MLS)');
7049: END IF;
7050: UPDATE fnd_default_context_fields SET
7051: last_updated_by = l_file_who.last_updated_by,
7052: last_update_date = l_file_who.last_update_date,
7053: last_update_login = l_file_who.last_update_login,
7054: description = Nvl(p_description, description)

Line 7084: UPDATE fnd_default_context_fields SET

7080:
7081: IF (g_debug_on) THEN
7082: debug(l_func_name, 'Updating DFF_REF_FIELD.(non-MLS)');
7083: END IF;
7084: UPDATE fnd_default_context_fields SET
7085: last_updated_by = l_file_who.last_updated_by,
7086: last_update_date = l_file_who.last_update_date,
7087: last_update_login = l_file_who.last_update_login,
7088: description = p_description

Line 7097: INSERT INTO fnd_default_context_fields

7093: IF (SQL%notfound) THEN
7094: IF (g_debug_on) THEN
7095: debug(l_func_name, 'Inserting DFF_REF_FIELD.(non-MLS)');
7096: END IF;
7097: INSERT INTO fnd_default_context_fields
7098: (
7099: application_id,
7100: descriptive_flexfield_name,
7101: default_context_field_name,