DBA Data[Home] [Help]

APPS.OE_BULK_PRICEORDER_PVT dependencies on V$TIMER

Line 1431: SELECT hsecs INTO l_start_time from v$timer;

1427: If l_debug_level > 0 Then
1428: -- Bug 5640601 =>
1429: -- Selecting hsecs from v$times is changed to execute only when debug
1430: -- is enabled, as hsec is used for logging only when debug is enabled.
1431: SELECT hsecs INTO l_start_time from v$timer;
1432: oe_debug_pub.add('before QP_BULK_PREQ_GRP.Bulk_insert_lines');
1433: end if;
1434: QP_BULK_PREQ_GRP.Bulk_insert_lines(p_header_rec => p_header_rec
1435: , p_line_rec => p_line_rec

Line 1457: SELECT hsecs INTO l_end_time from v$timer;

1453:
1454: -- Bug 5640601 =>
1455: -- Selecting hsecs from v$times is changed to execute only when debug
1456: -- is enabled, as hsec is used for logging only when debug is enabled.
1457: SELECT hsecs INTO l_end_time from v$timer;
1458: end if;
1459:
1460: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Bulk_insert_lines is (sec) '||((l_end_time-l_start_time)/100));
1461:

Line 1508: SELECT hsecs INTO l_start_time from v$timer;

1504: If l_debug_level > 0 Then
1505: -- Bug 5640601 =>
1506: -- Selecting hsecs from v$times is changed to execute only when debug
1507: -- is enabled, as hsec is used for logging only when debug is enabled.
1508: SELECT hsecs INTO l_start_time from v$timer;
1509:
1510: oe_debug_pub.add('before QP_PREQ_PUB.PRICE_REQUEST');
1511: end if;
1512: QP_PREQ_PUB.PRICE_REQUEST

Line 1523: SELECT hsecs INTO l_end_time from v$timer;

1519:
1520: -- Bug 5640601 =>
1521: -- Selecting hsecs from v$times is changed to execute only when debug
1522: -- is enabled, as hsec is used for logging only when debug is enabled.
1523: SELECT hsecs INTO l_end_time from v$timer;
1524: end if;
1525:
1526: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in PRICE_REQUEST is (sec) '||((l_end_time-l_start_time)/100));
1527: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

Line 1542: SELECT hsecs INTO l_start_time from v$timer;

1538:
1539: -- Bug 5640601 =>
1540: -- Selecting hsecs from v$times is changed to execute only when debug
1541: -- is enabled, as hsec is used for logging only when debug is enabled.
1542: SELECT hsecs INTO l_start_time from v$timer;
1543: end if;
1544:
1545: Check_Errors;
1546: IF l_debug_level > 0 Then

Line 1550: SELECT hsecs INTO l_end_time from v$timer;

1546: IF l_debug_level > 0 Then
1547: -- Bug 5640601 =>
1548: -- Selecting hsecs from v$times is changed to execute only when debug
1549: -- is enabled, as hsec is used for logging only when debug is enabled.
1550: SELECT hsecs INTO l_end_time from v$timer;
1551: end if;
1552: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Check_Errors is (sec) '||((l_end_time-l_start_time)/100));
1553:
1554: --Next Upadate memory with the lastest pricing info

Line 1559: SELECT hsecs INTO l_start_time from v$timer;

1555: IF l_debug_level > 0 Then
1556: -- Bug 5640601 =>
1557: -- Selecting hsecs from v$times is changed to execute only when debug
1558: -- is enabled, as hsec is used for logging only when debug is enabled.
1559: SELECT hsecs INTO l_start_time from v$timer;
1560: end if;
1561: Update_Global_Line;
1562: IF l_debug_level > 0 Then
1563: -- Bug 5640601 =>

Line 1566: SELECT hsecs INTO l_end_time from v$timer;

1562: IF l_debug_level > 0 Then
1563: -- Bug 5640601 =>
1564: -- Selecting hsecs from v$times is changed to execute only when debug
1565: -- is enabled, as hsec is used for logging only when debug is enabled.
1566: SELECT hsecs INTO l_end_time from v$timer;
1567: end if;
1568:
1569: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Update_Global_Line is (sec) '||((l_end_time-l_start_time)/100));
1570: check_gsa;

Line 1577: SELECT hsecs INTO l_start_time from v$timer;

1573: IF l_debug_level > 0 Then
1574: -- Bug 5640601 =>
1575: -- Selecting hsecs from v$times is changed to execute only when debug
1576: -- is enabled, as hsec is used for logging only when debug is enabled.
1577: SELECT hsecs INTO l_start_time from v$timer;
1578: end if;
1579: Insert_Adj;
1580: IF l_debug_level > 0 Then
1581: -- Bug 5640601 =>

Line 1584: SELECT hsecs INTO l_end_time from v$timer;

1580: IF l_debug_level > 0 Then
1581: -- Bug 5640601 =>
1582: -- Selecting hsecs from v$times is changed to execute only when debug
1583: -- is enabled, as hsec is used for logging only when debug is enabled.
1584: SELECT hsecs INTO l_end_time from v$timer;
1585: end if;
1586: FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent in Insert_Adj is (sec) '||((l_end_time-l_start_time)/100));
1587:
1588: --Credit checking (will be called from OEBVORDB.pls)