eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_MSITE_GRP dependencies on IBE_MSITES_B

Line 20: from ibe_msites_b

16: IS
17: CURSOR valid_msite_lang_cur(p_msite_id IN NUMBER) IS
18: select 1 from dual where exists (
19: select msite_id
20: from ibe_msites_b
21: where msite_id = p_msite_id
22: and default_language_code is not null );
23:
24: l_exists NUMBER;

Line 48: select msite_id from ibe_msites_b where

44: RETURN BOOLEAN
45: IS
46: CURSOR valid_msite_currency_cur(p_msite_id IN NUMBER) IS
47: select 1 from dual where exists (
48: select msite_id from ibe_msites_b where
49: msite_id = p_msite_id and default_currency_code is not null );
50:
51: l_exists NUMBER;
52: l_return_status Boolean := false;

Line 81: select msite_id from ibe_msites_b where

77: RETURN BOOLEAN
78: IS
79: CURSOR valid_msite_org_cur(p_msite_id IN NUMBER) IS
80: select 1 from dual where exists (
81: select msite_id from ibe_msites_b where
82: msite_id = p_msite_id and default_org_id is not null );
83:
84: l_exists NUMBER;
85: l_return_status Boolean := false;

Line 334: SELECT ibe_msites_b_s1.NEXTVAL

330:
331: l_debug VARCHAR2(1);
332:
333: CURSOR msite_id_seq IS
334: SELECT ibe_msites_b_s1.NEXTVAL
335: FROM DUAL;
336:
337: /*CURSOR store_id_cur IS
338: select store_id from ibe_stores_b

Line 343: select msite_id from ibe_msites_b

339: where rownum < 2 ;*/
340:
341: CURSOR master_msite_any_cur IS
342: select 1 from dual where exists (
343: select msite_id from ibe_msites_b
344: where master_msite_flag = 'Y') ;
345:
346: CURSOR master_msite_cur(p_msite_id IN NUMBER) IS
347: select 1 from dual

Line 350: from ibe_msites_b

346: CURSOR master_msite_cur(p_msite_id IN NUMBER) IS
347: select 1 from dual
348: where exists (
349: select msite_id
350: from ibe_msites_b
351: where master_msite_flag = 'Y'
352: AND msite_id <> p_msite_id);
353:
354: CURSOR yes_no_cur (p_code in varchar2) IS

Line 576: IBE_UTIL.Debug('Before insert into IBE_MSITES_B');

572:
573: IF l_operation_type = 'INSERT'
574: THEN
575: IF (l_debug = 'Y') THEN
576: IBE_UTIL.Debug('Before insert into IBE_MSITES_B');
577: END IF;
578: INSERT INTO IBE_MSITES_B (
579: MSITE_ID,
580: OBJECT_VERSION_NUMBER,

Line 578: INSERT INTO IBE_MSITES_B (

574: THEN
575: IF (l_debug = 'Y') THEN
576: IBE_UTIL.Debug('Before insert into IBE_MSITES_B');
577: END IF;
578: INSERT INTO IBE_MSITES_B (
579: MSITE_ID,
580: OBJECT_VERSION_NUMBER,
581: LAST_UPDATE_DATE,
582: LAST_UPDATED_BY,

Line 633: IBE_UTIL.Debug('After insert into IBE_MSITES_B');

629: l_enable_traffic_filter,
630: l_reporting_status,
631: p_msite_rec.site_type);
632: IF (l_debug = 'Y') THEN
633: IBE_UTIL.Debug('After insert into IBE_MSITES_B');
634: END IF;
635: --- Insert into the TL table
636: IF (l_debug = 'Y') THEN
637: IBE_UTIL.Debug('Before insert into IBE_MSITES_TL');

Line 728: FROM ibe_msites_b

724: -- Added by YAXU on -3/27/2002
725: --
726:
727: SELECT msite_root_section_id into l_cur_root_sct_id
728: FROM ibe_msites_b
729: WHERE msite_id = p_msite_rec.msite_id;
730:
731:
732: IF l_cur_root_sct_id = p_msite_rec.msite_root_section_id

Line 739: IBE_UTIL.Debug('Before updating IBE_MSITES_B');

735: END IF;
736:
737:
738: IF (l_debug = 'Y') THEN
739: IBE_UTIL.Debug('Before updating IBE_MSITES_B');
740: END IF;
741:
742: UPDATE IBE_MSITES_B SET
743: LAST_UPDATE_DATE = SYSDATE,

Line 742: UPDATE IBE_MSITES_B SET

738: IF (l_debug = 'Y') THEN
739: IBE_UTIL.Debug('Before updating IBE_MSITES_B');
740: END IF;
741:
742: UPDATE IBE_MSITES_B SET
743: LAST_UPDATE_DATE = SYSDATE,
744: LAST_UPDATED_BY = FND_GLOBAL.user_id,
745: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,
746: PROFILE_ID = p_msite_rec.profile_id,

Line 772: IBE_UTIL.Debug('After updating IBE_MSITES_B');

768: MSITE_ID = p_msite_rec.msite_id and
769: OBJECT_VERSION_NUMBER = p_msite_rec.object_version_number ;
770:
771: IF (l_debug = 'Y') THEN
772: IBE_UTIL.Debug('After updating IBE_MSITES_B');
773: IBE_UTIL.Debug('Before updating IBE_MSITES_TL');
774: END IF;
775:
776: UPDATE IBE_MSITES_TL SET

Line 825: update IBE_MSITES_B set msite_root_section_id = l_root_section_id ,

821: IBE_UTIL.Debug('After calling IBE_DSP_HIERARCHY_SETUP_PVT.' || 'Associate_Root_Sct_To_MSite ');
822: END IF;
823:
824: if l_return_status = FND_API.G_RET_STS_SUCCESS then
825: update IBE_MSITES_B set msite_root_section_id = l_root_section_id ,
826: store_id = l_store_id
827: where msite_id=p_msite_rec.msite_id;
828: else
829: raise FND_API.g_exc_error;

Line 1015: from ibe_msites_b

1011: l_msite_currencies_tbl IBE_MSite_GRP.MSITE_CURRENCIES_TBL_TYPE;
1012:
1013: CURSOR c_get_msite_detail_csr(c_msite_id NUMBER) IS
1014: select party_access_code
1015: from ibe_msites_b
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

Line 1651: update IBE_MSITES_B SET

1647: END IF;
1648:
1649: If default_index > 0 then
1650: --dbms_output.put_line('default is not null');
1651: update IBE_MSITES_B SET
1652: DEFAULT_LANGUAGE_CODE =
1653: p_msite_languages_tbl(default_index).language_code
1654: WHERE MSITE_ID = p_msite_id;
1655: else

Line 1914: update IBE_MSITES_B SET

1910: end if;
1911: */
1912: END IF;
1913: If default_index > 0 then
1914: update IBE_MSITES_B SET
1915: DEFAULT_CURRENCY_CODE =
1916: p_msite_currencies_tbl(default_index).currency_code
1917: WHERE MSITE_ID = p_msite_id;
1918: --dbms_output.put_line('set default currency');

Line 2118: update IBE_MSITES_B SET

2114: end if;*/
2115: END IF;
2116:
2117: If default_index > 0 then
2118: update IBE_MSITES_B SET
2119: DEFAULT_ORG_ID = p_msite_orgids_tbl(default_index).orgid where
2120: MSITE_ID = p_msite_id;
2121: else
2122: raise msite_default_org_missing;

Line 2273: delete from ibe_msites_b 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;
2273: delete from ibe_msites_b where msite_id = p_msite_id_tbl(l_index).msite_id;
2274:
2275: --added for deleting the rows from the newly added Merchant responsibility
2276: --table -- ssridhar
2277:

Line 2543: cursor C is select ROWID from IBE_MSITES_B

2539: X_ENABLE_TRAFFIC_FILTER in VARCHAR2 := 'N',
2540: X_REPORTING_STATUS in VARCHAR2 := 'N',
2541: X_SITE_TYPE in VARCHAR2 := 'I')
2542: is
2543: cursor C is select ROWID from IBE_MSITES_B
2544: where MSITE_ID = X_MSITE_ID
2545: ;
2546: begin
2547: insert into IBE_MSITES_B (

Line 2547: insert into IBE_MSITES_B (

2543: cursor C is select ROWID from IBE_MSITES_B
2544: where MSITE_ID = X_MSITE_ID
2545: ;
2546: begin
2547: insert into IBE_MSITES_B (
2548: ATTRIBUTE_CATEGORY,
2549: ATTRIBUTE1,
2550: ATTRIBUTE2,
2551: ATTRIBUTE3,

Line 2771: from IBE_MSITES_B

2767: DOMAIN_NAME,
2768: ENABLE_TRAFFIC_FILTER,
2769: REPORTING_STATUS,
2770: SITE_TYPE
2771: from IBE_MSITES_B
2772: where MSITE_ID = X_MSITE_ID
2773: for update of MSITE_ID nowait;
2774: recinfo c%rowtype;
2775:

Line 2949: update IBE_MSITES_B set

2945: X_REPORTING_STATUS in VARCHAR2 := 'N',
2946: X_SITE_TYPE in VARCHAR2 := 'I')
2947: IS
2948: begin
2949: update IBE_MSITES_B set
2950: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
2951: ATTRIBUTE1 = X_ATTRIBUTE1,
2952: ATTRIBUTE2 = X_ATTRIBUTE2,
2953: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 3034: delete from IBE_MSITES_B

3030: if (sql%notfound) then
3031: raise no_data_found;
3032: end if;
3033:
3034: delete from IBE_MSITES_B
3035: where MSITE_ID = X_MSITE_ID;
3036:
3037: if (sql%notfound) then
3038: raise no_data_found;

Line 3150: from ibe_msites_b

3146: f_luby := fnd_load_util.owner_id(X_OWNER);
3147: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
3148: select LAST_UPDATED_BY, LAST_UPDATE_DATE
3149: into db_luby, db_ludate
3150: from ibe_msites_b
3151: where MSITE_ID = X_MSITE_ID;
3152:
3153:
3154:

Line 3270: from IBE_MSITES_B B

3266: begin
3267: delete from IBE_MSITES_TL T
3268: where not exists
3269: (select NULL
3270: from IBE_MSITES_B B
3271: where B.MSITE_ID = T.MSITE_ID
3272: );
3273:
3274: update IBE_MSITES_TL T set (