[Home] [Help]
1326: hr_utility.set_location(l_proc, 280);
1327: end if;
1328: --
1329: l_from_str := ' from per_security_profiles sec,
1330: per_position_list posl,
1331: per_organization_list org ';
1332: --
1333: -- Modified for bug 11737636
1334: l_cond_str := ' org.security_profile_id = sec.security_profile_id
1637: hr_utility.set_location(l_proc, 370);
1638: end if;
1639: --
1640: l_from_str := ' from per_security_profiles sec,
1641: per_position_list posl ';
1642: --
1643: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
1644: and posl.position_id = :l_position_id
1645: and sec.view_all_organizations_flag = :l_all
1847: end if;
1848: --
1849: l_from_str := ' from per_security_profiles sec,
1850: pay_payroll_list pay,
1851: per_position_list posl,
1852: per_organization_list org ';
1853: --
1854: l_cond_str := ' org.security_profile_id = sec.security_profile_id
1855: and posl.security_profile_id = sec.security_profile_id
1967: hr_utility.set_location(l_proc, 460);
1968: end if;
1969: --
1970: l_from_str := ' from per_security_profiles sec,
1971: per_position_list posl,
1972: per_organization_list org ';
1973: --
1974: l_cond_str := ' org.security_profile_id = sec.security_profile_id
1975: and posl.security_profile_id = sec.security_profile_id
2190: end if;
2191: --
2192: l_from_str := ' from per_security_profiles sec,
2193: pay_payroll_list pay,
2194: per_position_list posl ';
2195: --
2196: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
2197: and pay.security_profile_id = sec.security_profile_id
2198: and pay.security_profile_id = posl.security_profile_id
2402: hr_utility.set_location(l_proc, 580);
2403: end if;
2404: --
2405: l_from_str := ' from per_security_profiles sec,
2406: per_position_list posl ';
2407: --
2408: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
2409: and posl.position_id = :l_position_id
2410: and sec.view_all_organizations_flag = :l_all
5842: -- security profile and therefore different access rights.
5843: --
5844: CURSOR csr_get_static_pos_for_user IS
5845: SELECT ppl.position_id
5846: FROM per_position_list ppl
5847: WHERE ppl.security_profile_id IS NOT NULL
5848: AND ppl.user_id IS NOT NULL
5849: AND ppl.security_profile_id = p_security_profile_id
5850: AND ppl.user_id = p_user_id;
5855: -- not in use.
5856: --
5857: CURSOR csr_get_static_pos IS
5858: SELECT ppl.position_id
5859: FROM per_position_list ppl
5860: WHERE ppl.security_profile_id IS NOT NULL
5861: AND ppl.user_id IS NULL
5862: AND ppl.security_profile_id = p_security_profile_id;
5863:
5874: -- If this is user-based, look for a user and
5875: -- security profile pair. Generally speaking, the static
5876: -- user lists will only be cached when it is known that
5877: -- this user is in the list of users to build static
5878: -- lists for AND they have rows in per_position_list.
5879: --
5880: IF g_dbg THEN op(l_proc, 20); END IF;
5881:
5882: IF NVL(p_top_position_method, 'S') = 'U' THEN
6611: IF g_dbg THEN op(l_proc, 30); END IF;
6612:
6613: SELECT ppl.position_id
6614: INTO l_position_id
6615: FROM per_position_list ppl
6616: WHERE ppl.user_id IS NOT NULL
6617: AND ppl.security_profile_id IS NOT NULL
6618: AND ppl.user_id = p_user_id
6619: AND ppl.security_profile_id = p_security_profile_id
6834:
6835: IF p_user_id IS NOT NULL AND p_security_profile_id IS NOT NULL THEN
6836:
6837: --
6838: -- Delete all positions in per_position_list for this user
6839: -- and this security profile.
6840: --
6841: IF g_dbg THEN op(l_proc, 20); END IF;
6842:
6839: -- and this security profile.
6840: --
6841: IF g_dbg THEN op(l_proc, 20); END IF;
6842:
6843: DELETE FROM per_position_list ppl
6844: WHERE ppl.user_id IS NOT NULL
6845: AND ppl.security_profile_id IS NOT NULL
6846: AND ppl.user_id = p_user_id
6847: AND ppl.security_profile_id = p_security_profile_id;
7120: -- delete_pos_list_for_user) prior to insertion.
7121: --
7122: IF g_dbg THEN op(l_proc||'('||to_char(i)||'):'); END IF;
7123:
7124: INSERT INTO per_position_list
7125: (security_profile_id
7126: ,position_id
7127: ,user_id
7128: ,request_id
7553: -- This is done dynamically because:
7554: -- a) user-based pos security or user-based org security
7555: -- is in use and the user does not have their permissions
7556: -- stored in static tables, or
7557: -- b) the per_position_list table is not to be used.
7558: --
7559: IF NOT p_use_static_lists
7560: OR ((NVL(p_sec_prof_rec.top_position_method, 'S') = 'U' OR
7561: NVL(p_sec_prof_rec.top_organization_method, 'S') = 'U')
9060: -- Position List.
9061: --
9062: IF g_dbg THEN op(l_proc, 30); END IF;
9063:
9064: DELETE FROM per_position_list ppl
9065: WHERE ppl.user_id IS NOT NULL
9066: AND ppl.security_profile_id IS NOT NULL
9067: AND ppl.user_id = p_user_id
9068: AND ppl.security_profile_id = p_security_profile_id;
9229: hr_utility.set_location(l_proc,50);
9230: --
9231: -- Changes 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date track position req.
9232: --
9233: DELETE FROM per_position_list pol
9234: WHERE EXISTS ( SELECT ''
9235: FROM hr_all_positions_f pos
9236: WHERE pos.position_id = pol.position_id
9237: AND pos.business_group_id = p_business_group_id);
9369: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.ADD_POS_TO_SECURITY_LIST';
9370: --
9371: begin
9372: --
9373: insert into per_position_list
9374: (security_profile_id, position_id)
9375: values (p_Security_Profile_Id, p_position_id);
9376: --
9377: end add_pos_to_security_list;
9386: --
9387: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_POS_FROM_SECURITY_LIST';
9388: begin
9389: hr_utility.set_location('Entering:'|| l_proc, 10);
9390: DELETE FROM PER_POSITION_LIST
9391: WHERE position_id = p_position_Id;
9392: exception
9393: when NO_DATA_FOUND then
9394: hr_utility.set_location(l_proc, 20);