[Home] [Help]
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;
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
7751: l_kff_str kff_str_type;
7752: l_101_code VARCHAR2(2000);
7753: l_count NUMBER;
7754: l_file_who who_type;
7755: l_concatenated_segs_view_name fnd_id_flexs.concatenated_segs_view_name%TYPE;
7756: BEGIN
7757: l_func_name := g_api_name || 'up_key_flex()';
7758: init('KEY_FLEX', p_upload_phase);
7759: IF (g_debug_on) THEN
7803: --
7804: IF (g_debug_on) THEN
7805: debug(l_func_name, 'Translating KEY_FLEX.(non-MLS)');
7806: END IF;
7807: UPDATE fnd_id_flexs SET
7808: last_updated_by = l_file_who.last_updated_by,
7809: last_update_date = l_file_who.last_update_date,
7810: last_update_login = l_file_who.last_update_login,
7811: id_flex_name = Nvl(p_id_flex_name, id_flex_name),
7851:
7852: IF (g_debug_on) THEN
7853: debug(l_func_name, 'Updating KEY_FLEX.(non-MLS)');
7854: END IF;
7855: UPDATE fnd_id_flexs SET
7856: last_updated_by = l_file_who.last_updated_by,
7857: last_update_date = l_file_who.last_update_date,
7858: last_update_login = l_file_who.last_update_login,
7859: table_application_id = l_tbl.application_id,
7875: IF (SQL%notfound) THEN
7876: IF (g_debug_on) THEN
7877: debug(l_func_name, 'Inserting KEY_FLEX.(non-MLS)');
7878: END IF;
7879: INSERT INTO fnd_id_flexs
7880: (
7881: application_id,
7882: id_flex_code,
7883: