APPS.FII_AP_INV_B_C dependencies on FII_AP_UNPOST_HEADERS_T

Line 186: FII_UTIL.put_line('Truncate table FII_AP_Unpost_Headers_T');

182: truncate_table('FII_AP_SUM_WORK_JOBS');
183:
184: IF (g_truncate_id = 'Y') THEN
185: if g_debug_flag = 'Y' then
186: FII_UTIL.put_line('Truncate table FII_AP_Unpost_Headers_T');
187: end if;
188: truncate_table('FII_AP_Unpost_Headers_T');
189: END IF;
190:

Line 188: truncate_table('FII_AP_Unpost_Headers_T');

184: IF (g_truncate_id = 'Y') THEN
185: if g_debug_flag = 'Y' then
186: FII_UTIL.put_line('Truncate table FII_AP_Unpost_Headers_T');
187: end if;
188: truncate_table('FII_AP_Unpost_Headers_T');
189: END IF;
190:
191: IF (g_truncate_staging = 'Y') THEN
192: if g_debug_flag = 'Y' then

Line 297: -- FII_AP_UNPOST_HEADERS_T stores the header id of records that have a null

293: l_count NUMBER;
294: BEGIN
295:
296: --------------------------------------------------------------------------------
297: -- FII_AP_UNPOST_HEADERS_T stores the header id of records that have a null
298: -- gl_sl_link_id and may be updated during the incremental load.
299: --------------------------------------------------------------------------------
300:
301: g_state := 'Inserting records into FII_AP_UNPOST_HEADERS_T table';

Line 301: g_state := 'Inserting records into FII_AP_UNPOST_HEADERS_T table';

297: -- FII_AP_UNPOST_HEADERS_T stores the header id of records that have a null
298: -- gl_sl_link_id and may be updated during the incremental load.
299: --------------------------------------------------------------------------------
300:
301: g_state := 'Inserting records into FII_AP_UNPOST_HEADERS_T table';
302: IF g_debug_flag = 'Y' then
303: FII_UTIL.put_line('');
304: FII_UTIL.put_line(g_state);
305: fii_util.start_timer;

Line 309: INSERT INTO FII_AP_UNPOST_HEADERS_T (

305: fii_util.start_timer;
306: fii_util.put_line('');
307: END IF;
308:
309: INSERT INTO FII_AP_UNPOST_HEADERS_T (
310: AE_HEADER_ID,
311: REF_AE_HEADER_ID,
312: TEMP_LINE_NUM,
313: SEQUENCE_ID,

Line 337: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT||' records in FII_AP_UNPOST_HEADERS_T');

333: l_count := SQL%ROWCOUNT;
334:
335: IF g_debug_flag = 'Y' then
336: FII_UTIL.stop_timer;
337: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT||' records in FII_AP_UNPOST_HEADERS_T');
338: FII_UTIL.print_timer('Duration');
339: END IF;
340:
341: RETURN l_count;

Line 363: g_state := 'Populating FII_AP_Inv_STG with updated data using the FII_AP_Unpost_Headers_T table';

359: BEGIN
360:
361: IF p_phase = 1 THEN
362:
363: g_state := 'Populating FII_AP_Inv_STG with updated data using the FII_AP_Unpost_Headers_T table';
364: if g_debug_flag = 'Y' then
365: FII_UTIL.put_line(g_state);
366: FII_UTIL.start_timer;
367: end if;

Line 380: FROM FII_AP_Unpost_Headers_T ID,

376: XDL.Ref_AE_Header_ID Ref_AE_Header_ID,
377: XDL.Temp_Line_Num Temp_Line_Num,
378: XAL.GL_SL_Link_ID GL_SL_Link_ID,
379: XAL.GL_SL_Link_Table GL_SL_Link_Table
380: FROM FII_AP_Unpost_Headers_T ID,
381: XLA_AE_Lines XAL,
382: XLA_Distribution_Links XDL
383: WHERE ID.AE_Header_ID = XDL.AE_Header_ID
384: AND ID.Ref_AE_Header_ID = XDL.Ref_AE_Header_ID

Line 644: -- Phase 1: Updated data is stored in fii_ap_unpost_headers_t.

640: g_state := 'Inside the procedure REGISTER_JOBS';
641:
642: ----------------------------------------------------------------
643: -- There are two types of jobs:
644: -- Phase 1: Updated data is stored in fii_ap_unpost_headers_t.
645: -- Phase 2: New data has a header id greater than the current
646: -- maximum header id.
647: ----------------------------------------------------------------
648:

Line 652: FROM FII_AP_Unpost_Headers_T;

648:
649: --Find start and end range for Phase 1 jobs.
650: SELECT nvl(max(sequence_id), -1), nvl(min(sequence_id), -1)
651: INTO l_max_number1, l_start_number1
652: FROM FII_AP_Unpost_Headers_T;
653:
654:
655: --Find start and end re for Phase 2 jobs.
656: SELECT MAX(NVL(AE_Header_ID, -1)) + 1 INTO l_start_number2 FROM FII_AP_INV_B;