APPS.IEC_EXECOCS_PVT dependencies on IEC_G_CACHE_RECORDS

Line 519: FROM IEC_G_CACHE_RECORDS A

515: endTime4 CHAR(5);
516:
517: CURSOR entry_cursor(listId NUMBER, subsetId NUMBER, callbackFlag VARCHAR2) IS
518: SELECT A.LIST_ENTRY_ID, A.CACHE_RECORD_ID
519: FROM IEC_G_CACHE_RECORDS A
520: WHERE A.LIST_HEADER_ID = listId
521: AND A.SUBSET_ID = subsetId
522: AND A.CALLBACK_FLAG = callbackFlag
523: AND A.CACHE_RECORD_ID < (SELECT B.RECORD_CACHE_SEQ

Line 566: FROM IEC_G_CACHE_RECORDS

562: -- entry is no longer of any use.
563: BEGIN
564: SELECT MAX(CACHE_RECORD_ID)
565: INTO maxRecordId
566: FROM IEC_G_CACHE_RECORDS
567: WHERE LIST_HEADER_ID = LIST_ID
568: AND LIST_ENTRY_ID = entry_rec.LIST_ENTRY_ID;
569: EXCEPTION
570: -- Fixme add logic to handle if entry does not exist.

Line 618: FROM IEC_G_CACHE_RECORDS

614: -- entry is no longer of any use.
615: BEGIN
616: SELECT MAX(CACHE_RECORD_ID)
617: INTO maxRecordId
618: FROM IEC_G_CACHE_RECORDS
619: WHERE LIST_HEADER_ID = LIST_ID
620: AND LIST_ENTRY_ID = entry_rec.LIST_ENTRY_ID;
621: EXCEPTION
622: -- Fixme add logic to handle if entry does not exist.

Line 641: DELETE FROM IEC_G_CACHE_RECORDS WHERE CACHE_RECORD_ID = deleteList(j);

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);
642:
643: SELECT TO_CHAR(SYSDATE, 'SSSSS') INTO endTime3 FROM DUAL;
644:
645: COMMIT;