APPS.IEC_REPORTS_UTIL_PVT dependencies on IEC_REP_AGENT_CPN_DETAILS

Line 161: -- update iec_rep_agent_cpn_details

157: l_result_count := 1;
158: end if;
159:
160: -- dbms_output.put_line( ' Begin work on Update_agent_cpn_details');
161: -- update iec_rep_agent_cpn_details
162: -- set outcome_id = P_OUTCOME_ID,
163: -- result_id = P_RESULT_ID,
164: -- result_count = nvl( result_count, 0 ) + l_result_count,
165: -- positive_response_flag = P_POSITIVE_RESPONSE_FLAG,

Line 177: insert into iec_rep_agent_cpn_details (

173: -- and ( result_id = P_RESULT_id OR nvl( result_id, 0 ) = 0 );
174:
175: -- if SQL%ROWCOUNT = 0
176: -- then
177: insert into iec_rep_agent_cpn_details (
178: agent_cpn_detail_id,
179: created_by,
180: creation_date,
181: last_updated_by,

Line 208: iec_rep_agent_cpn_details_s.nextval,

204: contact_flag,
205: login_agent_count
206: )
207: values(
208: iec_rep_agent_cpn_details_s.nextval,
209: NVL(FND_GLOBAL.user_id,-1),
210: sysdate,
211: NVL(FND_GLOBAL.conc_login_id,-1),
212: sysdate,

Line 282: Update iec_rep_agent_cpn_details /*+ index(iec_rep_agent_cpn_details iec_rep_agent_cpn_details_N1) */

278: -- Update all rows to '5' first and then set
279: -- the supplied cpn value with the "STATE".
280: -- '5' is state 'OUT' in fnd_lloups with lookup_type = 'BIX_DM_AGENT_STATUS'
281: --
282: Update iec_rep_agent_cpn_details /*+ index(iec_rep_agent_cpn_details iec_rep_agent_cpn_details_N1) */
283: set CURRENT_STATUS = '5'
284: where resource_Id = P_RESOURCE_ID
285: and dial_server_id = P_DIAL_SERVER_ID
286: and campaign_schedule_id <> P_CAMPAIGN_SCHEDULE_ID;

Line 291: Update iec_rep_agent_cpn_details /*+ index(iec_rep_agent_cpn_details iec_rep_agent_cpn_details_N1) */

287:
288: -- This will always exist.
289: if( P_CAMPAIGN_SCHEDULE_ID = -999999 )
290: then
291: Update iec_rep_agent_cpn_details /*+ index(iec_rep_agent_cpn_details iec_rep_agent_cpn_details_N1) */
292: set CURRENT_STATUS = P_CURRENT_STATUS,
293: current_status_begin_time = l_current_status_begin_time
294: where resource_Id = P_RESOURCE_ID
295: and dial_server_id = P_DIAL_SERVER_ID;

Line 297: Update iec_rep_agent_cpn_details /*+ index(iec_rep_agent_cpn_details iec_rep_agent_cpn_details_N1) */

293: current_status_begin_time = l_current_status_begin_time
294: where resource_Id = P_RESOURCE_ID
295: and dial_server_id = P_DIAL_SERVER_ID;
296: else
297: Update iec_rep_agent_cpn_details /*+ index(iec_rep_agent_cpn_details iec_rep_agent_cpn_details_N1) */
298: set CURRENT_STATUS = P_CURRENT_STATUS,
299: current_status_begin_time = l_current_status_begin_time
300: where resource_Id = P_RESOURCE_ID
301: and dial_server_id = P_DIAL_SERVER_ID