APPS.GL_GLCOAM_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 28: FROM FND_ID_FLEX_SEGMENTS

24: AND id_flex_num = flex_num;
25:
26: CURSOR segments_exist(flex_num NUMBER) IS
27: SELECT id_flex_num
28: FROM FND_ID_FLEX_SEGMENTS
29: WHERE application_id = 101
30: AND id_flex_code = 'GL#'
31: AND id_flex_num = flex_num;
32:

Line 60: DELETE FROM FND_ID_FLEX_SEGMENTS

56: WHERE application_id = 101
57: AND id_flex_code = 'GLLE'
58: AND id_flex_num = X_id_flex_num;
59:
60: DELETE FROM FND_ID_FLEX_SEGMENTS
61: WHERE application_id = 101
62: AND id_flex_code = 'GLLE'
63: AND id_flex_num = X_id_flex_num;
64:

Line 65: DELETE FROM FND_ID_FLEX_SEGMENTS_TL

61: WHERE application_id = 101
62: AND id_flex_code = 'GLLE'
63: AND id_flex_num = X_id_flex_num;
64:
65: DELETE FROM FND_ID_FLEX_SEGMENTS_TL
66: WHERE application_id = 101
67: AND id_flex_code = 'GLLE'
68: AND id_flex_num = X_id_flex_num;
69:

Line 177: INSERT INTO FND_ID_FLEX_SEGMENTS

173: FETCH segments_exist INTO x_num;
174: IF(segments_exist%FOUND)THEN
175:
176: --Insert the ledger segment as the first segment for the new structure.
177: INSERT INTO FND_ID_FLEX_SEGMENTS
178: (application_id,
179: id_flex_code,
180: id_flex_num,
181: application_column_name,

Line 240: INSERT INTO FND_ID_FLEX_SEGMENTS

236: AND lv.lookup_code = 'L'
237: AND lv.view_application_id = 101;
238:
239: --Copy the segments of the same structure based on the Accounting Flexfield.
240: INSERT INTO FND_ID_FLEX_SEGMENTS
241: (application_id,
242: id_flex_code,
243: id_flex_num,
244: application_column_name,

Line 292: FROM FND_ID_FLEX_SEGMENTS

288: default_type,
289: default_value,
290: runtime_property_function
291: -- security_group_id
292: FROM FND_ID_FLEX_SEGMENTS
293: WHERE application_id = 101
294: AND id_flex_code = 'GL#'
295: AND id_flex_num = X_id_flex_num;
296:

Line 299: INSERT INTO FND_ID_FLEX_SEGMENTS_TL

295: AND id_flex_num = X_id_flex_num;
296:
297: --Insert the ledger segment in multiple languages supported by the
298: --application.
299: INSERT INTO FND_ID_FLEX_SEGMENTS_TL
300: (application_id,
301: id_flex_code,
302: id_flex_num,
303: application_column_name,

Line 336: FROM FND_ID_FLEX_SEGMENTS_TL t

332: FND_LANGUAGES l
333: WHERE l.installed_flag in ('B','I')
334: AND NOT EXISTS
335: (SELECT NULL
336: FROM FND_ID_FLEX_SEGMENTS_TL t
337: WHERE t.application_id = 101
338: AND t.id_flex_code = 'GLLE'
339: AND t.id_flex_num = X_id_flex_num
340: AND t.application_column_name = 'LEDGER_SEGMENT'

Line 349: INSERT INTO FND_ID_FLEX_SEGMENTS_TL

345: AND lv.view_application_id = 101;
346:
347: --Insert the remaining segments in multiple languages supported by the
348: --application.
349: INSERT INTO FND_ID_FLEX_SEGMENTS_TL
350: (application_id,
351: id_flex_code,
352: id_flex_num,
353: application_column_name,

Line 381: FROM FND_ID_FLEX_SEGMENTS_TL

377: form_above_prompt,
378: description,
379: source_lang
380: -- security_group_id
381: FROM FND_ID_FLEX_SEGMENTS_TL
382: WHERE application_id = 101
383: AND id_flex_code = 'GL#'
384: AND id_flex_num = X_id_flex_num;
385:

Line 413: FROM FND_ID_FLEX_SEGMENTS

409: x_user_id,
410: x_login_id,
411: decode(application_column_name,'LEDGER_SEGMENT','Y','N')
412: -- security_group_id
413: FROM FND_ID_FLEX_SEGMENTS
414: WHERE application_id =101
415: AND id_flex_code = 'GLLE'
416: AND id_flex_num = X_id_flex_num;
417:

Line 452: FROM FND_ID_FLEX_SEGMENTS

448: AND val.id_flex_code = 'GL#'
449: AND val.id_flex_num = X_id_flex_num
450: AND val.application_column_name =
451: (SELECT application_column_name
452: FROM FND_ID_FLEX_SEGMENTS
453: WHERE application_id = 101
454: AND id_flex_code = 'GL#'
455: AND id_flex_num = X_id_flex_num
456: AND rownum=1)