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_AUTH_BULKLOAD_PKG dependencies on JTF_AUTH_PRINCIPALS_B

Line 32: from jtf_auth_principals_b

28: app_exception.raise_exception;
29: end if;
30:
31: select count(*) into cnt
32: from jtf_auth_principals_b
33: where principal_name=U_ROLE_NAME and is_user_flag=0;
34:
35: if cnt=0 then
36: fnd_message.set_name('JTF', 'JTF-1056');

Line 41: from jtf_auth_principals_b

37: app_exception.raise_exception;
38: end if;
39:
40: select count(*) into cnt
41: from jtf_auth_principals_b
42: where principal_name=U_USER_NAME and is_user_flag=1;
43:
44: if cnt=0 then
45:

Line 53: jtf_auth_principals_b a,

49: end if;
50:
51: select count(*) into count1
52: from jtf_auth_principal_maps c,
53: jtf_auth_principals_b a,
54: jtf_auth_domains_b d,
55: jtf_auth_principals_b b
56: where a.principal_name=U_USER_NAME and a.is_user_flag=1
57: and a.jtf_auth_principal_id=c.jtf_auth_principal_id

Line 55: jtf_auth_principals_b b

51: select count(*) into count1
52: from jtf_auth_principal_maps c,
53: jtf_auth_principals_b a,
54: jtf_auth_domains_b d,
55: jtf_auth_principals_b b
56: where a.principal_name=U_USER_NAME and a.is_user_flag=1
57: and a.jtf_auth_principal_id=c.jtf_auth_principal_id
58: and b.principal_name=U_ROLE_NAME and b.is_user_flag=0
59: and b.jtf_auth_principal_id=c.jtf_auth_parent_principal_id

Line 64: from jtf_auth_principals_b

60: and d.domain_name='CRM_DOMAIN'
61: and d.jtf_auth_domain_id=c.jtf_auth_domain_id;
62:
63: select jtf_auth_principal_id into p_id
64: from jtf_auth_principals_b
65: where principal_name=U_USER_NAME and is_user_flag=1;
66:
67: select jtf_auth_principal_id into r_id
68: from jtf_auth_principals_b

Line 68: from jtf_auth_principals_b

64: from jtf_auth_principals_b
65: where principal_name=U_USER_NAME and is_user_flag=1;
66:
67: select jtf_auth_principal_id into r_id
68: from jtf_auth_principals_b
69: where principal_name=U_ROLE_NAME and is_user_flag=0;
70:
71: select jtf_auth_domain_id into d_id
72: from jtf_auth_domains_b where

Line 95: and a.ownertable_name = 'JTF_AUTH_PRINCIPALS_B'

91:
92: select count(*) into maps_sources
93: from jtf_auth_maps_sources a
94: where a.jtf_auth_principal_mapping_id = mapping_id
95: and a.ownertable_name = 'JTF_AUTH_PRINCIPALS_B'
96: and a.ownertable_key = TO_CHAR(p_id);
97:
98: if maps_sources=0 then
99: insert into jtf_auth_maps_sources (JTF_AUTH_MAPS_SOURCE_ID,

Line 103: (source_id, mapping_id, 'JTF_AUTH_PRINCIPALS_B',

99: insert into jtf_auth_maps_sources (JTF_AUTH_MAPS_SOURCE_ID,
100: JTF_AUTH_PRINCIPAL_MAPPING_ID, OWNERTABLE_NAME, OWNERTABLE_KEY,
101: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
102: APPLICATION_ID, OBJECT_VERSION_NUMBER) VALUES
103: (source_id, mapping_id, 'JTF_AUTH_PRINCIPALS_B',
104: TO_CHAR(p_id), 0, SYSDATE, 0, SYSDATE, 690, 1);
105: end if;
106:
107:

Line 160: from jtf_auth_principals_b

156: app_exception.raise_exception;
157: end if;
158:
159: select count(*) into cnt
160: from jtf_auth_principals_b
161: where principal_name=U_ROLE_NAME and is_user_flag=0;
162:
163: if cnt=0 then
164: fnd_message.set_name('JTF', 'JTF-1056');

Line 170: from jtf_auth_principals_b

166: end if;
167:
168:
169: select count(*) into cnt
170: from jtf_auth_principals_b
171: where principal_name=U_USER_NAME and is_user_flag=1;
172:
173: if cnt=0 then
174:

Line 182: jtf_auth_principals_b a,

178: end if;
179:
180: select count(*) into count1
181: from jtf_auth_principal_maps c,
182: jtf_auth_principals_b a,
183: jtf_auth_domains_b d,
184: jtf_auth_principals_b b
185: where a.principal_name=U_USER_NAME and a.is_user_flag=1
186: and a.jtf_auth_principal_id=c.jtf_auth_principal_id

Line 184: jtf_auth_principals_b b

180: select count(*) into count1
181: from jtf_auth_principal_maps c,
182: jtf_auth_principals_b a,
183: jtf_auth_domains_b d,
184: jtf_auth_principals_b b
185: where a.principal_name=U_USER_NAME and a.is_user_flag=1
186: and a.jtf_auth_principal_id=c.jtf_auth_principal_id
187: and b.principal_name=U_ROLE_NAME and b.is_user_flag=0
188: and b.jtf_auth_principal_id=c.jtf_auth_parent_principal_id

Line 193: from jtf_auth_principals_b

189: and d.domain_name='CRM_DOMAIN'
190: and d.jtf_auth_domain_id=c.jtf_auth_domain_id;
191:
192: select jtf_auth_principal_id into p_id
193: from jtf_auth_principals_b
194: where principal_name=U_USER_NAME and is_user_flag=1;
195:
196: select jtf_auth_principal_id into r_id
197: from jtf_auth_principals_b

Line 197: from jtf_auth_principals_b

193: from jtf_auth_principals_b
194: where principal_name=U_USER_NAME and is_user_flag=1;
195:
196: select jtf_auth_principal_id into r_id
197: from jtf_auth_principals_b
198: where principal_name=U_ROLE_NAME and is_user_flag=0;
199:
200: select jtf_auth_domain_id into d_id
201: from jtf_auth_domains_b where

Line 277: from jtf_auth_principals_b

273: app_exception.raise_exception;
274: end if;
275:
276: select count(*) into cnt
277: from jtf_auth_principals_b
278: where principal_name=U_ROLE_NAME and is_user_flag=0;
279:
280: if cnt=0 then
281: fnd_message.set_name('JTF', 'JTF-1056');

Line 287: from jtf_auth_principals_b

283: end if;
284:
285:
286: select count(*) into cnt
287: from jtf_auth_principals_b
288: where principal_name=U_USER_NAME and is_user_flag=1;
289:
290: if cnt=0 then
291:

Line 299: jtf_auth_principals_b a,

295: end if;
296:
297: select count(*) into count1
298: from jtf_auth_principal_maps c,
299: jtf_auth_principals_b a,
300: jtf_auth_domains_b d,
301: jtf_auth_principals_b b
302: where a.principal_name=U_USER_NAME and a.is_user_flag=1
303: and a.jtf_auth_principal_id=c.jtf_auth_principal_id

Line 301: jtf_auth_principals_b b

297: select count(*) into count1
298: from jtf_auth_principal_maps c,
299: jtf_auth_principals_b a,
300: jtf_auth_domains_b d,
301: jtf_auth_principals_b b
302: where a.principal_name=U_USER_NAME and a.is_user_flag=1
303: and a.jtf_auth_principal_id=c.jtf_auth_principal_id
304: and b.principal_name=U_ROLE_NAME and b.is_user_flag=0
305: and b.jtf_auth_principal_id=c.jtf_auth_parent_principal_id

Line 310: from jtf_auth_principals_b

306: and d.domain_name='CRM_DOMAIN'
307: and d.jtf_auth_domain_id=c.jtf_auth_domain_id;
308:
309: select jtf_auth_principal_id into p_id
310: from jtf_auth_principals_b
311: where principal_name=U_USER_NAME and is_user_flag=1;
312:
313: select jtf_auth_principal_id into r_id
314: from jtf_auth_principals_b

Line 314: from jtf_auth_principals_b

310: from jtf_auth_principals_b
311: where principal_name=U_USER_NAME and is_user_flag=1;
312:
313: select jtf_auth_principal_id into r_id
314: from jtf_auth_principals_b
315: where principal_name=U_ROLE_NAME and is_user_flag=0;
316:
317: select jtf_auth_domain_id into d_id
318: from jtf_auth_domains_b where

Line 341: and a.ownertable_name = 'JTF_AUTH_PRINCIPALS_B'

337:
338: select count(*) into maps_sources
339: from jtf_auth_maps_sources a
340: where a.jtf_auth_principal_mapping_id = mapping_id
341: and a.ownertable_name = 'JTF_AUTH_PRINCIPALS_B'
342: and a.ownertable_key = TO_CHAR(p_id);
343:
344: if maps_sources=0 then
345: insert into jtf_auth_maps_sources (JTF_AUTH_MAPS_SOURCE_ID,

Line 349: (source_id, mapping_id, 'JTF_AUTH_PRINCIPALS_B',

345: insert into jtf_auth_maps_sources (JTF_AUTH_MAPS_SOURCE_ID,
346: JTF_AUTH_PRINCIPAL_MAPPING_ID, OWNERTABLE_NAME, OWNERTABLE_KEY,
347: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
348: APPLICATION_ID, OBJECT_VERSION_NUMBER) VALUES
349: (source_id, mapping_id, 'JTF_AUTH_PRINCIPALS_B',
350: TO_CHAR(p_id), 0, SYSDATE, 0, SYSDATE, APP_ID, 1);
351: end if;
352:
353:

Line 407: from jtf_auth_principals_b

403: app_exception.raise_exception;
404: end if;
405:
406: select count(*) into cnt
407: from jtf_auth_principals_b
408: where principal_name=U_ROLE_NAME and is_user_flag=0;
409:
410: if cnt=0 then
411: fnd_message.set_name('JTF', 'JTF-1056');

Line 417: from jtf_auth_principals_b

413: end if;
414:
415:
416: select count(*) into cnt
417: from jtf_auth_principals_b
418: where principal_name=U_USER_NAME and is_user_flag=1;
419:
420: if cnt=0 then
421:

Line 429: jtf_auth_principals_b a,

425: end if;
426:
427: select count(*) into count1
428: from jtf_auth_principal_maps c,
429: jtf_auth_principals_b a,
430: jtf_auth_domains_b d,
431: jtf_auth_principals_b b
432: where a.principal_name=U_USER_NAME and a.is_user_flag=1
433: and a.jtf_auth_principal_id=c.jtf_auth_principal_id

Line 431: jtf_auth_principals_b b

427: select count(*) into count1
428: from jtf_auth_principal_maps c,
429: jtf_auth_principals_b a,
430: jtf_auth_domains_b d,
431: jtf_auth_principals_b b
432: where a.principal_name=U_USER_NAME and a.is_user_flag=1
433: and a.jtf_auth_principal_id=c.jtf_auth_principal_id
434: and b.principal_name=U_ROLE_NAME and b.is_user_flag=0
435: and b.jtf_auth_principal_id=c.jtf_auth_parent_principal_id

Line 440: from jtf_auth_principals_b

436: and d.domain_name='CRM_DOMAIN'
437: and d.jtf_auth_domain_id=c.jtf_auth_domain_id;
438:
439: select jtf_auth_principal_id into p_id
440: from jtf_auth_principals_b
441: where principal_name=U_USER_NAME and is_user_flag=1;
442:
443: select jtf_auth_principal_id into r_id
444: from jtf_auth_principals_b

Line 444: from jtf_auth_principals_b

440: from jtf_auth_principals_b
441: where principal_name=U_USER_NAME and is_user_flag=1;
442:
443: select jtf_auth_principal_id into r_id
444: from jtf_auth_principals_b
445: where principal_name=U_ROLE_NAME and is_user_flag=0;
446:
447: select jtf_auth_domain_id into d_id
448: from jtf_auth_domains_b where