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.1.12010000.2 2008/10/24 20:55:06 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 221: FROM fnd_descr_flex_column_usages u, fnd_descr_flex_contexts c

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

Line 287: FROM fnd_descr_flex_column_usages

283: p_flexfield_name IN VARCHAR2,
284: p_context_code IN VARCHAR2)
285: IS
286: SELECT end_user_column_name
287: FROM fnd_descr_flex_column_usages
288: WHERE application_id = p_application_id
289: AND descriptive_flexfield_name = p_flexfield_name
290: AND descriptive_flex_context_code = p_context_code
291: AND enabled_flag = 'Y'