APPS.GL_GLCOAM_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 71: DELETE FROM FND_SEGMENT_ATTRIBUTE_VALUES

67: WHERE application_id = 101
68: AND id_flex_code = 'GLLE'
69: AND id_flex_num = X_id_flex_num;
70:
71: DELETE FROM FND_SEGMENT_ATTRIBUTE_VALUES
72: WHERE application_id = 101
73: AND id_flex_code = 'GLLE'
74: AND id_flex_num = X_id_flex_num;
75:

Line 388: INSERT INTO FND_SEGMENT_ATTRIBUTE_VALUES

384: AND id_flex_code = 'GL#'
385: AND id_flex_num = X_id_flex_num;
386:
387: --Insert the GL_LEDGER qualifier for all of the segments.
388: INSERT INTO FND_SEGMENT_ATTRIBUTE_VALUES
389: (application_id,
390: id_flex_code,
391: id_flex_num,
392: application_column_name,

Line 420: INSERT INTO FND_SEGMENT_ATTRIBUTE_VALUES

416: AND id_flex_code = 'GLLE'
417: AND id_flex_num = X_id_flex_num;
418:
419: --Insert the qualifiers for the ledger segment.
420: INSERT INTO FND_SEGMENT_ATTRIBUTE_VALUES
421: (application_id,
422: id_flex_code,
423: id_flex_num,
424: application_column_name,

Line 446: FROM FND_SEGMENT_ATTRIBUTE_VALUES val,

442: x_user_id,
443: x_login_id,
444: decode(val.segment_attribute_type,'GL_GLOBAL','Y','N')
445: -- security_group_id
446: FROM FND_SEGMENT_ATTRIBUTE_VALUES val,
447: FND_SEGMENT_ATTRIBUTE_TYPES typ
448: WHERE val.application_id=101
449: AND val.id_flex_code = 'GL#'
450: AND val.id_flex_num = X_id_flex_num

Line 463: INSERT INTO FND_SEGMENT_ATTRIBUTE_VALUES

459: AND typ.id_flex_code = 'GLLE'
460: AND typ.segment_attribute_type = val.segment_attribute_type;
461:
462: --Insert the qualifiers for the remaining segments.
463: INSERT INTO FND_SEGMENT_ATTRIBUTE_VALUES
464: (application_id,
465: id_flex_code,
466: id_flex_num,
467: application_column_name,

Line 489: FROM FND_SEGMENT_ATTRIBUTE_VALUES val,

485: x_user_id,
486: x_login_id,
487: val.attribute_value
488: -- security_group_id
489: FROM FND_SEGMENT_ATTRIBUTE_VALUES val,
490: FND_SEGMENT_ATTRIBUTE_TYPES typ
491: WHERE val.application_id = 101
492: AND val.id_flex_code = 'GL#'
493: AND val.id_flex_num = X_id_flex_num