DBA Data[Home] [Help]

APPS.FND_FLEX_LOADER_APIS dependencies on FND_ID_FLEXS

Line 89: SUBTYPE kff_flx_type IS fnd_id_flexs%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;
92: SUBTYPE kff_sgq_tl_type IS fnd_val_attribute_types_tl%ROWTYPE;
93: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;

Line 2237: FROM fnd_id_flexs

2233: get_app(p_application_short_name, l_app);
2234:
2235: SELECT *
2236: INTO x_kff_flx
2237: FROM fnd_id_flexs
2238: WHERE application_id = l_app.application_id
2239: AND id_flex_code = p_id_flex_code;
2240: RETURN TRUE;
2241: EXCEPTION

Line 7749: l_concatenated_segs_view_name fnd_id_flexs.concatenated_segs_view_name%TYPE;

7745: l_kff_str kff_str_type;
7746: l_101_code VARCHAR2(2000);
7747: l_count NUMBER;
7748: l_file_who who_type;
7749: l_concatenated_segs_view_name fnd_id_flexs.concatenated_segs_view_name%TYPE;
7750: BEGIN
7751: l_func_name := g_api_name || 'up_key_flex()';
7752: init('KEY_FLEX', p_upload_phase);
7753: IF (g_debug_on) THEN

Line 7801: UPDATE fnd_id_flexs SET

7797: --
7798: IF (g_debug_on) THEN
7799: debug(l_func_name, 'Translating KEY_FLEX.(non-MLS)');
7800: END IF;
7801: UPDATE fnd_id_flexs SET
7802: last_updated_by = l_file_who.last_updated_by,
7803: last_update_date = l_file_who.last_update_date,
7804: last_update_login = l_file_who.last_update_login,
7805: id_flex_name = Nvl(p_id_flex_name, id_flex_name),

Line 7849: UPDATE fnd_id_flexs SET

7845:
7846: IF (g_debug_on) THEN
7847: debug(l_func_name, 'Updating KEY_FLEX.(non-MLS)');
7848: END IF;
7849: UPDATE fnd_id_flexs SET
7850: last_updated_by = l_file_who.last_updated_by,
7851: last_update_date = l_file_who.last_update_date,
7852: last_update_login = l_file_who.last_update_login,
7853: table_application_id = l_tbl.application_id,

Line 7873: INSERT INTO fnd_id_flexs

7869: IF (SQL%notfound) THEN
7870: IF (g_debug_on) THEN
7871: debug(l_func_name, 'Inserting KEY_FLEX.(non-MLS)');
7872: END IF;
7873: INSERT INTO fnd_id_flexs
7874: (
7875: application_id,
7876: id_flex_code,
7877: