APPS.IBE_MSITE_GRP dependencies on IBE_MSITE_CURRENCIES

Line 1028: from ibe_msite_currencies m

1024: CURSOR c_get_msite_pricing_csr(c_msite_id NUMBER) IS
1025: select m.currency_code, m.bizpartner_prc_listid,
1026: m.registered_prc_listid, m.walkin_prc_listid,
1027: m.orderable_limit, m.payment_threshold,m.partner_prc_listid
1028: from ibe_msite_currencies m
1029: where m.msite_id = c_msite_id
1030: ORDER BY m.currency_code;
1031:
1032: CURSOR c_get_msite_resp_csr(c_msite_id NUMBER) IS

Line 1746: SELECT ibe_msite_currencies_s1.NEXTVAL

1742: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1743: l_msite_id NUMBER;
1744: l_exists NUMBER;
1745: CURSOR msite_currencies_id_seq IS
1746: SELECT ibe_msite_currencies_s1.NEXTVAL
1747: FROM DUAL;
1748: l_msite_currencies_id NUMBER;
1749: l_payment_threshold NUMBER;
1750: l_insert_row NUMBER := 0;

Line 1783: DELETE FROM IBE_MSITE_CURRENCIES where

1779: raise FND_API.g_exc_error;
1780: end if;
1781: if (p_msite_currencies_tbl.count > 0 ) then
1782: ---- Delete all the entries for the mini-site
1783: DELETE FROM IBE_MSITE_CURRENCIES where
1784: msite_id = p_msite_id;
1785:
1786: --- Insert all the rows for the minisite
1787: for l_index in 1..p_msite_currencies_tbl.count

Line 1860: INSERT INTO IBE_MSITE_CURRENCIES (

1856:
1857: OPEN msite_currencies_id_seq;
1858: FETCH msite_currencies_id_seq INTO l_msite_currencies_id;
1859: CLOSE msite_currencies_id_seq;
1860: INSERT INTO IBE_MSITE_CURRENCIES (
1861: MSITE_CURRENCY_ID,
1862: OBJECT_VERSION_NUMBER,
1863: LAST_UPDATE_DATE,
1864: LAST_UPDATED_BY,

Line 2268: delete from ibe_msite_currencies where msite_id = p_msite_id_tbl(l_index).msite_id;

2264:
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;