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 43: per_security_profiles psp

39: distinct ppl.security_profile_id, pcr.contact_person_id,
40: l_req_id, l_appl_id, l_prog_id, l_upd_date
41: from per_contact_relationships pcr,
42: per_person_list ppl,
43: per_security_profiles psp
44: where ppl.person_id = p_person_id
45: and ppl.security_profile_id = psp.security_profile_id
46: and (psp.view_all_contacts_flag = 'N' or
47: (psp.view_all_contacts_flag = 'Y' and

Line 126: from per_security_profiles psp

122: -- Cursor for p_generation_scope = 'ALL_BUS_GRP'
123: cursor csr_get_sec_profs_bg is
124: select psp.security_profile_id,
125: psp.business_group_id
126: from per_security_profiles psp
127: where (psp.view_all_contacts_flag = 'N' or
128: (psp.view_all_contacts_flag = 'Y' and
129: psp.view_all_candidates_flag = 'X'))
130: and (nvl(psp.top_organization_method, 'S') <> 'U' and

Line 139: from per_security_profiles psp

135: -- Cursor for p_generation_scope <> 'ALL_BUS_GRP'
136: cursor csr_get_sec_profs is
137: select psp.security_profile_id,
138: psp.business_group_id
139: from per_security_profiles psp
140: where (psp.view_all_contacts_flag = 'N' or
141: (psp.view_all_contacts_flag = 'Y' and
142: psp.view_all_candidates_flag = 'X'))
143: and (nvl(psp.top_organization_method, 'S') <> 'U' and

Line 525: FROM per_security_profiles s

521: p_request_id,
522: p_program_application_id,
523: p_program_id,
524: l_update_date
525: FROM per_security_profiles s
526: WHERE s.security_profile_id = l_security_profile_id
527: AND NOT EXISTS
528: (SELECT NULL
529: FROM per_organization_list b

Line 856: per_security_profiles psp

852: program_update_date, person_id)
853: select distinct psp.security_profile_id, l_req_id, l_appl_id,
854: l_prog_id, l_upd_date, papf.person_id
855: from per_all_people_f papf,
856: per_security_profiles psp
857: where psp.security_profile_id = p_security_profile_id
858: and (psp.business_group_id = papf.business_group_id or
859: psp.business_group_id is null)
860: and not exists

Line 959: sec_rec - Row in per_security_profiles for current profile

955: DESCRIPTION
956: populates the per_person_list using dynamic sql
957: PARAMETERS
958: Few parameters are needed due it inheriting from the parent function
959: sec_rec - Row in per_security_profiles for current profile
960: ========================================================================= */
961: --
962:
963: PROCEDURE create_person_list(sec_rec PER_SECURITY_PROFILES%ROWTYPE,

Line 963: PROCEDURE create_person_list(sec_rec PER_SECURITY_PROFILES%ROWTYPE,

959: sec_rec - Row in per_security_profiles for current profile
960: ========================================================================= */
961: --
962:
963: PROCEDURE create_person_list(sec_rec PER_SECURITY_PROFILES%ROWTYPE,
964: p_effective_date date,
965: p_update_date date,
966: p_who_to_process varchar2)
967: IS

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

1011: hr_utility.set_location('Leaveing execute_statement',10);
1012: END execute_statement;
1013:
1014: /*-- for the bug 5214715 --*/
1015: PROCEDURE add_comm_str ( p_sec_rec IN PER_SECURITY_PROFILES%ROWTYPE ) as
1016: l_restriction_flags varchar2(2000);
1017: l_exclude_flags varchar2(2000);
1018: BEGIN
1019: hr_utility.set_location('Entering add_comm_str',10);

Line 1103: ,p_sec_rec IN PER_SECURITY_PROFILES%ROWTYPE

1099: -- ,p_from_clause IN VARCHAR2
1100: --- ,p_generation_scope IN VARCHAR2
1101: -- ,p_business_group_id IN NUMBER
1102: -- ,p_assignment_type IN VARCHAR2
1103: ,p_sec_rec IN PER_SECURITY_PROFILES%ROWTYPE
1104: )
1105: AS
1106: BEGIN
1107: hr_utility.set_location('Entering init_statement',10);

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

1353: -- Bug6809753 - start
1354: l_del_str := ' delete from per_person_list ppl where
1355: ppl.person_id = '||p_person_id||'
1356: and ppl.granted_user_id is null and exists
1357: (select ''X'' from per_security_profiles pspf
1358: where pspf.security_profile_id = ppl.security_profile_id ';
1359: -- Bug6809753 - end
1360:
1361: if p_generation_scope = 'ALL_BUS_GRP' then

Line 1367: (select 'X' from per_security_profiles pspf

1363: /* Commented Bug6809753 - start
1364: delete from per_person_list ppl where
1365: ppl.person_id = p_person_id
1366: and ppl.granted_user_id is null and exists
1367: (select 'X' from per_security_profiles pspf
1368: where pspf.security_profile_id = ppl.security_profile_id
1369: and pspf.business_group_id = p_business_group_id);
1370: Commented Bug6809753 - end */
1371:

Line 1383: (select 'X' from per_security_profiles pspf

1379: /* Commented Bug6809753 - start
1380: delete from per_person_list ppl where
1381: ppl.person_id = p_person_id
1382: and ppl.granted_user_id is null and exists
1383: (select 'X' from per_security_profiles pspf
1384: where pspf.security_profile_id = ppl.security_profile_id
1385: and pspf.business_group_id is null);
1386: Commented Bug6809753 - end */
1387:

Line 1399: (select 'X' from per_security_profiles pspf

1395: /* Commented Bug6809753 - start
1396: delete from per_person_list ppl where
1397: ppl.person_id = p_person_id
1398: and ppl.granted_user_id is null and exists
1399: (select 'X' from per_security_profiles pspf
1400: where pspf.security_profile_id = ppl.security_profile_id);
1401: Commented Bug6809753 - end */
1402:
1403: -- Bug6809753 - start

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

1411: execute immediate l_exe_str; -- Bug6809753
1412:
1413: -- Clear records for the contacts of this person
1414: -- 2906862 - dkerr 2003-05-01
1415: -- I've restricted the scan of PER_SECURITY_PROFILES to restricted
1416: -- contact profiles - which can drastically reduce the amount of I/O
1417: -- performed.
1418: -- Analysis of major customer data suggests the following :
1419: -- 1. Security profiles with "view_all_contacts_flag='N'"

Line 1432: from per_security_profiles pspf

1428:
1429: delete from per_person_list ppl
1430: where ppl.security_profile_id in
1431: (select pspf.security_profile_id
1432: from per_security_profiles pspf
1433: where (pspf.view_all_contacts_flag = 'N' or
1434: (pspf.view_all_contacts_flag = 'Y' and
1435: pspf.view_all_candidates_flag = 'X'))
1436: and pspf.business_group_id = p_business_group_id

Line 1458: from per_security_profiles pspf

1454: if p_generation_scope = 'ALL_GLOBAL' then
1455: delete from per_person_list ppl
1456: where ppl.security_profile_id in
1457: (select pspf.security_profile_id
1458: from per_security_profiles pspf
1459: where (pspf.view_all_contacts_flag = 'N' or
1460: (pspf.view_all_contacts_flag = 'Y' and
1461: pspf.view_all_candidates_flag = 'X'))
1462: and pspf.business_group_id is null

Line 1482: from per_security_profiles pspf

1478: if p_generation_scope = 'ALL_PROFILES' then
1479: delete from per_person_list ppl
1480: where ppl.security_profile_id in
1481: (select pspf.security_profile_id
1482: from per_security_profiles pspf
1483: where (pspf.view_all_contacts_flag = 'N' or
1484: (pspf.view_all_contacts_flag = 'Y' and
1485: pspf.view_all_candidates_flag = 'X'))
1486: )

Line 1509: from per_security_profiles pspf

1505: -- Bug6809753 -start
1506: l_del_str := ' delete from per_person_list ppl
1507: where ppl.security_profile_id in
1508: (select pspf.security_profile_id
1509: from per_security_profiles pspf
1510: where (pspf.view_all_contacts_flag = ''N'' or
1511: (pspf.view_all_contacts_flag = ''Y'' and
1512: pspf.view_all_candidates_flag = ''X'')) '
1513: ||l_sub_str||')

Line 1559: from per_security_profiles pspf

1555:
1556: delete from per_person_list ppl
1557: where ppl.security_profile_id in
1558: (select pspf.security_profile_id
1559: from per_security_profiles pspf
1560: where (pspf.view_all_contacts_flag = 'N' or
1561: (pspf.view_all_contacts_flag = 'Y' and
1562: pspf.view_all_candidates_flag = 'X')))
1563: /* and ppl.person_id in

Line 1583: from per_security_profiles pspf

1579: else
1580: delete from per_person_list ppl
1581: where ppl.security_profile_id in
1582: (select pspf.security_profile_id
1583: from per_security_profiles pspf
1584: where (pspf.view_all_contacts_flag = 'N' or
1585: (pspf.view_all_contacts_flag = 'Y' and
1586: pspf.view_all_candidates_flag = 'X')))
1587: and ppl.person_id in

Line 2047: from per_security_profiles

2043: l_proc varchar2(72) := g_package||'.generate_opp_lists';
2044: --
2045: cursor security_profiles is
2046: select *
2047: from per_security_profiles
2048: where ((business_group_id = p_business_group_id and
2049: p_generation_scope = 'ALL_BUS_GRP')
2050: or (business_group_id is null and
2051: p_generation_scope = 'ALL_GLOBAL')

Line 2367: l_sec_prof_rec hr_security_internal.g_sec_prof_r; -- per_security_profiles

2363: l_debug boolean default FALSE;
2364: l_process_all_users boolean := TRUE; -- as just running for one user.
2365: l_user_id number;
2366: l_security_profile_id number;
2367: l_sec_prof_rec hr_security_internal.g_sec_prof_r; -- per_security_profiles
2368: -- %ROWTYPE;
2369: -- Cursors:
2370: --
2371: -- check that user and profile exist in per_security_users

Line 2386: from per_security_profiles

2382: --
2383: CURSOR csr_security_profile_record(l_security_profile_id number)
2384: IS
2385: SELECT *
2386: from per_security_profiles
2387: where security_profile_id = l_security_profile_id;
2388: --
2389: BEGIN
2390: --

Line 2460: l_security_profile_name per_security_profiles.security_profile_name%TYPE;

2456: l_business_group_id number;
2457: l_security_profile_id number;
2458: l_action_parameter_group_id number;
2459: l_user_id number;
2460: l_security_profile_name per_security_profiles.security_profile_name%TYPE;
2461: l_logging pay_action_parameters.parameter_value%TYPE;
2462: l_request_id number;
2463: l_effective_date varchar2(50);
2464: l_update_date date;

Line 2495: FROM per_security_profiles

2491:
2492: CURSOR security_profiles
2493: IS
2494: SELECT *
2495: FROM per_security_profiles
2496: WHERE ( (business_group_id = p_business_group_id and
2497: p_generation_scope = 'ALL_BUS_GRP')
2498: OR
2499: (business_group_id is null and

Line 2879: from per_security_profiles

2875: where pap.parameter_name = 'LOGGING';
2876: --
2877: cursor security_profiles is
2878: select *
2879: from per_security_profiles
2880: where (((security_profile_id = p_security_profile_id or
2881: security_profile_name = p_security_profile_name)
2882: and p_generation_scope in ('SINGLE_PROF','SINGLE_USER'))
2883: or (business_group_id = p_business_group_id and

Line 3541: from per_security_profiles_v pspv

3537: --
3538: -- Get all security profiles excluding the view_all profiles.
3539: cursor csr_security_prof is
3540: select pspv.*
3541: from per_security_profiles_v pspv
3542: where pspv.view_all_flag = 'N'
3543: and pspv.view_all_candidates_flag <> p_profile_option;
3544: --
3545: begin

Line 3562: per_security_profiles_pkg.lock_row(

3558: begin
3559: --
3560: hr_utility.set_location(l_proc, 30);
3561: -- Get the lock of the respective security profile record.
3562: per_security_profiles_pkg.lock_row(
3563: x_rowid => r_sec.row_id,
3564: x_security_profile_id => r_sec.security_profile_id,
3565: x_business_group_id => r_sec.business_group_id,
3566: x_position_id => r_sec.position_id,

Line 3603: per_security_profiles_pkg.update_row(

3599: hr_utility.set_location(l_proc, 40);
3600: -- Sucessfully locked the row, now updating the
3601: -- view_all_candidates_flag with the given value through parameter
3602: -- p_profile_option
3603: per_security_profiles_pkg.update_row(
3604: x_rowid => r_sec.row_id,
3605: x_security_profile_id => r_sec.security_profile_id,
3606: x_business_group_id => r_sec.business_group_id,
3607: x_position_id => r_sec.position_id,