APPS.BIS_RKPI dependencies on AK_REGION_ITEMS

Line 12: h_name AK_REGION_ITEMS.region_code%TYPE;

8: ) RETURN VARCHAR2
9: IS
10: TYPE t_cursor IS REF CURSOR;
11: h_cursor t_cursor;
12: h_name AK_REGION_ITEMS.region_code%TYPE;
13: h_group AK_REGION_ITEMS.region_code%TYPE;
14: h_sql VARCHAR2(32700);
15: h_sn_comb VARCHAR2(32700);
16: BEGIN

Line 13: h_group AK_REGION_ITEMS.region_code%TYPE;

9: IS
10: TYPE t_cursor IS REF CURSOR;
11: h_cursor t_cursor;
12: h_name AK_REGION_ITEMS.region_code%TYPE;
13: h_group AK_REGION_ITEMS.region_code%TYPE;
14: h_sql VARCHAR2(32700);
15: h_sn_comb VARCHAR2(32700);
16: BEGIN
17:

Line 29: ' FROM AK_REGION_ITEMS A'||

25: ' SUBSTR(A.attribute2,'||
26: ' 1,'||
27: ' INSTR(A.attribute2, ''+'') - 1)'||
28: ' AS gr'||
29: ' FROM AK_REGION_ITEMS A'||
30: ' WHERE A.region_code = :1'||
31: ' AND A.item_style <> ''NESTED_REGION'''||
32: ' AND A.attribute1 IN (''DIM LEVEL SINGLE VALUE'', '||
33: '''DIMENSION LEVEL'', ''HIDE DIMENSION LEVEL'', '||

Line 48: ' FROM AK_REGION_ITEMS A'||

44: ' SUBSTR(A.attribute2,'||
45: ' 1,'||
46: ' INSTR(A.attribute2, ''+'') - 1)'||
47: ' AS gr'||
48: ' FROM AK_REGION_ITEMS A'||
49: ' WHERE A.region_code IN '||
50: '(SELECT B.nested_region_code '||
51: 'FROM AK_REGION_ITEMS B '||
52: 'WHERE B.region_code = :2 '||

Line 51: 'FROM AK_REGION_ITEMS B '||

47: ' AS gr'||
48: ' FROM AK_REGION_ITEMS A'||
49: ' WHERE A.region_code IN '||
50: '(SELECT B.nested_region_code '||
51: 'FROM AK_REGION_ITEMS B '||
52: 'WHERE B.region_code = :2 '||
53: 'AND B.ITEM_STYLE = ''NESTED_REGION'')'||
54: ' AND A.attribute1 IN (''DIM LEVEL SINGLE VALUE'', '||
55: '''DIMENSION LEVEL'', ''HIDE DIMENSION LEVEL'', '||

Line 106: h_sn AK_REGION_ITEMS.attribute2%TYPE;

102: -- current shortname position in the list
103: h_start_pos NUMBER;
104: h_end_pos NUMBER;
105: h_strlen NUMBER;
106: h_sn AK_REGION_ITEMS.attribute2%TYPE;
107: h_name BIS_LEVELS_VL.name%TYPE;
108: h_name_comb VARCHAR2(32767);
109:
110: BEGIN

Line 172: h_sn AK_REGION_ITEMS.attribute2%TYPE;

168: h_com_start_pos NUMBER;
169: h_com_end_pos NUMBER;
170: h_com_strlen NUMBER;
171:
172: h_sn AK_REGION_ITEMS.attribute2%TYPE;
173: h_com_sn AK_REGION_ITEMS.attribute2%TYPE;
174:
175: h_sn_comb VARCHAR2(32767);
176:

Line 173: h_com_sn AK_REGION_ITEMS.attribute2%TYPE;

169: h_com_end_pos NUMBER;
170: h_com_strlen NUMBER;
171:
172: h_sn AK_REGION_ITEMS.attribute2%TYPE;
173: h_com_sn AK_REGION_ITEMS.attribute2%TYPE;
174:
175: h_sn_comb VARCHAR2(32767);
176:
177: BEGIN