DBA Data[Home] [Help]

APPS.FND_FLEX_APIS dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 119: FROM fnd_descr_flex_column_usages

115: IS
116: BEGIN
117: SELECT COUNT(*)
118: INTO x_num_of_segments
119: FROM fnd_descr_flex_column_usages
120: WHERE application_id = x_application_id
121: AND descriptive_flexfield_name = '$SRS$.'||x_conc_prog_name
122: AND enabled_flag = 'Y'
123: AND '$Header: AFFFAPIB.pls 120.3 2010/05/25 17:13:54 tebarnes ship $' IS NOT NULL;

Line 177: FROM fnd_descr_flex_column_usages u, fnd_descr_flex_contexts c

173: BEGIN
174: /* Changed existence check logic: Bug 4081024 */
175: SELECT 1
176: INTO row_count
177: FROM fnd_descr_flex_column_usages u, fnd_descr_flex_contexts c
178: WHERE u.application_id = x_application_id
179: AND u.descriptive_flexfield_name = x_desc_flex_name
180: AND c.application_id = u.application_id
181: AND c.descriptive_flexfield_name = u.descriptive_flexfield_name

Line 218: FROM fnd_descr_flex_column_usages u, fnd_descr_flex_contexts c

214: BEGIN
215: /* Changed existence check logic: Bug 4081024 */
216: SELECT 1
217: INTO row_count
218: FROM fnd_descr_flex_column_usages u, fnd_descr_flex_contexts c
219: WHERE u.application_id = x_application_id
220: AND u.descriptive_flexfield_name = x_desc_flex_name
221: AND c.application_id = u.application_id
222: AND c.descriptive_flexfield_name = u.descriptive_flexfield_name

Line 257: FROM fnd_descr_flex_column_usages u, fnd_descr_flex_contexts c

253: BEGIN
254: /* Changed existence check logic: Bug 4081024 */
255: SELECT 1
256: INTO row_count
257: FROM fnd_descr_flex_column_usages u, fnd_descr_flex_contexts c
258: WHERE u.application_id = x_application_id
259: AND u.descriptive_flexfield_name = x_desc_flex_name
260: AND c.application_id = u.application_id
261: AND c.descriptive_flexfield_name = u.descriptive_flexfield_name

Line 333: FROM fnd_descr_flex_column_usages

329: p_flexfield_name IN VARCHAR2,
330: p_context_code IN VARCHAR2)
331: IS
332: SELECT end_user_column_name
333: FROM fnd_descr_flex_column_usages
334: WHERE application_id = p_application_id
335: AND descriptive_flexfield_name = p_flexfield_name
336: AND descriptive_flex_context_code = p_context_code
337: AND enabled_flag = 'Y'