eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_AP_INV_SUM_INC dependencies on FII_AP_INVOICE_B

Line 181: --Invoice_B_Type is used to populate the memory structure FII_AP_Invoice_B_MS

177: --Pay_Sched_B_Type is used to populate the memory structure FII_AP_Pay_Sched_B_MS
178: TYPE Pay_Sched_B_Type IS TABLE OF FII_AP_PAY_SCHED_B%ROWTYPE
179: INDEX BY BINARY_INTEGER;
180:
181: --Invoice_B_Type is used to populate the memory structure FII_AP_Invoice_B_MS
182: TYPE Invoice_B_Type IS TABLE OF FII_AP_INVOICE_B%ROWTYPE
183: INDEX BY BINARY_INTEGER;
184:
185: --Aging_Bkts_B_Type is used to populate the memory structure FII_AP_Aging_Bkts_B_MS

Line 182: TYPE Invoice_B_Type IS TABLE OF FII_AP_INVOICE_B%ROWTYPE

178: TYPE Pay_Sched_B_Type IS TABLE OF FII_AP_PAY_SCHED_B%ROWTYPE
179: INDEX BY BINARY_INTEGER;
180:
181: --Invoice_B_Type is used to populate the memory structure FII_AP_Invoice_B_MS
182: TYPE Invoice_B_Type IS TABLE OF FII_AP_INVOICE_B%ROWTYPE
183: INDEX BY BINARY_INTEGER;
184:
185: --Aging_Bkts_B_Type is used to populate the memory structure FII_AP_Aging_Bkts_B_MS
186: TYPE Aging_Bkts_B_Type IS TABLE OF FII_AP_AGING_BKTS_B%ROWTYPE

Line 204: --Used to hold deleted records from FII_AP_Invoice_B.

200: Unique_ID NUMBER);
201: TYPE Pay_Sched_D_Type IS TABLE OF Pay_Sched_D_Rec
202: INDEX BY BINARY_INTEGER;
203:
204: --Used to hold deleted records from FII_AP_Invoice_B.
205: TYPE Invoice_D_Rec IS RECORD(
206: Invoice_ID Number(15,0));
207: TYPE Invoice_D_Type IS TABLE OF Invoice_D_Rec
208: INDEX BY BINARY_INTEGER;

Line 215: FII_AP_Invoice_B_MS Invoice_B_Type;

211: FII_AP_Pay_Sched_B_MS Pay_Sched_B_Type;
212: g_pay_sched_b_marker BINARY_INTEGER;
213: FII_AP_Pay_Sched_UI_MS Pay_Sched_B_Type; --Stores records that have been updated or inserted.
214: FII_AP_Pay_Sched_D_MS Pay_Sched_D_Type; --Stores records that have been deleted.
215: FII_AP_Invoice_B_MS Invoice_B_Type;
216: g_invoice_b_marker BINARY_INTEGER;
217: FII_AP_Invoice_UI_MS Invoice_B_Type; --Stores records that have been updated or inserted.
218: FII_AP_Invoice_D_MS Invoice_D_Type; --Stores records that have been deleted.
219: FII_AP_Inv_MS Inv_Type;

Line 763: FROM FII_AP_DBI_LOG_T Log, FII_AP_Invoice_B AI

759: WHERE Table_Name = 'AP_HOLDS');
760:
761: DELETE /*+ index(B) push_subq */ FROM FII_AP_INV_HOLDS_B B
762: WHERE Invoice_ID IN (SELECT /*+ cardinality(Log,1) */ Key_Value1_Num
763: FROM FII_AP_DBI_LOG_T Log, FII_AP_Invoice_B AI
764: WHERE Log.Key_Value1_Num = AI.Invoice_ID
765: AND AI.Cancel_Date IS NOT NULL
766: AND Log.Table_Name = 'AP_INVOICES');
767:

Line 832: FII_AP_Invoice_B AI

828: FROM FII_AP_DBI_LOG_T
829: WHERE Table_Name = 'AP_HOLDS'
830: AND Operation_Flag IN ('I','U')) T,
831: AP_Holds_All AH,
832: FII_AP_Invoice_B AI
833: WHERE AH.Invoice_ID = AI.Invoice_ID
834: AND AI.Cancel_Date IS NULL
835: AND AI.Invoice_Type NOT IN ('PREPAYMENT')
836: AND AH.Invoice_ID = T.Key_Value1_Num;

Line 847: FROM FII_AP_Invoice_B AI

843: end if;
844:
845: UPDATE FII_AP_INV_HOLDS_B HSUM
846: SET Supplier_ID = (SELECT AI.Supplier_ID
847: FROM FII_AP_Invoice_B AI
848: WHERE AI.Invoice_ID = HSUM.Invoice_ID)
849: WHERE HSUM.Invoice_ID IN (SELECT Key_Value1_Num
850: FROM FII_AP_DBI_LOG_T
851: WHERE Table_Name = 'AP_INVOICES'

Line 902: FROM FII_AP_DBI_LOG_T LOG, FII_AP_Invoice_B AI

898: WHERE Table_Name = 'AP_HOLDS');
899:
900: DELETE /*+ index(B) push_subq */ FROM FII_AP_Hold_Hist_B
901: WHERE Invoice_ID IN (SELECT /*+ cardinality(LOG,1) */ Key_Value1_Num
902: FROM FII_AP_DBI_LOG_T LOG, FII_AP_Invoice_B AI
903: WHERE LOG.Key_Value1_Num = AI.Invoice_ID
904: AND AI.Cancel_Date IS NOT NULL
905: AND LOG.Table_Name = 'AP_INVOICES');
906:

Line 966: FII_AP_INVOICE_B AI,

962: FROM FII_AP_DBI_LOG_T lt
963: WHERE Table_Name = 'AP_HOLDS'
964: AND Operation_Flag IN ('I','U')) LOG,
965: AP_HOLDS_ALL AH,
966: FII_AP_INVOICE_B AI,
967: (SELECT 'H' Rec_Type FROM DUAL WHERE dummy IS NOT NULL
968: UNION ALL select 'R' Rec_Type FROM DUAL WHERE dummy IS NOT NULL) RT
969: WHERE AH.Invoice_ID = LOG.Key_Value1_Num
970: AND AI.Invoice_ID = AH.Invoice_ID

Line 1137: ELSIF Invoice_ID IS NOT NULL AND Payment_Num IS NULL THEN --Check if FII_AP_Invoice_B_MS has any deletions.

