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_FLATTEN_SETUP_DATA

Line 31: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

27:
28: -- Clean up the GL_LEDGER_SET_ASSIGNMENTS table for any
29: -- unprocessed data left over from previous failed run
30:
31: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
32: GL_MESSAGE.Write_Log
33: (msg_name => 'SHRD0180',
34: token_num => 2,
35: t1 => 'ROUTINE',

Line 48: AND chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);

44: AND ledger_set_id IN
45: (SELECT ledger_id
46: FROM GL_LEDGERS
47: WHERE object_type_code = 'S'
48: AND chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
49:
50: row_count := SQL%ROWCOUNT;
51: GL_MESSAGE.Write_Log(msg_name => 'SHRD0119',
52: token_num => 2,

Line 59: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

55: t2 => 'TABLE',
56: v2 => 'GL_LEDGER_SET_ASSIGNMENTS');
57: row_count := 0;
58:
59: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
60: GL_MESSAGE.Write_Log
61: (msg_name => 'SHRD0180',
62: token_num => 2,
63: t1 => 'ROUTINE',

Line 78: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);

74: (SELECT ledger_id
75: FROM GL_LEDGERS
76: WHERE object_type_code = 'S'
77: AND chart_of_accounts_id =
78: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
79:
80: row_count := SQL%ROWCOUNT;
81: GL_MESSAGE.Write_Log(msg_name => 'SHRD0118',
82: token_num => 2,

Line 95: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

91: -- these explicit ledger sets that are left over from pervious runs.
92: -- We don't need to reset the D record for this table since the
93: -- implicit access sets of ledger sets only contain 1 assignment,
94: -- and that is the ledger set itself.
95: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
96: GL_MESSAGE.Write_Log
97: (msg_name => 'SHRD0180',
98: token_num => 2,
99: t1 => 'ROUTINE',

Line 112: AND chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);

108: AND access_set_id IN
109: (SELECT implicit_access_set_id
110: FROM GL_LEDGERS
111: WHERE object_type_code = 'S'
112: AND chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
113:
114: row_count := SQL%ROWCOUNT;
115: GL_MESSAGE.Write_Log(msg_name => 'SHRD0119',
116: token_num => 2,

Line 129: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

125:
126: -- Populate access information into GL_ACCESS_SET_NORM_ASSIGN
127: -- for all newly created ledger sets.
128:
129: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
130: GL_MESSAGE.Write_Log
131: (msg_name => 'SHRD0180',
132: token_num => 2,
133: t1 => 'ROUTINE',

Line 150: NULL, SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,

146: segment_value, start_date, end_date)
147: (SELECT distinct
148: gll.implicit_access_set_id, gllsna.ledger_set_id, 'Y',
149: 'S', 'B', 'I', -1,
150: NULL, SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
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

Line 151: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,

147: (SELECT distinct
148: gll.implicit_access_set_id, gllsna.ledger_set_id, 'Y',
149: 'S', 'B', 'I', -1,
150: NULL, SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
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,

Line 152: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,

148: gll.implicit_access_set_id, gllsna.ledger_set_id, 'Y',
149: 'S', 'B', 'I', -1,
150: NULL, SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
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

Line 153: GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID,

149: 'S', 'B', 'I', -1,
150: NULL, SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
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'

Line 158: AND gllsna.request_id = 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
160: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
161: AND gll.automatically_created_flag = 'N'
162: AND NOT EXISTS

Line 160: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

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
160: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
161: AND gll.automatically_created_flag = 'N'
162: AND NOT EXISTS
163: (SELECT 1
164: FROM GL_ACCESS_SET_NORM_ASSIGN glasna

Line 186: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

182:
183: -- Update the record_id column of the newly created records
184: -- in GL_ACCESS_SET_NORM_ASSIGN
185:
186: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
187: GL_MESSAGE.Write_Log
188: (msg_name => 'SHRD0180',
189: token_num => 2,
190: t1 => 'ROUTINE',

Line 201: AND glasna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID

197:
198: UPDATE GL_ACCESS_SET_NORM_ASSIGN glasna
199: SET glasna.record_id = GL_ACCESS_SET_NORM_ASSIGN_S.nextval
200: WHERE glasna.status_code = 'I'
201: AND glasna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
202: AND glasna.record_id = -1
203: AND glasna.access_set_id IN
204: (SELECT gll.implicit_access_set_id
205: FROM GL_LEDGERS gll

Line 207: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

203: AND glasna.access_set_id IN
204: (SELECT gll.implicit_access_set_id
205: FROM GL_LEDGERS gll
206: WHERE gll.chart_of_accounts_id =
207: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
208: AND gll.automatically_created_flag = 'N'
209: AND gll.object_type_code = 'S');
210:
211: row_count := SQL%ROWCOUNT;

Line 235: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

231: -- descendants for delete as well.
232: -- 3) Restore any mappings that are included via other paths. This
233: -- will be run in a loop until no changes occur.
234:
235: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
236: GL_MESSAGE.Write_Log
237: (msg_name => 'SHRD0180',
238: token_num => 2,
239: t1 => 'ROUTINE',

Line 265: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_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
266: AND gll.ledger_id = gllsna.ledger_set_id
267: AND gll.chart_of_accounts_id =
268: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
269: AND gll.automatically_created_flag = 'N'

Line 268: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

264: WHERE gllsna.status_code = 'D'
265: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
266: AND gll.ledger_id = gllsna.ledger_set_id
267: AND gll.chart_of_accounts_id =
268: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
269: AND gll.automatically_created_flag = 'N'
270: AND gll.object_type_code = 'S'
271: AND gllsa2.ledger_id = gllsna.ledger_set_id)
272: AND gllsa1.ledger_set_id <> gllsa1.ledger_id;

Line 283: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

279: t2 => 'TABLE',
280: v2 => 'GL_LEDGER_SET_ASSIGNMENTS');
281: row_count := 0;
282:
283: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
284: GL_MESSAGE.Write_Log
285: (msg_name => 'SHRD0180',
286: token_num => 2,
287: t1 => 'ROUTINE',

Line 304: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID

300: GL_LEDGERS gll,
301: GL_LEDGER_SET_ASSIGNMENTS gllsa2,
302: GL_LEDGER_SET_ASSIGNMENTS gllsa3
303: WHERE gllsna.status_code = 'D'
304: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
305: AND gll.ledger_id = gllsna.ledger_set_id
306: AND gll.chart_of_accounts_id =
307: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
308: AND gll.automatically_created_flag = 'N'

Line 307: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

303: WHERE gllsna.status_code = 'D'
304: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
305: AND gll.ledger_id = gllsna.ledger_set_id
306: AND gll.chart_of_accounts_id =
307: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
308: AND gll.automatically_created_flag = 'N'
309: AND gll.object_type_code = 'S'
310: AND gllsa2.ledger_id = gllsna.ledger_set_id
311: AND gllsa3.ledger_set_id = gllsna.ledger_id)

Line 326: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

322:
323: -- Commit changes so far before going into a loop
324: FND_CONCURRENT.Af_Commit;
325:
326: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
327: GL_MESSAGE.Write_Log
328: (msg_name => 'SHRD0180',
329: token_num => 2,
330: t1 => 'ROUTINE',

Line 347: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

343: AND gllsa1.ledger_set_id IN
344: (SELECT gll.ledger_id
345: FROM GL_LEDGERS gll
346: WHERE gll.chart_of_accounts_id =
347: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
348: AND gll.object_type_code = 'S'
349: AND gll.automatically_created_flag = 'N')
350: AND ( EXISTS
351: (SELECT 1

Line 389: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

385: -- 2) Add all newly added ledgers to the respective ledger sets.
386: -- 3) Insert mappings for all descendants of newly added child ledger
387: -- sets. This will be run in a loop until no changes occur.
388:
389: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
390: GL_MESSAGE.Write_Log
391: (msg_name => 'SHRD0180',
392: token_num => 2,
393: t1 => 'ROUTINE',

Line 405: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,

401: (ledger_set_id, ledger_id, status_code, last_update_date,
402: last_updated_by, last_update_login, creation_date,
403: created_by, start_date, end_date)
404: (SELECT distinct gll.ledger_id, gll.ledger_id, 'I', SYSDATE,
405: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
406: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,
407: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
408: NULL, NULL
409: FROM GL_LEDGERS gll

Line 406: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,

402: last_updated_by, last_update_login, creation_date,
403: created_by, start_date, end_date)
404: (SELECT distinct gll.ledger_id, gll.ledger_id, 'I', SYSDATE,
405: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
406: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,
407: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
408: NULL, NULL
409: FROM GL_LEDGERS gll
410: WHERE gll.object_type_code = 'S'

Line 407: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,

403: created_by, start_date, end_date)
404: (SELECT distinct gll.ledger_id, gll.ledger_id, 'I', SYSDATE,
405: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
406: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,
407: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
408: NULL, NULL
409: FROM GL_LEDGERS gll
410: WHERE gll.object_type_code = 'S'
411: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

Line 411: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

407: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,
408: NULL, NULL
409: FROM GL_LEDGERS gll
410: WHERE gll.object_type_code = 'S'
411: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
412: AND gll.automatically_created_flag = 'N'
413: AND NOT EXISTS
414: (SELECT 1
415: FROM GL_LEDGER_SET_ASSIGNMENTS gllsa

Line 429: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

425: t2 => 'TABLE',
426: v2 => 'GL_LEDGER_SET_ASSIGNMENTS');
427: row_count := 0;
428:
429: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
430: GL_MESSAGE.Write_Log
431: (msg_name => 'SHRD0180',
432: token_num => 2,
433: t1 => 'ROUTINE',

Line 445: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,

441: (ledger_set_id, ledger_id, status_code, last_update_date,
442: last_updated_by, last_update_login, creation_date,
443: created_by, start_date, end_date)
444: (SELECT distinct gllsa.ledger_set_id, gllsna.ledger_id, 'I', SYSDATE,
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,

Line 446: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID,

442: last_updated_by, last_update_login, creation_date,
443: created_by, start_date, end_date)
444: (SELECT distinct gllsa.ledger_set_id, gllsna.ledger_id, 'I', SYSDATE,
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,

Line 447: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,

443: created_by, start_date, end_date)
444: (SELECT distinct gllsa.ledger_set_id, gllsna.ledger_id, 'I', SYSDATE,
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

Line 453: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID

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
454: AND gll.ledger_id = gllsna.ledger_id
455: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
456: AND gll.object_type_code = 'L'
457: AND gllsa.ledger_id = gllsna.ledger_set_id

Line 455: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

451: GL_LEDGER_SET_ASSIGNMENTS gllsa
452: WHERE gllsna.status_code = 'I'
453: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
454: AND gll.ledger_id = gllsna.ledger_id
455: AND gll.chart_of_accounts_id = GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
456: AND gll.object_type_code = 'L'
457: AND gllsa.ledger_id = gllsna.ledger_set_id
458: AND NVL(gllsa.status_code, 'X') <> 'D'
459: AND NOT EXISTS

Line 480: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

476: FND_CONCURRENT.Af_Commit;
477:
478: stop_processing := FALSE;
479:
480: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
481: GL_MESSAGE.Write_Log
482: (msg_name => 'SHRD0180',
483: token_num => 2,
484: t1 => 'ROUTINE',

Line 498: 'I', SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,

494: (ledger_set_id, ledger_id, status_code, last_update_date,
495: last_updated_by, last_update_login, creation_date,
496: created_by, start_date, end_date)
497: (SELECT distinct gllsa1.ledger_set_id, gllsa2.ledger_id,
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,

Line 499: GL_FLATTEN_SETUP_DATA.GLSTFL_LOGIN_ID, SYSDATE,

495: last_updated_by, last_update_login, creation_date,
496: created_by, start_date, end_date)
497: (SELECT distinct gllsa1.ledger_set_id, gllsa2.ledger_id,
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,

Line 500: GL_FLATTEN_SETUP_DATA.GLSTFL_USER_ID,

496: created_by, start_date, end_date)
497: (SELECT distinct gllsa1.ledger_set_id, gllsa2.ledger_id,
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,

Line 507: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID

503: GL_LEDGERS gll,
504: GL_LEDGER_SET_ASSIGNMENTS gllsa1,
505: GL_LEDGER_SET_ASSIGNMENTS gllsa2
506: WHERE gllsna.status_code = 'I'
507: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
508: AND gll.ledger_id = gllsna.ledger_set_id
509: AND gll.chart_of_accounts_id =
510: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
511: AND gll.object_type_code = 'S'

Line 510: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

506: WHERE gllsna.status_code = 'I'
507: AND gllsna.request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID
508: AND gll.ledger_id = gllsna.ledger_set_id
509: AND gll.chart_of_accounts_id =
510: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
511: AND gll.object_type_code = 'S'
512: AND gll.automatically_created_flag = 'N'
513: AND gllsa1.ledger_id = gllsna.ledger_set_id
514: AND NVL(gllsa1.status_code, 'X') <> 'D'

Line 549: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID

545: GL_LEDGER_SET_ASSIGNMENTS gllsa2
546: WHERE gllsa1.status_code = 'I'
547: AND gll.ledger_id = gllsa1.ledger_set_id
548: AND gll.chart_of_accounts_id =
549: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID
550: AND gll.object_type_code = 'S'
551: AND gll.automatically_created_flag = 'N'
552: AND gllsa1.ledger_set_id <> gllsa1.ledger_id
553: AND NVL(gllsa2.status_code, 'X') <> 'D'

Line 627: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

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',
630: token_num => 2,
631: t1 => 'ROUTINE',

Line 641: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID

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
644: FROM GL_LEDGERS
645: WHERE object_type_code = 'S'

Line 647: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);

643: (SELECT ledger_id
644: FROM GL_LEDGERS
645: WHERE object_type_code = 'S'
646: AND chart_of_accounts_id =
647: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
648:
649: row_count := SQL%ROWCOUNT;
650: GL_MESSAGE.Write_Log(msg_name => 'SHRD0119',
651: token_num => 2,

Line 658: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

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
660: (msg_name => 'SHRD0180',
661: token_num => 2,
662: t1 => 'ROUTINE',

Line 674: AND request_id = GL_FLATTEN_SETUP_DATA.GLSTFL_REQ_ID

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
676: (SELECT ledger_id
677: FROM GL_LEDGERS
678: WHERE object_type_code = 'S'

Line 680: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);

676: (SELECT ledger_id
677: FROM GL_LEDGERS
678: WHERE object_type_code = 'S'
679: AND chart_of_accounts_id =
680: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
681:
682: row_count := SQL%ROWCOUNT;
683: GL_MESSAGE.Write_Log(msg_name => 'SHRD0118',
684: token_num => 2,

Line 691: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

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
693: (msg_name => 'SHRD0180',
694: token_num => 2,
695: t1 => 'ROUTINE',

Line 710: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);

706: (SELECT ledger_id
707: FROM GL_LEDGERS
708: WHERE object_type_code = 'S'
709: AND chart_of_accounts_id =
710: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
711:
712: row_count := SQL%ROWCOUNT;
713: GL_MESSAGE.Write_Log(msg_name => 'SHRD0119',
714: token_num => 2,

Line 721: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN

717: t2 => 'TABLE',
718: v2 => 'GL_LEDGER_SET_ASSIGNMENTS');
719: row_count := 0;
720:
721: IF (GL_FLATTEN_SETUP_DATA.GLSTFL_Debug) THEN
722: GL_MESSAGE.Write_log
723: (msg_name => 'SHRD0180',
724: token_num => 2,
725: t1 => 'ROUTINE',

Line 742: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);

738: (SELECT ledger_id
739: FROM GL_LEDGERS
740: WHERE object_type_code = 'S'
741: AND chart_of_accounts_id =
742: GL_FLATTEN_SETUP_DATA.GLSTFL_COA_ID);
743:
744: row_count := SQL%ROWCOUNT;
745: GL_MESSAGE.Write_Log(msg_name => 'SHRD0118',
746: token_num => 2,