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.PJI_PMV_UTIL dependencies on FND_PROFILE

Line 941: l_security_profile_id := fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');

937: l_view_all_org_flag per_security_profiles.view_all_organizations_flag%TYPE;
938: l_user_id NUMBER;
939: BEGIN
940:
941: l_security_profile_id := fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');
942: l_user_id := fnd_global.user_id;
943:
944: SELECT organization_id,
945: view_all_organizations_flag ,

Line 1058: AND sec.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');

1054: AND orgd.org_structure_version_id = pset.org_structure_version_id
1055: AND orgd.organization_id_child = org.organization_id
1056: AND org.language = USERENV('LANG')
1057: AND orgd.organization_id_child = sec.organization_id
1058: AND sec.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');
1059: l_Count:=l_Organization_List.COUNT;
1060:
1061: --Bug 4599990. The security restricts the view to only a part of hierarchy with organization on the user
1062: --assignment as the top org

Line 1113: AND sec.security_profile_id(+) = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')

1109: WHERE 1=1
1110: AND orgd.organization_id_child = org.organization_id
1111: AND org.language = USERENV('LANG')
1112: AND orgd.organization_id_child = sec.organization_id (+)
1113: AND sec.security_profile_id(+) = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
1114: AND fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL') IS NOT NULL
1115: AND prof.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
1116: AND ( prof.view_all_organizations_flag = 'Y'
1117: OR sec.organization_id IS NOT NULL))

Line 1114: AND fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL') IS NOT NULL

1110: AND orgd.organization_id_child = org.organization_id
1111: AND org.language = USERENV('LANG')
1112: AND orgd.organization_id_child = sec.organization_id (+)
1113: AND sec.security_profile_id(+) = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
1114: AND fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL') IS NOT NULL
1115: AND prof.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
1116: AND ( prof.view_all_organizations_flag = 'Y'
1117: OR sec.organization_id IS NOT NULL))
1118: LOOP

Line 1115: AND prof.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')

1111: AND org.language = USERENV('LANG')
1112: AND orgd.organization_id_child = sec.organization_id (+)
1113: AND sec.security_profile_id(+) = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
1114: AND fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL') IS NOT NULL
1115: AND prof.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
1116: AND ( prof.view_all_organizations_flag = 'Y'
1117: OR sec.organization_id IS NOT NULL))
1118: LOOP
1119: l_Count:=l_Count+1;

Line 1194: AND sec.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL'));

1190: AND orgd.org_structure_version_id = pset.org_structure_version_id
1191: AND orgd.organization_id_child = org.organization_id
1192: AND org.organization_id = p_org_id
1193: AND orgd.organization_id_child = sec.organization_id
1194: AND sec.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL'));
1195:
1196: RETURN l_org_id;
1197: ELSIF l_user_assmt_flag = 'Y' THEN
1198:

Line 1245: AND sec.security_profile_id(+) = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')

1241: WHERE 1=1
1242: AND orgd.organization_id_child = org.organization_id
1243: AND orgd.organization_id_child = p_org_id
1244: AND orgd.organization_id_child = sec.organization_id (+)
1245: AND sec.security_profile_id(+) = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
1246: AND fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL') IS NOT NULL
1247: AND prof.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
1248: AND ( prof.view_all_organizations_flag = 'Y' OR sec.organization_id IS NOT NULL));
1249:

Line 1246: AND fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL') IS NOT NULL

1242: AND orgd.organization_id_child = org.organization_id
1243: AND orgd.organization_id_child = p_org_id
1244: AND orgd.organization_id_child = sec.organization_id (+)
1245: AND sec.security_profile_id(+) = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
1246: AND fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL') IS NOT NULL
1247: AND prof.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
1248: AND ( prof.view_all_organizations_flag = 'Y' OR sec.organization_id IS NOT NULL));
1249:
1250: RETURN l_org_id;

Line 1247: AND prof.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')

1243: AND orgd.organization_id_child = p_org_id
1244: AND orgd.organization_id_child = sec.organization_id (+)
1245: AND sec.security_profile_id(+) = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
1246: AND fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL') IS NOT NULL
1247: AND prof.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
1248: AND ( prof.view_all_organizations_flag = 'Y' OR sec.organization_id IS NOT NULL));
1249:
1250: RETURN l_org_id;
1251: