[Home] [Help]
53: -- Restrict access to payrolls.
54: --
55: insert into pay_payroll_list (payroll_id, security_profile_id)
56: select p_payroll_id, psp.security_profile_id
57: from per_security_profiles psp
58: where psp.view_all_flag <> 'Y'
59: and (( psp.view_all_payrolls_flag <> 'Y'
60: and business_group_id = p_business_group_id)
61: or ( psp.view_all_payrolls_flag <> 'Y'
95: ,program_application_id, program_id
96: ,program_update_date)
97: select p_person_id, psp.security_profile_id, l_req_id, l_appl_id,
98: l_prog_id, l_upd_date
99: from per_security_profiles psp
100: where psp.view_all_flag <> 'Y'
101: and (((psp.view_all_contacts_flag <> 'Y' or
102: (psp.view_all_contacts_flag = 'Y' and
103: psp.view_all_candidates_flag = 'X')) and
161: ,PROGRAM_ID
162: ,PROGRAM_UPDATE_DATE)
163: select p_person_id, psp.security_profile_id, l_request_id,
164: l_program_application_id, l_program_id, l_update_date
165: from per_security_profiles psp
166: where psp.view_all_flag <> 'Y'
167: and ((
168: ( (psp.view_all_organizations_flag <> 'Y' and
169: nvl(psp.top_organization_method, 'S') <> 'U')
372: --
373: l_collection_index number:=0;
374:
375: -- This is used as a temp variable to collect the values for each Select Sql.
376: TYPE l_security_profie_type_temp IS TABLE OF per_security_profiles.security_profile_id%TYPE INDEX BY BINARY_INTEGER;
377: l_security_profie_table_temp l_security_profie_type_temp;
378:
379: -- This is used to store all the Records which need to be inserted after the
380: -- completion of the bulk select.
377: l_security_profie_table_temp l_security_profie_type_temp;
378:
379: -- This is used to store all the Records which need to be inserted after the
380: -- completion of the bulk select.
381: TYPE l_security_profie_type IS TABLE OF per_security_profiles.security_profile_id%TYPE INDEX BY BINARY_INTEGER;
382: l_security_profie_table l_security_profie_type;
383:
384: -- This procedure is used to populate the final copy of the PL/Sql table
385: -- before inserting the records in the table.
546: if g_debug then
547: hr_utility.set_location(l_proc, 40);
548: end if;
549: --
550: l_from_str := ' from per_security_profiles sec,
551: per_organization_list org ';
552: --
553: l_cond_str := ' org.security_profile_id = sec.security_profile_id
554: and org.organization_id = :l_organization_id
637: if g_debug then
638: hr_utility.set_location(l_proc, 70);
639: end if;
640: --
641: l_from_str := ' from per_security_profiles sec ';
642: --
643: l_cond_str := ' sec.view_all_organizations_flag = :l_all
644: and ((sec.view_all_positions_flag = :l_Restrict
645: and nvl(sec.top_position_method, :l_S) <> :l_U)
731: if g_debug then
732: hr_utility.set_location(l_proc, 100);
733: end if;
734: --
735: l_from_str := ' from per_security_profiles sec ';
736: --
737: l_cond_str := ' sec.view_all_organizations_flag = :l_all
738: and sec.view_all_positions_flag = :l_all
739: and sec.view_all_payrolls_flag = :l_all
825: if g_debug then
826: hr_utility.set_location(l_proc, 130);
827: end if;
828: --
829: l_from_str := ' from per_security_profiles sec,
830: pay_payroll_list pay,
831: per_organization_list org ';
832: --
833: l_cond_str := ' org.security_profile_id = sec.security_profile_id
923: if g_debug then
924: hr_utility.set_location(l_proc, 160);
925: end if;
926: --
927: l_from_str := ' from per_security_profiles sec,
928: per_organization_list org ';
929: --
930: l_cond_str := ' org.security_profile_id = sec.security_profile_id
931: and org.organization_id = :l_organization_id
1016: if g_debug then
1017: hr_utility.set_location(l_proc, 190);
1018: end if;
1019: --
1020: l_from_str := ' from per_security_profiles sec,
1021: pay_payroll_list pay ';
1022: --
1023: l_cond_str := ' pay.security_profile_id = sec.security_profile_id
1024: and pay.payroll_id = :l_payroll_id
1103: if g_debug then
1104: hr_utility.set_location(l_proc, 220);
1105: end if;
1106: --
1107: l_from_str := ' from per_security_profiles sec ';
1108: --
1109: l_cond_str := ' sec.view_all_organizations_flag = :l_all
1110: and sec.view_all_payrolls_flag = :l_all
1111: and sec.view_all_positions_flag = :l_Restrict
1206: if g_debug then
1207: hr_utility.set_location(l_proc, 250);
1208: end if;
1209: --
1210: l_from_str := ' from per_security_profiles sec ';
1211: --
1212: l_cond_str := ' sec.view_all_organizations_flag = :l_all
1213: and sec.view_all_positions_flag = :l_all
1214: and sec.view_all_payrolls_flag = :l_all
1309: if g_debug then
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
1420: if g_debug then
1421: hr_utility.set_location(l_proc, 310);
1422: end if;
1423: --
1424: l_from_str := ' from per_security_profiles sec,
1425: per_organization_list org ';
1426: --
1427: l_cond_str := ' org.security_profile_id = sec.security_profile_id
1428: and org.organization_id = :l_organization_id
1518: if g_debug then
1519: hr_utility.set_location(l_proc, 340);
1520: end if;
1521: --
1522: l_from_str := ' from per_security_profiles sec ';
1523: --
1524: l_cond_str := ' sec.view_all_organizations_flag = :l_all
1525: and sec.view_all_positions_flag = :l_all
1526: and sec.view_all_payrolls_flag = :l_Restrict and ';
1609: if g_debug then
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
1715: if g_debug then
1716: hr_utility.set_location(l_proc, 400);
1717: end if;
1718: --
1719: l_from_str := ' from per_security_profiles sec ';
1720: --
1721: l_cond_str := ' sec.view_all_organizations_flag = :l_all
1722: and sec.view_all_positions_flag = :l_all
1723: and sec.view_all_payrolls_flag = :l_all
1814: if g_debug then
1815: hr_utility.set_location(l_proc, 430);
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: --
1934: if g_debug then
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
2047: if g_debug then
2048: hr_utility.set_location(l_proc, 490);
2049: end if;
2050: --
2051: l_from_str := ' from per_security_profiles sec,
2052: pay_payroll_list pay,
2053: per_organization_list org ';
2054: --
2055: l_cond_str := ' org.security_profile_id = sec.security_profile_id
2154: if g_debug then
2155: hr_utility.set_location(l_proc, 520);
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
2262: if g_debug then
2263: hr_utility.set_location(l_proc, 550);
2264: end if;
2265: --
2266: l_from_str := ' from per_security_profiles sec,
2267: per_organization_list org ';
2268: --
2269: l_cond_str := ' org.security_profile_id = sec.security_profile_id
2270: and org.organization_id = :l_organization_id
2365: if g_debug then
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
2467: if g_debug then
2468: hr_utility.set_location(l_proc, 610);
2469: end if;
2470: --
2471: l_from_str := ' from per_security_profiles sec,
2472: pay_payroll_list pay ';
2473: --
2474: l_cond_str := ' pay.security_profile_id = sec.security_profile_id
2475: and pay.payroll_id = :l_payroll_id
2568: if g_debug then
2569: hr_utility.set_location(l_proc, 640);
2570: end if;
2571: --
2572: l_from_str := ' from per_security_profiles sec ';
2573: --
2574: l_cond_str := ' sec.view_all_organizations_flag = :l_all
2575: and sec.view_all_positions_flag = :l_all
2576: and sec.view_all_payrolls_flag = :l_all
2660: if g_debug then
2661: hr_utility.set_location(l_proc, 670);
2662: end if;
2663: --
2664: l_from_str := ' from per_security_profiles sec ';
2665: --
2666: l_cond_str := ' sec.view_all_organizations_flag = :l_all
2667: and sec.view_all_positions_flag = :l_all
2668: and sec.view_all_payrolls_flag = :l_all
4509: l_proc VARCHAR2(72) := g_package||'add_people_to_cache';
4510: l_org_restriction VARCHAR2(1) := 'N';
4511: l_pos_restriction VARCHAR2(1) := 'N';
4512: l_pay_restriction VARCHAR2(1) := 'N';
4513: l_custom_per per_security_profiles.custom_restriction_flag%TYPE;
4514: l_temp_asg_tbl g_number_t;
4515: l_temp_per_tbl g_number_t;
4516: l_ex_emp_security varchar2(1) := 'N';
4517: --
8385: WHERE ou.business_group_id = p_business_group_id
8386: and ou.organization_id = ol.organization_id);
8387: --
8388: hr_utility.set_location('hr_delete.delete_security_list_for_bg',7);
8389: DELETE FROM per_security_profiles psp
8390: WHERE psp.business_group_id = p_business_group_id
8391: AND psp.view_all_flag = 'N';
8392: --
8393: hr_utility.set_location('hr_delete.delete_security_list_for_bg',8);
8402: --
8403: hr_utility.set_location('hr_delete.delete_security_list_for_bg',9);
8404: DELETE FROM per_security_users psu
8405: WHERE psu.security_profile_id IN (SELECT sp.security_profile_id
8406: FROM per_security_profiles sp
8407: WHERE sp.business_group_id = p_business_group_id);
8408: --
8409: END delete_security_list_for_bg;
8410: --