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 DBMS_UTILITY

Line 1378: l_timestamp1 := DBMS_UTILITY.Get_Time;

1374: if g_debug_flag = 'Y' then
1375: FII_UTIL.put_line(g_state);
1376: end if;
1377:
1378: l_timestamp1 := DBMS_UTILITY.Get_Time;
1379: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1380:
1381: SELECT AI.Org_ID Org_ID,
1382: AI.Vendor_ID Supplier_ID,

Line 1379: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

1375: FII_UTIL.put_line(g_state);
1376: end if;
1377:
1378: l_timestamp1 := DBMS_UTILITY.Get_Time;
1379: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1380:
1381: SELECT AI.Org_ID Org_ID,
1382: AI.Vendor_ID Supplier_ID,
1383: AI.Invoice_ID Invoice_ID,

Line 1444: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

1440: FRATES.Functional_MAU, FRATES.Conversion_Rate, RATES.Prim_Conversion_Rate, RATES.Sec_Conversion_Rate,
1441: ID.Invoice_B_Flag, ID.Pay_Sched_B_Flag
1442: ORDER BY AI.Invoice_ID;
1443:
1444: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1445:
1446:
1447: if g_debug_flag = 'Y' then
1448: FII_UTIL.put_line('The Invoices Memory Structure has been populated with ' || FII_AP_Inv_MS.COUNT || ' Invoices.');

Line 1452: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

