APPS.JTF_MSITE_GRP dependencies on JTF_MSITE_ORGS

Line 1267: SELECT jtf_msite_orgs_s1.NEXTVAL

1263: l_exists NUMBER;
1264: l_insert_row NUMBER := 0;
1265:
1266: CURSOR msite_oprorg_id_seq IS
1267: SELECT jtf_msite_orgs_s1.NEXTVAL
1268: FROM DUAL;
1269:
1270: l_msite_org_id NUMBER;
1271: default_index NUMBER := 0;

Line 1306: DELETE FROM JTF_MSITE_ORGS where

1302: end if;
1303:
1304: if (p_msite_orgids_tbl.count > 0 ) then
1305: ---- Delete all the entries for the mini-site
1306: DELETE FROM JTF_MSITE_ORGS where
1307: msite_id = p_msite_id;
1308:
1309: --- Insert all the rows for the minisite
1310:

Line 1325: INSERT INTO JTF_MSITE_ORGS (

1321: OPEN msite_oprorg_id_seq;
1322: FETCH msite_oprorg_id_seq INTO l_msite_org_id;
1323: CLOSE msite_oprorg_id_seq;
1324:
1325: INSERT INTO JTF_MSITE_ORGS (
1326: MSITE_ORG_ID,
1327: OBJECT_VERSION_NUMBER,
1328: LAST_UPDATE_DATE,
1329: LAST_UPDATED_BY,

Line 1516: delete from jtf_msite_orgs where msite_id = p_msite_id_tbl(l_index).msite_id;

1512: jtf_physicalmap_grp.delete_msite(p_msite_id_tbl(l_index).msite_id);
1513:
1514: delete from jtf_msite_languages where msite_id = p_msite_id_tbl(l_index).msite_id;
1515: delete from jtf_msite_currencies where msite_id = p_msite_id_tbl(l_index).msite_id;
1516: delete from jtf_msite_orgs where msite_id = p_msite_id_tbl(l_index).msite_id;
1517: delete from jtf_dsp_msite_sct_sects where mini_site_id=p_msite_id_tbl(l_index).msite_id;
1518: delete from jtf_dsp_msite_sct_items where mini_site_id=p_msite_id_tbl(l_index).msite_id;
1519: delete from jtf_msites_tl where msite_id = p_msite_id_tbl(l_index).msite_id;
1520: delete from jtf_msites_b where msite_id = p_msite_id_tbl(l_index).msite_id;