APPS.IEC_REPORTCLEAN_PVT SQL Statements

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

Line: 11

  delete from iec_rep_cpn_dial_stats where campaign_schedule_id = P_SCHEDULE_ID;

Line: 12

	delete from iec_rep_agent_status where campaign_schedule_id = P_SCHEDULE_ID;

Line: 13

	delete from iec_rep_campaign_details where campaign_schedule_id = P_SCHEDULE_ID;

Line: 14

	delete from iec_rep_agent_cpn_details where campaign_schedule_id = P_SCHEDULE_ID;

Line: 16

  select count(*) into l_count from iec_g_cpn_schedule_reset where campaign_schedule_id = P_SCHEDULE_ID;

Line: 18

	insert into
				iec_g_cpn_schedule_reset(CPN_SCHEDULE_RESET_ID,
																CAMPAIGN_SCHEDULE_ID,
																LAST_RESET_TIME,
																CREATED_BY,
																CREATION_DATE,
																LAST_UPDATED_BY,
																LAST_UPDATE_DATE,
																LAST_UPDATE_LOGIN)
												values (iec_g_cpn_schedule_reset_s.nextval,
																P_SCHEDULE_ID,
																P_RESET_TIME,
																nvl(FND_GLOBAL.USER_ID,-1),
																sysdate,
																nvl(FND_GLOBAL.USER_ID,-1),
																sysdate,
																nvl(FND_GLOBAL.CONC_LOGIN_ID,-1));

Line: 36

	update iec_g_cpn_schedule_reset set last_reset_time = P_RESET_TIME,last_update_date = sysdate where campaign_schedule_id = P_SCHEDULE_ID;

Line: 44

  delete from iec_rep_cpn_dial_stats;

Line: 45

	delete from iec_rep_agent_status;

Line: 46

	delete from iec_rep_campaign_details;

Line: 47

	delete from iec_rep_agent_cpn_details;

Line: 48

  update iec_g_cpn_schedule_reset set last_update_date = sysdate;