APPS.ICX_API_REGION dependencies on ICX_PAGE_PLUGS

Line 136: update icx_page_plugs

132: icx_sec.g_user_id,
133: icx_sec.g_user_id
134: );
135:
136: update icx_page_plugs
137: set region_id = l_new_region_id
138: where region_id = p_region_id;
139:
140: end if;

Line 219: --update icx_page_plugs

215: icx_sec.g_user_id
216: );
217:
218: -- don't want to move plug data from the existing region.
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

Line 257: update icx_page_plugs

253: icx_sec.g_user_id,
254: icx_sec.g_user_id
255: );
256:
257: update icx_page_plugs
258: set region_id = l_new_region_id
259: where region_id = p_region_id;
260:
261: end if;

Line 327: update icx_page_plugs

323: icx_sec.g_user_id,
324: icx_sec.g_user_id
325: );
326:
327: update icx_page_plugs
328: set region_id = l_new_region_id
329: where region_id = p_region_id;
330:
331: end if;

Line 414: delete from icx_page_plugs

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
414: delete from icx_page_plugs
415: where region_id = region_record.region_id;
416: end loop;
417:
418: -- Delete any child regions

Line 423: delete from icx_page_plugs

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
424: where region_id = p_region_id;
425:
426: -- When deleting a region, check if it is the only child of the parent
427: select count(region_id)

Line 471: update icx_page_plugs

467: where region_id = l_parent_region_id;
468:
469: -- if the sibling had any plugs in it then they should
470: -- be transferred to the parent.
471: update icx_page_plugs
472: set region_id = l_parent_region_id
473: where region_id = l_region_sibling_id;
474:
475: else

Line 761: from icx_page_plugs

757:
758: l_plug_id number;
759: cursor plugs_to_be_copied is
760: select *
761: from icx_page_plugs
762: where region_id = p_from_region_id;
763:
764: begin
765:

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 770: insert into ICX_PAGE_PLUGS

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,
773: DISPLAY_SEQUENCE,
774: RESPONSIBILITY_APPLICATION_ID,