APPS.OE_OIP_UTIL dependencies on AK_REGION_ITEMS

Line 53: cursor ak_region_items (x_region_name in varchar2) is

49: where REGION_APPLICATION_ID = 660
50: and REGION_CODE = x_region_name
51: and ATTRIBUTE_CODE = x_attribute_code;
52:
53: cursor ak_region_items (x_region_name in varchar2) is
54: select level b,
55: a.region_application_id b2,
56: a.region_code b3,
57: attribute_application_id c1,

Line 59: from ak_region_items a

55: a.region_application_id b2,
56: a.region_code b3,
57: attribute_application_id c1,
58: a.attribute_code c
59: from ak_region_items a
60: where a.region_application_id =660
61: start with a.region_code = x_region_name
62: connect by a.region_code = PRIOR a.nested_region_code
63: order by level desc;

Line 111: print_msg('Start getting AK region_items for '|| p_region_page_1);

107: /*
108: raise error_exception;
109: */
110: end if;
111: print_msg('Start getting AK region_items for '|| p_region_page_1);
112:
113: /* */
114: /* loop thru each region item in a given region */
115: /* */

Line 117: OPEN ak_region_items (p_region_page_1);

113: /* */
114: /* loop thru each region item in a given region */
115: /* */
116:
117: OPEN ak_region_items (p_region_page_1);
118: LOOP
119: FETCH ak_region_items INTO p_level, p_region_appl_id, p_region_code,
120: p_attr_appl_id, p_attribute_code;
121:

Line 119: FETCH ak_region_items INTO p_level, p_region_appl_id, p_region_code,

115: /* */
116:
117: OPEN ak_region_items (p_region_page_1);
118: LOOP
119: FETCH ak_region_items INTO p_level, p_region_appl_id, p_region_code,
120: p_attr_appl_id, p_attribute_code;
121:
122: EXIT WHEN ak_region_items%NOTFOUND;
123:

Line 122: EXIT WHEN ak_region_items%NOTFOUND;

118: LOOP
119: FETCH ak_region_items INTO p_level, p_region_appl_id, p_region_code,
120: p_attr_appl_id, p_attribute_code;
121:
122: EXIT WHEN ak_region_items%NOTFOUND;
123:
124: select count(*)
125: into mycount
126: from AK_REGION_LOV_RELATIONS

Line 192: from AK_REGION_ITEMS

188: print_msg('REGION_ITEM = ' || p_region_code || '.' || p_attribute_code || ' will be deleted');
189:
190: select count(*)
191: into mycount1
192: from AK_REGION_ITEMS
193: where REGION_APPLICATION_ID = 660
194: and REGION_CODE = p_region_code
195: and ATTRIBUTE_CODE = p_attribute_code;
196:

Line 202: /* real code to delete ak region items */

198: print_msg('NO such AK item ' || p_region_code || '.' || p_attribute_code);
199:
200: else
201:
202: /* real code to delete ak region items */
203:
204: AK_REGION_ITEMS_PKG.DELETE_ROW(
205: X_REGION_APPLICATION_ID => p_region_appl_id,
206: X_REGION_CODE => p_region_code,

Line 204: AK_REGION_ITEMS_PKG.DELETE_ROW(

200: else
201:
202: /* real code to delete ak region items */
203:
204: AK_REGION_ITEMS_PKG.DELETE_ROW(
205: X_REGION_APPLICATION_ID => p_region_appl_id,
206: X_REGION_CODE => p_region_code,
207: X_ATTRIBUTE_APPLICATION_ID => p_attr_appl_id,
208: X_ATTRIBUTE_CODE => p_attribute_code);

Line 214: CLOSE ak_region_items;

210:
211: end if;
212: END LOOP;
213: print_msg('#################################################################');
214: CLOSE ak_region_items;
215:
216: print_msg('=================================================================');
217: print_msg('REGION:' || p_region_page_1 || '(' ||
218: p_style_name || ')' || ' will be deleted');