DBA Data[Home] [Help]

APPS.IEC_RECOVER_PVT dependencies on IEC_G_RETURN_ENTRIES

Line 129: FROM IEC_G_RETURN_ENTRIES

125: -- out of the list for too long.
126: ----------------------------------------------------------------
127: FOR entry_rec IN (SELECT LIST_ENTRY_ID
128: , RETURNS_ID
129: FROM IEC_G_RETURN_ENTRIES
130: WHERE LIST_HEADER_ID = P_LIST_ID
131: AND RECORD_OUT_FLAG = 'Y'
132: AND DO_NOT_USE_FLAG = 'N'
133: AND NVL(RECYCLE_FLAG, 'N') = 'N'

Line 157: UPDATE IEC_G_RETURN_ENTRIES

153: END IF;
154:
155: -- might want to get sysdate once and use.
156: FORALL j IN 1..L_UPDATE_LIST.COUNT
157: UPDATE IEC_G_RETURN_ENTRIES
158: SET RECORD_OUT_FLAG = 'N'
159: , LAST_UPDATE_DATE = SYSDATE
160: , LAST_UPDATED_BY = l_user_id
161: , CHECKIN_ACTION_TYPE = G_RECOVER_ACTION_TYPE

Line 187: UPDATE IEC_G_RETURN_ENTRIES

183: END IF;
184:
185: -- might want to get sysdate once and use.
186: FORALL j IN 1..L_UPDATE_LIST.COUNT
187: UPDATE IEC_G_RETURN_ENTRIES
188: SET RECORD_OUT_FLAG = 'N'
189: , CHECKIN_ACTION_TYPE = G_RECOVER_ACTION_TYPE
190: , CHECKIN_ACTION_TIME = SYSDATE
191: , CHECKIN_ACTION_ID = l_action_id