eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PYUCSLIS_PKG dependencies on PER_SECURITY_PROFILES

Line 53: per_security_profiles psp

49: distinct ppl.security_profile_id, pcr.contact_person_id,
50: l_req_id, l_appl_id, l_prog_id, l_upd_date
51: from per_contact_relationships pcr,
52: per_person_list_stage ppl,
53: per_security_profiles psp
54: where ppl.person_id = p_person_id
55: and ppl.security_profile_id = psp.security_profile_id
56: and (psp.view_all_contacts_flag = 'N' or
57: (psp.view_all_contacts_flag = 'Y' and

Line 90: per_security_profiles psp

86: distinct ppl.security_profile_id, pcr.contact_person_id,
87: l_req_id, l_appl_id, l_prog_id, l_upd_date
88: from per_contact_relationships pcr,
89: per_person_list ppl,
90: per_security_profiles psp
91: where ppl.person_id = p_person_id
92: and ppl.security_profile_id = psp.security_profile_id
93: and (psp.view_all_contacts_flag = 'N' or
94: (psp.view_all_contacts_flag = 'Y' and

Line 174: from per_security_profiles psp

170: -- Cursor for p_generation_scope = 'ALL_BUS_GRP'
171: cursor csr_get_sec_profs_bg is
172: select psp.security_profile_id,
173: psp.business_group_id
174: from per_security_profiles psp
175: where (psp.view_all_contacts_flag = 'N' or
176: (psp.view_all_contacts_flag = 'Y' and
177: psp.view_all_candidates_flag = 'X'))
178: and (nvl(psp.top_organization_method, 'S') <> 'U' and

Line 187: from per_security_profiles psp

183: -- Cursor for p_generation_scope <> 'ALL_BUS_GRP'
184: cursor csr_get_sec_profs is
185: select psp.security_profile_id,
186: psp.business_group_id
187: from per_security_profiles psp
188: where (psp.view_all_contacts_flag = 'N' or
189: (psp.view_all_contacts_flag = 'Y' and
190: psp.view_all_candidates_flag = 'X'))
191: and (nvl(psp.top_organization_method, 'S') <> 'U' and

Line 589: FROM per_security_profiles s

585: p_request_id,
586: p_program_application_id,
587: p_program_id,
588: l_update_date
589: FROM per_security_profiles s
590: WHERE s.security_profile_id = l_security_profile_id
591: AND NOT EXISTS
592: (SELECT NULL
593: FROM per_organization_list b

Line 980: per_security_profiles psp

976: program_update_date, person_id)
977: select distinct psp.security_profile_id, l_req_id, l_appl_id,
978: l_prog_id, l_upd_date, papf.person_id
979: from per_all_people_f papf,
980: per_security_profiles psp
981: where psp.security_profile_id = p_security_profile_id
982: and (psp.business_group_id = papf.business_group_id or
983: psp.business_group_id is null)
984: and not exists

Line 1013: per_security_profiles psp

1009: program_update_date, person_id)
1010: select distinct psp.security_profile_id, l_req_id, l_appl_id,
1011: l_prog_id, l_upd_date, papf.person_id
1012: from per_all_people_f papf,
1013: per_security_profiles psp
1014: where psp.security_profile_id = p_security_profile_id
1015: and (psp.business_group_id = papf.business_group_id or
1016: psp.business_group_id is null)
1017: and not exists

Line 1159: sec_rec - Row in per_security_profiles for current profile

1155: DESCRIPTION
1156: populates the per_person_list using dynamic sql
1157: PARAMETERS
1158: Few parameters are needed due it inheriting from the parent function
1159: sec_rec - Row in per_security_profiles for current profile
1160: ========================================================================= */
1161: --
1162:
1163: PROCEDURE create_person_list(sec_rec PER_SECURITY_PROFILES%ROWTYPE,

Line 1163: PROCEDURE create_person_list(sec_rec PER_SECURITY_PROFILES%ROWTYPE,

1159: sec_rec - Row in per_security_profiles for current profile
1160: ========================================================================= */
1161: --
1162:
1163: PROCEDURE create_person_list(sec_rec PER_SECURITY_PROFILES%ROWTYPE,
1164: p_effective_date date,
1165: p_update_date date,
1166: p_who_to_process varchar2)
1167: IS

Line 1215: PROCEDURE add_comm_str ( p_sec_rec IN PER_SECURITY_PROFILES%ROWTYPE ) as

1211: hr_utility.set_location('Leaveing execute_statement',10);
1212: END execute_statement;
1213:
1214: /*-- for the bug 5214715 --*/
1215: PROCEDURE add_comm_str ( p_sec_rec IN PER_SECURITY_PROFILES%ROWTYPE ) as
1216: l_restriction_flags varchar2(2000);
1217: l_exclude_flags varchar2(2000);
1218: BEGIN
1219: hr_utility.set_location('Entering add_comm_str',10);

Line 1303: ,p_sec_rec IN PER_SECURITY_PROFILES%ROWTYPE)

1299: -- ,p_from_clause IN VARCHAR2
1300: --- ,p_generation_scope IN VARCHAR2
1301: -- ,p_business_group_id IN NUMBER
1302: -- ,p_assignment_type IN VARCHAR2
1303: ,p_sec_rec IN PER_SECURITY_PROFILES%ROWTYPE)
1304: AS
1305:
1306: BEGIN
1307: hr_utility.set_location('Entering init_statement',10);

Line 1600: (select ''X'' from per_security_profiles pspf

1596: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
1597: l_del_str := ' delete from per_person_list_stage ppl where
1598: ppl.person_id = :p_person_id
1599: and ppl.granted_user_id is null and exists
1600: (select ''X'' from per_security_profiles pspf
1601: where pspf.security_profile_id = ppl.security_profile_id ';
1602: else
1603: l_del_str := ' delete from per_person_list ppl where
1604: ppl.person_id = :p_person_id

Line 1606: (select ''X'' from per_security_profiles pspf

1602: else
1603: l_del_str := ' delete from per_person_list ppl where
1604: ppl.person_id = :p_person_id
1605: and ppl.granted_user_id is null and exists
1606: (select ''X'' from per_security_profiles pspf
1607: where pspf.security_profile_id = ppl.security_profile_id ';
1608: end if;
1609: -- Bug6809753 - end
1610:

Line 1617: (select 'X' from per_security_profiles pspf

1613: /* Commented Bug6809753 - start
1614: delete from per_person_list ppl where
1615: ppl.person_id = p_person_id
1616: and ppl.granted_user_id is null and exists
1617: (select 'X' from per_security_profiles pspf
1618: where pspf.security_profile_id = ppl.security_profile_id
1619: and pspf.business_group_id = p_business_group_id);
1620: Commented Bug6809753 - end */
1621:

Line 1633: (select 'X' from per_security_profiles pspf

1629: /* Commented Bug6809753 - start
1630: delete from per_person_list ppl where
1631: ppl.person_id = p_person_id
1632: and ppl.granted_user_id is null and exists
1633: (select 'X' from per_security_profiles pspf
1634: where pspf.security_profile_id = ppl.security_profile_id
1635: and pspf.business_group_id is null);
1636: Commented Bug6809753 - end */
1637:

Line 1649: (select 'X' from per_security_profiles pspf

1645: /* Commented Bug6809753 - start
1646: delete from per_person_list ppl where
1647: ppl.person_id = p_person_id
1648: and ppl.granted_user_id is null and exists
1649: (select 'X' from per_security_profiles pspf
1650: where pspf.security_profile_id = ppl.security_profile_id);
1651: Commented Bug6809753 - end */
1652:
1653: -- Bug6809753 - start

Line 1671: -- I've restricted the scan of PER_SECURITY_PROFILES to restricted

1667: end if;
1668:
1669: -- Clear records for the contacts of this person
1670: -- 2906862 - dkerr 2003-05-01
1671: -- I've restricted the scan of PER_SECURITY_PROFILES to restricted
1672: -- contact profiles - which can drastically reduce the amount of I/O
1673: -- performed.
1674: -- Analysis of major customer data suggests the following :
1675: -- 1. Security profiles with "view_all_contacts_flag='N'"

Line 1688: from per_security_profiles pspf

1684:
1685: delete from per_person_list ppl
1686: where ppl.security_profile_id in
1687: (select pspf.security_profile_id
1688: from per_security_profiles pspf
1689: where (pspf.view_all_contacts_flag = 'N' or
1690: (pspf.view_all_contacts_flag = 'Y' and
1691: pspf.view_all_candidates_flag = 'X'))
1692: and pspf.business_group_id = p_business_group_id

Line 1714: from per_security_profiles pspf

1710: if p_generation_scope = 'ALL_GLOBAL' then
1711: delete from per_person_list ppl
1712: where ppl.security_profile_id in
1713: (select pspf.security_profile_id
1714: from per_security_profiles pspf
1715: where (pspf.view_all_contacts_flag = 'N' or
1716: (pspf.view_all_contacts_flag = 'Y' and
1717: pspf.view_all_candidates_flag = 'X'))
1718: and pspf.business_group_id is null

Line 1738: from per_security_profiles pspf

1734: if p_generation_scope = 'ALL_PROFILES' then
1735: delete from per_person_list ppl
1736: where ppl.security_profile_id in
1737: (select pspf.security_profile_id
1738: from per_security_profiles pspf
1739: where (pspf.view_all_contacts_flag = 'N' or
1740: (pspf.view_all_contacts_flag = 'Y' and
1741: pspf.view_all_candidates_flag = 'X'))
1742: )

Line 1769: from per_security_profiles pspf

1765:
1766: l_del_str := ' delete from per_person_list ppl
1767: where ppl.security_profile_id in
1768: (select pspf.security_profile_id
1769: from per_security_profiles pspf
1770: where (pspf.view_all_contacts_flag = ''N'' or
1771: (pspf.view_all_contacts_flag = ''Y'' and
1772: pspf.view_all_candidates_flag = ''X''))
1773: and pspf.business_group_id = :p_business_group_id )

Line 1799: from per_security_profiles pspf

1795: if p_generation_scope = 'ALL_GLOBAL' then
1796: l_del_str := ' delete from per_person_list ppl
1797: where ppl.security_profile_id in
1798: (select pspf.security_profile_id
1799: from per_security_profiles pspf
1800: where (pspf.view_all_contacts_flag = ''N'' or
1801: (pspf.view_all_contacts_flag = ''Y'' and
1802: pspf.view_all_candidates_flag = ''X''))
1803: and pspf.business_group_id is null )

Line 1829: from per_security_profiles pspf

1825: if p_generation_scope = 'ALL_PROFILES' then
1826: l_del_str := ' delete from per_person_list ppl
1827: where ppl.security_profile_id in
1828: (select pspf.security_profile_id
1829: from per_security_profiles pspf
1830: where (pspf.view_all_contacts_flag = ''N'' or
1831: (pspf.view_all_contacts_flag = ''Y'' and
1832: pspf.view_all_candidates_flag = ''X'')))
1833: and ppl.person_id in (

Line 1883: from per_security_profiles pspf

1879: hr_utility.set_location(l_proc||' using stage table',14);
1880: delete from per_person_list_stage ppl
1881: where ppl.security_profile_id in
1882: (select pspf.security_profile_id
1883: from per_security_profiles pspf
1884: where (pspf.view_all_contacts_flag = 'N' or
1885: (pspf.view_all_contacts_flag = 'Y' and
1886: pspf.view_all_candidates_flag = 'X')))
1887: /* and ppl.person_id in

Line 1907: from per_security_profiles pspf

1903: hr_utility.set_location(l_proc||' using actual table',18);
1904: delete from per_person_list ppl
1905: where ppl.security_profile_id in
1906: (select pspf.security_profile_id
1907: from per_security_profiles pspf
1908: where (pspf.view_all_contacts_flag = 'N' or
1909: (pspf.view_all_contacts_flag = 'Y' and
1910: pspf.view_all_candidates_flag = 'X')))
1911: /* and ppl.person_id in

Line 1932: from per_security_profiles pspf

1928: else
1929: delete from per_person_list ppl
1930: where ppl.security_profile_id in
1931: (select pspf.security_profile_id
1932: from per_security_profiles pspf
1933: where (pspf.view_all_contacts_flag = 'N' or
1934: (pspf.view_all_contacts_flag = 'Y' and
1935: pspf.view_all_candidates_flag = 'X')))
1936: and ppl.person_id in

Line 2217: TYPE l_security_profile_type IS TABLE OF per_security_profiles.security_profile_id%TYPE INDEX BY BINARY_INTEGER;

2213:
2214:
2215: -- Code changes for bug 8691129 Start
2216:
2217: TYPE l_security_profile_type IS TABLE OF per_security_profiles.security_profile_id%TYPE INDEX BY BINARY_INTEGER;
2218: l_security_profile_table l_security_profile_type;
2219: l_c_security_profile_table l_security_profile_type;
2220: l_d_security_profile_table l_security_profile_type;
2221: l_security_profile_table_temp l_security_profile_type;

Line 2371: l_from_str := ' from per_security_profiles sec,

2367: begin
2368: if g_debug then
2369: hr_utility.set_location(l_proc, 40);
2370: end if;
2371: l_from_str := ' from per_security_profiles sec,
2372: per_organization_list org ';
2373: -- Modified for bug 11737636
2374: l_cond_str := ' org.security_profile_id = sec.security_profile_id
2375: and org.organization_id = :l_organization_id

Line 2457: l_from_str := ' from per_security_profiles sec ';

2453: begin
2454: if g_debug then
2455: hr_utility.set_location(l_proc, 70);
2456: end if;
2457: l_from_str := ' from per_security_profiles sec ';
2458: -- Modified for 11737636
2459: l_cond_str := ' sec.view_all_organizations_flag = :l_all
2460: and ((sec.view_all_positions_flag = :l_Restrict
2461: and nvl(sec.top_position_method, :l_S) <> :l_U)

Line 2537: l_from_str := ' from per_security_profiles sec ';

2533: begin
2534: if g_debug then
2535: hr_utility.set_location(l_proc, 100);
2536: end if;
2537: l_from_str := ' from per_security_profiles sec ';
2538: l_cond_str := ' sec.view_all_organizations_flag = :l_all
2539: and sec.view_all_positions_flag = :l_all
2540: and sec.view_all_payrolls_flag = :l_all
2541: and sec.custom_restriction_flag = :l_all

Line 2615: l_from_str := ' from per_security_profiles sec,

2611: begin
2612: if g_debug then
2613: hr_utility.set_location(l_proc, 130);
2614: end if;
2615: l_from_str := ' from per_security_profiles sec,
2616: pay_payroll_list pay,
2617: per_organization_list org ';
2618: l_cond_str := ' org.security_profile_id = sec.security_profile_id
2619: and pay.security_profile_id = sec.security_profile_id

Line 2699: l_from_str := ' from per_security_profiles sec,

2695: begin
2696: if g_debug then
2697: hr_utility.set_location(l_proc, 160);
2698: end if;
2699: l_from_str := ' from per_security_profiles sec,
2700: per_organization_list org ';
2701: l_cond_str := ' org.security_profile_id = sec.security_profile_id
2702: and org.organization_id = :l_organization_id
2703: and sec.view_all_organizations_flag = :l_Restrict

Line 2777: l_from_str := ' from per_security_profiles sec,

2773: begin
2774: if g_debug then
2775: hr_utility.set_location(l_proc, 190);
2776: end if;
2777: l_from_str := ' from per_security_profiles sec,
2778: pay_payroll_list pay ';
2779: l_cond_str := ' pay.security_profile_id = sec.security_profile_id
2780: and pay.payroll_id = :l_payroll_id
2781: and sec.view_all_organizations_flag = :l_all

Line 2850: l_from_str := ' from per_security_profiles sec ';

2846: begin
2847: if g_debug then
2848: hr_utility.set_location(l_proc, 220);
2849: end if;
2850: l_from_str := ' from per_security_profiles sec ';
2851: l_cond_str := ' sec.view_all_organizations_flag = :l_all
2852: and sec.view_all_payrolls_flag = :l_all
2853: and sec.view_all_positions_flag = :l_Restrict
2854: and nvl(sec.top_position_method, :l_S) <> :l_U

Line 2936: l_from_str := ' from per_security_profiles sec ';

2932: begin
2933: if g_debug then
2934: hr_utility.set_location(l_proc, 250);
2935: end if;
2936: l_from_str := ' from per_security_profiles sec ';
2937: l_cond_str := ' sec.view_all_organizations_flag = :l_all
2938: and sec.view_all_positions_flag = :l_all
2939: and sec.view_all_payrolls_flag = :l_all
2940: and sec.custom_restriction_flag = :l_all

Line 3021: l_from_str := ' from per_security_profiles sec,

3017: begin
3018: if g_debug then
3019: hr_utility.set_location(l_proc, 280);
3020: end if;
3021: l_from_str := ' from per_security_profiles sec,
3022: per_position_list posl,
3023: per_organization_list org ';
3024: -- Modified for bug 11737636
3025: l_cond_str := ' org.security_profile_id = sec.security_profile_id

Line 3121: l_from_str := ' from per_security_profiles sec,

3117: begin
3118: if g_debug then
3119: hr_utility.set_location(l_proc, 310);
3120: end if;
3121: l_from_str := ' from per_security_profiles sec,
3122: per_organization_list org ';
3123: -- Changed for bug 11737636
3124: l_cond_str := ' org.security_profile_id = sec.security_profile_id
3125: and org.organization_id = :l_organization_id

Line 3210: l_from_str := ' from per_security_profiles sec ';

3206: begin
3207: if g_debug then
3208: hr_utility.set_location(l_proc, 340);
3209: end if;
3210: l_from_str := ' from per_security_profiles sec ';
3211: -- Changed for bug 11737636
3212: l_cond_str := ' sec.view_all_organizations_flag = :l_all
3213: and sec.view_all_positions_flag = :l_all
3214: and sec.view_all_payrolls_flag <> :l_Restrict and ';

Line 3288: l_from_str := ' from per_security_profiles sec,

3284: begin
3285: if g_debug then
3286: hr_utility.set_location(l_proc, 370);
3287: end if;
3288: l_from_str := ' from per_security_profiles sec,
3289: per_position_list posl ';
3290: --Modified for bug 11737636
3291: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
3292: and posl.position_id = :l_position_id

Line 3382: l_from_str := ' from per_security_profiles sec ';

3378: begin
3379: if g_debug then
3380: hr_utility.set_location(l_proc, 400);
3381: end if;
3382: l_from_str := ' from per_security_profiles sec ';
3383: l_cond_str := ' sec.view_all_organizations_flag = :l_all
3384: and sec.view_all_positions_flag = :l_all
3385: and sec.view_all_payrolls_flag = :l_all
3386: and sec.custom_restriction_flag = :l_all

Line 3466: l_from_str := ' from per_security_profiles sec,

3462: begin
3463: if g_debug then
3464: hr_utility.set_location(l_proc, 430);
3465: end if;
3466: l_from_str := ' from per_security_profiles sec,
3467: pay_payroll_list pay,
3468: per_position_list posl,
3469: per_organization_list org ';
3470: l_cond_str := ' org.security_profile_id = sec.security_profile_id

Line 3571: l_from_str := ' from per_security_profiles sec,

3567: begin
3568: if g_debug then
3569: hr_utility.set_location(l_proc, 460);
3570: end if;
3571: l_from_str := ' from per_security_profiles sec,
3572: per_position_list posl,
3573: per_organization_list org ';
3574: l_cond_str := ' org.security_profile_id = sec.security_profile_id
3575: and posl.security_profile_id = sec.security_profile_id

Line 3669: l_from_str := ' from per_security_profiles sec,

3665: begin
3666: if g_debug then
3667: hr_utility.set_location(l_proc, 490);
3668: end if;
3669: l_from_str := ' from per_security_profiles sec,
3670: pay_payroll_list pay,
3671: per_organization_list org ';
3672: l_cond_str := ' org.security_profile_id = sec.security_profile_id
3673: and pay.security_profile_id = sec.security_profile_id

Line 3761: l_from_str := ' from per_security_profiles sec,

3757: begin
3758: if g_debug then
3759: hr_utility.set_location(l_proc, 520);
3760: end if;
3761: l_from_str := ' from per_security_profiles sec,
3762: pay_payroll_list pay,
3763: per_position_list posl ';
3764: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
3765: and pay.security_profile_id = sec.security_profile_id

Line 3854: l_from_str := ' from per_security_profiles sec,

3850: begin
3851: if g_debug then
3852: hr_utility.set_location(l_proc, 550);
3853: end if;
3854: l_from_str := ' from per_security_profiles sec,
3855: per_organization_list org ';
3856: l_cond_str := ' org.security_profile_id = sec.security_profile_id
3857: and org.organization_id = :l_organization_id
3858: and sec.view_all_organizations_flag = :l_Restrict

Line 3942: l_from_str := ' from per_security_profiles sec,

3938: begin
3939: if g_debug then
3940: hr_utility.set_location(l_proc, 580);
3941: end if;
3942: l_from_str := ' from per_security_profiles sec,
3943: per_position_list posl ';
3944: l_cond_str := ' posl.security_profile_id = sec.security_profile_id
3945: and posl.position_id = :l_position_id
3946: and sec.view_all_organizations_flag = :l_all

Line 4029: l_from_str := ' from per_security_profiles sec,

4025: begin
4026: if g_debug then
4027: hr_utility.set_location(l_proc, 610);
4028: end if;
4029: l_from_str := ' from per_security_profiles sec,
4030: pay_payroll_list pay ';
4031: l_cond_str := ' pay.security_profile_id = sec.security_profile_id
4032: and pay.payroll_id = :l_payroll_id
4033: and sec.view_all_organizations_flag = :l_all

Line 4111: l_from_str := ' from per_security_profiles sec ';

4107: begin
4108: if g_debug then
4109: hr_utility.set_location(l_proc, 640);
4110: end if;
4111: l_from_str := ' from per_security_profiles sec ';
4112: l_cond_str := ' sec.view_all_organizations_flag = :l_all
4113: and sec.view_all_positions_flag = :l_all
4114: and sec.view_all_payrolls_flag = :l_all
4115: and sec.custom_restriction_flag = :l_all

Line 4185: l_from_str := ' from per_security_profiles sec ';

4181: begin
4182: if g_debug then
4183: hr_utility.set_location(l_proc, 670);
4184: end if;
4185: l_from_str := ' from per_security_profiles sec ';
4186: l_cond_str := ' sec.view_all_organizations_flag = :l_all
4187: and sec.view_all_positions_flag = :l_all
4188: and sec.view_all_payrolls_flag = :l_all
4189: and sec.custom_restriction_flag = :l_all

Line 4382: from per_security_profiles pspf

4378: SAVE EXCEPTIONS
4379: Delete from per_person_list ppl
4380: where ppl.security_profile_id in
4381: (select pspf.security_profile_id
4382: from per_security_profiles pspf
4383: where pspf.security_profile_id = l_d_security_profile_table(per_rec) and
4384: (pspf.view_all_contacts_flag = 'N' or
4385: (pspf.view_all_contacts_flag = 'Y' and
4386: pspf.view_all_candidates_flag = 'X'))

Line 4462: (select 'X' from per_security_profiles pspf

4458: select security_profile_id bulk collect into l_c_security_profile_table
4459: from per_person_list ppl where
4460: ppl.person_id = p_person_id
4461: and ppl.granted_user_id is null and exists
4462: (select 'X' from per_security_profiles pspf
4463: where pspf.security_profile_id = ppl.security_profile_id);
4464:
4465:
4466: hr_utility.set_location('Current list',1);

Line 4571: from per_security_profiles pspf

4567:
4568: delete from per_person_list ppl
4569: where ppl.security_profile_id in
4570: (select pspf.security_profile_id
4571: from per_security_profiles pspf
4572: where (pspf.view_all_contacts_flag = 'N' or
4573: (pspf.view_all_contacts_flag = 'Y' and
4574: pspf.view_all_candidates_flag = 'X'))
4575: )

Line 4835: from per_security_profiles

4831: l_proc varchar2(72) := g_package||'.generate_opp_lists';
4832: --
4833: cursor security_profiles is
4834: select *
4835: from per_security_profiles
4836: where ((business_group_id = p_business_group_id and
4837: p_generation_scope = 'ALL_BUS_GRP')
4838: or (business_group_id is null and
4839: p_generation_scope = 'ALL_GLOBAL')

Line 5196: l_sec_prof_rec hr_security_internal.g_sec_prof_r; -- per_security_profiles

5192: l_debug boolean default FALSE;
5193: l_process_all_users boolean := TRUE; -- as just running for one user.
5194: l_user_id number;
5195: l_security_profile_id number;
5196: l_sec_prof_rec hr_security_internal.g_sec_prof_r; -- per_security_profiles
5197: -- %ROWTYPE;
5198: -- Cursors:
5199: --
5200: -- check that user and profile exist in per_security_users

Line 5215: from per_security_profiles

5211: --
5212: CURSOR csr_security_profile_record(l_security_profile_id number)
5213: IS
5214: SELECT *
5215: from per_security_profiles
5216: where security_profile_id = l_security_profile_id;
5217: --
5218: BEGIN
5219: --

Line 5291: l_security_profile_name per_security_profiles.security_profile_name%TYPE;

5287: l_business_group_id number;
5288: l_security_profile_id number;
5289: l_action_parameter_group_id number;
5290: l_user_id number;
5291: l_security_profile_name per_security_profiles.security_profile_name%TYPE;
5292: l_logging pay_action_parameters.parameter_value%TYPE;
5293: l_request_id number;
5294: l_effective_date varchar2(50);
5295: l_update_date date;

Line 5326: FROM per_security_profiles

5322:
5323: CURSOR security_profiles
5324: IS
5325: SELECT *
5326: FROM per_security_profiles
5327: WHERE ( (business_group_id = p_business_group_id and
5328: p_generation_scope = 'ALL_BUS_GRP')
5329: OR
5330: (business_group_id is null and

Line 5830: from per_security_profiles

5826: where pap.parameter_name = 'LOGGING';
5827: --
5828: cursor security_profiles is
5829: select *
5830: from per_security_profiles
5831: where (((security_profile_id = p_security_profile_id or
5832: security_profile_name = p_security_profile_name)
5833: and p_generation_scope in ('SINGLE_PROF','SINGLE_USER'))
5834: or (business_group_id = p_business_group_id and

Line 6538: from per_security_profiles_v pspv

6534: --
6535: -- Get all security profiles excluding the view_all profiles.
6536: cursor csr_security_prof is
6537: select pspv.*
6538: from per_security_profiles_v pspv
6539: where pspv.view_all_flag = 'N'
6540: and pspv.view_all_candidates_flag <> p_profile_option;
6541: --
6542: begin

Line 6559: per_security_profiles_pkg.lock_row(

6555: begin
6556: --
6557: hr_utility.set_location(l_proc, 30);
6558: -- Get the lock of the respective security profile record.
6559: per_security_profiles_pkg.lock_row(
6560: x_rowid => r_sec.row_id,
6561: x_security_profile_id => r_sec.security_profile_id,
6562: x_business_group_id => r_sec.business_group_id,
6563: x_position_id => r_sec.position_id,

Line 6600: per_security_profiles_pkg.update_row(

6596: hr_utility.set_location(l_proc, 40);
6597: -- Sucessfully locked the row, now updating the
6598: -- view_all_candidates_flag with the given value through parameter
6599: -- p_profile_option
6600: per_security_profiles_pkg.update_row(
6601: x_rowid => r_sec.row_id,
6602: x_security_profile_id => r_sec.security_profile_id,
6603: x_business_group_id => r_sec.business_group_id,
6604: x_position_id => r_sec.position_id,