DBA Data[Home] [Help]

APPS.FND_FLEX_LOADER_APIS dependencies on FND_DESCR_FLEX_CONTEXTS

Line 84: SUBTYPE dff_ctx_type IS fnd_descr_flex_contexts%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;
88:

Line 85: SUBTYPE dff_ctx_tl_type IS fnd_descr_flex_contexts_tl%ROWTYPE;

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;
88:
89: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;

Line 2066: FROM fnd_descr_flex_contexts

2062: BEGIN
2063: l_func_name := g_api_name || 'get_dff_ctx(F)';
2064: SELECT *
2065: INTO x_dff_ctx
2066: FROM fnd_descr_flex_contexts
2067: WHERE application_id = p_dff_flx.application_id
2068: AND descriptive_flexfield_name = p_dff_flx.descriptive_flexfield_name
2069: AND descriptive_flex_context_code = p_descriptive_flex_context_cod;
2070: RETURN TRUE;

Line 2117: FROM fnd_descr_flex_contexts_tl

2113: BEGIN
2114: l_func_name := g_api_name || 'get_dff_ctx_tl(F)';
2115: SELECT *
2116: INTO x_dff_ctx_tl
2117: FROM fnd_descr_flex_contexts_tl
2118: WHERE application_id = p_dff_ctx.application_id
2119: AND descriptive_flexfield_name = p_dff_ctx.descriptive_flexfield_name
2120: AND descriptive_flex_context_code = p_dff_ctx.descriptive_flex_context_code
2121: AND language = p_language;

Line 5891: FROM fnd_descr_flex_contexts

5887: WHERE application_id = l_app.application_id
5888: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
5889:
5890: DELETE
5891: FROM fnd_descr_flex_contexts
5892: WHERE application_id = l_app.application_id
5893: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
5894:
5895: DELETE

Line 5896: FROM fnd_descr_flex_contexts_tl

5892: WHERE application_id = l_app.application_id
5893: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
5894:
5895: DELETE
5896: FROM fnd_descr_flex_contexts_tl
5897: WHERE application_id = l_app.application_id
5898: AND descriptive_flexfield_name = p_descriptive_flexfield_name;
5899:
5900: DELETE

Line 5940: UPDATE fnd_descr_flex_contexts

5936: title = p_title
5937: WHERE application_id = l_app.application_id
5938: AND descriptive_flexfield_name = g_srs_loader_flex_name;
5939:
5940: UPDATE fnd_descr_flex_contexts
5941: SET descriptive_flexfield_name = p_descriptive_flexfield_name
5942: WHERE application_id = l_app.application_id
5943: AND descriptive_flexfield_name = g_srs_loader_flex_name;
5944:

Line 5945: UPDATE fnd_descr_flex_contexts_tl

5941: SET descriptive_flexfield_name = p_descriptive_flexfield_name
5942: WHERE application_id = l_app.application_id
5943: AND descriptive_flexfield_name = g_srs_loader_flex_name;
5944:
5945: UPDATE fnd_descr_flex_contexts_tl
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:

Line 7228: fnd_descr_flex_contexts_pkg.translate_row

7224:
7225: IF (g_debug_on) THEN
7226: debug(l_func_name, 'Translating DFF_CONTEXT.(MLS)');
7227: END IF;
7228: fnd_descr_flex_contexts_pkg.translate_row
7229: (x_application_short_name => p_application_short_name,
7230: x_descriptive_flexfield_name => l_descriptive_flexfield_name,
7231: x_descriptive_flex_context_cod => p_descriptive_flex_context_cod,
7232: x_who => l_file_who,

Line 7287: fnd_descr_flex_contexts_pkg.load_row

7283:
7284: IF (g_debug_on) THEN
7285: debug(l_func_name, 'Uploading DFF_CONTEXT.(MLS)');
7286: END IF;
7287: fnd_descr_flex_contexts_pkg.load_row
7288: (x_application_short_name => p_application_short_name,
7289: x_descriptive_flexfield_name => l_descriptive_flexfield_name,
7290: x_descriptive_flex_context_cod => p_descriptive_flex_context_cod,
7291: x_who => l_file_who,

Line 7521: l_ctx_code fnd_descr_flex_contexts.descriptive_flex_context_code%TYPE;

7517: -- Check for duplicate column usage between Global and any Context
7518: --
7519: DECLARE
7520: l_error_msg VARCHAR2(2000);
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,

Line 7526: fnd_descr_flex_contexts fdfc

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
7530: AND fdfcu.application_id = fdfc.application_id