APPS.IEC_EXECOCS_PVT dependencies on AMS_LIST_ENTRIES

Line 124: -- Function : Refresh entries that have been checked out of AMS_LIST_ENTRIES for longer

120: --
121: -- API name : REFRESH_ENTRIES
122: -- Type : Public
123: -- Pre-reqs : None
124: -- Function : Refresh entries that have been checked out of AMS_LIST_ENTRIES for longer
125: -- than the time sent in as P_STALE_INTERVAL.
126: -- Parameters : P_LOST_INTERVAL IN NUMBER Required
127: -- X_RETURN_CODE OUT VARCHAR2 Required
128: --

Line 149: -- Function : Recover entries that have been checked out of AMS_LIST_ENTRIES for longer

145: --
146: -- API name : RECOVER_ENTRIES
147: -- Type : Public
148: -- Pre-reqs : None
149: -- Function : Recover entries that have been checked out of AMS_LIST_ENTRIES for longer
150: -- than the time sent in as P_LOST_INTERVAL.
151: -- Parameters : P_LOST_INTERVAL IN NUMBER Required
152: -- X_RETURN_CODE OUT VARCHAR2 Required
153: --

Line 542: SELECT /*+ INDEX (AMS_LIST_ENTRIES AMS_LIST_ENTRIES_U1) */ RECORD_OUT_FLAG

538: -- If there exist a cache record with an entryid and listid
539: -- that has the check out flag set to N in the list entries table
540: -- then we can assume that this entry is no longer of any use.
541: BEGIN
542: SELECT /*+ INDEX (AMS_LIST_ENTRIES AMS_LIST_ENTRIES_U1) */ RECORD_OUT_FLAG
543: INTO recordOutFlag
544: FROM AMS_LIST_ENTRIES
545: WHERE LIST_ENTRY_ID = entry_rec.LIST_ENTRY_ID
546: AND LIST_HEADER_ID = LIST_ID;

Line 544: FROM AMS_LIST_ENTRIES

540: -- then we can assume that this entry is no longer of any use.
541: BEGIN
542: SELECT /*+ INDEX (AMS_LIST_ENTRIES AMS_LIST_ENTRIES_U1) */ RECORD_OUT_FLAG
543: INTO recordOutFlag
544: FROM AMS_LIST_ENTRIES
545: WHERE LIST_ENTRY_ID = entry_rec.LIST_ENTRY_ID
546: AND LIST_HEADER_ID = LIST_ID;
547: EXCEPTION
548: -- Fixme add logic to handle if entry does not exist.

Line 594: SELECT /*+ INDEX (AMS_LIST_ENTRIES AMS_LIST_ENTRIES_U1) */ RECORD_OUT_FLAG

590: -- If there exist a cache record with an entryid and listid
591: -- that has the check out flag set to N in the list entries table
592: -- then we can assume that this entry is no longer of any use.
593: BEGIN
594: SELECT /*+ INDEX (AMS_LIST_ENTRIES AMS_LIST_ENTRIES_U1) */ RECORD_OUT_FLAG
595: INTO recordOutFlag
596: FROM AMS_LIST_ENTRIES
597: WHERE LIST_ENTRY_ID = entry_rec.LIST_ENTRY_ID
598: AND LIST_HEADER_ID = LIST_ID;

Line 596: FROM AMS_LIST_ENTRIES

592: -- then we can assume that this entry is no longer of any use.
593: BEGIN
594: SELECT /*+ INDEX (AMS_LIST_ENTRIES AMS_LIST_ENTRIES_U1) */ RECORD_OUT_FLAG
595: INTO recordOutFlag
596: FROM AMS_LIST_ENTRIES
597: WHERE LIST_ENTRY_ID = entry_rec.LIST_ENTRY_ID
598: AND LIST_HEADER_ID = LIST_ID;
599: EXCEPTION
600: -- Fixme add logic to handle if entry does not exist.

Line 685: FROM AMS_LIST_ENTRIES

681: L_LIST_ENTRIES_TAB ListEntryTab;
682:
683: CURSOR entry_cursor(listId NUMBER, lastEntrySeq NUMBER) IS
684: SELECT LIST_ENTRY_ID
685: FROM AMS_LIST_ENTRIES
686: WHERE LIST_HEADER_ID = listId
687: AND LIST_ENTRY_ID > lastEntrySeq
688: AND ROWNUM <= 1000
689: ORDER BY LIST_ENTRY_ID;