APPS.IBE_MSITE_GRP dependencies on IBE_MSITE_LANGUAGES

Line 1020: from ibe_msite_languages

1016: where msite_id = c_msite_id;
1017:
1018: CURSOR c_get_msite_langs_csr(c_msite_id NUMBER) IS
1019: select language_code, enable_flag
1020: from ibe_msite_languages
1021: where msite_id = c_msite_id
1022: order by language_code;
1023:
1024: CURSOR c_get_msite_pricing_csr(c_msite_id NUMBER) IS

Line 1538: SELECT ibe_msite_languages_s1.NEXTVAL

1534: l_exists NUMBER;
1535: default_index NUMBER := 0;
1536:
1537: CURSOR msite_languages_id_seq IS
1538: SELECT ibe_msite_languages_s1.NEXTVAL
1539: FROM DUAL;
1540:
1541: l_msite_languages_id NUMBER;
1542: l_insert_row NUMBER := 0;

Line 1583: DELETE FROM IBE_MSITE_LANGUAGES where

1579:
1580: if p_msite_languages_tbl.count > 0
1581: then
1582:
1583: DELETE FROM IBE_MSITE_LANGUAGES where
1584: msite_id = p_msite_id;
1585:
1586: --- Insert all the rows for the minisite
1587:

Line 1605: INSERT INTO IBE_MSITE_LANGUAGES (

1601: OPEN msite_languages_id_seq;
1602: FETCH msite_languages_id_seq INTO l_msite_languages_id;
1603: CLOSE msite_languages_id_seq;
1604:
1605: INSERT INTO IBE_MSITE_LANGUAGES (
1606: MSITE_LANGUAGE_ID,
1607: OBJECT_VERSION_NUMBER,
1608: LAST_UPDATE_DATE,
1609: LAST_UPDATED_BY,

Line 2267: delete from ibe_msite_languages where msite_id = p_msite_id_tbl(l_index).msite_id;

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