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 25: l_security_profile_id := fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');

21: l_view_all_org_flag per_security_profiles.view_all_organizations_flag%TYPE;
22: l_user_id NUMBER;
23: BEGIN
24:
25: l_security_profile_id := fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL');
26: l_user_id := fnd_global.user_id;
27:
28: SELECT organization_id,
29: view_all_organizations_flag ,

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

122: AND orgd.org_structure_version_id = pset.org_structure_version_id
123: AND orgd.organization_id_child = org.organization_id
124: AND org.organization_id = p_org_id
125: AND orgd.organization_id_child = sec.organization_id
126: AND sec.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL'));
127:
128: RETURN l_org_id;
129: ELSIF l_user_assmt_flag = 'Y' THEN
130:

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

173: WHERE 1=1
174: AND orgd.organization_id_child = org.organization_id
175: AND orgd.organization_id_child = p_org_id
176: AND orgd.organization_id_child = sec.organization_id (+)
177: AND sec.security_profile_id(+) = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
178: AND fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL') IS NOT NULL
179: AND prof.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
180: AND ( prof.view_all_organizations_flag = 'Y' OR sec.organization_id IS NOT NULL));
181:

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

174: AND orgd.organization_id_child = org.organization_id
175: AND orgd.organization_id_child = p_org_id
176: AND orgd.organization_id_child = sec.organization_id (+)
177: AND sec.security_profile_id(+) = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
178: AND fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL') IS NOT NULL
179: AND prof.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
180: AND ( prof.view_all_organizations_flag = 'Y' OR sec.organization_id IS NOT NULL));
181:
182: RETURN l_org_id;

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

175: AND orgd.organization_id_child = p_org_id
176: AND orgd.organization_id_child = sec.organization_id (+)
177: AND sec.security_profile_id(+) = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
178: AND fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL') IS NOT NULL
179: AND prof.security_profile_id = fnd_profile.value('PJI_SECURITY_PROFILE_LEVEL')
180: AND ( prof.view_all_organizations_flag = 'Y' OR sec.organization_id IS NOT NULL));
181:
182: RETURN l_org_id;
183: