APPS.FII_AP_INV_DISTRIBUTIONS_B_C dependencies on FII_AP_INV_ID

Line 136: FII_UTIL.put_line('Truncate table FII_AP_INV_ID');

132: truncate_table('FII_AP_SUM_WORK_JOBS');
133:
134: IF (g_truncate_id = 'Y') THEN
135: if g_debug_flag = 'Y' then
136: FII_UTIL.put_line('Truncate table FII_AP_INV_ID');
137: end if;
138: truncate_table('FII_AP_INV_ID');
139: END IF;
140:

Line 138: truncate_table('FII_AP_INV_ID');

134: IF (g_truncate_id = 'Y') THEN
135: if g_debug_flag = 'Y' then
136: FII_UTIL.put_line('Truncate table FII_AP_INV_ID');
137: end if;
138: truncate_table('FII_AP_INV_ID');
139: END IF;
140:
141: IF (g_truncate_staging = 'Y') THEN
142: if g_debug_flag = 'Y' then

Line 251: g_state := 'Inserting records into FII_AP_INV_ID table from AP log table';

247: --------------------------------------------------------------------------------
248: -- For Incremental mode we will get the list of invoices from the log table and
249: -- insert into the temp table.
250: --------------------------------------------------------------------------------
251: g_state := 'Inserting records into FII_AP_INV_ID table from AP log table';
252: IF g_debug_flag = 'Y' then
253: FII_UTIL.put_line('');
254: FII_UTIL.put_line(g_state);
255: fii_util.start_timer;

Line 259: INSERT INTO FII_AP_INV_ID (INVOICE_ID, SEQUENCE_ID)

255: fii_util.start_timer;
256: fii_util.put_line('');
257: END IF;
258:
259: INSERT INTO FII_AP_INV_ID (INVOICE_ID, SEQUENCE_ID)
260: SELECT
261: invoice_id INVOICE_ID,
262: rownum SEQUENCE_ID
263: FROM

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

275: l_count := SQL%ROWCOUNT;
276:
277: IF g_debug_flag = 'Y' then
278: FII_UTIL.stop_timer;
279: FII_UTIL.put_line('Inserted ' || SQL%ROWCOUNT||' records in FII_AP_INV_ID');
280: FII_UTIL.print_timer('Duration');
281: END IF;
282:
283: RETURN l_count;

Line 301: g_state := 'Populating FII_AP_INV_DIST_T from FII_AP_INV_ID table';

297: PROCEDURE POPULATE_AP_SUM_STG (p_start_range IN number,
298: p_end_range IN number) is
299: l_stmt VARCHAR2(1000);
300: BEGIN
301: g_state := 'Populating FII_AP_INV_DIST_T from FII_AP_INV_ID table';
302: if g_debug_flag = 'Y' then
303: FII_UTIL.put_line(g_state);
304: FII_UTIL.start_timer;
305: end if;

Line 361: FROM fii_ap_inv_id temp,

357: aid.LINE_TYPE_LOOKUP_CODE,
358: AIL.Inventory_Item_ID,
359: AIL.Purchasing_Category_ID,
360: AIL.Item_Description
361: FROM fii_ap_inv_id temp,
362: ap_invoices_all ai,
363: ap_invoice_lines_all ail,
364: ap_invoice_distributions_all aid,
365: gl_ledgers_public_v gsob,

Line 431: FROM FII_AP_INV_ID;

427: end if;
428:
429: SELECT max(sequence_id), min(sequence_id)
430: INTO l_max_number, l_start_number
431: FROM FII_AP_INV_ID;
432:
433: -----------------------------------------
434: --SELECT min and max sequence IDs from your ID temp table
435: -----------------------------------------

Line 807: AND bsum.invoice_id IN (SELECT id.invoice_id FROM FII_AP_INV_ID id);

803: end if;
804:
805: DELETE FROM FII_AP_INV_DIST_F bsum
806: WHERE (bsum.UPDATE_SEQUENCE <> seq_id OR bsum.posted_flag = 'Y')
807: AND bsum.invoice_id IN (SELECT id.invoice_id FROM FII_AP_INV_ID id);
808:
809: if g_debug_flag = 'Y' then
810: FII_UTIL.put_line('Deleted ' || SQL%ROWCOUNT || ' records from FII_AP_INV_DIST_F');
811: FII_UTIL.put_line('');

Line 2149: -- mode. We purposely don't want to truncate FII_AP_INV_ID

2145: ---------------------------------------------------------------
2146: -- Truncating the staging table so the next time the program
2147: -- is ran, the program will start from beginning. If we leave
2148: -- records in staging table, this program would run in resume
2149: -- mode. We purposely don't want to truncate FII_AP_INV_ID
2150: -- because we can use it for debugging purpose if the program
2151: -- error out. FII_AP_INV_ID always gets truncated at the start
2152: -- of the program.
2153: ---------------------------------------------------------------

Line 2151: -- error out. FII_AP_INV_ID always gets truncated at the start

2147: -- is ran, the program will start from beginning. If we leave
2148: -- records in staging table, this program would run in resume
2149: -- mode. We purposely don't want to truncate FII_AP_INV_ID
2150: -- because we can use it for debugging purpose if the program
2151: -- error out. FII_AP_INV_ID always gets truncated at the start
2152: -- of the program.
2153: ---------------------------------------------------------------
2154: Truncate_table('FII_AP_INV_DIST_T');
2155: