APPS.PJI_PMV_UTIL dependencies on PER_SECURITY_PROFILES

Line 14: (x_top_org_id OUT nocopy per_security_profiles.organization_id%TYPE,

10: -- If the top org is obtained from the user assignment then the value will be 'Y'
11: --> x_insert_top_org : Flag indicating whether the user has permissions to the see the top org in the
12: -- hierarchy
13: PROCEDURE get_top_org_details
14: (x_top_org_id OUT nocopy per_security_profiles.organization_id%TYPE,
15: x_top_org_name OUT nocopy hr_all_organization_units_tl.name%TYPE,
16: x_user_assmt_flag OUT nocopy VARCHAR2,
17: x_insert_top_org_flag OUT nocopy VARCHAR2 )
18: IS

Line 19: l_security_profile_id per_security_profiles.security_profile_id%TYPE;

15: x_top_org_name OUT nocopy hr_all_organization_units_tl.name%TYPE,
16: x_user_assmt_flag OUT nocopy VARCHAR2,
17: x_insert_top_org_flag OUT nocopy VARCHAR2 )
18: IS
19: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
20: l_top_organization_id per_security_profiles.organization_id%TYPE;
21: l_view_all_org_flag per_security_profiles.view_all_organizations_flag%TYPE;
22: l_user_id NUMBER;
23: BEGIN

Line 20: l_top_organization_id per_security_profiles.organization_id%TYPE;

16: x_user_assmt_flag OUT nocopy VARCHAR2,
17: x_insert_top_org_flag OUT nocopy VARCHAR2 )
18: IS
19: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
20: l_top_organization_id per_security_profiles.organization_id%TYPE;
21: l_view_all_org_flag per_security_profiles.view_all_organizations_flag%TYPE;
22: l_user_id NUMBER;
23: BEGIN
24:

Line 21: l_view_all_org_flag per_security_profiles.view_all_organizations_flag%TYPE;

17: x_insert_top_org_flag OUT nocopy VARCHAR2 )
18: IS
19: l_security_profile_id per_security_profiles.security_profile_id%TYPE;
20: l_top_organization_id per_security_profiles.organization_id%TYPE;
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');

Line 34: FROM per_security_profiles

30: include_top_organization_flag
31: INTO l_top_organization_id,
32: l_view_all_org_flag,
33: x_insert_top_org_flag
34: FROM per_security_profiles
35: WHERE security_profile_id=l_security_profile_id;
36:
37: x_user_assmt_flag := 'N';
38:

Line 84: l_top_organization_id per_security_profiles.organization_id%TYPE;

80: --present in the list of PJI organizations. Otherwise it returns null
81: --This helps to check the access to Performance Reporting from Project List page.
82: FUNCTION PJI_ORGANIZATION_EXISTS(p_org_id IN NUMBER) RETURN NUMBER
83: IS
84: l_top_organization_id per_security_profiles.organization_id%TYPE;
85: l_org_id per_security_profiles.organization_id%TYPE;
86: l_top_org_name hr_all_organization_units_tl.name%TYPE;
87: l_user_assmt_flag VARCHAR2(1);
88: l_insert_top_org_flag VARCHAR2(1);

Line 85: l_org_id per_security_profiles.organization_id%TYPE;

81: --This helps to check the access to Performance Reporting from Project List page.
82: FUNCTION PJI_ORGANIZATION_EXISTS(p_org_id IN NUMBER) RETURN NUMBER
83: IS
84: l_top_organization_id per_security_profiles.organization_id%TYPE;
85: l_org_id per_security_profiles.organization_id%TYPE;
86: l_top_org_name hr_all_organization_units_tl.name%TYPE;
87: l_user_assmt_flag VARCHAR2(1);
88: l_insert_top_org_flag VARCHAR2(1);
89:

Line 172: , per_security_profiles prof

168: where c.organization_id_child = p.organization_id_parent
169: and c.org_structure_version_id = p.org_structure_version_id)) orgd
170: , per_organization_list sec
171: , hr_all_organization_units org
172: , per_security_profiles prof
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 (+)