DBA Data[Home] [Help]

APPS.FND_CONCURRENT_ARGUMENTS_PKG dependencies on FND_DESCR_FLEX_COL_USAGE_TL

Line 105: INSERT INTO fnd_descr_flex_col_usage_TL

101: --
102: -- Insert translated columns in _TL table.
103: --
104:
105: INSERT INTO fnd_descr_flex_col_usage_TL
106: (
107: application_id,
108: descriptive_flexfield_name,
109: descriptive_flex_context_code,

Line 140: FROM fnd_descr_flex_col_usage_TL T

136: FROM FND_LANGUAGES L
137: WHERE L.installed_flag in ('I', 'B')
138: AND not exists
139: (SELECT NULL
140: FROM fnd_descr_flex_col_usage_TL T
141: WHERE T.application_id = X_APPLICATION_ID
142: AND T.descriptive_flexfield_name = X_DESCRIPTIVE_FLEXFIELD_NAME
143: AND T.descriptive_flex_context_code = X_DESCRIPTIVE_FLEX_CONTEXT_COD
144: AND T.application_column_name = X_APPLICATION_COLUMN_NAME

Line 207: FROM fnd_descr_flex_col_usage_TL

203: Recinfo C%ROWTYPE;
204: CURSOR C1 IS
205: SELECT application_column_name, form_left_prompt,
206: form_above_prompt, description
207: FROM fnd_descr_flex_col_usage_TL
208: WHERE application_id = X_APPLICATION_ID
209: AND descriptive_flexfield_name = X_DESCRIPTIVE_FLEXFIELD_NAME
210: AND descriptive_flex_context_code = X_DESCRIPTIVE_FLEX_CONTEXT_COD
211: AND application_column_name = X_APPLICATION_COLUMN_NAME

Line 370: UPDATE fnd_descr_flex_col_usage_tl SET

366:
367: --
368: -- Update translated columns in _TL for current language
369: --
370: UPDATE fnd_descr_flex_col_usage_tl SET
371: form_left_prompt = X_FORM_LEFT_PROMPT,
372: form_above_prompt = X_FORM_ABOVE_PROMPT,
373: description = X_DESCRIPTION,
374: last_update_date = X_LAST_UPDATE_DATE,

Line 409: DELETE FROM fnd_descr_flex_col_usage_TL

405: if (SQL%NOTFOUND) then
406: Raise NO_DATA_FOUND;
407: end if;
408:
409: DELETE FROM fnd_descr_flex_col_usage_TL
410: WHERE application_id = X_APPLICATION_ID
411: AND descriptive_flexfield_name = X_DESCRIPTIVE_FLEXFIELD_NAME
412: AND descriptive_flex_context_code = X_DESCRIPTIVE_FLEX_CONTEXT_COD
413: AND application_column_name = X_APPLICATION_COLUMN_NAME;