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.JTF_MSITE_GRP dependencies on JTF_MSITES_TL

Line 592: insert into JTF_MSITES_TL (

588: DECODE(p_msite_rec.url,FND_API.G_MISS_CHAR,null,p_msite_rec.url) ,
589: DECODE(p_msite_rec.theme_id,FND_API.G_MISS_NUM,null,
590: p_msite_rec.theme_id));
591: --- Insert into the TL table
592: insert into JTF_MSITES_TL (
593: MSITE_ID,
594: LAST_UPDATE_DATE,
595: LAST_UPDATED_BY,
596: CREATION_DATE,

Line 619: from JTF_MSITES_TL T

615: from FND_LANGUAGES L
616: where L.INSTALLED_FLAG in ('I', 'B')
617: and not exists(
618: select NULL
619: from JTF_MSITES_TL T
620: where T.MSITE_ID =l_msite_id
621: and T.LANGUAGE = L.LANGUAGE_CODE);
622:
623: p_msite_rec.msite_id := l_msite_id;

Line 693: UPDATE JTF_MSITES_TL SET

689: WHERE
690: MSITE_ID = p_msite_rec.msite_id and
691: OBJECT_VERSION_NUMBER = p_msite_rec.object_version_number ;
692:
693: UPDATE JTF_MSITES_TL SET
694: MSITE_NAME = decode( p_msite_rec.Display_name, FND_API.G_MISS_CHAR,
695: MSITE_NAME, p_msite_rec.Display_name),
696: MSITE_DESCRIPTION = decode( p_msite_rec.description,
697: FND_API.G_MISS_CHAR, MSITE_DESCRIPTION, p_msite_rec.description),

Line 1519: delete from jtf_msites_tl 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;
1520: delete from jtf_msites_b where msite_id = p_msite_id_tbl(l_index).msite_id;
1521:
1522: --added for deleting the rows from the newly added Merchant responsibility
1523: --table -- ssridhar

Line 1869: insert into JTF_MSITES_TL (

1865: X_ACCESS_NAME,
1866: X_URL,
1867: X_THEME_ID );
1868:
1869: insert into JTF_MSITES_TL (
1870: SECURITY_GROUP_ID,
1871: MSITE_ID,
1872: OBJECT_VERSION_NUMBER,
1873: CREATED_BY,

Line 1899: from JTF_MSITES_TL T

1895: from FND_LANGUAGES L
1896: where L.INSTALLED_FLAG in ('I', 'B')
1897: and not exists
1898: (select NULL
1899: from JTF_MSITES_TL T
1900: where T.MSITE_ID = X_MSITE_ID
1901: and T.LANGUAGE = L.LANGUAGE_CODE);
1902:
1903: open c;

Line 2003: from JTF_MSITES_TL

1999: cursor c1 is select
2000: MSITE_NAME,
2001: MSITE_DESCRIPTION,
2002: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
2003: from JTF_MSITES_TL
2004: where MSITE_ID = X_MSITE_ID
2005: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
2006: for update of MSITE_ID nowait;
2007: begin

Line 2210: update JTF_MSITES_TL set

2206: if (sql%notfound) then
2207: raise no_data_found;
2208: end if;
2209:
2210: update JTF_MSITES_TL set
2211: MSITE_NAME = X_MSITE_NAME,
2212: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
2213: MSITE_DESCRIPTION = X_MSITE_DESCRIPTION,
2214: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 2234: delete from JTF_MSITES_TL

2230: procedure DELETE_ROW (
2231: X_MSITE_ID in NUMBER
2232: ) IS
2233: begin
2234: delete from JTF_MSITES_TL
2235: where MSITE_ID = X_MSITE_ID;
2236:
2237: if (sql%notfound) then
2238: raise no_data_found;

Line 2258: update jtf_msites_tl

2254: ) IS
2255:
2256: begin
2257:
2258: update jtf_msites_tl
2259: set language = USERENV('LANG'),
2260: source_lang = USERENV('LANG'),
2261: object_version_number = object_version_number + 1,
2262: msite_name = X_MSITE_NAME,

Line 2435: delete from JTF_MSITES_TL T

2431:
2432: procedure ADD_LANGUAGE
2433: is
2434: begin
2435: delete from JTF_MSITES_TL T
2436: where not exists
2437: (select NULL
2438: from JTF_MSITES_B B
2439: where B.MSITE_ID = T.MSITE_ID

Line 2442: update JTF_MSITES_TL T set (

2438: from JTF_MSITES_B B
2439: where B.MSITE_ID = T.MSITE_ID
2440: );
2441:
2442: update JTF_MSITES_TL T set (
2443: MSITE_NAME,
2444: MSITE_DESCRIPTION
2445: ) = (select
2446: B.MSITE_NAME,

Line 2448: from JTF_MSITES_TL B

2444: MSITE_DESCRIPTION
2445: ) = (select
2446: B.MSITE_NAME,
2447: B.MSITE_DESCRIPTION
2448: from JTF_MSITES_TL B
2449: where B.MSITE_ID = T.MSITE_ID
2450: and B.LANGUAGE = T.SOURCE_LANG)
2451: where (
2452: T.MSITE_ID,

Line 2457: from JTF_MSITES_TL SUBB, JTF_MSITES_TL SUBT

2453: T.LANGUAGE
2454: ) in (select
2455: SUBT.MSITE_ID,
2456: SUBT.LANGUAGE
2457: from JTF_MSITES_TL SUBB, JTF_MSITES_TL SUBT
2458: where SUBB.MSITE_ID = SUBT.MSITE_ID
2459: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2460: and (SUBB.MSITE_NAME <> SUBT.MSITE_NAME
2461: or (SUBB.MSITE_NAME is null and SUBT.MSITE_NAME is not null)

Line 2468: insert into JTF_MSITES_TL (

2464: or (SUBB.MSITE_DESCRIPTION is null and SUBT.MSITE_DESCRIPTION is not null)
2465: or (SUBB.MSITE_DESCRIPTION is not null and SUBT.MSITE_DESCRIPTION is null)
2466: ));
2467:
2468: insert into JTF_MSITES_TL (
2469: MSITE_ID,
2470: OBJECT_VERSION_NUMBER,
2471: CREATED_BY,
2472: CREATION_DATE,

Line 2492: from JTF_MSITES_TL B, FND_LANGUAGES L

2488: B.MSITE_NAME,
2489: B.MSITE_DESCRIPTION,
2490: L.LANGUAGE_CODE,
2491: B.SOURCE_LANG
2492: from JTF_MSITES_TL B, FND_LANGUAGES L
2493: where L.INSTALLED_FLAG in ('I', 'B')
2494: and B.LANGUAGE = userenv('LANG')
2495: and not exists
2496: (select NULL

Line 2497: from JTF_MSITES_TL T

2493: where L.INSTALLED_FLAG in ('I', 'B')
2494: and B.LANGUAGE = userenv('LANG')
2495: and not exists
2496: (select NULL
2497: from JTF_MSITES_TL T
2498: where T.MSITE_ID = B.MSITE_ID
2499: and T.LANGUAGE = L.LANGUAGE_CODE);
2500: end ADD_LANGUAGE;
2501: END JTF_Msite_GRP;