APPS.OE_OIP_UTIL dependencies on AK_REGIONS

Line 30: from AK_REGIONS

26:
27: cursor ak_region_pages (x_region_page in varchar2,
28: x_region_style in varchar2) is
29: select region_code
30: from AK_REGIONS
31: where REGION_APPLICATION_ID = 660
32: and REGION_CODE = x_region_page
33: and REGION_STYLE =x_region_style;
34:

Line 222: from AK_REGIONS

218: p_style_name || ')' || ' will be deleted');
219:
220: select count(*)
221: into mycount2
222: from AK_REGIONS
223: where REGION_APPLICATION_ID = 660
224: and REGION_CODE = p_region_page_1;
225:
226: if (mycount2 = 0) then

Line 230: AK_REGIONS_PKG.DELETE_ROW(

226: if (mycount2 = 0) then
227: print_msg('NO such AK region ' || p_region_code );
228: else
229: /* real code to delete regions */
230: AK_REGIONS_PKG.DELETE_ROW(
231: X_REGION_APPLICATION_ID =>660,
232: X_REGION_CODE => p_region_page_1);
233: print_msg('REGION:' || p_region_page_1 || '(' ||
234: p_style_name || ')' || ' has be deleted');