1133: FII_AP_Pay_Sched_D_MS(FII_AP_Pay_Sched_D_MS.Count+1) := Deleted_Pay_Sched;
1134: g_pay_sched_b_marker := FII_AP_Pay_Sched_B_MS.Next(g_pay_sched_b_marker);
1135: END LOOP;
1136:
1137: ELSIF Invoice_ID IS NOT NULL AND Payment_Num IS NULL THEN --Check if FII_AP_Invoice_B_MS has any deletions.
1138:
1139: WHILE g_invoice_b_marker IS NOT NULL
1140: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID < Invoice_ID LOOP
1141: Deleted_Invoice.Invoice_ID := FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID;

Line 1140: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID < Invoice_ID LOOP

1136:
1137: ELSIF Invoice_ID IS NOT NULL AND Payment_Num IS NULL THEN --Check if FII_AP_Invoice_B_MS has any deletions.
1138:
1139: WHILE g_invoice_b_marker IS NOT NULL
1140: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID < Invoice_ID LOOP
1141: Deleted_Invoice.Invoice_ID := FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID;
1142: FII_AP_Invoice_D_MS(FII_AP_Invoice_D_MS.Count+1) := Deleted_Invoice;
1143: g_invoice_b_marker := FII_AP_Invoice_B_MS.Next(g_invoice_b_marker);
1144: END LOOP;

Line 1141: Deleted_Invoice.Invoice_ID := FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID;

1137: ELSIF Invoice_ID IS NOT NULL AND Payment_Num IS NULL THEN --Check if FII_AP_Invoice_B_MS has any deletions.
1138:
1139: WHILE g_invoice_b_marker IS NOT NULL
1140: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID < Invoice_ID LOOP
1141: Deleted_Invoice.Invoice_ID := FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID;
1142: FII_AP_Invoice_D_MS(FII_AP_Invoice_D_MS.Count+1) := Deleted_Invoice;
1143: g_invoice_b_marker := FII_AP_Invoice_B_MS.Next(g_invoice_b_marker);
1144: END LOOP;
1145:

Line 1143: g_invoice_b_marker := FII_AP_Invoice_B_MS.Next(g_invoice_b_marker);

1139: WHILE g_invoice_b_marker IS NOT NULL
1140: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID < Invoice_ID LOOP
1141: Deleted_Invoice.Invoice_ID := FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID;
1142: FII_AP_Invoice_D_MS(FII_AP_Invoice_D_MS.Count+1) := Deleted_Invoice;
1143: g_invoice_b_marker := FII_AP_Invoice_B_MS.Next(g_invoice_b_marker);
1144: END LOOP;
1145:
1146: ELSIF Invoice_ID IS NULL AND Payment_Num IS NULL THEN
1147:

Line 1160: Deleted_Invoice.Invoice_ID := FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID;

1156: g_pay_sched_b_marker := FII_AP_Pay_Sched_B_MS.Next(g_pay_sched_b_marker);
1157: END LOOP;
1158:
1159: WHILE g_invoice_b_marker IS NOT NULL LOOP
1160: Deleted_Invoice.Invoice_ID := FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID;
1161: FII_AP_Invoice_D_MS(FII_AP_Invoice_D_MS.Count+1) := Deleted_Invoice;
1162: g_invoice_b_marker := FII_AP_Invoice_B_MS.Next(g_invoice_b_marker);
1163: END LOOP;
1164:

Line 1162: g_invoice_b_marker := FII_AP_Invoice_B_MS.Next(g_invoice_b_marker);

1158:
1159: WHILE g_invoice_b_marker IS NOT NULL LOOP
1160: Deleted_Invoice.Invoice_ID := FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID;
1161: FII_AP_Invoice_D_MS(FII_AP_Invoice_D_MS.Count+1) := Deleted_Invoice;
1162: g_invoice_b_marker := FII_AP_Invoice_B_MS.Next(g_invoice_b_marker);
1163: END LOOP;
1164:
1165: END IF;
1166:

Line 1295: -- record in FII_AP_Invoice_B_MS (existing data).

1291: -- Purpose
1292: -- This INSERT_INVOICE_B_REC routine inserts records into
1293: -- FII_AP_Invoice_UI_MS, and/or FII_AP_Invoice_D_MS
1294: -- by comparing the record passed as a parameter with the current
1295: -- record in FII_AP_Invoice_B_MS (existing data).
1296: ------------------------------------------------------------------
1297: PROCEDURE INSERT_INVOICE_B_REC(Invoice_Rec FII_AP_Invoice_B%ROWTYPE) IS
1298:
1299: BEGIN

Line 1297: PROCEDURE INSERT_INVOICE_B_REC(Invoice_Rec FII_AP_Invoice_B%ROWTYPE) IS

1293: -- FII_AP_Invoice_UI_MS, and/or FII_AP_Invoice_D_MS
1294: -- by comparing the record passed as a parameter with the current
1295: -- record in FII_AP_Invoice_B_MS (existing data).
1296: ------------------------------------------------------------------
1297: PROCEDURE INSERT_INVOICE_B_REC(Invoice_Rec FII_AP_Invoice_B%ROWTYPE) IS
1298:
1299: BEGIN
1300: g_state := 'Inside INSERT_INVOICE_B_REC Procedure.';
1301:

Line 1307: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID = Invoice_Rec.Invoice_ID THEN

1303: -- INSERT_DELETED_REC(Invoice_Rec.Invoice_ID, NULL);
1304:
1305: --Check if Invoice_Rec exists from previous load.
1306: IF g_invoice_b_marker IS NOT NULL
1307: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID = Invoice_Rec.Invoice_ID THEN
1308: --Check if Invoice_Rec has been updated.
1309: IF FII_AP_Invoice_B_MS(g_invoice_b_marker).Org_ID <> Invoice_Rec.Org_ID
1310: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Supplier_ID <> Invoice_Rec.Supplier_ID
1311: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Type <> Invoice_Rec.Invoice_Type

Line 1309: IF FII_AP_Invoice_B_MS(g_invoice_b_marker).Org_ID <> Invoice_Rec.Org_ID

1305: --Check if Invoice_Rec exists from previous load.
1306: IF g_invoice_b_marker IS NOT NULL
1307: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID = Invoice_Rec.Invoice_ID THEN
1308: --Check if Invoice_Rec has been updated.
1309: IF FII_AP_Invoice_B_MS(g_invoice_b_marker).Org_ID <> Invoice_Rec.Org_ID
1310: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Supplier_ID <> Invoice_Rec.Supplier_ID
1311: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Type <> Invoice_Rec.Invoice_Type
1312: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Number <> Invoice_Rec.Invoice_Number
1313: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Date <> Invoice_Rec.Invoice_Date

Line 1310: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Supplier_ID <> Invoice_Rec.Supplier_ID

1306: IF g_invoice_b_marker IS NOT NULL
1307: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID = Invoice_Rec.Invoice_ID THEN
1308: --Check if Invoice_Rec has been updated.
1309: IF FII_AP_Invoice_B_MS(g_invoice_b_marker).Org_ID <> Invoice_Rec.Org_ID
1310: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Supplier_ID <> Invoice_Rec.Supplier_ID
1311: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Type <> Invoice_Rec.Invoice_Type
1312: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Number <> Invoice_Rec.Invoice_Number
1313: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Date <> Invoice_Rec.Invoice_Date
1314: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Amount <> Invoice_Rec.Invoice_Amount

Line 1311: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Type <> Invoice_Rec.Invoice_Type

1307: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID = Invoice_Rec.Invoice_ID THEN
1308: --Check if Invoice_Rec has been updated.
1309: IF FII_AP_Invoice_B_MS(g_invoice_b_marker).Org_ID <> Invoice_Rec.Org_ID
1310: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Supplier_ID <> Invoice_Rec.Supplier_ID
1311: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Type <> Invoice_Rec.Invoice_Type
1312: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Number <> Invoice_Rec.Invoice_Number
1313: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Date <> Invoice_Rec.Invoice_Date
1314: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Amount <> Invoice_Rec.Invoice_Amount
1315: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Amount <> Invoice_Rec.Base_Amount

Line 1312: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Number <> Invoice_Rec.Invoice_Number

1308: --Check if Invoice_Rec has been updated.
1309: IF FII_AP_Invoice_B_MS(g_invoice_b_marker).Org_ID <> Invoice_Rec.Org_ID
1310: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Supplier_ID <> Invoice_Rec.Supplier_ID
1311: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Type <> Invoice_Rec.Invoice_Type
1312: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Number <> Invoice_Rec.Invoice_Number
1313: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Date <> Invoice_Rec.Invoice_Date
1314: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Amount <> Invoice_Rec.Invoice_Amount
1315: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Amount <> Invoice_Rec.Base_Amount
1316: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Amount <> Invoice_Rec.Prim_Amount

Line 1313: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Date <> Invoice_Rec.Invoice_Date

1309: IF FII_AP_Invoice_B_MS(g_invoice_b_marker).Org_ID <> Invoice_Rec.Org_ID
1310: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Supplier_ID <> Invoice_Rec.Supplier_ID
1311: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Type <> Invoice_Rec.Invoice_Type
1312: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Number <> Invoice_Rec.Invoice_Number
1313: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Date <> Invoice_Rec.Invoice_Date
1314: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Amount <> Invoice_Rec.Invoice_Amount
1315: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Amount <> Invoice_Rec.Base_Amount
1316: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Amount <> Invoice_Rec.Prim_Amount
1317: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Amount <> Invoice_Rec.Sec_Amount

Line 1314: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Amount <> Invoice_Rec.Invoice_Amount

1310: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Supplier_ID <> Invoice_Rec.Supplier_ID
1311: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Type <> Invoice_Rec.Invoice_Type
1312: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Number <> Invoice_Rec.Invoice_Number
1313: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Date <> Invoice_Rec.Invoice_Date
1314: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Amount <> Invoice_Rec.Invoice_Amount
1315: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Amount <> Invoice_Rec.Base_Amount
1316: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Amount <> Invoice_Rec.Prim_Amount
1317: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Amount <> Invoice_Rec.Sec_Amount
1318: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Currency_Code <> Invoice_Rec.Invoice_Currency_Code

Line 1315: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Amount <> Invoice_Rec.Base_Amount

1311: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Type <> Invoice_Rec.Invoice_Type
1312: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Number <> Invoice_Rec.Invoice_Number
1313: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Date <> Invoice_Rec.Invoice_Date
1314: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Amount <> Invoice_Rec.Invoice_Amount
1315: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Amount <> Invoice_Rec.Base_Amount
1316: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Amount <> Invoice_Rec.Prim_Amount
1317: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Amount <> Invoice_Rec.Sec_Amount
1318: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Currency_Code <> Invoice_Rec.Invoice_Currency_Code
1319: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Currency_Code <> Invoice_Rec.Base_Currency_Code

Line 1316: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Amount <> Invoice_Rec.Prim_Amount

1312: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Number <> Invoice_Rec.Invoice_Number
1313: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Date <> Invoice_Rec.Invoice_Date
1314: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Amount <> Invoice_Rec.Invoice_Amount
1315: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Amount <> Invoice_Rec.Base_Amount
1316: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Amount <> Invoice_Rec.Prim_Amount
1317: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Amount <> Invoice_Rec.Sec_Amount
1318: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Currency_Code <> Invoice_Rec.Invoice_Currency_Code
1319: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Currency_Code <> Invoice_Rec.Base_Currency_Code
1320: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Entered_Date <> Invoice_Rec.Entered_Date

Line 1317: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Amount <> Invoice_Rec.Sec_Amount

1313: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Date <> Invoice_Rec.Invoice_Date
1314: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Amount <> Invoice_Rec.Invoice_Amount
1315: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Amount <> Invoice_Rec.Base_Amount
1316: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Amount <> Invoice_Rec.Prim_Amount
1317: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Amount <> Invoice_Rec.Sec_Amount
1318: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Currency_Code <> Invoice_Rec.Invoice_Currency_Code
1319: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Currency_Code <> Invoice_Rec.Base_Currency_Code
1320: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Entered_Date <> Invoice_Rec.Entered_Date
1321: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Currency_Code <> Invoice_Rec.Payment_Currency_Code

Line 1318: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Currency_Code <> Invoice_Rec.Invoice_Currency_Code

1314: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Amount <> Invoice_Rec.Invoice_Amount
1315: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Amount <> Invoice_Rec.Base_Amount
1316: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Amount <> Invoice_Rec.Prim_Amount
1317: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Amount <> Invoice_Rec.Sec_Amount
1318: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Currency_Code <> Invoice_Rec.Invoice_Currency_Code
1319: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Currency_Code <> Invoice_Rec.Base_Currency_Code
1320: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Entered_Date <> Invoice_Rec.Entered_Date
1321: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Currency_Code <> Invoice_Rec.Payment_Currency_Code
1322: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Date <> Invoice_Rec.Fully_Paid_Date

Line 1319: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Currency_Code <> Invoice_Rec.Base_Currency_Code

1315: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Amount <> Invoice_Rec.Base_Amount
1316: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Amount <> Invoice_Rec.Prim_Amount
1317: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Amount <> Invoice_Rec.Sec_Amount
1318: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Currency_Code <> Invoice_Rec.Invoice_Currency_Code
1319: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Currency_Code <> Invoice_Rec.Base_Currency_Code
1320: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Entered_Date <> Invoice_Rec.Entered_Date
1321: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Currency_Code <> Invoice_Rec.Payment_Currency_Code
1322: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Date <> Invoice_Rec.Fully_Paid_Date
1323: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Terms_ID <> Invoice_Rec.Terms_ID

Line 1320: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Entered_Date <> Invoice_Rec.Entered_Date

1316: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Amount <> Invoice_Rec.Prim_Amount
1317: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Amount <> Invoice_Rec.Sec_Amount
1318: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Currency_Code <> Invoice_Rec.Invoice_Currency_Code
1319: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Currency_Code <> Invoice_Rec.Base_Currency_Code
1320: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Entered_Date <> Invoice_Rec.Entered_Date
1321: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Currency_Code <> Invoice_Rec.Payment_Currency_Code
1322: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Date <> Invoice_Rec.Fully_Paid_Date
1323: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Terms_ID <> Invoice_Rec.Terms_ID
1324: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Source <> Invoice_Rec.Source

Line 1321: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Currency_Code <> Invoice_Rec.Payment_Currency_Code

1317: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Amount <> Invoice_Rec.Sec_Amount
1318: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Currency_Code <> Invoice_Rec.Invoice_Currency_Code
1319: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Currency_Code <> Invoice_Rec.Base_Currency_Code
1320: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Entered_Date <> Invoice_Rec.Entered_Date
1321: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Currency_Code <> Invoice_Rec.Payment_Currency_Code
1322: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Date <> Invoice_Rec.Fully_Paid_Date
1323: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Terms_ID <> Invoice_Rec.Terms_ID
1324: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Source <> Invoice_Rec.Source
1325: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).E_Invoices_Flag <> Invoice_Rec.E_Invoices_Flag

Line 1322: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Date <> Invoice_Rec.Fully_Paid_Date

1318: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_Currency_Code <> Invoice_Rec.Invoice_Currency_Code
1319: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Currency_Code <> Invoice_Rec.Base_Currency_Code
1320: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Entered_Date <> Invoice_Rec.Entered_Date
1321: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Currency_Code <> Invoice_Rec.Payment_Currency_Code
1322: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Date <> Invoice_Rec.Fully_Paid_Date
1323: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Terms_ID <> Invoice_Rec.Terms_ID
1324: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Source <> Invoice_Rec.Source
1325: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).E_Invoices_Flag <> Invoice_Rec.E_Invoices_Flag
1326: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Flag <> Invoice_Rec.Cancel_Flag

Line 1323: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Terms_ID <> Invoice_Rec.Terms_ID

1319: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Base_Currency_Code <> Invoice_Rec.Base_Currency_Code
1320: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Entered_Date <> Invoice_Rec.Entered_Date
1321: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Currency_Code <> Invoice_Rec.Payment_Currency_Code
1322: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Date <> Invoice_Rec.Fully_Paid_Date
1323: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Terms_ID <> Invoice_Rec.Terms_ID
1324: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Source <> Invoice_Rec.Source
1325: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).E_Invoices_Flag <> Invoice_Rec.E_Invoices_Flag
1326: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Flag <> Invoice_Rec.Cancel_Flag
1327: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Date <> Invoice_Rec.Cancel_Date

Line 1324: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Source <> Invoice_Rec.Source

1320: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Entered_Date <> Invoice_Rec.Entered_Date
1321: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Currency_Code <> Invoice_Rec.Payment_Currency_Code
1322: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Date <> Invoice_Rec.Fully_Paid_Date
1323: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Terms_ID <> Invoice_Rec.Terms_ID
1324: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Source <> Invoice_Rec.Source
1325: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).E_Invoices_Flag <> Invoice_Rec.E_Invoices_Flag
1326: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Flag <> Invoice_Rec.Cancel_Flag
1327: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Date <> Invoice_Rec.Cancel_Date
1328: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Dist_Count <> Invoice_Rec.Dist_Count

Line 1325: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).E_Invoices_Flag <> Invoice_Rec.E_Invoices_Flag

1321: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Currency_Code <> Invoice_Rec.Payment_Currency_Code
1322: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Date <> Invoice_Rec.Fully_Paid_Date
1323: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Terms_ID <> Invoice_Rec.Terms_ID
1324: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Source <> Invoice_Rec.Source
1325: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).E_Invoices_Flag <> Invoice_Rec.E_Invoices_Flag
1326: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Flag <> Invoice_Rec.Cancel_Flag
1327: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Date <> Invoice_Rec.Cancel_Date
1328: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Dist_Count <> Invoice_Rec.Dist_Count
1329: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Due_Date <> Invoice_Rec.Due_Date

Line 1326: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Flag <> Invoice_Rec.Cancel_Flag

1322: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Date <> Invoice_Rec.Fully_Paid_Date
1323: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Terms_ID <> Invoice_Rec.Terms_ID
1324: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Source <> Invoice_Rec.Source
1325: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).E_Invoices_Flag <> Invoice_Rec.E_Invoices_Flag
1326: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Flag <> Invoice_Rec.Cancel_Flag
1327: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Date <> Invoice_Rec.Cancel_Date
1328: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Dist_Count <> Invoice_Rec.Dist_Count
1329: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Due_Date <> Invoice_Rec.Due_Date
1330: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered <> Invoice_Rec.Discount_Offered

Line 1327: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Date <> Invoice_Rec.Cancel_Date

1323: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Terms_ID <> Invoice_Rec.Terms_ID
1324: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Source <> Invoice_Rec.Source
1325: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).E_Invoices_Flag <> Invoice_Rec.E_Invoices_Flag
1326: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Flag <> Invoice_Rec.Cancel_Flag
1327: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Date <> Invoice_Rec.Cancel_Date
1328: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Dist_Count <> Invoice_Rec.Dist_Count
1329: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Due_Date <> Invoice_Rec.Due_Date
1330: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered <> Invoice_Rec.Discount_Offered
1331: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered_B <> Invoice_Rec.Discount_Offered_B

Line 1328: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Dist_Count <> Invoice_Rec.Dist_Count

1324: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Source <> Invoice_Rec.Source
1325: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).E_Invoices_Flag <> Invoice_Rec.E_Invoices_Flag
1326: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Flag <> Invoice_Rec.Cancel_Flag
1327: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Date <> Invoice_Rec.Cancel_Date
1328: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Dist_Count <> Invoice_Rec.Dist_Count
1329: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Due_Date <> Invoice_Rec.Due_Date
1330: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered <> Invoice_Rec.Discount_Offered
1331: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered_B <> Invoice_Rec.Discount_Offered_B
1332: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Discount_Offered <> Invoice_Rec.Prim_Discount_Offered

Line 1329: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Due_Date <> Invoice_Rec.Due_Date

1325: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).E_Invoices_Flag <> Invoice_Rec.E_Invoices_Flag
1326: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Flag <> Invoice_Rec.Cancel_Flag
1327: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Date <> Invoice_Rec.Cancel_Date
1328: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Dist_Count <> Invoice_Rec.Dist_Count
1329: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Due_Date <> Invoice_Rec.Due_Date
1330: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered <> Invoice_Rec.Discount_Offered
1331: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered_B <> Invoice_Rec.Discount_Offered_B
1332: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Discount_Offered <> Invoice_Rec.Prim_Discount_Offered
1333: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Discount_Offered <> Invoice_Rec.Sec_Discount_Offered

Line 1330: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered <> Invoice_Rec.Discount_Offered

1326: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Flag <> Invoice_Rec.Cancel_Flag
1327: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Date <> Invoice_Rec.Cancel_Date
1328: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Dist_Count <> Invoice_Rec.Dist_Count
1329: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Due_Date <> Invoice_Rec.Due_Date
1330: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered <> Invoice_Rec.Discount_Offered
1331: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered_B <> Invoice_Rec.Discount_Offered_B
1332: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Discount_Offered <> Invoice_Rec.Prim_Discount_Offered
1333: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Discount_Offered <> Invoice_Rec.Sec_Discount_Offered
1334: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).First_Hold_Date <> Invoice_Rec.First_Hold_Date

Line 1331: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered_B <> Invoice_Rec.Discount_Offered_B

1327: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Cancel_Date <> Invoice_Rec.Cancel_Date
1328: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Dist_Count <> Invoice_Rec.Dist_Count
1329: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Due_Date <> Invoice_Rec.Due_Date
1330: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered <> Invoice_Rec.Discount_Offered
1331: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered_B <> Invoice_Rec.Discount_Offered_B
1332: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Discount_Offered <> Invoice_Rec.Prim_Discount_Offered
1333: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Discount_Offered <> Invoice_Rec.Sec_Discount_Offered
1334: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).First_Hold_Date <> Invoice_Rec.First_Hold_Date
1335: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Date <> Invoice_Rec.Exchange_Date

Line 1332: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Discount_Offered <> Invoice_Rec.Prim_Discount_Offered

1328: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Dist_Count <> Invoice_Rec.Dist_Count
1329: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Due_Date <> Invoice_Rec.Due_Date
1330: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered <> Invoice_Rec.Discount_Offered
1331: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered_B <> Invoice_Rec.Discount_Offered_B
1332: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Discount_Offered <> Invoice_Rec.Prim_Discount_Offered
1333: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Discount_Offered <> Invoice_Rec.Sec_Discount_Offered
1334: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).First_Hold_Date <> Invoice_Rec.First_Hold_Date
1335: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Date <> Invoice_Rec.Exchange_Date
1336: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate <> Invoice_Rec.Exchange_Rate

Line 1333: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Discount_Offered <> Invoice_Rec.Sec_Discount_Offered

1329: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Due_Date <> Invoice_Rec.Due_Date
1330: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered <> Invoice_Rec.Discount_Offered
1331: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered_B <> Invoice_Rec.Discount_Offered_B
1332: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Discount_Offered <> Invoice_Rec.Prim_Discount_Offered
1333: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Discount_Offered <> Invoice_Rec.Sec_Discount_Offered
1334: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).First_Hold_Date <> Invoice_Rec.First_Hold_Date
1335: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Date <> Invoice_Rec.Exchange_Date
1336: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate <> Invoice_Rec.Exchange_Rate
1337: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate_Type <> Invoice_Rec.Exchange_Rate_Type

Line 1334: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).First_Hold_Date <> Invoice_Rec.First_Hold_Date

1330: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered <> Invoice_Rec.Discount_Offered
1331: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered_B <> Invoice_Rec.Discount_Offered_B
1332: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Discount_Offered <> Invoice_Rec.Prim_Discount_Offered
1333: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Discount_Offered <> Invoice_Rec.Sec_Discount_Offered
1334: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).First_Hold_Date <> Invoice_Rec.First_Hold_Date
1335: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Date <> Invoice_Rec.Exchange_Date
1336: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate <> Invoice_Rec.Exchange_Rate
1337: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate_Type <> Invoice_Rec.Exchange_Rate_Type
1338: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Status_Flag <> Invoice_Rec.Payment_Status_Flag

Line 1335: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Date <> Invoice_Rec.Exchange_Date

1331: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Discount_Offered_B <> Invoice_Rec.Discount_Offered_B
1332: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Discount_Offered <> Invoice_Rec.Prim_Discount_Offered
1333: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Discount_Offered <> Invoice_Rec.Sec_Discount_Offered
1334: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).First_Hold_Date <> Invoice_Rec.First_Hold_Date
1335: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Date <> Invoice_Rec.Exchange_Date
1336: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate <> Invoice_Rec.Exchange_Rate
1337: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate_Type <> Invoice_Rec.Exchange_Rate_Type
1338: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Status_Flag <> Invoice_Rec.Payment_Status_Flag
1339: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Cross_Rate <> Invoice_Rec.Payment_Cross_Rate

Line 1336: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate <> Invoice_Rec.Exchange_Rate

1332: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Discount_Offered <> Invoice_Rec.Prim_Discount_Offered
1333: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Discount_Offered <> Invoice_Rec.Sec_Discount_Offered
1334: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).First_Hold_Date <> Invoice_Rec.First_Hold_Date
1335: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Date <> Invoice_Rec.Exchange_Date
1336: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate <> Invoice_Rec.Exchange_Rate
1337: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate_Type <> Invoice_Rec.Exchange_Rate_Type
1338: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Status_Flag <> Invoice_Rec.Payment_Status_Flag
1339: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Cross_Rate <> Invoice_Rec.Payment_Cross_Rate
1340: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount <> Invoice_Rec.Fully_Paid_Amount

Line 1337: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate_Type <> Invoice_Rec.Exchange_Rate_Type

1333: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Discount_Offered <> Invoice_Rec.Sec_Discount_Offered
1334: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).First_Hold_Date <> Invoice_Rec.First_Hold_Date
1335: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Date <> Invoice_Rec.Exchange_Date
1336: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate <> Invoice_Rec.Exchange_Rate
1337: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate_Type <> Invoice_Rec.Exchange_Rate_Type
1338: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Status_Flag <> Invoice_Rec.Payment_Status_Flag
1339: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Cross_Rate <> Invoice_Rec.Payment_Cross_Rate
1340: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount <> Invoice_Rec.Fully_Paid_Amount
1341: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount_B <> Invoice_Rec.Fully_Paid_Amount_B

Line 1338: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Status_Flag <> Invoice_Rec.Payment_Status_Flag

1334: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).First_Hold_Date <> Invoice_Rec.First_Hold_Date
1335: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Date <> Invoice_Rec.Exchange_Date
1336: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate <> Invoice_Rec.Exchange_Rate
1337: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate_Type <> Invoice_Rec.Exchange_Rate_Type
1338: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Status_Flag <> Invoice_Rec.Payment_Status_Flag
1339: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Cross_Rate <> Invoice_Rec.Payment_Cross_Rate
1340: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount <> Invoice_Rec.Fully_Paid_Amount
1341: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount_B <> Invoice_Rec.Fully_Paid_Amount_B
1342: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Fully_Paid_Amount <> Invoice_Rec.Prim_Fully_Paid_Amount

Line 1339: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Cross_Rate <> Invoice_Rec.Payment_Cross_Rate

1335: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Date <> Invoice_Rec.Exchange_Date
1336: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate <> Invoice_Rec.Exchange_Rate
1337: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate_Type <> Invoice_Rec.Exchange_Rate_Type
1338: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Status_Flag <> Invoice_Rec.Payment_Status_Flag
1339: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Cross_Rate <> Invoice_Rec.Payment_Cross_Rate
1340: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount <> Invoice_Rec.Fully_Paid_Amount
1341: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount_B <> Invoice_Rec.Fully_Paid_Amount_B
1342: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Fully_Paid_Amount <> Invoice_Rec.Prim_Fully_Paid_Amount
1343: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Fully_Paid_Amount <> Invoice_Rec.Sec_Fully_Paid_Amount THEN

Line 1340: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount <> Invoice_Rec.Fully_Paid_Amount

1336: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate <> Invoice_Rec.Exchange_Rate
1337: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate_Type <> Invoice_Rec.Exchange_Rate_Type
1338: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Status_Flag <> Invoice_Rec.Payment_Status_Flag
1339: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Cross_Rate <> Invoice_Rec.Payment_Cross_Rate
1340: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount <> Invoice_Rec.Fully_Paid_Amount
1341: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount_B <> Invoice_Rec.Fully_Paid_Amount_B
1342: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Fully_Paid_Amount <> Invoice_Rec.Prim_Fully_Paid_Amount
1343: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Fully_Paid_Amount <> Invoice_Rec.Sec_Fully_Paid_Amount THEN
1344:

Line 1341: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount_B <> Invoice_Rec.Fully_Paid_Amount_B

1337: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Exchange_Rate_Type <> Invoice_Rec.Exchange_Rate_Type
1338: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Status_Flag <> Invoice_Rec.Payment_Status_Flag
1339: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Cross_Rate <> Invoice_Rec.Payment_Cross_Rate
1340: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount <> Invoice_Rec.Fully_Paid_Amount
1341: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount_B <> Invoice_Rec.Fully_Paid_Amount_B
1342: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Fully_Paid_Amount <> Invoice_Rec.Prim_Fully_Paid_Amount
1343: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Fully_Paid_Amount <> Invoice_Rec.Sec_Fully_Paid_Amount THEN
1344:
1345: --Record has changed, so update.

Line 1342: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Fully_Paid_Amount <> Invoice_Rec.Prim_Fully_Paid_Amount

1338: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Status_Flag <> Invoice_Rec.Payment_Status_Flag
1339: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Cross_Rate <> Invoice_Rec.Payment_Cross_Rate
1340: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount <> Invoice_Rec.Fully_Paid_Amount
1341: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount_B <> Invoice_Rec.Fully_Paid_Amount_B
1342: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Fully_Paid_Amount <> Invoice_Rec.Prim_Fully_Paid_Amount
1343: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Fully_Paid_Amount <> Invoice_Rec.Sec_Fully_Paid_Amount THEN
1344:
1345: --Record has changed, so update.
1346: FII_AP_Invoice_UI_MS(FII_AP_Invoice_UI_MS.Count+1) := Invoice_Rec;

Line 1343: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Fully_Paid_Amount <> Invoice_Rec.Sec_Fully_Paid_Amount THEN

1339: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Payment_Cross_Rate <> Invoice_Rec.Payment_Cross_Rate
1340: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount <> Invoice_Rec.Fully_Paid_Amount
1341: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Fully_Paid_Amount_B <> Invoice_Rec.Fully_Paid_Amount_B
1342: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Prim_Fully_Paid_Amount <> Invoice_Rec.Prim_Fully_Paid_Amount
1343: OR FII_AP_Invoice_B_MS(g_invoice_b_marker).Sec_Fully_Paid_Amount <> Invoice_Rec.Sec_Fully_Paid_Amount THEN
1344:
1345: --Record has changed, so update.
1346: FII_AP_Invoice_UI_MS(FII_AP_Invoice_UI_MS.Count+1) := Invoice_Rec;
1347: END IF;

Line 1349: g_invoice_b_marker := FII_AP_Invoice_B_MS.Next(g_invoice_b_marker);

1345: --Record has changed, so update.
1346: FII_AP_Invoice_UI_MS(FII_AP_Invoice_UI_MS.Count+1) := Invoice_Rec;
1347: END IF;
1348:
1349: g_invoice_b_marker := FII_AP_Invoice_B_MS.Next(g_invoice_b_marker);
1350:
1351: ELSE --Invoice_Rec does not exist in previous load, so insert.
1352: FII_AP_Invoice_UI_MS(FII_AP_Invoice_UI_MS.Count+1) := Invoice_Rec;
1353: END IF;

Line 1669: SELECT /+ ordered index(AI, FII_AP_INVOICE_B_U1) /

1665:
1666: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1667:
1668:
1669: SELECT /*+ ordered index(AI, FII_AP_INVOICE_B_U1) */
1670: AI.Org_ID, AI.Supplier_ID, AI.Invoice_ID, AI.Invoice_Type, AI.Invoice_Number,
1671: AI.Invoice_Date, AI.Invoice_Amount, AI.Base_Amount, AI.Prim_Amount,
1672: AI.Sec_Amount, Ai.Invoice_Currency_Code, AI.Base_Currency_Code, AI.Entered_Date,
1673: AI.Payment_Currency_Code, AI.Fully_Paid_Date, AI.Terms_ID, AI.Source,

Line 1681: BULK COLLECT INTO FII_AP_Invoice_B_MS

1677: AI.Last_Updated_By, AI.Creation_Date, AI.Created_By, AI.Last_Update_Login,
1678: AI.Exchange_Date, AI.Exchange_Rate, AI.Exchange_Rate_Type, AI.Payment_Status_Flag,
1679: AI.Payment_Cross_Rate, AI.Fully_Paid_Amount, AI.Fully_Paid_Amount_B,
1680: AI.Prim_Fully_Paid_Amount, AI.Sec_Fully_Paid_Amount
1681: BULK COLLECT INTO FII_AP_Invoice_B_MS
1682: FROM FII_AP_Invoice_IDS ID,
1683: FII_AP_Invoice_B AI
1684: WHERE ID.Invoice_ID = AI.Invoice_ID
1685: AND ID.Invoice_B_Flag = 'Y'

Line 1683: FII_AP_Invoice_B AI

1679: AI.Payment_Cross_Rate, AI.Fully_Paid_Amount, AI.Fully_Paid_Amount_B,
1680: AI.Prim_Fully_Paid_Amount, AI.Sec_Fully_Paid_Amount
1681: BULK COLLECT INTO FII_AP_Invoice_B_MS
1682: FROM FII_AP_Invoice_IDS ID,
1683: FII_AP_Invoice_B AI
1684: WHERE ID.Invoice_ID = AI.Invoice_ID
1685: AND ID.Invoice_B_Flag = 'Y'
1686: ORDER BY AI.Invoice_ID;
1687:

Line 1691: FII_UTIL.put_line('The Memory Structure FII_AP_Invoice_B_MS has been populated with ' || FII_AP_Invoice_B_MS.COUNT || ' records.');

1687:
1688: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1689:
1690: if g_debug_flag = 'Y' then
1691: FII_UTIL.put_line('The Memory Structure FII_AP_Invoice_B_MS has been populated with ' || FII_AP_Invoice_B_MS.COUNT || ' records.');
1692: FII_UTIL.put_line('The time taken to populate FII_AP_Invoice_B_MS is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1693: end if;
1694:
1695:

Line 1692: FII_UTIL.put_line('The time taken to populate FII_AP_Invoice_B_MS is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

1688: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1689:
1690: if g_debug_flag = 'Y' then
1691: FII_UTIL.put_line('The Memory Structure FII_AP_Invoice_B_MS has been populated with ' || FII_AP_Invoice_B_MS.COUNT || ' records.');
1692: FII_UTIL.put_line('The time taken to populate FII_AP_Invoice_B_MS is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1693: end if;
1694:
1695:
1696: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;

Line 2018: -- summary table FII_AP_INVOICE_B.

2014: -- Procedure MAINTAIN_INVOICE_B
2015: -- Purpose
2016: -- This MAINTAIN_INVOICE_B routine deletes deleted records,
2017: -- updates changed records and inserts new records into base
2018: -- summary table FII_AP_INVOICE_B.
2019: ------------------------------------------------------------------
2020:
2021: PROCEDURE MAINTAIN_INVOICE_B IS
2022: l_timestamp1 BINARY_INTEGER;

Line 2026: g_state := 'Deleting records from FII_AP_Invoice_B.';

2022: l_timestamp1 BINARY_INTEGER;
2023: l_timestamp1_tmp BINARY_INTEGER;
2024: BEGIN
2025:
2026: g_state := 'Deleting records from FII_AP_Invoice_B.';
2027: if g_debug_flag = 'Y' then
2028: FII_UTIL.put_line(g_state);
2029: end if;
2030:

Line 2034: DELETE FROM FII_AP_Invoice_B AI

2030:
2031: l_timestamp1 := DBMS_UTILITY.Get_Time;
2032: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
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);

Line 2043: FII_UTIL.put_line('The time taken to delete records from FII_AP_Invoice_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

2039:
2040: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
2041:
2042: if g_debug_flag = 'Y' then
2043: FII_UTIL.put_line('The time taken to delete records from FII_AP_Invoice_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
2044: end if;
2045:
2046: g_state := 'Updating and Inserting records in FII_Invoice_B.';
2047: if g_debug_flag = 'Y' then

Line 2053: MERGE INTO FII_AP_Invoice_B AI

2049: end if;
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,

Line 2121: FII_UTIL.put_line('The time taken to update and insert records in FII_AP_Invoice_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

2117:
2118: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
2119:
2120: if g_debug_flag = 'Y' then
2121: FII_UTIL.put_line('The time taken to update and insert records in FII_AP_Invoice_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
2122: end if;
2123:
2124: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;
2125: if g_debug_flag = 'Y' then

Line 2126: FII_UTIL.put_line('The time taken to maintain FII_AP_Invoice_B is: ' || to_char(l_timestamp1/100) || ' seconds.');

2122: end if;
2123:
2124: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;
2125: if g_debug_flag = 'Y' then
2126: FII_UTIL.put_line('The time taken to maintain FII_AP_Invoice_B is: ' || to_char(l_timestamp1/100) || ' seconds.');
2127: end if;
2128:
2129:
2130: EXCEPTION

Line 2141: -- summary tables FII_AP_INVOICE_B, FII_AP_PAY_SCHED_B,

2137: ------------------------------------------------------------------
2138: -- Procedure POPULATE_INV_PAY_SCHED_SUM
2139: -- Purpose
2140: -- This POPULATE_INV_PAY_SCHED_SUM routine inserts records into base
2141: -- summary tables FII_AP_INVOICE_B, FII_AP_PAY_SCHED_B,
2142: -- FII_AP_AGING_BKTS_B and FII_AP_DUE_COUNTS_B using data cached in memory.
2143: ------------------------------------------------------------------
2144:
2145: PROCEDURE POPULATE_INV_PAY_SCHED_SUM IS

Line 2154: l_timestamp3 BINARY_INTEGER := 0; --Used to keep track of total time to populate the memory structures for FII_AP_Invoice_B.

2150: l_prepay_applied Prepay_Applied_Rec;
2151:
2152: l_timestamp2 BINARY_INTEGER := 0; --Used to keep track of total time to populate the memory structures for FII_AP_Pay_Sched_B.
2153: l_timestamp2_tmp BINARY_INTEGER;
2154: l_timestamp3 BINARY_INTEGER := 0; --Used to keep track of total time to populate the memory structures for FII_AP_Invoice_B.
2155: l_timestamp3_tmp BINARY_INTEGER;
2156: l_timestamp4 BINARY_INTEGER := 0; --Used to keep track of total time to populate FII_AP_Aging_Bkts_B and FII_AP_Due_Counts_B.
2157: l_timestamp4_tmp BINARY_INTEGER;
2158: BEGIN

Line 2213: g_invoice_b_marker := FII_AP_Invoice_B_MS.First;

2209:
2210: --Initialize global markers to traverse through Memory Structures.
2211: g_state := 'Initializing global markers to traverse through Memory Structures.';
2212: g_pay_sched_b_marker := FII_AP_Pay_Sched_B_MS.First;
2213: g_invoice_b_marker := FII_AP_Invoice_B_MS.First;
2214: l_pay_sched_marker := FII_AP_Pay_Sched_MS.First;
2215: l_inv_pay_marker := FII_AP_Inv_Pay_MS.First;
2216: l_wh_tax_marker := FII_AP_WH_Tax_MS.First;
2217: l_prepay_applied_marker := FII_AP_Prepay_Applied_MS.First;

Line 2234: l_invoice_b FII_AP_INVOICE_B%ROWTYPE;

2230: l_inv_disc_avail NUMBER := 0;
2231: l_inv_due_date DATE := NULL;
2232: l_inv_has_mult_ps VARCHAR2(1) := 'N';
2233:
2234: l_invoice_b FII_AP_INVOICE_B%ROWTYPE;
2235:
2236: l_ps_aging PS_Aging_Rec;
2237: l_ps_aging_marker VARCHAR2(50);
2238: l_aging_bkts_b FII_AP_AGING_BKTS_B%ROWTYPE;

Line 2258: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID = l_invoice.Invoice_ID

2254:
2255: --Check if there has been a supplier merge.
2256: INSERT_DELETED_REC(l_invoice.Invoice_ID, NULL);
2257: If g_invoice_b_marker IS NOT NULL
2258: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID = l_invoice.Invoice_ID
2259: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Supplier_ID <> l_invoice.Supplier_ID THEN
2260: l_supplier_merge_flag := 'Y';
2261: ELSE l_supplier_merge_flag := 'N';
2262: END IF;

Line 2259: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Supplier_ID <> l_invoice.Supplier_ID THEN

2255: --Check if there has been a supplier merge.
2256: INSERT_DELETED_REC(l_invoice.Invoice_ID, NULL);
2257: If g_invoice_b_marker IS NOT NULL
2258: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Invoice_ID = l_invoice.Invoice_ID
2259: AND FII_AP_Invoice_B_MS(g_invoice_b_marker).Supplier_ID <> l_invoice.Supplier_ID THEN
2260: l_supplier_merge_flag := 'Y';
2261: ELSE l_supplier_merge_flag := 'N';
2262: END IF;
2263:

Line 3928: ---------------- BEGIN INSERTING INTO FII_AP_INVOICE_B Memory Structures --------------

3924: end if;
3925: l_prepay_applied_marker := FII_AP_Prepay_Applied_MS.Next(l_prepay_applied_marker);
3926: END LOOP;
3927:
3928: ---------------- BEGIN INSERTING INTO FII_AP_INVOICE_B Memory Structures --------------
3929: g_state := 'Inserting invoice for Invoice ' || l_invoice.Invoice_ID || '.';
3930: IF l_invoice.Invoice_B_Flag = 'Y' THEN
3931: l_timestamp3_tmp := DBMS_UTILITY.Get_Time;
3932:

Line 3995: ---------------- END INSERTING INTO FII_AP_INVOICE_B Memory Structures --------------

3991: l_timestamp3_tmp := DBMS_UTILITY.Get_Time - l_timestamp3_tmp;
3992: l_timestamp3 := l_timestamp3 + l_timestamp3_tmp;
3993:
3994: END IF; --IF l_invoice.Invoice_B_Flag = 'Y' THEN
3995: ---------------- END INSERTING INTO FII_AP_INVOICE_B Memory Structures --------------
3996:
3997: ----------------- BEGIN INSERTING INTO FII_AP_AGING_BKTS_B_MS AND FII_AP_DUE_COUNTS_B ------------------
3998:
3999: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;

Line 4148: FII_UTIL.put_line('The time taken to populate the memory structures for FII_AP_Invoice_B is: ' || to_char(l_timestamp3/100) || ' seconds.');

4144:
4145: --Print out time breakdown for each table.
4146: if g_debug_flag = 'Y' then
4147: FII_UTIL.put_line('The time taken to populate the memory structures for FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp2/100) || ' seconds.');
4148: FII_UTIL.put_line('The time taken to populate the memory structures for FII_AP_Invoice_B is: ' || to_char(l_timestamp3/100) || ' seconds.');
4149: FII_UTIL.put_line('The time taken to populate FII_AP_Aging_Bkts_B_MS and FII_AP_Due_Counts_B_MS is: ' || to_char(l_timestamp4/100) || ' seconds.');
4150: end if;
4151:
4152:

Line 4159: --Update, Insert, or Delete Records into FII_AP_Invoice_B.

4155:
4156: --Update, Insert, or Delete Records into FII_AP_Pay_Sched_B.
4157: MAINTAIN_PAY_SCHED_B;
4158:
4159: --Update, Insert, or Delete Records into FII_AP_Invoice_B.
4160: MAINTAIN_INVOICE_B;
4161:
4162:
4163: g_state := 'Updating Supplier_ID in FII_AP_AGING_BKTS_B';

Line 4166: FROM FII_AP_Invoice_B AI

4162:
4163: g_state := 'Updating Supplier_ID in FII_AP_AGING_BKTS_B';
4164: UPDATE FII_AP_AGING_BKTS_B AB
4165: SET Supplier_ID = (SELECT AI.Supplier_ID
4166: FROM FII_AP_Invoice_B AI
4167: WHERE AI.Invoice_ID = AB.Invoice_ID)
4168: WHERE AB.Invoice_ID IN (SELECT Key_Value1_Num
4169: FROM FII_AP_DBI_LOG_T
4170: WHERE Table_Name = 'AP_INVOICES'

Line 4176: FROM FII_AP_Invoice_B AI

4172:
4173: g_state := 'Updating Supplier_ID in FII_AP_DUE_COUNTS_B';
4174: UPDATE FII_AP_DUE_COUNTS_B DC
4175: SET Supplier_ID = (SELECT AI.Supplier_ID
4176: FROM FII_AP_Invoice_B AI
4177: WHERE AI.Invoice_ID = DC.Invoice_ID)
4178: WHERE DC.Invoice_ID IN (SELECT Key_Value1_Num
4179: FROM FII_AP_DBI_LOG_T
4180: WHERE Table_Name = 'AP_INVOICES'