eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_API_REGION dependencies on ICX_REGIONS

Line 10: l_region_id icx_regions.region_id%type;

6: function create_main_region
7: return number
8:
9: is
10: l_region_id icx_regions.region_id%type;
11:
12: begin
13:
14: -- Generate the region id

Line 15: select icx_regions_s.nextval

11:
12: begin
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

Line 22: insert into icx_regions

18:
19: -- Insert a record into the region table
20: -- For the the parent_id is 0
21: -- and the region is not split
22: insert into icx_regions
23: (
24: region_id,
25: parent_region_id,
26: split_mode,

Line 74: l_region icx_regions%rowtype;

70: , p_split_mode in number
71: )
72: is
73:
74: l_region icx_regions%rowtype;
75: l_parent_region icx_regions%rowtype;
76: l_new_region_id number;
77:
78: begin

Line 75: l_parent_region icx_regions%rowtype;

71: )
72: is
73:
74: l_region icx_regions%rowtype;
75: l_parent_region icx_regions%rowtype;
76: l_new_region_id number;
77:
78: begin
79:

Line 84: from icx_regions

80: -- Security Check
81:
82: -- Get the record for the region to be split
83: select * into l_region
84: from icx_regions
85: where region_id = p_region_id;
86:
87: -- If the region is already split in one direction then
88: -- do not change that

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 109: insert into icx_regions

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,
112: parent_region_id,
113: split_mode,

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 144: insert into icx_regions

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,
147: parent_region_id,
148: split_mode,

Line 171: update icx_regions

167: icx_sec.g_user_id,
168: icx_sec.g_user_id
169: );
170:
171: update icx_regions
172: set split_mode = p_split_mode
173: where region_id = l_region.region_id;
174:
175: commit;

Line 181: from icx_regions

