APPS.FII_GL_JE_B_C dependencies on FII_GL_NEW_JRL_HEADER_IDS

Line 604: FROM FII_GL_NEW_JRL_HEADER_IDS;

600: ------------------------------------------------------------
601: g_phase := 'select min and max sequence IDs from the ID Temp table';
602: SELECT NVL(max(record_id), 0), nvl(min(record_id),1)
603: INTO l_max_number, l_start_number
604: FROM FII_GL_NEW_JRL_HEADER_IDS;
605:
606: WHILE (l_start_number <= l_max_number) LOOP
607: l_end_number:= l_start_number + g_child_process_size;
608: g_phase := 'Loop to insert into FII_GL_WORKER_JOBS: '

Line 840: TRUNCATE_TABLE('FII_GL_NEW_JRL_HEADER_IDS');

836:
837: TRUNCATE_TABLE('FII_GL_WORKER_JOBS');
838:
839: IF (g_truncate_id) THEN
840: TRUNCATE_TABLE('FII_GL_NEW_JRL_HEADER_IDS');
841: END IF;
842:
843: IF (g_truncate_stg) THEN
844: TRUNCATE_TABLE('FII_GL_JE_SUMMARY_STG');

Line 1345: FROM fii_gl_new_jrl_header_ids;

1341: g_fii_user_id,
1342: sysdate,
1343: g_fii_login_id,
1344: g_fii_user_id
1345: FROM fii_gl_new_jrl_header_ids;
1346:
1347: if g_debug_flag = 'Y' then
1348: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT || ' rows into FII_GL_PROCESSED_HEADER_IDS');
1349: FII_UTIL.stop_timer;

Line 1391: INSERT /*+ append */ INTO fii_gl_new_jrl_header_ids

1387: --Bug 3121847: changed the hint per performance team suggestion
1388:
1389: --Added filtering by JE category/source for DBI 6.0
1390:
1391: INSERT /*+ append */ INTO fii_gl_new_jrl_header_ids
1392: (record_id,
1393: je_header_id,
1394: currency_code,
1395: je_source,

Line 1461: ' JE header IDs into FII_GL_NEW_JRL_HEADER_IDS');

1457: l_number_of_rows := SQL%ROWCOUNT;
1458:
1459: if g_debug_flag = 'Y' then
1460: FII_UTIL.put_line('Inserted '||l_number_of_rows||
1461: ' JE header IDs into FII_GL_NEW_JRL_HEADER_IDS');
1462: FII_UTIL.stop_timer;
1463: FII_UTIL.print_timer('Duration');
1464: FII_UTIL.put_line('');
1465: end if;

Line 1492: -- Header IDs are stored in FII_GL_NEW_JRL_HEADER_IDS table into

1488: BEGIN
1489:
1490: ------------------------------------------------------------------
1491: -- Insert summarize journal entry lines at day level whose journal
1492: -- Header IDs are stored in FII_GL_NEW_JRL_HEADER_IDS table into
1493: -- FII_GL_JE_SUMMARY_STG.
1494: ------------------------------------------------------------------
1495: if g_debug_flag = 'Y' then
1496: FII_UTIL.put_line('Processing ID range: ' || p_start_range ||

Line 1578: FROM fii_gl_new_jrl_header_ids njhi,

1574: g_fii_user_id || ',
1575: sysdate, ' ||
1576: g_fii_user_id || ',' ||
1577: g_fii_login_id || '
1578: FROM fii_gl_new_jrl_header_ids njhi,
1579: gl_je_lines line,
1580: gl_ledgers_public_v sob,
1581: fii_gl_ccid_dimensions fin,
1582: fii_slg_assignments slga,