APPS.GL_GLCOAM_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 70: DELETE FROM FND_SEGMENT_ATTRIBUTE_VALUES

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

Line 387: INSERT INTO FND_SEGMENT_ATTRIBUTE_VALUES

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

Line 419: INSERT INTO FND_SEGMENT_ATTRIBUTE_VALUES

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

Line 445: FROM FND_SEGMENT_ATTRIBUTE_VALUES val,

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

Line 462: INSERT INTO FND_SEGMENT_ATTRIBUTE_VALUES

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

Line 488: FROM FND_SEGMENT_ATTRIBUTE_VALUES val,

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