APPS.JTF_MSITE_GRP dependencies on JTF_MSITE_CURRENCIES

Line 1065: SELECT jtf_msite_currencies_s1.NEXTVAL

1061: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1062: l_msite_id NUMBER;
1063: l_exists NUMBER;
1064: CURSOR msite_currencies_id_seq IS
1065: SELECT jtf_msite_currencies_s1.NEXTVAL
1066: FROM DUAL;
1067: l_msite_currencies_id NUMBER;
1068: l_insert_row NUMBER := 0;
1069: default_index NUMBER := 0;

Line 1094: DELETE FROM JTF_MSITE_CURRENCIES where

1090: raise FND_API.g_exc_error;
1091: end if;
1092: if (p_msite_currencies_tbl.count > 0 ) then
1093: ---- Delete all the entries for the mini-site
1094: DELETE FROM JTF_MSITE_CURRENCIES where
1095: msite_id = p_msite_id;
1096:
1097: --- Insert all the rows for the minisite
1098: for l_index in 1..p_msite_currencies_tbl.count

Line 1119: INSERT INTO JTF_MSITE_CURRENCIES (

1115:
1116: OPEN msite_currencies_id_seq;
1117: FETCH msite_currencies_id_seq INTO l_msite_currencies_id;
1118: CLOSE msite_currencies_id_seq;
1119: INSERT INTO JTF_MSITE_CURRENCIES (
1120: MSITE_CURRENCY_ID,
1121: OBJECT_VERSION_NUMBER,
1122: LAST_UPDATE_DATE,
1123: LAST_UPDATED_BY,

Line 1515: delete from jtf_msite_currencies where msite_id = p_msite_id_tbl(l_index).msite_id;

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;
1519: delete from jtf_msites_tl where msite_id = p_msite_id_tbl(l_index).msite_id;