[Home] [Help]
110: p_ending_backlog number ,
111: p_sr_assigned number ,
112: p_sr_reassigned_to_others number ) is
113: begin
114: update csy_response_resolutions
115: set
116: total_response_time = nvl(total_response_time,0)+
117: nvl(p_response_time,0),
118: total_requests_responded = nvl(total_requests_responded,0)+
149: and owner_group_id = p_owner_group_id
150: and owner_type = p_owner_type
151: and incident_severity_id = p_incident_severity_id;
152: if (sql%notfound) then
153: insert into csy_response_resolutions
154: (summary_date,
155: incident_owner_id,
156: incident_severity_id,
157: owner_group_id,
297: --dbms_output.put_line('To date:'||to_char(p_to_date,'dd-mon-yyyy hh24:mi:ss'));
298: --dbms_output.put_line('End date:'||to_char(l_end_date,'dd-mon-yyyy hh24:mi:ss'));
299: -- These 2 updaes are needed because if backlog is reduced to 0 then c_backlog
300: -- cursor will not return any row and existing value will not be overwritten
301: update csy_response_resolutions
302: set ending_backlog = 0
303: where summary_date between trunc(p_from_date) and trunc(p_to_date);
304: update csy_response_resolutions
305: set beginning_backlog = 0
300: -- cursor will not return any row and existing value will not be overwritten
301: update csy_response_resolutions
302: set ending_backlog = 0
303: where summary_date between trunc(p_from_date) and trunc(p_to_date);
304: update csy_response_resolutions
305: set beginning_backlog = 0
306: where summary_date between trunc(p_from_date+1) and trunc(p_to_date+1);
307: loop
308: if (l_dt > l_end_date ) then exit; end if;
1222: l_incident_owner_id := l_owner_id;
1223: else
1224: l_owner_group_id := l_owner_id;
1225: end if;
1226: update csy_response_resolutions
1227: set total_sr_assigned = nvl(total_sr_assigned,0)+l_sr_in,
1228: total_sr_reassigned_to_others = nvl(total_sr_reassigned_to_others,0)+
1229: l_sr_out
1230: where summary_date = l_dt
1232: and owner_group_id = l_owner_group_id
1233: and owner_type = p_owner_type
1234: and incident_severity_id = l_sev_id;
1235: if (sql%notfound) then
1236: insert into csy_response_resolutions
1237: (summary_date,
1238: incident_owner_id,
1239: incident_severity_id,
1240: total_sr_assigned,
1500: p_to_date in date) is
1501: begin
1502: null;
1503: /* 10/13/2003 Not used
1504: merge into csy_response_resolutions a using (
1505: select trunc(aud.creation_date) summary_date,
1506: aud.group_id group_id ,
1507: incident_severity_id incident_severity_id,
1508: count(distinct aud.incident_id) sr_in,
2027: sum(total_resp_sla_missed ) resp_sla,
2028: sum(total_resl_sla_missed ) resl_sla,
2029: sum(beginning_backlog ) begblog,
2030: sum(ending_backlog ) endblog
2031: from csy_response_resolutions
2032: where summary_date between p_from_date and p_to_date
2033: and owner_type = 'A'
2034: group by owner_group_id,
2035: summary_date,
2035: summary_date,
2036: incident_severity_id;
2037: begin
2038: for l_rec in c_group_data loop
2039: update csy_response_resolutions
2040: set total_response_time = l_rec.resp_time,
2041: total_requests_responded = l_rec.req_resp,
2042: total_wait_on_agent_resp = l_rec.wait_on_agent_resp,
2043: total_wait_on_others_resp = l_rec.wait_on_others_resp,
2057: and owner_type = 'G'
2058: and incident_owner_id = -1
2059: and incident_severity_id = l_rec.incident_severity_id;
2060: if (sql%notfound) then
2061: insert into csy_response_resolutions
2062: (summary_date,
2063: incident_owner_id,
2064: incident_severity_id,
2065: owner_group_id,
2193: select min(creation_date) - 1
2194: into l_min_date
2195: from cs_incidents_audit_b;
2196: */
2197: delete from csy_response_resolutions;
2198: delete from csy_resolution_qlty;
2199: commit;
2200: l_min_date := trunc(sysdate) - 370;
2201: l_ret_val := fnd_profile.save('CS_CSY_LAST_PROGRAM_RUN_DATE',