117: -- buld insert.
118: ----------------------------------------------------------------
119: SELECT SYSDATE
120: INTO l_update_date
121: FROM DUAL;
122:
123: ----------------------------------------------------------------
124: -- this loop returns all of the entries that have been checked
125: -- out of the list for too long.
145: THEN
146:
147: SELECT IEC_G_RETURN_ENTRY_ACTION_S.NEXTVAL
148: INTO l_action_id
149: FROM DUAL;
150:
151: X_ACTION_ID := l_action_id;
152:
153: END IF;
175: IF (l_action_id = -1)
176: THEN
177: SELECT IEC_G_RETURN_ENTRY_ACTION_S.NEXTVAL
178: INTO l_action_id
179: FROM DUAL;
180:
181: X_ACTION_ID := l_action_id;
182:
183: END IF;