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_B

Line 19: from jtf_msites_b a ,

15: IS
16: CURSOR valid_store_msite_cur(p_msite_id IN NUMBER) IS
17: select 1 from dual where exists (
18: select msite_id
19: from jtf_msites_b a ,
20: jtf_stores_b b
21: WHERE a.msite_id = p_msite_id
22: and b.store_id = a.store_id );
23: l_exists NUMBER;

Line 47: from jtf_msites_b

43: IS
44: CURSOR valid_msite_lang_cur(p_msite_id IN NUMBER) IS
45: select 1 from dual where exists (
46: select msite_id
47: from jtf_msites_b
48: where msite_id = p_msite_id
49: and default_language_code is not null );
50:
51: l_exists NUMBER;

Line 75: select msite_id from jtf_msites_b where

71: RETURN BOOLEAN
72: IS
73: CURSOR valid_msite_currency_cur(p_msite_id IN NUMBER) IS
74: select 1 from dual where exists (
75: select msite_id from jtf_msites_b where
76: msite_id = p_msite_id and default_currency_code is not null );
77:
78: l_exists NUMBER;
79: l_return_status Boolean := false;

Line 108: select msite_id from jtf_msites_b where

104: RETURN BOOLEAN
105: IS
106: CURSOR valid_msite_org_cur(p_msite_id IN NUMBER) IS
107: select 1 from dual where exists (
108: select msite_id from jtf_msites_b where
109: msite_id = p_msite_id and default_org_id is not null );
110:
111: l_exists NUMBER;
112: l_return_status Boolean := false;

Line 346: SELECT jtf_msites_b_s1.NEXTVAL

342: l_resp_access_flag VARCHAR2(1);
343: l_party_access_code VARCHAR2(1);
344:
345: CURSOR msite_id_seq IS
346: SELECT jtf_msites_b_s1.NEXTVAL
347: FROM DUAL;
348:
349: CURSOR store_id_cur IS
350: select store_id from jtf_stores_b

Line 355: select msite_id from jtf_msites_b

351: where rownum < 2 ;
352:
353: CURSOR master_msite_any_cur IS
354: select 1 from dual where exists (
355: select msite_id from jtf_msites_b
356: where master_msite_flag = 'Y') ;
357:
358: CURSOR master_msite_cur(p_msite_id IN NUMBER) IS
359: select 1 from dual

Line 362: from jtf_msites_b

358: CURSOR master_msite_cur(p_msite_id IN NUMBER) IS
359: select 1 from dual
360: where exists (
361: select msite_id
362: from jtf_msites_b
363: where master_msite_flag = 'Y'
364: AND msite_id <> p_msite_id);
365:
366: CURSOR yes_no_cur (p_code in varchar2) IS

Line 544: INSERT INTO JTF_MSITES_B (

540: END IF;
541:
542: IF l_operation_type = 'INSERT'
543: THEN
544: INSERT INTO JTF_MSITES_B (
545: MSITE_ID,
546: OBJECT_VERSION_NUMBER,
547: LAST_UPDATE_DATE,
548: LAST_UPDATED_BY,

Line 669: UPDATE JTF_MSITES_B SET

665: THEN
666: p_msite_rec.theme_id := NULL;
667: END IF;
668:
669: UPDATE JTF_MSITES_B SET
670: LAST_UPDATE_DATE = SYSDATE,
671: LAST_UPDATED_BY = FND_GLOBAL.user_id,
672: LAST_UPDATE_LOGIN = FND_GLOBAL.user_id,
673: PROFILE_ID = p_msite_rec.profile_id,

Line 728: -- update JTF_MSITES_B set msite_root_section_id = l_root_section_id ,

724: -- x_msg_data => l_msg_data
725: -- );
726: --
727: -- if l_return_status = FND_API.G_RET_STS_SUCCESS then
728: -- update JTF_MSITES_B set msite_root_section_id = l_root_section_id ,
729: -- store_id = l_store_id
730: -- where msite_id=p_msite_rec.msite_id;
731: -- else
732: -- raise FND_API.g_exc_error;

Line 971: update JTF_MSITES_B SET

967: END IF;
968:
969: If default_index > 0 then
970: --dbms_output.put_line('default is not null');
971: update JTF_MSITES_B SET
972: DEFAULT_LANGUAGE_CODE =
973: p_msite_languages_tbl(default_index).language_code
974: WHERE MSITE_ID = p_msite_id;
975: else

Line 1166: update JTF_MSITES_B SET

1162: end if;
1163: */
1164: END IF;
1165: If default_index > 0 then
1166: update JTF_MSITES_B SET
1167: DEFAULT_CURRENCY_CODE =
1168: p_msite_currencies_tbl(default_index).currency_code
1169: WHERE MSITE_ID = p_msite_id;
1170: --dbms_output.put_line('set default currency');

Line 1368: update JTF_MSITES_B SET

1364: end if;
1365: END IF;
1366:
1367: If default_index > 0 then
1368: update JTF_MSITES_B SET
1369: DEFAULT_ORG_ID = p_msite_orgids_tbl(default_index).orgid where
1370: MSITE_ID = p_msite_id;
1371: else
1372: raise msite_default_org_missing;

Line 1520: delete from jtf_msites_b 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
1524:

Line 1781: cursor C is select ROWID from JTF_MSITES_B

1777: X_ACCESS_NAME in VARCHAR2 ,
1778: X_URL in VARCHAR2 ,
1779: X_THEME_ID in NUMBER)
1780: is
1781: cursor C is select ROWID from JTF_MSITES_B
1782: where MSITE_ID = X_MSITE_ID
1783: ;
1784: begin
1785: insert into JTF_MSITES_B (

Line 1785: insert into JTF_MSITES_B (

1781: cursor C is select ROWID from JTF_MSITES_B
1782: where MSITE_ID = X_MSITE_ID
1783: ;
1784: begin
1785: insert into JTF_MSITES_B (
1786: ATTRIBUTE_CATEGORY,
1787: ATTRIBUTE1,
1788: ATTRIBUTE2,
1789: ATTRIBUTE3,

Line 1994: from JTF_MSITES_B

1990: PARTY_ACCESS_CODE ,
1991: ACCESS_NAME ,
1992: URL ,
1993: THEME_ID
1994: from JTF_MSITES_B
1995: where MSITE_ID = X_MSITE_ID
1996: for update of MSITE_ID nowait;
1997: recinfo c%rowtype;
1998:

Line 2160: update JTF_MSITES_B set

2156: X_URL IN VARCHAR2 ,
2157: X_THEME_ID IN NUMBER )
2158: IS
2159: begin
2160: update JTF_MSITES_B set
2161: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
2162: ATTRIBUTE1 = X_ATTRIBUTE1,
2163: ATTRIBUTE2 = X_ATTRIBUTE2,
2164: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 2241: delete from JTF_MSITES_B

2237: if (sql%notfound) then
2238: raise no_data_found;
2239: end if;
2240:
2241: delete from JTF_MSITES_B
2242: where MSITE_ID = X_MSITE_ID;
2243:
2244: if (sql%notfound) then
2245: raise no_data_found;

Line 2438: from JTF_MSITES_B B

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
2440: );
2441:
2442: update JTF_MSITES_TL T set (