APPS.JTF_MSITE_GRP dependencies on JTF_MSITE_LANGUAGES

Line 863: SELECT jtf_msite_languages_s1.NEXTVAL

859: l_exists NUMBER;
860: default_index NUMBER := 0;
861:
862: CURSOR msite_languages_id_seq IS
863: SELECT jtf_msite_languages_s1.NEXTVAL
864: FROM DUAL;
865:
866: l_msite_languages_id NUMBER;
867: l_insert_row NUMBER := 0;

Line 905: DELETE FROM JTF_MSITE_LANGUAGES where

901:
902: if p_msite_languages_tbl.count > 0
903: then
904:
905: DELETE FROM JTF_MSITE_LANGUAGES where
906: msite_id = p_msite_id;
907:
908: --- Insert all the rows for the minisite
909:

Line 927: INSERT INTO JTF_MSITE_LANGUAGES (

923: OPEN msite_languages_id_seq;
924: FETCH msite_languages_id_seq INTO l_msite_languages_id;
925: CLOSE msite_languages_id_seq;
926:
927: INSERT INTO JTF_MSITE_LANGUAGES (
928: MSITE_LANGUAGE_ID,
929: OBJECT_VERSION_NUMBER,
930: LAST_UPDATE_DATE,
931: LAST_UPDATED_BY,

Line 1514: delete from jtf_msite_languages where msite_id = p_msite_id_tbl(l_index).msite_id;

1510: --- end if;
1511:
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;