APPS.BIV_DASH_BIN_PKG dependencies on AK_ATTRIBUTES_VL

Line 410: from ak_attributes_vl

406: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');
407: BEGIN
408: -- get the first word in the report name
409: select attribute_label_long into l_report_name
410: from ak_attributes_vl
411: where attribute_code = 'P_SR_SEV_RPT_1';
412:
413: -- getting the second word
414: if l_channel = 'WEB' then

Line 416: from ak_attributes_vl

412:
413: -- getting the second word
414: if l_channel = 'WEB' then
415: select attribute_label_long into l_tmp
416: from ak_attributes_vl
417: where attribute_code = 'P_SR_SEV_RPT_3';
418: elsif l_channel = 'PHONE' then
419: select attribute_label_long into l_tmp
420: from ak_attributes_vl

Line 420: from ak_attributes_vl

416: from ak_attributes_vl
417: where attribute_code = 'P_SR_SEV_RPT_3';
418: elsif l_channel = 'PHONE' then
419: select attribute_label_long into l_tmp
420: from ak_attributes_vl
421: where attribute_code = 'P_SR_SEV_RPT_4';
422: else
423: select attribute_label_long into l_tmp
424: from ak_attributes_vl

Line 424: from ak_attributes_vl

420: from ak_attributes_vl
421: where attribute_code = 'P_SR_SEV_RPT_4';
422: else
423: select attribute_label_long into l_tmp
424: from ak_attributes_vl
425: where attribute_code = 'P_SR_SEV_RPT_5';
426: end if;
427: l_report_name := l_report_name || ' ' || l_tmp;
428:

Line 431: from ak_attributes_vl

427: l_report_name := l_report_name || ' ' || l_tmp;
428:
429: -- get the third part
430: select attribute_label_long into l_tmp
431: from ak_attributes_vl
432: where attribute_code = 'P_SR_SEV_RPT_2';
433: l_report_name := l_report_name || ' ' || l_tmp;
434:
435: -- get the last part

Line 456: from ak_attributes_vl

452: l_esc VARCHAR2(30) := biv_core_pkg.get_parameter_value(p_param_str,'P_ESC_LVL');
453: BEGIN
454: -- get the first word in the report name
455: select attribute_label_long into l_label
456: from ak_attributes_vl
457: where attribute_code = 'P_SR_SEV_RPT_6';
458:
459: -- getting the second word
460: if l_channel = 'WEB' then

Line 462: from ak_attributes_vl

458:
459: -- getting the second word
460: if l_channel = 'WEB' then
461: select attribute_label_long into l_tmp
462: from ak_attributes_vl
463: where attribute_code = 'P_SR_SEV_RPT_3';
464: elsif l_channel = 'PHONE' then
465: select attribute_label_long into l_tmp
466: from ak_attributes_vl

Line 466: from ak_attributes_vl

462: from ak_attributes_vl
463: where attribute_code = 'P_SR_SEV_RPT_3';
464: elsif l_channel = 'PHONE' then
465: select attribute_label_long into l_tmp
466: from ak_attributes_vl
467: where attribute_code = 'P_SR_SEV_RPT_4';
468: else
469: select attribute_label_long into l_tmp
470: from ak_attributes_vl

Line 470: from ak_attributes_vl

466: from ak_attributes_vl
467: where attribute_code = 'P_SR_SEV_RPT_4';
468: else
469: select attribute_label_long into l_tmp
470: from ak_attributes_vl
471: where attribute_code = 'P_SR_SEV_RPT_5';
472: end if;
473: l_label := l_label || ' ' || l_tmp;
474:

Line 477: from ak_attributes_vl

473: l_label := l_label || ' ' || l_tmp;
474:
475: -- get the third part
476: select attribute_label_long into l_tmp
477: from ak_attributes_vl
478: where attribute_code = 'P_SR_SEV_RPT_7';
479: l_label := l_label || ' ' || l_tmp;
480:
481: -- get the fourth part

Line 490: from ak_attributes_vl

486: l_label := l_label || ' ' || l_tmp;
487:
488: -- get the last part
489: select attribute_label_long into l_tmp
490: from ak_attributes_vl
491: where attribute_code = 'P_SR_SEV_RPT_8';
492: l_label := l_label || ' ' || l_tmp;
493:
494: return l_label;