APPS.GL_MANAGEMENT_SEGMENT_UPGRADE dependencies on GL_JE_SEGMENT_VALUES

Line 300: INSERT INTO GL_JE_SEGMENT_VALUES

296: AND b.je_batch_id = msu.je_batch_id
297: AND b.status || '' = 'P';
298:
299: -- Process batches in _GT
300: INSERT INTO GL_JE_SEGMENT_VALUES
301: (je_header_id, segment_type_code, segment_value, creation_date,
302: created_by, last_update_date, last_updated_by, last_update_login)
303: SELECT l.je_header_id, 'M',
304: decode(l_mgt_seg_column_name, 'SEGMENT1', cc.segment1,

Line 402: INSERT INTO GL_JE_SEGMENT_VALUES

398: WHERE b.je_batch_id BETWEEN low_batch_id AND high_batch_id
399: AND b.status <> 'P'
400: AND b.chart_of_accounts_id = X_Chart_Of_Accounts_Id;
401:
402: INSERT INTO GL_JE_SEGMENT_VALUES
403: (je_header_id, segment_type_code, segment_value, creation_date,
404: created_by, last_update_date, last_updated_by, last_update_login)
405: SELECT l.je_header_id, 'M',
406: decode(l_mgt_seg_column_name, 'SEGMENT1', cc.segment1,

Line 571: INSERT INTO GL_JE_SEGMENT_VALUES

567:
568: GL_MESSAGE.write_log('SHRD0209', 1, 'USERLOCK', lock_name);
569:
570: -- Process batches in GL_MGT_SEG_UPGRADE
571: INSERT INTO GL_JE_SEGMENT_VALUES
572: (je_header_id, segment_type_code, segment_value, creation_date,
573: created_by, last_update_date, last_updated_by, last_update_login)
574: SELECT l.je_header_id, 'M',
575: decode(l_mgt_seg_column_name, 'SEGMENT1', cc.segment1,

Line 650: INSERT INTO GL_JE_SEGMENT_VALUES

646:
647: GL_MESSAGE.write_log('MGTS0008', 1, 'BATCHID', l_max_proc_batch_id);
648:
649: -- Process batches beyond max_processed_batch_id
650: INSERT INTO GL_JE_SEGMENT_VALUES
651: (je_header_id, segment_type_code, segment_value, creation_date,
652: created_by, last_update_date, last_updated_by, last_update_login)
653: SELECT l.je_header_id, 'M',
654: decode(l_mgt_seg_column_name, 'SEGMENT1', cc.segment1,