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_IAPP_FAMILIES_PKG dependencies on JTF_IAPP_FAMILIES_B

Line 16: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B

12: X_APP_FAMILY_DISPLAY_NAME in VARCHAR2,
13: X_APP_FAMILY_DESCRIPTION in VARCHAR2,
14: X_OWNER in VARCHAR2
15: ) is
16: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B
17: where APP_FAMILY_ID = X_APP_FAMILY_ID
18: ;
19:
20: cursor C_2 is

Line 21: select JTF_IAPP_FAMILIES_B_S.nextval from SYS.DUAL

17: where APP_FAMILY_ID = X_APP_FAMILY_ID
18: ;
19:
20: cursor C_2 is
21: select JTF_IAPP_FAMILIES_B_S.nextval from SYS.DUAL
22: ;
23:
24: l_app_family_id NUMBER := NULL;
25: l_last_updated_by NUMBER := G_USER_ID;

Line 46: insert into JTF_IAPP_FAMILIES_B (

42: else
43: l_last_updated_by := G_USER_ID;
44: end if;
45:
46: insert into JTF_IAPP_FAMILIES_B (
47: APP_FAMILY_ID,
48: APP_FAMILY_ACCESS_NAME,
49: DISPLAY_SEQUENCE,
50: ENABLED_FLAG,

Line 126: update JTF_IAPP_FAMILIES_B set

122:
123: l_last_updated_by NUMBER := G_USER_ID;
124:
125: begin
126: update JTF_IAPP_FAMILIES_B set
127: APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME,
128: DISPLAY_SEQUENCE = X_DISPLAY_SEQUENCE,
129: ENABLED_FLAG = X_ENABLED_FLAG,
130: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,

Line 173: delete from JTF_IAPP_FAMILIES_B

169: if (sql%notfound) then
170: raise no_data_found;
171: end if;
172:
173: delete from JTF_IAPP_FAMILIES_B
174: where APP_FAMILY_ID = X_APP_FAMILY_ID;
175:
176: if (sql%notfound) then
177: raise no_data_found;

Line 188: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B

184: X_APP_FAMILY_ACCESS_NAME in VARCHAR2,
185: X_APP_ID in NUMBER
186: ) is
187:
188: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B
189: where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
190: ;
191:
192: cursor C_2 is select f.APP_FAMILY_ID, APPLICATION_ID

Line 193: from JTF_IAPP_FAMILIES_B f, JTF_IAPP_FAMILY_APP_MAP a

189: where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
190: ;
191:
192: cursor C_2 is select f.APP_FAMILY_ID, APPLICATION_ID
193: from JTF_IAPP_FAMILIES_B f, JTF_IAPP_FAMILY_APP_MAP a
194: where f.APP_FAMILY_ID = a.APP_FAMILY_ID
195: AND f.APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
196: AND a.APPLICATION_ID = X_APP_ID
197: ;

Line 246: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B

242: procedure DELETE_ALL_APPS_IN_FAMILY (
243: X_APP_FAMILY_ACCESS_NAME in VARCHAR2
244: ) is
245:
246: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B
247: where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
248: ;
249:
250: l_app_family_id NUMBER := NULL;

Line 277: update JTF_IAPP_FAMILIES_B set DELETED_FLAG = 'Y' where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME;

273: begin
274:
275: jtf_iapp_families_pkg.DELETE_ALL_APPS_IN_FAMILY (X_APP_FAMILY_ACCESS_NAME => X_APP_FAMILY_ACCESS_NAME);
276:
277: update JTF_IAPP_FAMILIES_B set DELETED_FLAG = 'Y' where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME;
278:
279: if (sql%notfound) then
280: raise no_data_found;
281: end if;

Line 291: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B

287: X_APP_FAMILY_ACCESS_NAME in VARCHAR2,
288: X_APP_ID in NUMBER
289: ) is
290:
291: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B
292: where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
293: ;
294:
295: l_app_family_id NUMBER := NULL;

Line 321: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B

317: X_USER_ID in NUMBER,
318: X_DEFAULT_RESP_ID in NUMBER
319: ) is
320:
321: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B
322: where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
323: ;
324:
325: cursor C_2 is select f.APP_FAMILY_ID, USER_ID

Line 326: from JTF_IAPP_FAMILIES_B f, JTF_IAPP_FAMILY_USR_MAP u

322: where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
323: ;
324:
325: cursor C_2 is select f.APP_FAMILY_ID, USER_ID
326: from JTF_IAPP_FAMILIES_B f, JTF_IAPP_FAMILY_USR_MAP u
327: where f.APP_FAMILY_ID = u.APP_FAMILY_ID
328: AND f.APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
329: AND u.USER_ID = X_USER_ID
330: ;

Line 395: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B

391: X_APP_FAMILY_ACCESS_NAME in VARCHAR2,
392: X_USER_ID in NUMBER
393: ) is
394:
395: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B
396: where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
397: ;
398:
399: l_app_family_id NUMBER := NULL;

Line 454: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B

450: X_APPLICATION_ID in NUMBER,
451: X_OWNER in VARCHAR2
452: )is
453:
454: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B
455: where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
456: ;
457: cursor c_2 is select nvl(max(app_family_id), 0)
458: from jtf_iapp_families_b where app_family_id < 10000

Line 458: from jtf_iapp_families_b where app_family_id < 10000

454: cursor C is select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B
455: where APP_FAMILY_ACCESS_NAME = X_APP_FAMILY_ACCESS_NAME
456: ;
457: cursor c_2 is select nvl(max(app_family_id), 0)
458: from jtf_iapp_families_b where app_family_id < 10000
459: ;
460:
461: l_app_family_id NUMBER := X_APP_FAMILY_ID;
462: l_app_pseudo_seq NUMBER := NULL;

Line 523: and APP_FAMILY_ID = (select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B

519: LAST_UPDATED_BY = decode(x_OWNER, 'SEED', 1, 0),
520: LAST_UPDATE_LOGIN = 0,
521: SOURCE_LANG = userenv('LANG')
522: where userenv('LANG') in (LANGUAGE, SOURCE_LANG)
523: and APP_FAMILY_ID = (select APP_FAMILY_ID from JTF_IAPP_FAMILIES_B
524: where APP_FAMILY_ACCESS_NAME = x_APP_FAMILY_ACCESS_NAME);
525: end TRANSLATE_ROW;
526:
527:

Line 534: from JTF_IAPP_FAMILIES_B B

530: begin
531: delete from JTF_IAPP_FAMILIES_TL T
532: where not exists
533: (select NULL
534: from JTF_IAPP_FAMILIES_B B
535: where B.APP_FAMILY_ID = T.APP_FAMILY_ID
536: );
537:
538: update JTF_IAPP_FAMILIES_TL T set (