APPS.IEC_EXECOCS_PVT dependencies on DUAL

Line 531: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO startTime1 FROM DUAL;

527: AND B.CALLBACK_FLAG = A.CALLBACK_FLAG);
528: BEGIN
529: X_RETURN_STATUS := 'S';
530:
531: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO startTime1 FROM DUAL;
532: startTime4 := startTime1;
533:
534: -- Remove unnecessary non-callback cache entries.
535: FOR entry_rec IN entry_cursor(LIST_ID, SUBSET_ID, 'Y')

Line 584: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO endTime1 FROM DUAL;

580: END IF;
581:
582: END IF;
583: END LOOP;
584: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO endTime1 FROM DUAL;
585:
586: startTime2 := endTime1;
587:
588: -- Remove unnecessary callback cache entries.

Line 637: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO endTime2 FROM DUAL;

633:
634: END IF;
635: END LOOP;
636:
637: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO endTime2 FROM DUAL;
638: startTime3 := endTime2;
639:
640: FORALL j IN 1..recordCount
641: DELETE FROM IEC_G_CACHE_RECORDS WHERE CACHE_RECORD_ID = deleteList(j);

Line 643: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO endTime3 FROM DUAL;

639:
640: FORALL j IN 1..recordCount
641: DELETE FROM IEC_G_CACHE_RECORDS WHERE CACHE_RECORD_ID = deleteList(j);
642:
643: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO endTime3 FROM DUAL;
644:
645: COMMIT;
646: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO endTime4 FROM DUAL;
647:

Line 646: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO endTime4 FROM DUAL;

642:
643: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO endTime3 FROM DUAL;
644:
645: COMMIT;
646: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO endTime4 FROM DUAL;
647:
648: -- DBMS_OUTPUT.PUT_LINE('Execution Time (secs)');
649: -- DBMS_OUTPUT.PUT_LINE('Number deleted: ' || TO_CHAR(recordCount));
650: -- DBMS_OUTPUT.PUT_LINE('Identifying non-callbacks: ' || TO_CHAR(endTime1 - startTime1));

Line 697: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO startTime1 FROM DUAL;

693: X_RETURN_STATUS := 'S';
694:
695: SAVEPOINT remove_old_entries;
696:
697: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO startTime1 FROM DUAL;
698:
699: WHILE (L_ENTRY_COUNT = 1000)
700: LOOP
701: