APPS.BIV_SR_DETAILS_PKG dependencies on BIV_SR_SUMMARY

Line 8: from biv_sr_summary;

4: function get_last_run_time return date is
5: l_dt date;
6: begin
7: select max(last_update_date) into l_dt
8: from biv_sr_summary;
9: return nvl(l_dt,sysdate - 3650);
10: exception
11: when others then
12: return sysdate - 365*10;

Line 57: insert into biv_sr_summary(incident_id,

53: begin
54: l_last_prog_run := get_last_run_time;
55: --dbms_output.put_line('Last time program was run on ' ||
56: -- to_char(l_last_prog_run,'dd-mon-yyyy hh24:mi:ss'));
57: insert into biv_sr_summary(incident_id,
58: arrival_time,
59: last_update_date,
60: creation_date,
61: last_updated_by,

Line 75: where not exists ( select 1 from biv_sr_summary sm

71: l_user_id,
72: l_user_id,
73: l_login_id
74: from cs_incidents_all_b sr
75: where not exists ( select 1 from biv_sr_summary sm
76: where sr.incident_id = sm.incident_id)
77: ;
78: --dbms_output.put_line('Number of New incidents inserted in Summary Table :'||
79: -- to_char(sql%rowcount));

Line 96: update biv_sr_summary

92: fetch c_sreqs into l_incident_id, l_incident_date;
93: if c_sreqs % notfound then exit; end if;
94: l_resp_time := get_response_time(l_incident_id, l_incident_date);
95: if (l_resp_time is not null) then
96: update biv_sr_summary
97: set response_time = l_resp_time
98: where incident_id = l_incident_id;
99: end if;
100: end loop;

Line 135: update biv_sr_summary

131: procedure update_reopen_reclose_date(p_incident_id number,
132: p_reopen_date date,
133: p_reclose_date date) as
134: begin
135: update biv_sr_summary
136: set reopen_date = p_reopen_date,
137: reclose_date = p_reclose_date
138: where incident_id = p_incident_id;
139: exception

Line 163: update biv_sr_summary

159: loop
160: fetch c_escalation into l_incident_id, l_esc_level,
161: l_owner_id, l_dt;
162: if c_escalation % notfound then exit; end if;
163: update biv_sr_summary
164: set escalation_level = l_esc_level,
165: esc_owner_id = l_owner_id,
166: escalation_date = l_dt
167: where incident_id = l_incident_id;