1448: FII_UTIL.put_line('The Invoices Memory Structure has been populated with ' || FII_AP_Inv_MS.COUNT || ' Invoices.');
1449: FII_UTIL.put_line('The time taken to populate the Invoices Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1450: end if;
1451:
1452: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1453:
1454: SELECT PS.Invoice_ID Invoice_ID,
1455: PS.Payment_Num Payment_Num,
1456: PS.Due_Date Due_Date,

Line 1473: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

1469: WHERE ID.Invoice_ID = PS.Invoice_ID
1470: AND (ID.Invoice_B_Flag = 'Y' OR ID.Pay_Sched_B_Flag = 'Y')
1471: ORDER BY PS.Invoice_ID, PS.Payment_Num;
1472:
1473: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1474:
1475: if g_debug_flag = 'Y' then
1476: FII_UTIL.put_line('The Payment Schedules Memory Structure has been populated with ' || FII_AP_Pay_Sched_MS.COUNT || ' Payment Schedules.');
1477: FII_UTIL.put_line('The time taken to populate the Payment Schedules Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

Line 1480: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

1476: FII_UTIL.put_line('The Payment Schedules Memory Structure has been populated with ' || FII_AP_Pay_Sched_MS.COUNT || ' Payment Schedules.');
1477: FII_UTIL.put_line('The time taken to populate the Payment Schedules Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1478: end if;
1479:
1480: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1481:
1482: SELECT AIP.Amount Amount,
1483: AIP.Check_ID Check_ID,
1484: AIP.Invoice_ID Invoice_ID,

Line 1507: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

1503: AND (ID.Invoice_B_Flag = 'Y' OR ID.Pay_Sched_B_Flag = 'Y')
1504: AND AC.Void_Date IS NULL
1505: ORDER BY AIP.Invoice_ID, AIP.Payment_Num, AIP.Creation_Date;
1506:
1507: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1508:
1509: if g_debug_flag = 'Y' then
1510: FII_UTIL.put_line('The Invoice Payments Memory Structure has been populated with ' || FII_AP_Inv_Pay_MS.COUNT || ' Invoice Payments.');
1511: FII_UTIL.put_line('The time taken to populate the Invoices Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds .');

Line 1516: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

1512: end if;
1513:
1514:
1515:
1516: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1517:
1518: SELECT /*+ USE_NL (ID, AID) */ AID.Invoice_ID Invoice_ID,
1519: AID.Line_Type_Lookup_Code Line_Type_Lookup_Code,
1520: SUM(AID.Amount) Amount,

Line 1539: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

1535: GROUP BY AID.Invoice_ID, AID.Line_Type_Lookup_Code,
1536: TRUNC(AID.Creation_Date)
1537: ORDER BY AID.Invoice_ID, TRUNC(AID.Creation_Date), AID.Line_Type_Lookup_Code;
1538:
1539: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1540:
1541: if g_debug_flag = 'Y' then
1542: FII_UTIL.put_line('The Withholding/Tax Memory Structure has been populated with ' || FII_AP_WH_Tax_MS.COUNT || ' Withholding/Tax Distributions.');
1543: FII_UTIL.put_line('The time taken to populate the Withholding/Tax Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

Line 1546: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

1542: FII_UTIL.put_line('The Withholding/Tax Memory Structure has been populated with ' || FII_AP_WH_Tax_MS.COUNT || ' Withholding/Tax Distributions.');
1543: FII_UTIL.put_line('The time taken to populate the Withholding/Tax Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1544: end if;
1545:
1546: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1547:
1548: SELECT /*+ ORDERED USE_NL(AC) */
1549: TEMP2.Invoice_ID Invoice_ID,
1550: -1 * SUM(TEMP2.Amount) Amount,

Line 1597: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

1593:
1594: ORDER BY TEMP2.Invoice_ID, TEMP2.Creation_Date, AC.Check_ID;
1595:
1596:
1597: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1598:
1599: if g_debug_flag = 'Y' then
1600: FII_UTIL.put_line('The Prepayments Applied Memory Structure has been populated with ' || FII_AP_Prepay_Applied_MS.COUNT || ' Prepayments Applied .');
1601: FII_UTIL.put_line('The time taken to populate the Prepayments Applied Memory Structure is: ' || to_char(l_timestamp1_tmp/100) || ' seconds .');

Line 1609: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

1605:
1606:
1607:
1608:
1609: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1610:
1611: /* Populate with existing data to compare to new data and reduce MV log.*/
1612: SELECT /*+ ordered index(PSUM, FII_AP_PAY_SCHED_B_N1) */
1613: PSUM.Time_ID, PSUM.Period_Type_ID, PSUM.Action_Date, PSUM.Action,

Line 1658: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

1654: 'PREPAYMENT', 7),
1655: DECODE(PSUM.Inv_Pymt_Flag, NULL, 0, 'N', 1, 'Y', 2, 0),
1656: NVL(PSUM.Unique_ID, 0);
1657:
1658: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1659:
1660: if g_debug_flag = 'Y' then
1661: FII_UTIL.put_line('The Memory Structure FII_AP_Pay_Sched_B_MS has been populated with ' || FII_AP_Pay_Sched_B_MS.COUNT || ' records.');
1662: FII_UTIL.put_line('The time taken to populate FII_AP_Pay_Sched_B_MS is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');

Line 1666: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

1662: FII_UTIL.put_line('The time taken to populate FII_AP_Pay_Sched_B_MS is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1663: end if;
1664:
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,

Line 1688: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

1684: WHERE ID.Invoice_ID = AI.Invoice_ID
1685: AND ID.Invoice_B_Flag = 'Y'
1686: ORDER BY AI.Invoice_ID;
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.');

Line 1696: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;

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;
1697:
1698: if g_debug_flag = 'Y' then
1699: FII_UTIL.put_line('The time taken to populate all Memory Structures is: ' || to_char(l_timestamp1/100) || ' seconds.');
1700: end if;

Line 1721: l_timestamp1 := DBMS_UTILITY.Get_Time;

1717: PROCEDURE POPULATE_TABLES_FROM_MS IS
1718: l_timestamp1 BINARY_INTEGER;
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:

Line 1724: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

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
1728: INSERT INTO FII_AP_Invoice_D_GT VALUES FII_AP_Invoice_D_MS(i);

Line 1731: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

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:
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;

Line 1738: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

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
1742: INSERT INTO FII_AP_Invoice_UI_GT VALUES FII_AP_Invoice_UI_MS(i);

Line 1745: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

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:
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;

Line 1752: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

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;
1753:
1754: IF FII_AP_Pay_Sched_D_MS.Count > 0 THEN
1755: FORALL i IN FII_AP_Pay_Sched_D_MS.First..FII_AP_Pay_Sched_D_MS.Last
1756: INSERT INTO FII_AP_Pay_Sched_D_GT VALUES FII_AP_Pay_Sched_D_MS(i);

Line 1759: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

1755: FORALL i IN FII_AP_Pay_Sched_D_MS.First..FII_AP_Pay_Sched_D_MS.Last
1756: INSERT INTO FII_AP_Pay_Sched_D_GT VALUES FII_AP_Pay_Sched_D_MS(i);
1757: END IF;
1758:
1759: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1760:
1761: if g_debug_flag = 'Y' then
1762: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Pay_Sched_D_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1763: end if;

Line 1766: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

1762: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Pay_Sched_D_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1763: end if;
1764:
1765: g_state := 'Bulk inserting into FII_AP_Pay_Sched_UI_GT from FII_AP_Pay_Sched_UI_MS.';
1766: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1767:
1768: IF FII_AP_Pay_Sched_UI_MS.Count > 0 THEN
1769: FORALL i IN FII_AP_Pay_Sched_UI_MS.First..FII_AP_Pay_Sched_UI_MS.Last
1770: INSERT INTO FII_AP_Pay_Sched_UI_GT VALUES FII_AP_Pay_Sched_UI_MS(i);

Line 1773: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

1769: FORALL i IN FII_AP_Pay_Sched_UI_MS.First..FII_AP_Pay_Sched_UI_MS.Last
1770: INSERT INTO FII_AP_Pay_Sched_UI_GT VALUES FII_AP_Pay_Sched_UI_MS(i);
1771: END IF;
1772:
1773: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1774:
1775: if g_debug_flag = 'Y' then
1776: FII_UTIL.put_line('The time taken to bulk insert records into FII_AP_Pay_Sched_UI_GT is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1777: end if;

Line 1781: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

1777: end if;
1778:
1779:
1780: g_state := 'Bulk inserting into FII_AP_Aging_Bkts_B from FII_AP_Aging_Bkts_B_MS.';
1781: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1782:
1783: IF FII_AP_Aging_Bkts_B_MS.Count > 0 THEN
1784: FORALL i IN FII_AP_Aging_Bkts_B_MS.First..FII_AP_Aging_Bkts_B_MS.Last
1785: INSERT INTO FII_AP_AGING_BKTS_B VALUES FII_AP_Aging_Bkts_B_MS(i);

Line 1788: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

1784: FORALL i IN FII_AP_Aging_Bkts_B_MS.First..FII_AP_Aging_Bkts_B_MS.Last
1785: INSERT INTO FII_AP_AGING_BKTS_B VALUES FII_AP_Aging_Bkts_B_MS(i);
1786: END IF;
1787:
1788: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1789:
1790: if g_debug_flag = 'Y' then
1791: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Aging_Bkts_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1792: end if;

Line 1795: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

1791: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Aging_Bkts_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1792: end if;
1793:
1794: g_state := 'Bulk inserting into FII_AP_Due_Counts_B from FII_AP_Due_Counts_B_MS.';
1795: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1796:
1797: IF FII_AP_Due_Counts_B_MS.Count > 0 THEN
1798: FORALL i IN FII_AP_Due_Counts_B_MS.First..FII_AP_Due_Counts_B_MS.Last
1799: INSERT INTO FII_AP_DUE_COUNTS_B VALUES FII_AP_Due_Counts_B_MS(i);

Line 1802: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

1798: FORALL i IN FII_AP_Due_Counts_B_MS.First..FII_AP_Due_Counts_B_MS.Last
1799: INSERT INTO FII_AP_DUE_COUNTS_B VALUES FII_AP_Due_Counts_B_MS(i);
1800: END IF;
1801:
1802: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1803:
1804: if g_debug_flag = 'Y' then
1805: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Due_Counts_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1806: end if;

Line 1808: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;

1804: if g_debug_flag = 'Y' then
1805: FII_UTIL.put_line('The time taken to bulk insert into FII_AP_Due_Counts_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1806: end if;
1807:
1808: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;
1809: if g_debug_flag = 'Y' then
1810: FII_UTIL.put_line('The time taken to populate all Tables from Memory Structures is: ' || to_char(l_timestamp1/100) || ' seconds.');
1811: end if;
1812:

Line 1838: l_timestamp1 := DBMS_UTILITY.Get_Time;

1834: if g_debug_flag = 'Y' then
1835: FII_UTIL.put_line(g_state);
1836: end if;
1837:
1838: l_timestamp1 := DBMS_UTILITY.Get_Time;
1839: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1840:
1841: DELETE FROM FII_AP_Pay_Sched_B PSUM
1842: WHERE EXISTS

Line 1839: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

1835: FII_UTIL.put_line(g_state);
1836: end if;
1837:
1838: l_timestamp1 := DBMS_UTILITY.Get_Time;
1839: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1840:
1841: DELETE FROM FII_AP_Pay_Sched_B PSUM
1842: WHERE EXISTS
1843: (SELECT 1

Line 1852: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

1848: AND D.Action = PSUM.Action
1849: AND NVL(D.Inv_Pymt_Flag, ' ') = NVL(PSUM.Inv_Pymt_Flag, ' ')
1850: AND NVL(D.Unique_ID, -99) = NVL(PSUM.Unique_ID, -99));
1851:
1852: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1853:
1854: if g_debug_flag = 'Y' then
1855: FII_UTIL.put_line('The time taken to delete records from FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1856: end if;

Line 1863: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

1859: if g_debug_flag = 'Y' then
1860: FII_UTIL.put_line(g_state);
1861: end if;
1862:
1863: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;
1864:
1865: MERGE INTO FII_AP_Pay_Sched_B PSUM
1866: USING FII_AP_Pay_Sched_UI_GT UI
1867: ON (PSUM.Invoice_ID = UI.Invoice_ID

Line 1994: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

1990: UI.Last_Updated_By, UI.Creation_Date, UI.Created_By, UI.Last_Update_Login,
1991: UI.Check_Date, UI.Inv_Pymt_Flag, UI.Unique_ID);
1992:
1993:
1994: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;
1995:
1996: if g_debug_flag = 'Y' then
1997: FII_UTIL.put_line('The time taken to update and insert records in FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1998: end if;

Line 2000: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;

1996: if g_debug_flag = 'Y' then
1997: FII_UTIL.put_line('The time taken to update and insert records in FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp1_tmp/100) || ' seconds.');
1998: end if;
1999:
2000: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;
2001: if g_debug_flag = 'Y' then
2002: FII_UTIL.put_line('The time taken to maintain FII_AP_Pay_Sched_B is: ' || to_char(l_timestamp1/100) || ' seconds.');
2003: end if;
2004:

Line 2031: l_timestamp1 := DBMS_UTILITY.Get_Time;

2027: if g_debug_flag = 'Y' then
2028: FII_UTIL.put_line(g_state);
2029: end if;
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

Line 2032: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

2028: FII_UTIL.put_line(g_state);
2029: end if;
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

Line 2040: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

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:
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;

Line 2051: l_timestamp1_tmp := DBMS_UTILITY.Get_Time;

2047: if g_debug_flag = 'Y' then
2048: FII_UTIL.put_line(g_state);
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)

Line 2118: l_timestamp1_tmp := DBMS_UTILITY.Get_Time - l_timestamp1_tmp;

2114: UI.Payment_Cross_Rate, UI.Fully_Paid_Amount, UI.Fully_Paid_Amount_B,
2115: UI.Prim_Fully_Paid_Amount, UI.Sec_Fully_Paid_Amount);
2116:
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;

Line 2124: l_timestamp1 := DBMS_UTILITY.Get_Time - l_timestamp1;

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
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:

Line 2297: l_timestamp2_tmp := DBMS_UTILITY.Get_Time;

2293: g_state := 'Checking Pay_Sched_B_Flag for Invoice ' || l_invoice.Invoice_ID || ', Payment Number ' || l_pay_sched.Payment_Num || '.';
2294:
2295: IF l_invoice.Pay_Sched_B_Flag = 'Y' OR l_supplier_merge_flag = 'Y' THEN
2296:
2297: l_timestamp2_tmp := DBMS_UTILITY.Get_Time;
2298:
2299: g_state := 'Checking if multiple payment schedules exist for Invoice ' || l_invoice.Invoice_ID || ', Payment Number ' || l_pay_sched.Payment_Num || '.';
2300:
2301: IF l_inv_has_mult_ps = 'N'

Line 2418: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

2414: l_pay_sched_temp.Number1 := 2;
2415: FII_AP_Pay_Sched_Temp_MS(to_char(l_pay_sched_temp.Action_Date, 'RRRR/MM/DD') || '/3') := l_pay_sched_temp;
2416: END IF;
2417:
2418: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
2419: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
2420:
2421: END IF; --IF l_invoice.Pay_Sched_B_Flag = 'Y' ...
2422:

Line 2436: l_timestamp2_tmp := DBMS_UTILITY.Get_Time;

2432:
2433:
2434: IF l_invoice.Pay_Sched_B_Flag = 'Y' OR l_supplier_merge_flag = 'Y' THEN
2435:
2436: l_timestamp2_tmp := DBMS_UTILITY.Get_Time;
2437:
2438: IF l_invoice.Cancel_Date IS NULL THEN
2439: IF l_invoice.Invoice_Type = 'PREPAYMENT' THEN
2440: l_pay_sched_temp.Action := 'PREPAYMENT';

Line 2454: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

2450: l_pay_sched_temp.String1 := l_inv_pay.Processing_Type;
2451: FII_AP_Pay_Sched_Temp_MS(to_char(l_pay_sched_temp.Action_Date, 'RRRR/MM/DD') || '/5/' || l_inv_pay.Invoice_Payment_ID) := l_pay_sched_temp;
2452: END IF;
2453:
2454: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
2455: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
2456:
2457: END IF; --IF l_invoice.Pay_Sched_B_Flag = 'Y' ...
2458:

Line 2484: l_timestamp2_tmp := DBMS_UTILITY.Get_Time;

2480: g_state := 'Inserting withholding/tax record into FII_AP_Pay_Sched_Temp_MS for Invoice ' || l_invoice.Invoice_ID || ', Payment Number ' || l_pay_sched.Payment_Num || ', Invoice Distribution ' || l_wh_tax.Invoice_Distribution_ID || '.';
2481:
2482: IF l_invoice.Pay_Sched_B_Flag = 'Y' OR l_supplier_merge_flag = 'Y' THEN
2483:
2484: l_timestamp2_tmp := DBMS_UTILITY.Get_Time;
2485:
2486: IF --l_invoice.Invoice_Type <> 'PREPAYMENT' AND
2487: l_invoice.Cancel_Date IS NULL THEN
2488: IF l_wh_tax.Line_Type_Lookup_Code = 'AWT' THEN

Line 2500: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

2496: END IF;
2497: FII_AP_Pay_Sched_Temp_MS(to_char(l_pay_sched_temp.Action_Date, 'RRRR/MM/DD') || '/4/' || l_wh_tax.Invoice_Distribution_ID) := l_pay_sched_temp;
2498: END IF; --l_invoice.Cancel_Date IS NULL THEN ...
2499:
2500: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
2501: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
2502:
2503: END IF; --IF l_invoice.Pay_Sched_B_Flag = 'Y' ...
2504:

Line 2521: l_timestamp2_tmp := DBMS_UTILITY.Get_Time;

2517:
2518:
2519: IF l_invoice.Pay_Sched_B_Flag = 'Y' OR l_supplier_merge_flag = 'Y' THEN
2520:
2521: l_timestamp2_tmp := DBMS_UTILITY.Get_Time;
2522:
2523: --Loop through FII_AP_Pay_Sched_Temp_MS.
2524: g_state := 'Looping through the temporary memory structure FII_AP_Pay_Sched_Temp_MS for Invoice ' || l_invoice.Invoice_ID || ', Payment Number ' || l_pay_sched.Payment_Num || '.';
2525:

Line 2748: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

2744: ELSE Insert_Pay_Sched_B_Rec(l_pay_sched_b, 'N');
2745: END IF;
2746:
2747: IF l_ps_amount_remaining = 0 THEN
2748: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
2749: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
2750:
2751: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;
2752:

Line 2751: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;

2747: IF l_ps_amount_remaining = 0 THEN
2748: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
2749: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
2750:
2751: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;
2752:
2753: g_state := 'Updating aging buckets memory structure(s) with applied prepayment for Invoice ' || l_invoice.Invoice_ID || ', Payment Number ' || l_pay_sched.Payment_Num || '.';
2754:
2755: IF l_inv_has_mult_ps = 'N' THEN

Line 2821: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;

2817: RAISE;
2818: END;
2819: END IF; --IF l_inv_has_mult_ps = 'N' THEN
2820:
2821: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;
2822: l_timestamp4 := l_timestamp4 + l_timestamp4_tmp;
2823:
2824: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
2825:

Line 2824: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

2820:
2821: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;
2822: l_timestamp4 := l_timestamp4 + l_timestamp4_tmp;
2823:
2824: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
2825:
2826: END IF; --IF l_ps_amount_remaining = 0 THEN
2827: ELSIF l_invoice.Invoice_Type = 'PREPAYMENT' AND l_invoice.Cancel_Date IS NULL THEN
2828: l_ps_amount_remaining := l_ps_amount_remaining + ROUND(-1 * l_prepay_amount / l_invoice.Minimum_Accountable_Unit) * l_invoice.Minimum_Accountable_Unit;

Line 2961: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

2957: Insert_Pay_Sched_B_Rec(l_pay_sched_b, 'Y');
2958: ELSE Insert_Pay_Sched_B_Rec(l_pay_sched_b, 'N');
2959: END IF;
2960:
2961: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
2962: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
2963:
2964: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;
2965:

Line 2964: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;

2960:
2961: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
2962: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
2963:
2964: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;
2965:
2966: g_state := 'Updating aging buckets memory structure(s) with creation record for Invoice ' || l_invoice.Invoice_ID || ', Payment Number ' || l_pay_sched.Payment_Num || '.';
2967: IF l_inv_has_mult_ps = 'N' THEN
2968: l_aging_bkts_b.Time_ID := TO_NUMBER(TO_CHAR(l_pay_sched_b.Action_Date,'J'));

Line 3034: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;

3030: RAISE;
3031: END;
3032: END IF;
3033:
3034: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;
3035: l_timestamp4 := l_timestamp4 + l_timestamp4_tmp;
3036:
3037: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3038:

Line 3037: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

3033:
3034: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;
3035: l_timestamp4 := l_timestamp4 + l_timestamp4_tmp;
3036:
3037: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3038:
3039: l_pay_sched_temp_marker := FII_AP_Pay_Sched_Temp_MS.Next(l_pay_sched_temp_marker);
3040:
3041: ELSIF l_pay_sched_temp.Action = 'DISCOUNT' THEN

Line 3294: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

3290: Insert_Pay_Sched_B_Rec(l_pay_sched_b, 'Y');
3291: ELSE Insert_Pay_Sched_B_Rec(l_pay_sched_b, 'N');
3292: END IF;
3293:
3294: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3295: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
3296:
3297: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;
3298:

Line 3297: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;

3293:
3294: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3295: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
3296:
3297: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;
3298:
3299: g_state := 'Updating aging buckets memory structure(s) with Due Bucket/Due/Past Bucket for Invoice ' || l_invoice.Invoice_ID || ', Payment Number ' || l_pay_sched.Payment_Num || ', Date ' || l_pay_sched_b.Action_Date || '.';
3300:
3301: IF l_inv_has_mult_ps = 'N' THEN

Line 3370: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;

3366: RAISE;
3367: END;
3368: END IF;
3369:
3370: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;
3371: l_timestamp4 := l_timestamp4 + l_timestamp4_tmp;
3372:
3373: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3374:

Line 3373: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

3369:
3370: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;
3371: l_timestamp4 := l_timestamp4 + l_timestamp4_tmp;
3372:
3373: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3374:
3375: END IF; --IF l_ps_amount_remaining > 0
3376: l_pay_sched_temp_marker := FII_AP_Pay_Sched_Temp_MS.Next(l_pay_sched_temp_marker);
3377:

Line 3546: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

3542: END IF;
3543:
3544:
3545: IF l_ps_amount_remaining = 0 THEN
3546: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3547: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
3548:
3549: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;
3550:

Line 3549: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;

3545: IF l_ps_amount_remaining = 0 THEN
3546: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3547: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
3548:
3549: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;
3550:
3551:
3552: g_state := 'Updating aging buckets memory structure(s) with invoice payment for Invoice ' || l_invoice.Invoice_ID || ', Payment Number ' || l_pay_sched.Payment_Num || ', Marker ' || l_pay_sched_temp_marker || '.';
3553: IF l_inv_has_mult_ps = 'N' THEN

Line 3619: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;

3615: RAISE;
3616: END;
3617: END IF; --IF l_inv_has_mult_ps = 'N' THEN
3618:
3619: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;
3620: l_timestamp4 := l_timestamp4 + l_timestamp4_tmp;
3621:
3622: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3623:

Line 3622: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

3618:
3619: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;
3620: l_timestamp4 := l_timestamp4 + l_timestamp4_tmp;
3621:
3622: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3623:
3624: END IF; --IF l_ps_amount_remaining = 0 THEN
3625:
3626: l_pay_sched_temp_marker := FII_AP_Pay_Sched_Temp_MS.Next(l_pay_sched_temp_marker);

Line 3799: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

3795: ELSE Insert_Pay_Sched_B_Rec(l_pay_sched_b, 'N');
3796: END IF;
3797:
3798: IF l_ps_amount_remaining = 0 THEN
3799: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3800: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
3801:
3802: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;
3803:

Line 3802: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;

3798: IF l_ps_amount_remaining = 0 THEN
3799: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3800: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
3801:
3802: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;
3803:
3804: g_state := 'Updating aging buckets memory structure(s) with wh/tax for Invoice ' || l_invoice.Invoice_ID || ', Payment Number ' || l_pay_sched.Payment_Num || ', Marker ' || l_pay_sched_temp_marker || '.';
3805:
3806: IF l_inv_has_mult_ps = 'N' THEN

Line 3872: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;

3868: RAISE;
3869: END;
3870: END IF; --IF l_inv_has_mult_ps = 'N' THEN
3871:
3872: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;
3873: l_timestamp4 := l_timestamp4 + l_timestamp4_tmp;
3874:
3875: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3876:

Line 3875: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

3871:
3872: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;
3873: l_timestamp4 := l_timestamp4 + l_timestamp4_tmp;
3874:
3875: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3876:
3877: END IF; --IF l_ps_amount_remaining = 0 THEN
3878: ELSE --l_invoice.Invoice_Type = 'PREPAYMENT'
3879: l_ps_amount_remaining := l_ps_amount_remaining + ROUND(l_pay_sched_temp.Number1 / l_invoice.Minimum_Accountable_Unit) * l_invoice.Minimum_Accountable_Unit;

Line 3891: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;

3887: END;
3888:
3889: END LOOP; --End of FII_AP_Pay_Sched_Temp_MS Loop.
3890:
3891: l_timestamp2_tmp := DBMS_UTILITY.Get_Time - l_timestamp2_tmp;
3892: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
3893:
3894: ELSIF l_invoice.Pay_Sched_B_Flag = 'N' AND l_invoice.Invoice_B_Flag = 'Y' THEN
3895:

Line 3896: l_timestamp3_tmp := DBMS_UTILITY.Get_Time;

3892: l_timestamp2 := l_timestamp2 + l_timestamp2_tmp;
3893:
3894: ELSIF l_invoice.Pay_Sched_B_Flag = 'N' AND l_invoice.Invoice_B_Flag = 'Y' THEN
3895:
3896: l_timestamp3_tmp := DBMS_UTILITY.Get_Time;
3897:
3898: g_state := 'Invoice has Pay_Sched_B_Flag = ''N'' so advance prepayment applied marker for Invoice ' || l_invoice.Invoice_ID || ', Payment Number ' || l_pay_sched.Payment_Num || '.';
3899: WHILE l_prepay_applied_marker IS NOT NULL
3900: AND FII_AP_Prepay_Applied_MS(l_prepay_applied_marker).Invoice_ID = l_invoice.Invoice_ID LOOP

Line 3909: l_timestamp3_tmp := DBMS_UTILITY.Get_Time - l_timestamp3_tmp;

3905:
3906: l_prepay_applied_marker := FII_AP_Prepay_Applied_MS.Next(l_prepay_applied_marker);
3907: END LOOP;
3908:
3909: l_timestamp3_tmp := DBMS_UTILITY.Get_Time - l_timestamp3_tmp;
3910: l_timestamp3 := l_timestamp3 + l_timestamp3_tmp;
3911:
3912: END IF; --l_invoice.Pay_Sched_B_Flag = 'Y' THEN Loop through FII_AP_Pay_Sched_Temp_MS.
3913:

Line 3931: l_timestamp3_tmp := DBMS_UTILITY.Get_Time;

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:
3933: l_invoice_b.Org_ID := l_invoice.Org_ID;
3934: l_invoice_b.Supplier_ID := l_invoice.Supplier_ID;
3935: l_invoice_b.Invoice_ID := l_invoice.Invoice_ID;

Line 3991: l_timestamp3_tmp := DBMS_UTILITY.Get_Time - l_timestamp3_tmp;

3987: / g_secondary_mau) * g_secondary_mau;
3988:
3989: Insert_Invoice_B_Rec(l_invoice_b);
3990:
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 --------------

Line 3999: l_timestamp4_tmp := DBMS_UTILITY.Get_Time;

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;
4000:
4001: IF (l_invoice.Pay_Sched_B_Flag = 'Y' OR l_supplier_merge_flag = 'Y')
4002: AND l_inv_has_mult_ps = 'Y' THEN
4003:

Line 4135: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;

4131: l_ps_aging_marker := FII_AP_PS_Aging_MS.Next(l_ps_aging_marker);
4132: END LOOP; --End of FII_AP_PS_Aging_MS Loop.
4133: END IF; --IF l_invoice.Pay_Sched_B_Flag = 'Y' THEN
4134:
4135: l_timestamp4_tmp := DBMS_UTILITY.Get_Time - l_timestamp4_tmp;
4136: l_timestamp4 := l_timestamp4 + l_timestamp4_tmp;
4137: ------------------ END INSERTING INTO FII_AP_AGING_BKTS_B_MS AND FII_AP_DUE_COUNTS_B -------------------
4138:
4139: END;