APPS.BIV_RT_ESC_CUS_BLOG_PKG dependencies on AK_ATTRIBUTES_VL

Line 12: from ak_attributes_vl

8: l_check_val number;
9: begin
10:
11: select attribute_label_long into l_label_m
12: from ak_attributes_vl
13: where attribute_application_id = 862
14: and attribute_code='P_DASH_SR_VIEW_11';
15:
16: l_check_val:=fnd_profile.value('BIV:INC_SEVERITY_1') ;

Line 38: from ak_attributes_vl

34: l_label_s varchar2(100);
35: l_check_val number;
36: begin
37: select attribute_label_long into l_label_m1
38: from ak_attributes_vl
39: where attribute_application_id = 862
40: and attribute_code='P_SR_SEV_RPT_5';
41:
42: select attribute_label_long into l_label_m2

Line 43: from ak_attributes_vl

39: where attribute_application_id = 862
40: and attribute_code='P_SR_SEV_RPT_5';
41:
42: select attribute_label_long into l_label_m2
43: from ak_attributes_vl
44: where attribute_application_id = 862
45: and attribute_code='P_SR_SEV_RPT_7';
46:
47:

Line 49: from ak_attributes_vl

45: and attribute_code='P_SR_SEV_RPT_7';
46:
47:
48: select attribute_label_long into l_label_m3
49: from ak_attributes_vl
50: where attribute_application_id = 862
51: and attribute_code='P_DASH_SR_VIEW_9';
52:
53: l_label_m:=l_label_m1||' '||l_label_m3||' '||l_label_m2;

Line 81: from ak_attributes_vl

77: l_label_s varchar2(100);
78: l_check_val number;
79: begin
80: select attribute_label_long into l_label_m1
81: from ak_attributes_vl
82: where attribute_application_id = 862
83: and attribute_code='P_SR_SEV_RPT_5';
84:
85: select attribute_label_long into l_label_m2

Line 86: from ak_attributes_vl

82: where attribute_application_id = 862
83: and attribute_code='P_SR_SEV_RPT_5';
84:
85: select attribute_label_long into l_label_m2
86: from ak_attributes_vl
87: where attribute_application_id = 862
88: and attribute_code='P_SR_SEV_RPT_7';
89:
90:

Line 92: from ak_attributes_vl

88: and attribute_code='P_SR_SEV_RPT_7';
89:
90:
91: select attribute_label_long into l_label_m3
92: from ak_attributes_vl
93: where attribute_application_id = 862
94: and attribute_code='P_DASH_SR_VIEW_9';
95:
96: l_label_m:=l_label_m1||' '||l_label_m3||' '||l_label_m2;

Line 122: from ak_attributes_vl

118: l_label_s varchar2(100);
119: l_check_val number;
120: begin
121: select attribute_label_long into l_label_m1
122: from ak_attributes_vl
123: where attribute_application_id = 862
124: and attribute_code='P_SR_SEV_RPT_5';
125:
126: select attribute_label_long into l_label_m2

Line 127: from ak_attributes_vl

123: where attribute_application_id = 862
124: and attribute_code='P_SR_SEV_RPT_5';
125:
126: select attribute_label_long into l_label_m2
127: from ak_attributes_vl
128: where attribute_application_id = 862
129: and attribute_code='P_SR_SEV_RPT_7';
130:
131:

Line 133: from ak_attributes_vl

129: and attribute_code='P_SR_SEV_RPT_7';
130:
131:
132: select attribute_label_long into l_label_m3
133: from ak_attributes_vl
134: where attribute_application_id = 862
135: and attribute_code='P_DASH_SR_VIEW_9';
136:
137: l_label_m:=l_label_m1||' '||l_label_m3||' '||l_label_m2;