177: -- For all other regions
178: else
179:
180: select * into l_parent_region
181: from icx_regions
182: where region_id = l_region.parent_region_id;
183:
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 )

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 190: -- Insert a row into icx_regions for the new region

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: (
193: region_id,
194: parent_region_id,

Line 191: insert into icx_regions

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: (
193: region_id,
194: parent_region_id,
195: split_mode,

Line 223: -- If the parent region was not split then update the flag in icx_regions for the parent

219: --update icx_page_plugs
220: -- set region_id = l_new_region_id
221: -- where region_id = p_region_id;
222:
223: -- If the parent region was not split then update the flag in icx_regions for the parent
224: elsif p_split_mode = REGION_HORIZONTAL_SPLIT then
225:
226: if l_region.split_mode = REGION_NOT_SPLIT then
227:

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 230: insert into icx_regions

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,
233: parent_region_id,
234: split_mode,

Line 263: insert into icx_regions

259: where region_id = p_region_id;
260:
261: end if;
262:
263: insert into icx_regions
264: (
265: region_id,
266: parent_region_id,
267: split_mode,

Line 278: icx_regions_s.nextval,

274: last_update_login
275: )
276: values
277: (
278: icx_regions_s.nextval,
279: p_region_id,
280: REGION_NOT_SPLIT,
281: l_region.portlet_flow,
282: l_region.border,

Line 290: update icx_regions

286: icx_sec.g_user_id,
287: icx_sec.g_user_id
288: );
289:
290: update icx_regions
291: set split_mode = REGION_HORIZONTAL_SPLIT
292: where region_id = p_region_id;
293:
294:

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 300: insert into icx_regions

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: (
302: region_id,
303: parent_region_id,
304: split_mode,

Line 333: insert into icx_regions

329: where region_id = p_region_id;
330:
331: end if;
332:
333: insert into icx_regions
334: (
335: region_id,
336: parent_region_id,
337: split_mode,

Line 348: icx_regions_s.nextval,

344: last_update_login
345: )
346: values
347: (
348: icx_regions_s.nextval,
349: p_region_id,
350: REGION_NOT_SPLIT,
351: l_region.portlet_flow,
352: l_region.border,

Line 360: update icx_regions

356: icx_sec.g_user_id,
357: icx_sec.g_user_id
358: );
359:
360: update icx_regions
361: set split_mode = REGION_VERTICAL_SPLIT
362: where region_id = p_region_id;
363:
364: end if;

Line 401: from icx_regions

397: l_region_sibling_id number := 0;
398:
399: cursor child_regions is
400: select region_id
401: from icx_regions
402: where parent_region_id = p_region_id;
403:
404: begin
405:

Line 409: from icx_regions

405:
406: -- get the parent for the region to be deleted
407: select parent_region_id
408: into l_parent_region_id
409: from icx_regions
410: where region_id = p_region_id;
411:
412: -- Delete plugs, if any, associated with the children of the region being deleted
413: for region_record in child_regions loop

Line 419: delete from icx_regions

415: where region_id = region_record.region_id;
416: end loop;
417:
418: -- Delete any child regions
419: delete from icx_regions
420: where parent_region_id = p_region_id;
421:
422: -- delete plugs for the region to be deleted
423: delete from icx_page_plugs

Line 429: from icx_regions

425:
426: -- When deleting a region, check if it is the only child of the parent
427: select count(region_id)
428: into l_count
429: from icx_regions
430: where parent_region_id = l_parent_region_id;
431:
432: -- If it is the only region
433: if l_count = 1 then

Line 436: delete from icx_regions

432: -- If it is the only region
433: if l_count = 1 then
434:
435: -- Delete the region
436: delete from icx_regions
437: where region_id = p_region_id;
438:
439: -- Update the parent splig flag
440: update icx_regions

Line 440: update icx_regions

436: delete from icx_regions
437: where region_id = p_region_id;
438:
439: -- Update the parent splig flag
440: update icx_regions
441: set split_mode = REGION_NOT_SPLIT
442: where region_id = l_parent_region_id;
443:
444:

Line 454: from icx_regions

450: elsif l_count = 2 then
451:
452: select split_mode, region_id
453: into l_split_mode, l_region_sibling_id
454: from icx_regions
455: where parent_region_id = l_parent_region_id
456: and region_id <> p_region_id;
457:
458: if l_split_mode = REGION_NOT_SPLIT then

Line 461: delete from icx_regions

457:
458: if l_split_mode = REGION_NOT_SPLIT then
459:
460: -- Delete both the regions
461: delete from icx_regions
462: where parent_region_id = l_parent_region_id;
463:
464: -- Update the parent split flag
465: update icx_regions

Line 465: update icx_regions

461: delete from icx_regions
462: where parent_region_id = l_parent_region_id;
463:
464: -- Update the parent split flag
465: update icx_regions
466: set split_mode = REGION_NOT_SPLIT
467: where region_id = l_parent_region_id;
468:
469: -- if the sibling had any plugs in it then they should

Line 477: delete from icx_regions

473: where region_id = l_region_sibling_id;
474:
475: else
476: -- Delete only the region
477: delete from icx_regions
478: where region_id = p_region_id;
479: end if;
480:
481: else

Line 483: delete from icx_regions

479: end if;
480:
481: else
482: -- Delete only the region
483: delete from icx_regions
484: where region_id = p_region_id;
485: end if;
486:
487: commit;

Line 540: from icx_regions

536: l_region.width_restrict,
537: l_region.portlet_flow,
538: l_region.navwidget_id,
539: l_region.border
540: from icx_regions
541: where region_id = p_region_id;
542:
543: return l_region;
544:

Line 560: l_region_id icx_regions.region_id%type;

556: return integer
557:
558: is
559:
560: l_region_id icx_regions.region_id%type;
561:
562: begin
563:
564: -- Security Check

Line 569: select icx_regions_s.nextval

565:
566: -- Validate the record fields
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

Line 573: insert into icx_regions

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,
576: parent_region_id,
577: split_mode,

Line 636: update icx_regions

632: is
633:
634: begin
635:
636: update icx_regions
637: set parent_region_id = p_region.parent_region_id,
638: split_mode = p_region.split_mode,
639: width = p_region.width,
640: height = p_region.height,

Line 676: for x in (select * from icx_regions where parent_region_id = p_region_id) loop

672: begin
673:
674: -- Security Check
675:
676: for x in (select * from icx_regions where parent_region_id = p_region_id) loop
677:
678: l_index := l_index + 1;
679:
680: l_region_list(l_index).region_id := x.region_id;

Line 728: --for x in (select * from icx_regions where region_id = p_page_id )

724: -- 'wwpob_api_region.delete_regions');
725: -- raise REGION_VALIDATION_EXCEPTION;
726: --end if;
727:
728: --for x in (select * from icx_regions where region_id = p_page_id )
729: --loop
730: -- Delete the translations for strings
731: -- l_count := wwnls_api.remove_string(x.title_id, TRUE);
732: --end loop;

Line 735: --delete from icx_regions

731: -- l_count := wwnls_api.remove_string(x.title_id, TRUE);
732: --end loop;
733:
734: -- Delete all regions for a layout
735: --delete from icx_regions
736: --where layout_id = p_layout_id;
737:
738: --commit;
739:

Line 749: -- from icx_regions

745:
746:
747: --procedure get_region_list (p_region_id) is
748: -- select region_id
749: -- from icx_regions
750: -- start with region_id = p_region_id
751: -- connect by prior region_id = parent_region_id;
752:
753: procedure copy_region_plugs (p_from_region_id in number,

Line 818: l_region_id icx_regions.region_id%type;

814: )
815:
816: is
817:
818: l_region_id icx_regions.region_id%type;
819: l_region icx_regions%rowtype;
820:
821: begin
822:

Line 819: l_region icx_regions%rowtype;

815:
816: is
817:
818: l_region_id icx_regions.region_id%type;
819: l_region icx_regions%rowtype;
820:
821: begin
822:
823: -- Security

Line 825: for x in (select * from icx_regions where parent_region_id = p_from_region_id) loop

821: begin
822:
823: -- Security
824:
825: for x in (select * from icx_regions where parent_region_id = p_from_region_id) loop
826:
827: select * into l_region
828: from icx_regions
829: where region_id = p_to_region_id;

Line 828: from icx_regions

824:
825: for x in (select * from icx_regions where parent_region_id = p_from_region_id) loop
826:
827: select * into l_region
828: from icx_regions
829: where region_id = p_to_region_id;
830:
831: -- Insert a new record and copy the attributes
832: select icx_regions_s.nextval

Line 832: select icx_regions_s.nextval

828: from icx_regions
829: where region_id = p_to_region_id;
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

Line 836: insert into icx_regions

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,
839: parent_region_id,
840: split_mode,

Line 938: from icx_regions

934: l_region.width_restrict,
935: l_region.portlet_flow,
936: l_region.navwidget_id,
937: l_region.border
938: from icx_regions
939: where region_id = p_region_id;
940:
941: return l_region;
942: