APPS.IEC_RECOVER_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 66

  l_update_count NUMBER := 0;

Line: 67

  l_update_list EntryCollection;

Line: 71

  l_update_subset_collection EntryCollection;

Line: 80

  l_update_date DATE;

Line: 119

  SELECT SYSDATE
  INTO   l_update_date
  FROM   DUAL;

Line: 127

  FOR entry_rec IN (SELECT   LIST_ENTRY_ID
                    ,        RETURNS_ID
                    FROM     IEC_G_RETURN_ENTRIES
                    WHERE    LIST_HEADER_ID = P_LIST_ID
                    AND      RECORD_OUT_FLAG = 'Y'
                    AND      DO_NOT_USE_FLAG = 'N'
                    AND      NVL(RECYCLE_FLAG, 'N') = 'N'
                    AND      l_update_date > RECORD_RELEASE_TIME + l_lost_interval
                    ORDER BY LIST_ENTRY_ID)
  LOOP

    l_update_count := l_update_list.COUNT + 1;

Line: 139

    l_update_list(l_update_count) := entry_rec.RETURNS_ID;

Line: 141

    IF l_update_list.COUNT = 500
    THEN

      IF (l_action_id = -1)
      THEN

         SELECT IEC_G_RETURN_ENTRY_ACTION_S.NEXTVAL
         INTO   l_action_id
         FROM   DUAL;

Line: 156

      FORALL j IN 1..L_UPDATE_LIST.COUNT
                UPDATE IEC_G_RETURN_ENTRIES
                SET    RECORD_OUT_FLAG = 'N'
                ,      LAST_UPDATE_DATE = SYSDATE
                ,      LAST_UPDATED_BY = l_user_id
                ,      CHECKIN_ACTION_TYPE = G_RECOVER_ACTION_TYPE
                ,      CHECKIN_ACTION_TIME = SYSDATE
                ,      CHECKIN_ACTION_ID = l_action_id
                WHERE  RETURNS_ID = l_update_list(j);

Line: 166

      l_update_list.DELETE;

Line: 172

    IF l_update_list.COUNT > 0
    THEN

      IF (l_action_id = -1)
      THEN
         SELECT IEC_G_RETURN_ENTRY_ACTION_S.NEXTVAL
         INTO   l_action_id
         FROM   DUAL;

Line: 186

      FORALL j IN 1..L_UPDATE_LIST.COUNT
                UPDATE IEC_G_RETURN_ENTRIES
                SET    RECORD_OUT_FLAG = 'N'
                ,      CHECKIN_ACTION_TYPE = G_RECOVER_ACTION_TYPE
                ,      CHECKIN_ACTION_TIME = SYSDATE
                ,      CHECKIN_ACTION_ID = l_action_id
                ,      LAST_UPDATE_DATE = SYSDATE
                ,      LAST_UPDATED_BY = l_user_id
                WHERE  RETURNS_ID = l_update_list(j);

Line: 196

      l_update_list.DELETE;

Line: 280

  FOR schedule_rec IN (SELECT LIST_HEADER_ID
                       FROM   IEC_G_EXECUTING_LISTS_V
											 WHERE SCHEDULE_ID = P_SCHED_ID)
  LOOP

    RECOVER_LIST_ENTRIES( P_SOURCE_ID
                         , schedule_rec.LIST_HEADER_ID
                         , P_LOST_INTERVAL
                         , l_action_id);