DBA Data[Home] [Help]

APPS.IEC_REPORTS_UTIL_PVT dependencies on IEC_REP_AGENT_STATUS

Line 7: -- iec_rep_agent_status

3:
4: -- Sub-Program Unit Declarations
5:
6: -- Update table
7: -- iec_rep_agent_status
8: -- resource_id
9: -- dial_server_id
10: -- campaign_id
11: -- campaign_schedule_id

Line 36: -- update iec_rep_agent_status

32: BEGIN
33: l_start_time := sysdate;
34: -- begin
35: -- dbms_output.put_line( ' Begin work on Update_agent_state');
36: -- update iec_rep_agent_status
37: -- set campaign_schedule_id = P_CPN_SCHEDULE_ID,
38: -- status = P_STATUS,
39: -- status_reason = P_STATUS_REASON,
40: -- status_start_time = to_date(P_START_TIME, 'yyyy-mm-dd HH24:MI:SS')

Line 50: insert into iec_rep_agent_status (

46: -- then
47: if P_START_TIME IS NOT NULL then
48: l_start_time := to_date(P_START_TIME, 'yyyy-mm-dd HH24:MI:SS');
49: end if;
50: insert into iec_rep_agent_status (
51: resource_Id,
52: dial_server_id,
53: campaign_id,
54: campaign_schedule_id,