APPS.ICX_API_REGION dependencies on DUAL

Line 17: from sys.dual;

13:
14: -- Generate the region id
15: select icx_regions_s.nextval
16: into l_region_id
17: from sys.dual;
18:
19: -- Insert a record into the region table
20: -- For the the parent_id is 0
21: -- and the region is not split

Line 107: select icx_regions_s.nextval into l_new_region_id from sys.dual;

103: if l_region.parent_region_id = MAIN_REGION then
104:
105: if l_region.split_mode = REGION_NOT_SPLIT then
106:
107: select icx_regions_s.nextval into l_new_region_id from sys.dual;
108:
109: insert into icx_regions
110: (
111: region_id,

Line 142: select icx_regions_s.nextval into l_new_region_id from sys.dual;

138: where region_id = p_region_id;
139:
140: end if;
141:
142: select icx_regions_s.nextval into l_new_region_id from sys.dual;
143:
144: insert into icx_regions
145: (
146: region_id,

Line 188: select icx_regions_s.nextval into l_new_region_id from sys.dual;

184: -- Check if the parent region was already split
185: if ( l_parent_region.split_mode = REGION_HORIZONTAL_SPLIT and p_split_mode = REGION_HORIZONTAL_SPLIT )
186: or ( l_parent_region.split_mode = REGION_VERTICAL_SPLIT and p_split_mode = REGION_VERTICAL_SPLIT ) then
187:
188: select icx_regions_s.nextval into l_new_region_id from sys.dual;
189:
190: -- Insert a row into icx_regions for the new region
191: insert into icx_regions
192: (

Line 228: select icx_regions_s.nextval into l_new_region_id from sys.dual;

224: elsif p_split_mode = REGION_HORIZONTAL_SPLIT then
225:
226: if l_region.split_mode = REGION_NOT_SPLIT then
227:
228: select icx_regions_s.nextval into l_new_region_id from sys.dual;
229:
230: insert into icx_regions
231: (
232: region_id,

Line 297: select icx_regions_s.nextval into l_new_region_id from sys.dual;

293:
294:
295: elsif p_split_mode = REGION_VERTICAL_SPLIT then
296:
297: select icx_regions_s.nextval into l_new_region_id from sys.dual;
298:
299: if l_region.split_mode = REGION_NOT_SPLIT then
300: insert into icx_regions
301: (

Line 571: from sys.dual;

567:
568: -- Generate the region id
569: select icx_regions_s.nextval
570: into l_region_id
571: from sys.dual;
572:
573: insert into icx_regions
574: (
575: region_id,

Line 768: select icx_page_plugs_s.nextval into l_plug_id from dual;

764: begin
765:
766: for thisplug in plugs_to_be_copied loop
767:
768: select icx_page_plugs_s.nextval into l_plug_id from dual;
769:
770: insert into ICX_PAGE_PLUGS
771: (PLUG_ID,
772: PAGE_ID,

Line 834: from sys.dual;

830:
831: -- Insert a new record and copy the attributes
832: select icx_regions_s.nextval
833: into l_region_id
834: from sys.dual;
835:
836: insert into icx_regions
837: (
838: region_id,