APPS.IEC_REPORTCLEAN_PVT dependencies on IEC_G_CPN_SCHEDULE_RESET_S

Line 27: values (iec_g_cpn_schedule_reset_s.nextval,

23: CREATION_DATE,
24: LAST_UPDATED_BY,
25: LAST_UPDATE_DATE,
26: LAST_UPDATE_LOGIN)
27: values (iec_g_cpn_schedule_reset_s.nextval,
28: P_SCHEDULE_ID,
29: P_RESET_TIME,
30: nvl(FND_GLOBAL.USER_ID,-1),
31: sysdate,

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;

32: nvl(FND_GLOBAL.USER_ID,-1),
33: sysdate,
34: nvl(FND_GLOBAL.CONC_LOGIN_ID,-1));
35: else
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;
37: end if;
38: END;
39:
40: PROCEDURE CLEANUP

Line 48: update iec_g_cpn_schedule_reset set last_update_date = sysdate;

44: delete from iec_rep_cpn_dial_stats;
45: delete from iec_rep_agent_status;
46: delete from iec_rep_campaign_details;
47: delete from iec_rep_agent_cpn_details;
48: update iec_g_cpn_schedule_reset set last_update_date = sysdate;
49: END;
50:
51: END IEC_REPORTCLEAN_PVT;
52: