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_TRIGGERTEST dependencies on ALL_TRIGGERS

Line 59: select count(*) into v_count1 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T4' and OWNER = 'APPS';

55: JTF_DIAGNOSTIC_ADAPTUTIL.setUpVars;
56: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
57:
58:
59: select count(*) into v_count1 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T4' and OWNER = 'APPS';
60: select count(*) into v_count2 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAIN_TI' and OWNER = 'APPS';
61: select count(*) into v_count3 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_ROLE_PERM_TI' and OWNER = 'APPS';
62: select count(*) into v_count4 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PERMISSIONS_B_T1' and OWNER = 'APPS';
63: select count(*) into v_count5 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAINS_B_T1' and OWNER = 'APPS';

Line 60: select count(*) into v_count2 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAIN_TI' and OWNER = 'APPS';

56: JTF_DIAGNOSTIC_ADAPTUTIL.addStringToReport('@html');
57:
58:
59: select count(*) into v_count1 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T4' and OWNER = 'APPS';
60: select count(*) into v_count2 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAIN_TI' and OWNER = 'APPS';
61: select count(*) into v_count3 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_ROLE_PERM_TI' and OWNER = 'APPS';
62: select count(*) into v_count4 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PERMISSIONS_B_T1' and OWNER = 'APPS';
63: select count(*) into v_count5 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAINS_B_T1' and OWNER = 'APPS';
64: select count(*) into v_count6 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPALS_B_T1' and OWNER = 'APPS';

Line 61: select count(*) into v_count3 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_ROLE_PERM_TI' and OWNER = 'APPS';

57:
58:
59: select count(*) into v_count1 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T4' and OWNER = 'APPS';
60: select count(*) into v_count2 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAIN_TI' and OWNER = 'APPS';
61: select count(*) into v_count3 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_ROLE_PERM_TI' and OWNER = 'APPS';
62: select count(*) into v_count4 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PERMISSIONS_B_T1' and OWNER = 'APPS';
63: select count(*) into v_count5 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAINS_B_T1' and OWNER = 'APPS';
64: select count(*) into v_count6 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPALS_B_T1' and OWNER = 'APPS';
65: select count(*) into v_count7 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T3' and OWNER = 'APPS';

Line 62: select count(*) into v_count4 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PERMISSIONS_B_T1' and OWNER = 'APPS';

58:
59: select count(*) into v_count1 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T4' and OWNER = 'APPS';
60: select count(*) into v_count2 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAIN_TI' and OWNER = 'APPS';
61: select count(*) into v_count3 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_ROLE_PERM_TI' and OWNER = 'APPS';
62: select count(*) into v_count4 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PERMISSIONS_B_T1' and OWNER = 'APPS';
63: select count(*) into v_count5 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAINS_B_T1' and OWNER = 'APPS';
64: select count(*) into v_count6 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPALS_B_T1' and OWNER = 'APPS';
65: select count(*) into v_count7 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T3' and OWNER = 'APPS';
66:

Line 63: select count(*) into v_count5 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAINS_B_T1' and OWNER = 'APPS';

59: select count(*) into v_count1 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T4' and OWNER = 'APPS';
60: select count(*) into v_count2 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAIN_TI' and OWNER = 'APPS';
61: select count(*) into v_count3 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_ROLE_PERM_TI' and OWNER = 'APPS';
62: select count(*) into v_count4 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PERMISSIONS_B_T1' and OWNER = 'APPS';
63: select count(*) into v_count5 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAINS_B_T1' and OWNER = 'APPS';
64: select count(*) into v_count6 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPALS_B_T1' and OWNER = 'APPS';
65: select count(*) into v_count7 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T3' and OWNER = 'APPS';
66:
67:

Line 64: select count(*) into v_count6 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPALS_B_T1' and OWNER = 'APPS';

60: select count(*) into v_count2 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAIN_TI' and OWNER = 'APPS';
61: select count(*) into v_count3 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_ROLE_PERM_TI' and OWNER = 'APPS';
62: select count(*) into v_count4 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PERMISSIONS_B_T1' and OWNER = 'APPS';
63: select count(*) into v_count5 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAINS_B_T1' and OWNER = 'APPS';
64: select count(*) into v_count6 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPALS_B_T1' and OWNER = 'APPS';
65: select count(*) into v_count7 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T3' and OWNER = 'APPS';
66:
67:
68: IF (v_count1 = 1) AND (v_count2 = 1) AND (v_count3 = 1) AND (v_count4 = 1) AND (v_count5 = 1) AND (v_count6 = 1) AND (v_count7 = 1) THEN

Line 65: select count(*) into v_count7 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T3' and OWNER = 'APPS';

61: select count(*) into v_count3 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_ROLE_PERM_TI' and OWNER = 'APPS';
62: select count(*) into v_count4 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PERMISSIONS_B_T1' and OWNER = 'APPS';
63: select count(*) into v_count5 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_DOMAINS_B_T1' and OWNER = 'APPS';
64: select count(*) into v_count6 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPALS_B_T1' and OWNER = 'APPS';
65: select count(*) into v_count7 from ALL_TRIGGERS where upper(TRIGGER_NAME) = 'JTF_AUTH_PRINCIPAL_MAPS_T3' and OWNER = 'APPS';
66:
67:
68: IF (v_count1 = 1) AND (v_count2 = 1) AND (v_count3 = 1) AND (v_count4 = 1) AND (v_count5 = 1) AND (v_count6 = 1) AND (v_count7 = 1) THEN
69: