[Home] [Help]
1310: hr_utility.set_location(l_proc, 280);
1311: end if;
1312: --
1313: l_from_str := ' from per_security_profiles sec,
1314: per_position_list posl,
1315: per_organization_list org ';
1316: --
1317: l_cond_str := ' org.security_profile_id = sec.security_profile_id
1318: and posl.security_profile_id = sec.security_profile_id
1610: hr_utility.set_location(l_proc, 370);
1611: end if;
1612: --
1613: l_from_str := ' from per_security_profiles sec,
1614: per_position_list posl ';
1615: --
1616: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
1617: and posl.position_id = :l_position_id
1618: and sec.view_all_organizations_flag = :l_all
1816: end if;
1817: --
1818: l_from_str := ' from per_security_profiles sec,
1819: pay_payroll_list pay,
1820: per_position_list posl,
1821: per_organization_list org ';
1822: --
1823: l_cond_str := ' org.security_profile_id = sec.security_profile_id
1824: and posl.security_profile_id = sec.security_profile_id
1935: hr_utility.set_location(l_proc, 460);
1936: end if;
1937: --
1938: l_from_str := ' from per_security_profiles sec,
1939: per_position_list posl,
1940: per_organization_list org ';
1941: --
1942: l_cond_str := ' org.security_profile_id = sec.security_profile_id
1943: and posl.security_profile_id = sec.security_profile_id
2156: end if;
2157: --
2158: l_from_str := ' from per_security_profiles sec,
2159: pay_payroll_list pay,
2160: per_position_list posl ';
2161: --
2162: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
2163: and pay.security_profile_id = sec.security_profile_id
2164: and pay.security_profile_id = posl.security_profile_id
2366: hr_utility.set_location(l_proc, 580);
2367: end if;
2368: --
2369: l_from_str := ' from per_security_profiles sec,
2370: per_position_list posl ';
2371: --
2372: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
2373: and posl.position_id = :l_position_id
2374: and sec.view_all_organizations_flag = :l_all
5598: -- security profile and therefore different access rights.
5599: --
5600: CURSOR csr_get_static_pos_for_user IS
5601: SELECT ppl.position_id
5602: FROM per_position_list ppl
5603: WHERE ppl.security_profile_id IS NOT NULL
5604: AND ppl.user_id IS NOT NULL
5605: AND ppl.security_profile_id = p_security_profile_id
5606: AND ppl.user_id = p_user_id;
5611: -- not in use.
5612: --
5613: CURSOR csr_get_static_pos IS
5614: SELECT ppl.position_id
5615: FROM per_position_list ppl
5616: WHERE ppl.security_profile_id IS NOT NULL
5617: AND ppl.user_id IS NULL
5618: AND ppl.security_profile_id = p_security_profile_id;
5619:
5630: -- If this is user-based, look for a user and
5631: -- security profile pair. Generally speaking, the static
5632: -- user lists will only be cached when it is known that
5633: -- this user is in the list of users to build static
5634: -- lists for AND they have rows in per_position_list.
5635: --
5636: IF g_dbg THEN op(l_proc, 20); END IF;
5637:
5638: IF NVL(p_top_position_method, 'S') = 'U' THEN
6367: IF g_dbg THEN op(l_proc, 30); END IF;
6368:
6369: SELECT ppl.position_id
6370: INTO l_position_id
6371: FROM per_position_list ppl
6372: WHERE ppl.user_id IS NOT NULL
6373: AND ppl.security_profile_id IS NOT NULL
6374: AND ppl.user_id = p_user_id
6375: AND ppl.security_profile_id = p_security_profile_id
6590:
6591: IF p_user_id IS NOT NULL AND p_security_profile_id IS NOT NULL THEN
6592:
6593: --
6594: -- Delete all positions in per_position_list for this user
6595: -- and this security profile.
6596: --
6597: IF g_dbg THEN op(l_proc, 20); END IF;
6598:
6595: -- and this security profile.
6596: --
6597: IF g_dbg THEN op(l_proc, 20); END IF;
6598:
6599: DELETE FROM per_position_list ppl
6600: WHERE ppl.user_id IS NOT NULL
6601: AND ppl.security_profile_id IS NOT NULL
6602: AND ppl.user_id = p_user_id
6603: AND ppl.security_profile_id = p_security_profile_id;
6876: -- delete_pos_list_for_user) prior to insertion.
6877: --
6878: IF g_dbg THEN op(l_proc||'('||to_char(i)||'):'); END IF;
6879:
6880: INSERT INTO per_position_list
6881: (security_profile_id
6882: ,position_id
6883: ,user_id
6884: ,request_id
7309: -- This is done dynamically because:
7310: -- a) user-based pos security or user-based org security
7311: -- is in use and the user does not have their permissions
7312: -- stored in static tables, or
7313: -- b) the per_position_list table is not to be used.
7314: --
7315: IF NOT p_use_static_lists
7316: OR ((NVL(p_sec_prof_rec.top_position_method, 'S') = 'U' OR
7317: NVL(p_sec_prof_rec.top_organization_method, 'S') = 'U')
8196: -- Position List.
8197: --
8198: IF g_dbg THEN op(l_proc, 30); END IF;
8199:
8200: DELETE FROM per_position_list ppl
8201: WHERE ppl.user_id IS NOT NULL
8202: AND ppl.security_profile_id IS NOT NULL
8203: AND ppl.user_id = p_user_id
8204: AND ppl.security_profile_id = p_security_profile_id;
8365: hr_utility.set_location(l_proc,50);
8366: --
8367: -- Changes 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date track position req.
8368: --
8369: DELETE FROM per_position_list pol
8370: WHERE EXISTS ( SELECT ''
8371: FROM hr_all_positions_f pos
8372: WHERE pos.position_id = pol.position_id
8373: AND pos.business_group_id = p_business_group_id);
8505: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.ADD_POS_TO_SECURITY_LIST';
8506: --
8507: begin
8508: --
8509: insert into per_position_list
8510: (security_profile_id, position_id)
8511: values (p_Security_Profile_Id, p_position_id);
8512: --
8513: end add_pos_to_security_list;
8522: --
8523: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_POS_FROM_SECURITY_LIST';
8524: begin
8525: hr_utility.set_location('Entering:'|| l_proc, 10);
8526: DELETE FROM PER_POSITION_LIST
8527: WHERE position_id = p_position_Id;
8528: exception
8529: when NO_DATA_FOUND then
8530: hr_utility.set_location(l_proc, 20);