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 61: DELETE FROM FND_ID_FLEX_SEGMENTS

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

Line 66: DELETE FROM FND_ID_FLEX_SEGMENTS_TL

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

Line 178: INSERT INTO FND_ID_FLEX_SEGMENTS

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

Line 241: INSERT INTO FND_ID_FLEX_SEGMENTS

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

Line 293: FROM FND_ID_FLEX_SEGMENTS

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

Line 300: INSERT INTO FND_ID_FLEX_SEGMENTS_TL

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

Line 337: FROM FND_ID_FLEX_SEGMENTS_TL t

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

Line 350: INSERT INTO FND_ID_FLEX_SEGMENTS_TL

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

Line 382: FROM FND_ID_FLEX_SEGMENTS_TL

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

Line 414: FROM FND_ID_FLEX_SEGMENTS

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

Line 453: FROM FND_ID_FLEX_SEGMENTS

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