APPS.HR_SECURITY dependencies on PER_SECURITY_PROFILES

Line 25: g_context per_security_profiles%ROWTYPE;

21: g_resp_id NUMBER;
22: g_resp_appl_id NUMBER;
23: g_security_group_id NUMBER;
24: g_person_id NUMBER;
25: g_context per_security_profiles%ROWTYPE;
26: g_view_no_rows BOOLEAN;
27: g_effective_date DATE := sysdate;
28: g_is_rtm boolean := false;
29: type g_vac_list_tbl_typ is table of number index by binary_integer;

Line 54: g_mo_context per_security_profiles%ROWTYPE;

50: -----------------------------------------------------------------------
51: --
52: g_org_id_initialized BOOLEAN := FALSE;
53: g_org_id VARCHAR2(15);
54: g_mo_context per_security_profiles%ROWTYPE;
55: g_mo_person_id NUMBER;
56: g_mo_org_sec_known BOOLEAN;
57: --
58: -----------------------------------------------------------------------

Line 116: FROM per_security_profiles

112: --
113: CURSOR get_reporting_id
114: IS
115: SELECT security_profile_id
116: FROM per_security_profiles
117: WHERE reporting_oracle_username = USER;
118: --
119: BEGIN
120: --

Line 160: from per_security_profiles

156: function get_person_id return number is
157: --
158: cursor get_sec_person_id(p_security_profile_id number) is
159: select named_person_id
160: from per_security_profiles
161: where security_profile_id=p_security_profile_id;
162: --
163: cursor get_user_person_id(p_user_id number) is
164: select employee_id

Line 254: -- Get the row from per_security_profiles corresponding to the

250: SUBSTRB(USERENV('CLIENT_INFO'),1, 10))
251: FROM FND_ORACLE_USERID
252: WHERE ORACLE_USERNAME = user;
253: --
254: -- Get the row from per_security_profiles corresponding to the
255: -- security profile for the session
256: --
257: CURSOR csr_get_sec_prf(p_security_profile_id number)
258: IS

Line 260: FROM per_security_profiles

256: --
257: CURSOR csr_get_sec_prf(p_security_profile_id number)
258: IS
259: SELECT *
260: FROM per_security_profiles
261: WHERE security_profile_id = p_security_profile_id;
262:
263: --
264: -- Get if the person is an RTM