APPS.IBE_MSITE_GRP dependencies on IBE_MSITE_ORGS

Line 2015: SELECT ibe_msite_orgs_s1.NEXTVAL

2011: l_exists NUMBER;
2012: l_insert_row NUMBER := 0;
2013:
2014: CURSOR msite_oprorg_id_seq IS
2015: SELECT ibe_msite_orgs_s1.NEXTVAL
2016: FROM DUAL;
2017:
2018: l_msite_org_id NUMBER;
2019: default_index NUMBER := 0;

Line 2056: DELETE FROM IBE_MSITE_ORGS where

2052: end if;
2053:
2054: if (p_msite_orgids_tbl.count > 0 ) then
2055: ---- Delete all the entries for the mini-site
2056: DELETE FROM IBE_MSITE_ORGS where
2057: msite_id = p_msite_id;
2058:
2059: --- Insert all the rows for the minisite
2060:

Line 2075: INSERT INTO IBE_MSITE_ORGS (

2071: OPEN msite_oprorg_id_seq;
2072: FETCH msite_oprorg_id_seq INTO l_msite_org_id;
2073: CLOSE msite_oprorg_id_seq;
2074:
2075: INSERT INTO IBE_MSITE_ORGS (
2076: MSITE_ORG_ID,
2077: OBJECT_VERSION_NUMBER,
2078: LAST_UPDATE_DATE,
2079: LAST_UPDATED_BY,

Line 2269: delete from ibe_msite_orgs where msite_id = p_msite_id_tbl(l_index).msite_id;

2265: ibe_physicalmap_grp.delete_msite(p_msite_id_tbl(l_index).msite_id);
2266:
2267: delete from ibe_msite_languages where msite_id = p_msite_id_tbl(l_index).msite_id;
2268: delete from ibe_msite_currencies where msite_id = p_msite_id_tbl(l_index).msite_id;
2269: delete from ibe_msite_orgs where msite_id = p_msite_id_tbl(l_index).msite_id;
2270: delete from ibe_dsp_msite_sct_sects where mini_site_id=p_msite_id_tbl(l_index).msite_id;
2271: delete from ibe_dsp_msite_sct_items where mini_site_id=p_msite_id_tbl(l_index).msite_id;
2272: delete from ibe_msites_tl where msite_id = p_msite_id_tbl(l_index).msite_id;
2273: delete from ibe_msites_b where msite_id = p_msite_id_tbl(l_index).msite_id;