APPS.FII_AP_INV_SUM_INC dependencies on FII_AP_INVOICE_D_GT

Line 1723: g_state := 'Bulk inserting into FII_AP_Invoice_D_GT from FII_AP_Invoice_D_MS.';

1719: l_timestamp1_tmp BINARY_INTEGER;
1720: BEGIN
1721: l_timestamp1 := DBMS_UTILITY.Get_Time;
1722:
1723: g_state := 'Bulk inserting into FII_AP_Invoice_D_GT from FII_AP_Invoice_D_MS.';
1724: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1725:
1726: IF FII_AP_Invoice_D_MS.Count > 0 THEN
1727: FORALL i IN FII_AP_Invoice_D_MS.First..FII_AP_Invoice_D_MS.Last

Line 1728: INSERT INTO FII_AP_Invoice_D_GT VALUES FII_AP_Invoice_D_MS(i);

1724: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1725:
1726: IF FII_AP_Invoice_D_MS.Count > 0 THEN
1727: FORALL i IN FII_AP_Invoice_D_MS.First..FII_AP_Invoice_D_MS.Last
1728: INSERT INTO FII_AP_Invoice_D_GT VALUES FII_AP_Invoice_D_MS(i);
1729: END IF;
1730:
1731: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1732:

Line 1734: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Invoice_D_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1730:
1731: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1732:
1733: if g_debug_flag = 'Y' then
1734: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Invoice_D_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1735: end if;
1736:
1737: g_state := 'Bulk inserting into FII_AP_Invoice_UI_GT from FII_AP_Invoice_UI_MS.';
1738: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 2037: FROM FII_AP_Invoice_D_GT D

2033:
2034: DELETE FROM FII_AP_Invoice_B AI
2035: WHERE EXISTS
2036: (SELECT 1
2037: FROM FII_AP_Invoice_D_GT D
2038: WHERE D.Invoice_ID = AI.Invoice_ID);
2039:
2040: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
2041: