132: where session_id = biv_core_pkg.get_session_id;
133: commit;
134:
135: select attribute_label_long INTO l_total_label
136: from ak_attributes_vl
137: where attribute_code = 'P_SR_SEV_RPT_6'
138: and attribute_application_id = 862;
139:
140: if (g_debug_flag = 'Y') then
291: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_1');
292:
293: -- get "Severity"
294: SELECT attribute_label_long INTO l_label_2
295: FROM ak_attributes_vl
296: WHERE attribute_application_id = 862
297: AND attribute_code = 'P_DASH_SR_VIEW_11';
298:
299: return l_label_2 || ' ' || l_label_1;
310: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_2');
311:
312: -- get "Severity"
313: SELECT attribute_label_long INTO l_label_2
314: FROM ak_attributes_vl
315: WHERE attribute_application_id = 862
316: AND attribute_code = 'P_DASH_SR_VIEW_11';
317:
318: return l_label_2 || ' ' || l_label_1;
329: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_3');
330:
331: -- get "Severity"
332: SELECT attribute_label_long INTO l_label_2
333: FROM ak_attributes_vl
334: WHERE attribute_application_id = 862
335: AND attribute_code = 'P_DASH_SR_VIEW_11';
336:
337: return l_label_2 || ' ' || l_label_1;
348: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_4');
349:
350: -- get "Severity"
351: SELECT attribute_label_long INTO l_label_2
352: FROM ak_attributes_vl
353: WHERE attribute_application_id = 862
354: AND attribute_code = 'P_DASH_SR_VIEW_11';
355:
356: return l_label_2 || ' ' || l_label_1;
367: WHERE a.incident_severity_id = fnd_profile.value('BIV:INC_SEVERITY_5');
368:
369: -- get "Severity"
370: SELECT attribute_label_long INTO l_label_2
371: FROM ak_attributes_vl
372: WHERE attribute_application_id = 862
373: AND attribute_code = 'P_DASH_SR_VIEW_11';
374:
375: return l_label_2 || ' ' || l_label_1;