eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_FLATTEN_LEDGER_SETS dependencies on GL_LEDGER_SET_NORM_ASSIGN

Line 155: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,

151: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
152: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
153: GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID,
154: NULL, gllsna.start_date, gllsna.end_date
155: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,
156: GL_LEDGERS gll
157: WHERE gllsna.status_code = 'I'
158: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
159: AND gll.ledger_id = gllsna.ledger_set_id

Line 226: -- 1) For all records in GL_LEDGER_SET_NORM_ASSIGN with a status_code

222:
223: -- This section of code will mark any outdated ledger set/ledger
224: -- mappings for delete.
225: -- Here is the sequence of events:
226: -- 1) For all records in GL_LEDGER_SET_NORM_ASSIGN with a status_code
227: -- of 'D', go into GL_LEDGER_SET_ASSIGNMENTS and determine all
228: -- records that contain the deleted mappings, and mark them for
229: -- delete as well.
230: -- 2) For any ledger sets that are deleted, mark all of their

Line 261: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,

257: SET gllsa1.status_code = 'D'
258: WHERE NVL(gllsa1.status_code, 'X') <> 'D'
259: AND (gllsa1.ledger_set_id, gllsa1.ledger_id) IN
260: (SELECT distinct gllsa2.ledger_set_id, gllsna.ledger_id
261: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,
262: GL_LEDGERS gll,
263: GL_LEDGER_SET_ASSIGNMENTS gllsa2
264: WHERE gllsna.status_code = 'D'
265: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID

Line 299: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,

295: SET gllsa1.status_code = 'D'
296: WHERE NVL(gllsa1.status_code, 'X') <> 'D'
297: AND (gllsa1.ledger_set_id, gllsa1.ledger_id) IN
298: (SELECT distinct gllsa2.ledger_set_id, gllsa3.ledger_id
299: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,
300: GL_LEDGERS gll,
301: GL_LEDGER_SET_ASSIGNMENTS gllsa2,
302: GL_LEDGER_SET_ASSIGNMENTS gllsa3
303: WHERE gllsna.status_code = 'D'

Line 361: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna

357: AND gllsa3.ledger_set_id = gllsa1.ledger_set_id
358: AND gllsa3.ledger_id = gllsa2.ledger_set_id)
359: OR EXISTS
360: (SELECT 1
361: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna
362: WHERE gllsna.ledger_set_id = gllsa1.ledger_set_id
363: AND gllsna.ledger_id = gllsa1.ledger_id
364: AND gllsna.status_code is NULL));
365:

Line 449: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,

445: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
446: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,
447: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
448: NULL, NULL
449: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,
450: GL_LEDGERS gll,
451: GL_LEDGER_SET_ASSIGNMENTS gllsa
452: WHERE gllsna.status_code = 'I'
453: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID

Line 502: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,

498: 'I', SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
499: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,
500: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
501: NULL, NULL
502: FROM GL_LEDGER_SET_NORM_ASSIGN gllsna,
503: GL_LEDGERS gll,
504: GL_LEDGER_SET_ASSIGNMENTS gllsa1,
505: GL_LEDGER_SET_ASSIGNMENTS gllsa2
506: WHERE gllsna.status_code = 'I'

Line 625: -- GL_LEDGER_SET_NORM_ASSIGN and GL_LEDGER_SET_ASSIGNMENTS

621: GL_MESSAGE.Func_Ent
622: (func_name => 'GL_FLATTEN_LEDGER_SETS.Clean_Up_Explicit_Sets');
623:
624: -- Run the following statements to clean up both
625: -- GL_LEDGER_SET_NORM_ASSIGN and GL_LEDGER_SET_ASSIGNMENTS
626:
627: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
628: GL_MESSAGE.Write_Log
629: (msg_name => 'SHRD0180',

Line 634: v2 => 'Deleting records from GL_LEDGER_SET_NORM_ASSIGN...');

630: token_num => 2,
631: t1 => 'ROUTINE',
632: v1 => 'Clean_Up_Explicit_Sets()',
633: t2 => 'ACTION',
634: v2 => 'Deleting records from GL_LEDGER_SET_NORM_ASSIGN...');
635: END IF;
636:
637: -- Delete records from GL_LEDGER_SET_NORM_ASSIGN
638:

Line 637: -- Delete records from GL_LEDGER_SET_NORM_ASSIGN

633: t2 => 'ACTION',
634: v2 => 'Deleting records from GL_LEDGER_SET_NORM_ASSIGN...');
635: END IF;
636:
637: -- Delete records from GL_LEDGER_SET_NORM_ASSIGN
638:
639: DELETE from GL_LEDGER_SET_NORM_ASSIGN
640: WHERE status_code = 'D'
641: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID

Line 639: DELETE from GL_LEDGER_SET_NORM_ASSIGN

635: END IF;
636:
637: -- Delete records from GL_LEDGER_SET_NORM_ASSIGN
638:
639: DELETE from GL_LEDGER_SET_NORM_ASSIGN
640: WHERE status_code = 'D'
641: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
642: AND ledger_set_id IN
643: (SELECT ledger_id

Line 655: v2 => 'GL_LEDGER_SET_NORM_ASSIGN');

651: token_num => 2,
652: t1 => 'NUM',
653: v1 => TO_CHAR(row_count),
654: t2 => 'TABLE',
655: v2 => 'GL_LEDGER_SET_NORM_ASSIGN');
656: row_count := 0;
657:
658: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
659: GL_MESSAGE.Write_Log

Line 665: v2 => 'Updating records in GL_LEDGER_SET_NORM_ASSIGN...');

661: token_num => 2,
662: t1 => 'ROUTINE',
663: v1 => 'Clean_Up_Explicit_Sets()',
664: t2 => 'ACTION',
665: v2 => 'Updating records in GL_LEDGER_SET_NORM_ASSIGN...');
666: END IF;
667:
668: -- Update records in GL_LEDGER_SET_NORM_ASSIGN
669: -- Bear in mind there will never be U records in gllsna

Line 668: -- Update records in GL_LEDGER_SET_NORM_ASSIGN

664: t2 => 'ACTION',
665: v2 => 'Updating records in GL_LEDGER_SET_NORM_ASSIGN...');
666: END IF;
667:
668: -- Update records in GL_LEDGER_SET_NORM_ASSIGN
669: -- Bear in mind there will never be U records in gllsna
670:
671: UPDATE GL_LEDGER_SET_NORM_ASSIGN
672: SET status_code = NULL, request_id = NULL

Line 671: UPDATE GL_LEDGER_SET_NORM_ASSIGN

667:
668: -- Update records in GL_LEDGER_SET_NORM_ASSIGN
669: -- Bear in mind there will never be U records in gllsna
670:
671: UPDATE GL_LEDGER_SET_NORM_ASSIGN
672: SET status_code = NULL, request_id = NULL
673: WHERE status_code = 'I'
674: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
675: AND ledger_set_id IN

Line 688: v2 => 'GL_LEDGER_SET_NORM_ASSIGN');

684: token_num => 2,
685: t1 => 'NUM',
686: v1 => TO_CHAR(row_count),
687: t2 => 'TABLE',
688: v2 => 'GL_LEDGER_SET_NORM_ASSIGN');
689: row_count := 0;
690:
691: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
692: GL_MESSAGE.Write_Log