[Home] [Help]
61:
62:
63: SUBTYPE app_type IS fnd_application%ROWTYPE;
64: SUBTYPE tbl_type IS fnd_tables%ROWTYPE;
65: SUBTYPE col_type IS fnd_columns%ROWTYPE;
66: SUBTYPE resp_type IS fnd_responsibility%ROWTYPE;
67:
68: SUBTYPE vst_set_type IS fnd_flex_value_sets%ROWTYPE;
69: SUBTYPE vst_tbl_type IS fnd_flex_validation_tables%ROWTYPE;
1154: get_tbl(l_app.application_short_name, p_table_name, l_tbl);
1155:
1156: SELECT *
1157: INTO x_col
1158: FROM fnd_columns
1159: WHERE application_id = l_tbl.application_id
1160: AND table_id = l_tbl.table_id
1161: AND column_name = p_column_name;
1162: RETURN TRUE;
6761: END IF;
6762:
6763: IF (l_descriptive_flexfield_name NOT LIKE '$SRS$.%') THEN
6764: --
6765: -- Make sure Context column is marked in fnd_columns.
6766: --
6767: fnd_flex_loader_apis.up_dff_column
6768: (p_upload_phase => 'LEAF',
6769: p_upload_mode => NULL,
6939:
6940: IF (g_debug_on) THEN
6941: debug(l_func_name, 'Updating DFF_COLUMN.(no-TL)');
6942: END IF;
6943: UPDATE fnd_columns SET
6944: last_updated_by = l_file_who.last_updated_by,
6945: last_update_date = l_file_who.last_update_date,
6946: last_update_login = l_file_who.last_update_login,
6947: flexfield_application_id = Decode(p_flexfield_usage_code,
7939: -- Usual upload.
7940: --
7941:
7942: --
7943: -- Make sure columns are marked in fnd_columns.
7944: --
7945: fnd_flex_loader_apis.up_kff_column
7946: (p_upload_phase => 'LEAF',
7947: p_upload_mode => NULL,
8192:
8193: IF (g_debug_on) THEN
8194: debug(l_func_name, 'Updating KFF_COLUMN.(no-TL)');
8195: END IF;
8196: UPDATE fnd_columns SET
8197: last_updated_by = l_file_who.last_updated_by,
8198: last_update_date = l_file_who.last_update_date,
8199: last_update_login = l_file_who.last_update_login,
8200: flexfield_application_id = NULL,
8570: x_prompt => p_prompt,
8571: x_description => p_description);
8572:
8573: --
8574: -- Make sure application column is marked in fnd_columns.
8575: --
8576: fnd_flex_loader_apis.up_kff_column
8577: (p_upload_phase => 'LEAF',
8578: p_upload_mode => NULL,