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_TL

Line 637: IBE_UTIL.Debug('Before insert into IBE_MSITES_TL');

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');
638: END IF;
639:
640: insert into IBE_MSITES_TL (
641: MSITE_ID,

Line 640: insert into IBE_MSITES_TL (

636: IF (l_debug = 'Y') THEN
637: IBE_UTIL.Debug('Before insert into IBE_MSITES_TL');
638: END IF;
639:
640: insert into IBE_MSITES_TL (
641: MSITE_ID,
642: LAST_UPDATE_DATE,
643: LAST_UPDATED_BY,
644: CREATION_DATE,

Line 667: from IBE_MSITES_TL T

663: from FND_LANGUAGES L
664: where L.INSTALLED_FLAG in ('I', 'B')
665: and not exists(
666: select NULL
667: from IBE_MSITES_TL T
668: where T.MSITE_ID =l_msite_id
669: and T.LANGUAGE = L.LANGUAGE_CODE);
670: IF (l_debug = 'Y') THEN
671: IBE_UTIL.Debug('After insert into IBE_MSITES_TL');

Line 671: IBE_UTIL.Debug('After insert into IBE_MSITES_TL');

667: from IBE_MSITES_TL T
668: where T.MSITE_ID =l_msite_id
669: and T.LANGUAGE = L.LANGUAGE_CODE);
670: IF (l_debug = 'Y') THEN
671: IBE_UTIL.Debug('After insert into IBE_MSITES_TL');
672: END IF;
673:
674: p_msite_rec.msite_id := l_msite_id;
675: p_msite_rec.object_version_number := 1;

Line 773: IBE_UTIL.Debug('Before updating IBE_MSITES_TL');

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
777: MSITE_NAME = decode( p_msite_rec.Display_name, FND_API.G_MISS_CHAR,

Line 776: UPDATE IBE_MSITES_TL SET

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
777: MSITE_NAME = decode( p_msite_rec.Display_name, FND_API.G_MISS_CHAR,
778: MSITE_NAME, p_msite_rec.Display_name),
779: MSITE_DESCRIPTION = decode( p_msite_rec.description,
780: FND_API.G_MISS_CHAR, MSITE_DESCRIPTION, p_msite_rec.description),

Line 790: IBE_UTIL.Debug('After updating IBE_MSITES_TL');

786: where msite_id = p_msite_rec.msite_id
787: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
788:
789: IF (l_debug = 'Y') THEN
790: IBE_UTIL.Debug('After updating IBE_MSITES_TL');
791: END IF;
792:
793: p_msite_rec.object_version_number :=
794: p_msite_rec.object_version_number + 1;

Line 2272: delete from ibe_msites_tl 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;
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

Line 2640: insert into IBE_MSITES_TL (

2636: X_ENABLE_TRAFFIC_FILTER,
2637: X_REPORTING_STATUS,
2638: X_SITE_TYPE );
2639:
2640: insert into IBE_MSITES_TL (
2641: MSITE_ID,
2642: OBJECT_VERSION_NUMBER,
2643: CREATED_BY,
2644: CREATION_DATE,

Line 2668: from IBE_MSITES_TL T

2664: from FND_LANGUAGES L
2665: where L.INSTALLED_FLAG in ('I', 'B')
2666: and not exists
2667: (select NULL
2668: from IBE_MSITES_TL T
2669: where T.MSITE_ID = X_MSITE_ID
2670: and T.LANGUAGE = L.LANGUAGE_CODE);
2671:
2672: open c;

Line 2780: from IBE_MSITES_TL

2776: cursor c1 is select
2777: MSITE_NAME,
2778: MSITE_DESCRIPTION,
2779: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
2780: from IBE_MSITES_TL
2781: where MSITE_ID = X_MSITE_ID
2782: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
2783: for update of MSITE_ID nowait;
2784: begin

Line 3003: update IBE_MSITES_TL set

2999: if (sql%notfound) then
3000: raise no_data_found;
3001: end if;
3002:
3003: update IBE_MSITES_TL set
3004: MSITE_NAME = X_MSITE_NAME,
3005: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
3006: MSITE_DESCRIPTION = X_MSITE_DESCRIPTION,
3007: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 3027: delete from IBE_MSITES_TL

3023: procedure DELETE_ROW (
3024: X_MSITE_ID in NUMBER
3025: ) IS
3026: begin
3027: delete from IBE_MSITES_TL
3028: where MSITE_ID = X_MSITE_ID;
3029:
3030: if (sql%notfound) then
3031: raise no_data_found;

Line 3060: from ibe_msites_tl

3056: f_luby := fnd_load_util.owner_id(X_OWNER);
3057: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
3058: select LAST_UPDATED_BY, LAST_UPDATE_DATE
3059: into db_luby, db_ludate
3060: from ibe_msites_tl
3061: where msite_id = X_MSITE_ID
3062: and language=userenv('LANG');-- bug #5089259
3063:
3064: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then

Line 3066: update ibe_msites_tl

3062: and language=userenv('LANG');-- bug #5089259
3063:
3064: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE)) then
3065:
3066: update ibe_msites_tl
3067: set language = USERENV('LANG'),
3068: source_lang = USERENV('LANG'),
3069: object_version_number = object_version_number + 1,
3070: msite_name = X_MSITE_NAME,

Line 3267: delete from IBE_MSITES_TL T

3263:
3264: procedure ADD_LANGUAGE
3265: is
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

Line 3274: update IBE_MSITES_TL T set (

3270: from IBE_MSITES_B B
3271: where B.MSITE_ID = T.MSITE_ID
3272: );
3273:
3274: update IBE_MSITES_TL T set (
3275: MSITE_NAME,
3276: MSITE_DESCRIPTION
3277: ) = (select
3278: B.MSITE_NAME,

Line 3280: from IBE_MSITES_TL B

3276: MSITE_DESCRIPTION
3277: ) = (select
3278: B.MSITE_NAME,
3279: B.MSITE_DESCRIPTION
3280: from IBE_MSITES_TL B
3281: where B.MSITE_ID = T.MSITE_ID
3282: and B.LANGUAGE = T.SOURCE_LANG)
3283: where (
3284: T.MSITE_ID,

Line 3289: from IBE_MSITES_TL SUBB, IBE_MSITES_TL SUBT

3285: T.LANGUAGE
3286: ) in (select
3287: SUBT.MSITE_ID,
3288: SUBT.LANGUAGE
3289: from IBE_MSITES_TL SUBB, IBE_MSITES_TL SUBT
3290: where SUBB.MSITE_ID = SUBT.MSITE_ID
3291: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
3292: and (SUBB.MSITE_NAME <> SUBT.MSITE_NAME
3293: or (SUBB.MSITE_NAME is null and SUBT.MSITE_NAME is not null)

Line 3300: insert into IBE_MSITES_TL (

3296: or (SUBB.MSITE_DESCRIPTION is null and SUBT.MSITE_DESCRIPTION is not null)
3297: or (SUBB.MSITE_DESCRIPTION is not null and SUBT.MSITE_DESCRIPTION is null)
3298: ));
3299:
3300: insert into IBE_MSITES_TL (
3301: MSITE_ID,
3302: OBJECT_VERSION_NUMBER,
3303: CREATED_BY,
3304: CREATION_DATE,

Line 3324: from IBE_MSITES_TL B, FND_LANGUAGES L

3320: B.MSITE_NAME,
3321: B.MSITE_DESCRIPTION,
3322: L.LANGUAGE_CODE,
3323: B.SOURCE_LANG
3324: from IBE_MSITES_TL B, FND_LANGUAGES L
3325: where L.INSTALLED_FLAG in ('I', 'B')
3326: and B.LANGUAGE = userenv('LANG')
3327: and not exists
3328: (select NULL

Line 3329: from IBE_MSITES_TL T

3325: where L.INSTALLED_FLAG in ('I', 'B')
3326: and B.LANGUAGE = userenv('LANG')
3327: and not exists
3328: (select NULL
3329: from IBE_MSITES_TL T
3330: where T.MSITE_ID = B.MSITE_ID
3331: and T.LANGUAGE = L.LANGUAGE_CODE);
3332: end ADD_LANGUAGE;
3333: