APPS.BIV_SR_DETAILS_PKG dependencies on BIV_RESOURCE_GROUPS

Line 194: delete from biv_resource_groups;

190: /**End of appsperf fix for bug#5029442**/
191:
192: l_group_id jtf_rs_groups_b.group_id % type;
193: begin
194: delete from biv_resource_groups;
195: open c_parent_groups;
196: loop
197: begin
198: fetch c_parent_groups into l_group_id;

Line 200: insert into biv_resource_groups ( group_id, group_level)

196: loop
197: begin
198: fetch c_parent_groups into l_group_id;
199: if c_parent_groups%notfound then exit; end if;
200: insert into biv_resource_groups ( group_id, group_level)
201: values ( l_group_id, 1);
202: /** Now top level group has been inserted. The query below will insert
203: all the groups at lower hierarchy levels
204: ****************/

Line 206: insert into biv_resource_groups ( group_id, group_level)

202: /** Now top level group has been inserted. The query below will insert
203: all the groups at lower hierarchy levels
204: ****************/
205: -- dbms_output.put_line('Parent Group Id:'|| to_char(l_group_id));
206: insert into biv_resource_groups ( group_id, group_level)
207: select group_id, level+1
208: from jtf_rs_grp_relations
209: where relation_type = 'PARENT_GROUP'
210: start with related_group_id = l_group_id

Line 221: update biv_resource_groups a

217: -- to_char(l_group_id));
218: -- dbms_output.put_line('Error Text:'|| sqlerrm);
219: end;
220: end loop;
221: update biv_resource_groups a
222: set usage = (select usage from jtf_rs_group_usages b
223: where a.group_id = b.group_id
224: and usage in ('METRICS', 'SUPPORT')
225: and rownum = 1);

Line 228: insert into biv_resource_groups ( group_id, group_level, usage)

224: and usage in ('METRICS', 'SUPPORT')
225: and rownum = 1);
226: close c_parent_groups;
227: commit;
228: insert into biv_resource_groups ( group_id, group_level, usage)
229: select a.group_id, 1, b.usage
230: from jtf_rs_groups_b a, jtf_rs_group_usages b
231: where a.group_id = b.group_id
232: and b.usage in ('SUPPORT', 'METRICS')

Line 234: from biv_resource_groups r

230: from jtf_rs_groups_b a, jtf_rs_group_usages b
231: where a.group_id = b.group_id
232: and b.usage in ('SUPPORT', 'METRICS')
233: and not exists ( select 1
234: from biv_resource_groups r
235: where r.group_id = a.group_id
236: or r.group_id = a.group_id
237: );
238:

Line 239: delete from biv_resource_groups

235: where r.group_id = a.group_id
236: or r.group_id = a.group_id
237: );
238:
239: delete from biv_resource_groups
240: where nvl(usage,'XX') not in ('SUPPORT', 'METRICS');
241:
242: end;
243: function get_response_time(p_incident_id number,