APPS.GL_GLCOAM_PKG dependencies on FND_ID_FLEX_SEGMENTS_TL

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 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: