APPS.IEC_RETURNS_UTIL_PVT dependencies on IEC_G_RETURN_ENTRIES

Line 92: insert into IEC_G_RETURN_ENTRIES

88: ,TRUE
89: );
90: END IF;
91:
92: insert into IEC_G_RETURN_ENTRIES
93: ( RETURNS_ID
94: , LIST_ENTRY_ID
95: , LIST_HEADER_ID
96: , SUBSET_ID

Line 115: values ( IEC_G_RETURN_ENTRIES_S.NEXTVAL

111: , CREATION_DATE
112: , LAST_UPDATED_BY
113: , LAST_UPDATE_DATE
114: , LAST_UPDATE_LOGIN )
115: values ( IEC_G_RETURN_ENTRIES_S.NEXTVAL
116: , P_LIST_ENTRY_ID
117: , P_LIST_HEADER_ID
118: , P_SUBSET_ID
119: , P_OUTCOME_ID

Line 182: update IEC_G_RETURN_ENTRIES

178:
179: IF (P_OUTCOME_ID = 37 AND P_RESULT_ID = 11)
180: THEN
181:
182: update IEC_G_RETURN_ENTRIES
183: set OUTCOME_ID = P_OUTCOME_ID
184: , RESULT_ID = P_RESULT_ID
185: , LAST_UPDATE_DATE = sysdate
186: , RECORD_OUT_FLAG = 'N'

Line 192: update IEC_G_RETURN_ENTRIES

188:
189: ELSIF (P_OUTCOME_ID = 31 OR P_OUTCOME_ID = 38)
190: THEN
191:
192: update IEC_G_RETURN_ENTRIES
193: set CALL_START_TIME = to_date(P_CALL_START_TIME, 'YYYY-MM-DD HH24:MI:SS')
194: , CALL_END_TIME = to_date(P_CALL_END_TIME, 'YYYY-MM-DD HH24:MI:SS')
195: , NEXT_CALL_TIME = to_date(P_NEXT_CALL_TIME, 'YYYY-MM-DD HH24:MI:SS')
196: , CALLBACK_FLAG = l_callback_flag

Line 208: update IEC_G_RETURN_ENTRIES

204: , RECORD_OUT_FLAG = 'Y'
205: where RETURNS_ID = P_RETURNS_ID;
206:
207: ELSE
208: update IEC_G_RETURN_ENTRIES
209: set CALL_START_TIME = to_date(P_CALL_START_TIME, 'YYYY-MM-DD HH24:MI:SS')
210: , CALL_END_TIME = to_date(P_CALL_END_TIME, 'YYYY-MM-DD HH24:MI:SS')
211: , NEXT_CALL_TIME = to_date(P_NEXT_CALL_TIME, 'YYYY-MM-DD HH24:MI:SS')
212: , OUTCOME_ID = P_OUTCOME_ID

Line 292: update IEC_G_RETURN_ENTRIES

288:
289: IF (P_OUTCOME_ID = 37 AND P_RESULT_ID = 11)
290: THEN
291:
292: update IEC_G_RETURN_ENTRIES
293: set OUTCOME_ID = P_OUTCOME_ID
294: , RESULT_ID = P_RESULT_ID
295: , LAST_UPDATE_DATE = sysdate
296: , RECORD_OUT_FLAG = 'N'

Line 301: update IEC_G_RETURN_ENTRIES

297: where RETURNS_ID = P_RETURNS_ID;
298:
299: ELSE
300:
301: update IEC_G_RETURN_ENTRIES
302: set CALL_START_TIME = P_CALL_START_TIME
303: , CALL_END_TIME = P_CALL_END_TIME
304: , AGENT_RECYCLE_ACTION = P_AGENT_RECYCLE_ACTION
305: , OUTCOME_ID = P_OUTCOME_ID

Line 353: update IEC_G_RETURN_ENTRIES

349: ,TRUE
350: );
351: END IF;
352:
353: update IEC_G_RETURN_ENTRIES
354: set RECYCLE_FLAG = 'N'
355: , LAST_UPDATED_BY = l_user_id
356: , LAST_UPDATE_DATE = sysdate
357: where LIST_ENTRY_ID = P_LIST_ENTRY_ID