APPS.FII_AP_INV_SUM_INC dependencies on FII_AP_INVOICE_UI_GT

Line 1737: g_state := 'Bulk inserting into FII_AP_Invoice_UI_GT from FII_AP_Invoice_UI_MS.';

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;
1739:
1740: IF FII_AP_Invoice_UI_MS.Count > 0 THEN
1741: FORALL i IN FII_AP_Invoice_UI_MS.First..FII_AP_Invoice_UI_MS.Last

Line 1742: INSERT INTO FII_AP_Invoice_UI_GT VALUES FII_AP_Invoice_UI_MS(i);

1738: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1739:
1740: IF FII_AP_Invoice_UI_MS.Count > 0 THEN
1741: FORALL i IN FII_AP_Invoice_UI_MS.First..FII_AP_Invoice_UI_MS.Last
1742: INSERT INTO FII_AP_Invoice_UI_GT VALUES FII_AP_Invoice_UI_MS(i);
1743: END IF;
1744:
1745: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1746:

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

1744:
1745: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1746:
1747: if g_debug_flag = 'Y' then
1748: FII_UTIL.put_line('The time taken to bulk insert records into FII_AP_Invoice_UI_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1749: end if;
1750:
1751: g_state := 'Bulk inserting into FII_AP_Pay_Sched_D_GT from FII_AP_Pay_Sched_D_MS.';
1752: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

Line 2054: USING FII_AP_Invoice_UI_GT UI

2050:
2051: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
2052:
2053: MERGE INTO FII_AP_Invoice_B AI
2054: USING FII_AP_Invoice_UI_GT UI
2055: ON (AI.Invoice_ID = UI.Invoice_ID)
2056: WHEN MATCHED THEN
2057: UPDATE SET AI.Org_ID = UI.Org_ID,
2058: AI.Supplier_ID = UI.Supplier_ID,