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_PERSON_LIST

Line 45: insert into per_person_list_stage(security_profile_id, person_id, request_id,

41:
42: --Start changes for the code for 13504049
43: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
44: hr_utility.set_location(l_proc||' using stage table',20);
45: insert into per_person_list_stage(security_profile_id, person_id, request_id,
46: program_application_id, program_id,
47: program_update_date)
48: select /*+ USE_NL(PSP) */
49: distinct ppl.security_profile_id, pcr.contact_person_id,

Line 52: per_person_list_stage ppl,

48: select /*+ USE_NL(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

Line 75: from per_person_list_stage ppl1

71: where asg.person_id = pcr.contact_person_id
72: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
73: and not exists
74: (select /*+ NO_MERGE */ null
75: from per_person_list_stage ppl1
76: where ppl1.person_id = pcr.contact_person_id
77: and ppl1.granted_user_id is null
78: and ppl1.security_profile_id = ppl.security_profile_id);
79:

Line 82: insert into per_person_list(security_profile_id, person_id, request_id,

78: and ppl1.security_profile_id = ppl.security_profile_id);
79:
80: else
81: hr_utility.set_location(l_proc||' using actual table',30);
82: insert into per_person_list(security_profile_id, person_id, request_id,
83: program_application_id, program_id,
84: program_update_date)
85: select /*+ USE_NL(PSP) */
86: distinct ppl.security_profile_id, pcr.contact_person_id,

Line 89: per_person_list ppl,

85: select /*+ USE_NL(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

Line 112: from per_person_list ppl1

108: where asg.person_id = pcr.contact_person_id
109: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
110: and not exists
111: (select /*+ NO_MERGE */ null
112: from per_person_list ppl1
113: where ppl1.person_id = pcr.contact_person_id
114: and ppl1.granted_user_id is null
115: and ppl1.security_profile_id = ppl.security_profile_id);
116: end if;

Line 253: from per_person_list p2

249: then
250: begin
251:
252: select 'X' into t_varchar
253: from per_person_list p2
254: where p2.person_id = l_per_tbl(j)
255: and p2.security_profile_id = l_sp_tbl(i);
256:
257: exception

Line 263: insert into per_person_list_stage(security_profile_id, person_id,

259:
260: -- Start changes for bug 13504049
261: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
262: hr_utility.set_location(l_proc||' using stage table',50);
263: insert into per_person_list_stage(security_profile_id, person_id,
264: request_id, program_application_id,
265: program_id, program_update_date)
266: values (l_sp_tbl(i), l_per_tbl(j), l_req_id,
267: l_appl_id, l_prog_id, l_upd_date);

Line 270: insert into per_person_list(security_profile_id, person_id,

266: values (l_sp_tbl(i), l_per_tbl(j), l_req_id,
267: l_appl_id, l_prog_id, l_upd_date);
268: else
269: hr_utility.set_location(l_proc||' using actual table',60);
270: insert into per_person_list(security_profile_id, person_id,
271: request_id, program_application_id,
272: program_id, program_update_date)
273: values (l_sp_tbl(i), l_per_tbl(j), l_req_id,
274: l_appl_id, l_prog_id, l_upd_date);

Line 847: insert into per_person_list_stage(security_profile_id, request_id, program_id

843: -- Query #1
844: -- Start changes for bug 13504049
845: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
846: hr_utility.set_location(l_proc||' using stage table', 14);
847: insert into per_person_list_stage(security_profile_id, request_id, program_id
848: ,program_application_id, program_update_date
849: ,person_id)
850: select distinct p_security_profile_id, l_req_id, l_prog_id,
851: l_appl_id, l_upd_date, pcr.contact_person_id

Line 853: per_all_people_f ppl -- per_person_list ppl for bug (6376000/4774264)

849: ,person_id)
850: select distinct p_security_profile_id, l_req_id, l_prog_id,
851: l_appl_id, l_upd_date, pcr.contact_person_id
852: from per_contact_relationships pcr,
853: per_all_people_f ppl -- per_person_list ppl for bug (6376000/4774264)
854: where ppl.person_id = pcr.person_id
855: and (pcr.business_group_id = p_business_group_id or
856: p_business_group_id is null)
857: -- and ppl.security_profile_id = p_security_profile_id for bug (6376000/4774264)

Line 865: from per_person_list_stage ppl1

861: where asg.person_id = pcr.contact_person_id
862: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
863: and not exists
864: (select null
865: from per_person_list_stage ppl1
866: where ppl1.person_id = pcr.contact_person_id
867: and ppl1.granted_user_id is null
868: and ppl1.security_profile_id = p_security_profile_id ); -- ppl.security_profile_id) for bug (6376000/4774264)
869: else

Line 871: insert into per_person_list(security_profile_id, request_id, program_id

867: and ppl1.granted_user_id is null
868: and ppl1.security_profile_id = p_security_profile_id ); -- ppl.security_profile_id) for bug (6376000/4774264)
869: else
870: hr_utility.set_location(l_proc||' using actual table', 18);
871: insert into per_person_list(security_profile_id, request_id, program_id
872: ,program_application_id, program_update_date
873: ,person_id)
874: select distinct p_security_profile_id, l_req_id, l_prog_id,
875: l_appl_id, l_upd_date, pcr.contact_person_id

Line 877: per_all_people_f ppl -- per_person_list ppl for bug (6376000/4774264)

873: ,person_id)
874: select distinct p_security_profile_id, l_req_id, l_prog_id,
875: l_appl_id, l_upd_date, pcr.contact_person_id
876: from per_contact_relationships pcr,
877: per_all_people_f ppl -- per_person_list ppl for bug (6376000/4774264)
878: where ppl.person_id = pcr.person_id
879: and (pcr.business_group_id = p_business_group_id or
880: p_business_group_id is null)
881: -- and ppl.security_profile_id = p_security_profile_id for bug (6376000/4774264)

Line 889: from per_person_list ppl1

885: where asg.person_id = pcr.contact_person_id
886: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
887: and not exists
888: (select null
889: from per_person_list ppl1
890: where ppl1.person_id = pcr.contact_person_id
891: and ppl1.granted_user_id is null
892: and ppl1.security_profile_id = p_security_profile_id ); -- ppl.security_profile_id) for bug (6376000/4774264)
893: end if;

Line 915: insert into per_person_list_stage(security_profile_id, request_id, program_id

911: -- Query #2
912:
913: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
914: hr_utility.set_location(l_proc||' using stage table', 24);
915: insert into per_person_list_stage(security_profile_id, request_id, program_id
916: ,program_application_id, program_update_date
917: ,person_id)
918: select distinct ppl.security_profile_id, l_req_id, l_prog_id,
919: l_appl_id, l_upd_date, pcr.contact_person_id

Line 921: per_person_list_stage ppl

917: ,person_id)
918: select distinct ppl.security_profile_id, l_req_id, l_prog_id,
919: l_appl_id, l_upd_date, pcr.contact_person_id
920: from per_contact_relationships pcr,
921: per_person_list_stage ppl
922: where ppl.person_id = pcr.person_id
923: and (pcr.business_group_id = p_business_group_id or
924: p_business_group_id is null)
925: and ppl.security_profile_id = p_security_profile_id

Line 933: from per_person_list_stage ppl1

929: where asg.person_id = pcr.contact_person_id
930: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
931: and not exists
932: (select null
933: from per_person_list_stage ppl1
934: where ppl1.person_id = pcr.contact_person_id
935: and ppl1.granted_user_id is null
936: and ppl1.security_profile_id = ppl.security_profile_id);
937: else

Line 939: insert into per_person_list(security_profile_id, request_id, program_id

935: and ppl1.granted_user_id is null
936: and ppl1.security_profile_id = ppl.security_profile_id);
937: else
938: hr_utility.set_location(l_proc||' using actual table', 28);
939: insert into per_person_list(security_profile_id, request_id, program_id
940: ,program_application_id, program_update_date
941: ,person_id)
942: select distinct ppl.security_profile_id, l_req_id, l_prog_id,
943: l_appl_id, l_upd_date, pcr.contact_person_id

Line 945: per_person_list ppl

941: ,person_id)
942: select distinct ppl.security_profile_id, l_req_id, l_prog_id,
943: l_appl_id, l_upd_date, pcr.contact_person_id
944: from per_contact_relationships pcr,
945: per_person_list ppl
946: where ppl.person_id = pcr.person_id
947: and (pcr.business_group_id = p_business_group_id or
948: p_business_group_id is null)
949: and ppl.security_profile_id = p_security_profile_id

Line 957: from per_person_list ppl1

953: where asg.person_id = pcr.contact_person_id
954: and asg.ASSIGNMENT_TYPE <> 'B') -- Bug 4450149
955: and not exists
956: (select null
957: from per_person_list ppl1
958: where ppl1.person_id = pcr.contact_person_id
959: and ppl1.granted_user_id is null
960: and ppl1.security_profile_id = ppl.security_profile_id);
961: end if;

Line 974: insert into per_person_list_stage(security_profile_id, request_id,

970: -- Query #3
971:
972: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
973: hr_utility.set_location(l_proc||' using stage table', 34);
974: insert into per_person_list_stage(security_profile_id, request_id,
975: program_application_id, program_id,
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

Line 1001: from per_person_list_stage ppl

997: and ptuf.person_type_id = ppt.person_type_id
998: and ptuf.person_id = papf.person_id)
999: and not exists
1000: (select null
1001: from per_person_list_stage ppl
1002: where ppl.person_id = papf.person_id
1003: and ppl.granted_user_id is null
1004: and ppl.security_profile_id = psp.security_profile_id);
1005: else

Line 1007: insert into per_person_list(security_profile_id, request_id,

1003: and ppl.granted_user_id is null
1004: and ppl.security_profile_id = psp.security_profile_id);
1005: else
1006: hr_utility.set_location(l_proc||' using actual table', 38);
1007: insert into per_person_list(security_profile_id, request_id,
1008: program_application_id, program_id,
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

Line 1034: from per_person_list ppl

1030: and ptuf.person_type_id = ppt.person_type_id
1031: and ptuf.person_id = papf.person_id)
1032: and not exists
1033: (select null
1034: from per_person_list ppl
1035: where ppl.person_id = papf.person_id
1036: and ppl.granted_user_id is null
1037: and ppl.security_profile_id = psp.security_profile_id);
1038: end if;

Line 1074: INSERT INTO per_person_list_stage

1070: --
1071: -- Start change for bug 13504049
1072: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
1073: hr_utility.set_location(l_proc||' using stage table', 14);
1074: INSERT INTO per_person_list_stage
1075: (security_profile_id,
1076: person_id,
1077: request_id,
1078: program_application_id,

Line 1087: FROM per_person_list_changes plc

1083: p_request_id,
1084: p_program_application_id,
1085: p_program_id,
1086: l_update_date
1087: FROM per_person_list_changes plc
1088: WHERE plc.security_profile_id = l_security_profile_id
1089: AND NOT EXISTS
1090: (SELECT NULL
1091: FROM per_all_assignments_f pos

Line 1104: FROM per_person_list_stage ppl

1100: WHERE pos.person_id = plc.person_id
1101: AND l_effective_date > pos.effective_start_date)
1102: AND NOT EXISTS
1103: (SELECT NULL
1104: FROM per_person_list_stage ppl
1105: WHERE ppl.person_id = plc.person_id
1106: AND ppl.granted_user_Id IS NULL
1107: AND ppl.security_profile_id = plc.security_profile_id);
1108: else

Line 1110: INSERT INTO per_person_list

1106: AND ppl.granted_user_Id IS NULL
1107: AND ppl.security_profile_id = plc.security_profile_id);
1108: else
1109: hr_utility.set_location(l_proc||' using actual table', 18);
1110: INSERT INTO per_person_list
1111: (security_profile_id,
1112: person_id,
1113: request_id,
1114: program_application_id,

Line 1123: FROM per_person_list_changes plc

1119: p_request_id,
1120: p_program_application_id,
1121: p_program_id,
1122: l_update_date
1123: FROM per_person_list_changes plc
1124: WHERE plc.security_profile_id = l_security_profile_id
1125: AND NOT EXISTS
1126: (SELECT NULL
1127: FROM per_all_assignments_f pos

Line 1140: FROM per_person_list ppl

1136: WHERE pos.person_id = plc.person_id
1137: AND l_effective_date > pos.effective_start_date)
1138: AND NOT EXISTS
1139: (SELECT NULL
1140: FROM per_person_list ppl
1141: WHERE ppl.person_id = plc.person_id
1142: AND ppl.granted_user_Id IS NULL
1143: AND ppl.security_profile_id = plc.security_profile_id);
1144: end if;

Line 1156: populates the per_person_list using dynamic sql

1152: /* =======================================================================
1153: NAME
1154: create_person_list
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: ========================================================================= */

Line 1313: 'INSERT into per_person_list_stage

1309:
1310: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
1311: hr_utility.set_location('init_statement using stage table',14);
1312: fnd_dsql.add_text(
1313: 'INSERT into per_person_list_stage
1314: (security_profile_id,
1315: person_id,
1316: request_id,
1317: program_application_id,

Line 1323: 'INSERT into per_person_list

1319: program_update_date ) ');
1320: else
1321: hr_utility.set_location('init_statement using actual table',18);
1322: fnd_dsql.add_text(
1323: 'INSERT into per_person_list
1324: (security_profile_id,
1325: person_id,
1326: request_id,
1327: program_application_id,

Line 1535: from per_person_list_stage ppl

1531:
1532: -- Start changes for bug 13504049
1533: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
1534: fnd_dsql.add_text(' and not exists(select 1
1535: from per_person_list_stage ppl
1536: where ppl.security_profile_id = ');
1537: else
1538:
1539: fnd_dsql.add_text(' and not exists(select 1

Line 1540: from per_person_list ppl

1536: where ppl.security_profile_id = ');
1537: else
1538:
1539: fnd_dsql.add_text(' and not exists(select 1
1540: from per_person_list ppl
1541: where ppl.security_profile_id = ');
1542: end if;
1543: -- End changes for bug 13504049
1544: fnd_dsql.add_bind(sec_rec.security_profile_id);

Line 1597: l_del_str := ' delete from per_person_list_stage ppl where

1593: -- Clear the records for this person.
1594:
1595: -- Bug6809753 - start
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 ';

Line 1603: l_del_str := ' delete from per_person_list ppl where

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
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 ';

Line 1614: delete from per_person_list ppl where

1610:
1611: if p_generation_scope = 'ALL_BUS_GRP' then
1612:
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

Line 1630: delete from per_person_list ppl where

1626: end if;
1627: if p_generation_scope = 'ALL_GLOBAL' then
1628:
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

Line 1646: delete from per_person_list ppl where

1642: end if;
1643: if p_generation_scope = 'ALL_PROFILES' then
1644:
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);

Line 1685: delete from per_person_list ppl

1681: /* Commented Bug6809753 - start
1682:
1683: if p_generation_scope = 'ALL_BUS_GRP' then
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

Line 1711: delete from per_person_list ppl

1707:
1708:
1709: End if;
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

Line 1735: delete from per_person_list ppl

1731: and ppt.system_person_type = 'OTHER')
1732: and ppl.granted_user_id is null;
1733: End if;
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

Line 1766: l_del_str := ' delete from per_person_list ppl

1762: l_effective_date := to_date(to_char(p_effective_date,'dd/mm/yyyy'),'dd/mm/yyyy');
1763:
1764: if p_generation_scope = 'ALL_BUS_GRP' then
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

Line 1796: l_del_str := ' delete from per_person_list ppl

1792: l_effective_date;
1793: end if;
1794:
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

Line 1826: l_del_str := ' delete from per_person_list ppl

1822: l_effective_date;
1823: end if;
1824:
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

Line 1880: delete from per_person_list_stage ppl

1876: if p_generation_scope <> 'ALL_BUS_GRP' then
1877:
1878: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
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

Line 1904: delete from per_person_list ppl

1900: from per_contact_relationships pcr
1901: where pcr.contact_person_id = ppl.person_id);
1902: else
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

Line 1929: delete from per_person_list ppl

1925: where pcr.contact_person_id = ppl.person_id);
1926: end if;
1927:
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

Line 1992: from per_person_list_stage

1988: -- Start changes for bug 13504049
1989: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
1990: hr_utility.set_location(l_proc||' using stage table',34);
1991: delete
1992: from per_person_list_stage
1993: where security_profile_id = p_security_profile_id
1994: and granted_user_id is null;
1995: else
1996: hr_utility.set_location(l_proc||' using actual table',38);

Line 1998: from per_person_list

1994: and granted_user_id is null;
1995: else
1996: hr_utility.set_location(l_proc||' using actual table',38);
1997: delete
1998: from per_person_list
1999: where security_profile_id = p_security_profile_id
2000: and granted_user_id is null;
2001: end if;
2002: -- End changes for bug 13504049

Line 4307: Insert into per_person_list_stage(security_profile_id,

4303: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
4304: hr_utility.set_location(l_proc||' using stage table',24);
4305: forall per_rec in l_c_security_profile_table.first .. l_c_security_profile_table.last
4306: SAVE EXCEPTIONS
4307: Insert into per_person_list_stage(security_profile_id,
4308: person_id,request_id,
4309: program_application_id,
4310: program_id,
4311: program_update_date)

Line 4323: Insert into per_person_list(security_profile_id,

4319: else
4320: hr_utility.set_location(l_proc||' using actual table',24);
4321: forall per_rec in l_c_security_profile_table.first .. l_c_security_profile_table.last
4322: SAVE EXCEPTIONS
4323: Insert into per_person_list(security_profile_id,
4324: person_id,request_id,
4325: program_application_id,
4326: program_id,
4327: program_update_date)

Line 4379: Delete from per_person_list ppl

4375:
4376:
4377: /* forall per_rec in l_d_security_profile_table.first .. l_d_security_profile_table.last
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

Line 4407: Delete from per_person_list_stage

4403: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
4404: hr_utility.set_location(l_proc||'deleting stage table', 24);
4405: forall per_rec in l_d_security_profile_table.first .. l_d_security_profile_table.last
4406: SAVE EXCEPTIONS
4407: Delete from per_person_list_stage
4408: where person_id = p_person_id
4409: and security_profile_id = l_d_security_profile_table(per_rec);
4410: else
4411: hr_utility.set_location(l_proc||'deleting actual table', 28);

Line 4414: Delete from per_person_list

4410: else
4411: hr_utility.set_location(l_proc||'deleting actual table', 28);
4412: forall per_rec in l_d_security_profile_table.first .. l_d_security_profile_table.last
4413: SAVE EXCEPTIONS
4414: Delete from per_person_list
4415: where person_id = p_person_id
4416: and security_profile_id = l_d_security_profile_table(per_rec);
4417: end if;
4418: -- End changes for bug 13504049

Line 4459: from per_person_list ppl where

4455:
4456: begin
4457: hr_utility.set_location('Entering '||l_proc,10);
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);

Line 4568: delete from per_person_list ppl

4564: if( p_generation_scope = 'ALL_PROFILES') then
4565:
4566: -- To delete all the contacts of the person
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

Line 4647: -- insert the processed list to the per_person_list marked for insertion.

4643: -- process the list prepared from the above sections.
4644:
4645: profile_process_list;
4646:
4647: -- insert the processed list to the per_person_list marked for insertion.
4648:
4649: profile_insert_cache_to_list;
4650:
4651: -- delete the processed list from the per_person_list marked for deletion.

Line 4651: -- delete the processed list from the per_person_list marked for deletion.

4647: -- insert the processed list to the per_person_list marked for insertion.
4648:
4649: profile_insert_cache_to_list;
4650:
4651: -- delete the processed list from the per_person_list marked for deletion.
4652:
4653: profile_delete_cache_from_list;
4654:
4655: -- add all contacts of the person to person list

Line 5499: insert into per_person_list(

5495: p_static_user_processing => p_static_user_processing);
5496:
5497: if g_use_temp_table = 'Y' and g_generation_scope = 'SINGLE_PROF' and g_static_list_profile = 'N' then
5498: hr_utility.set_location(l_proc||'Sync stage table with actual table',21);
5499: insert into per_person_list(
5500: SECURITY_PROFILE_ID,
5501: PERSON_ID,
5502: REQUEST_ID,
5503: PROGRAM_APPLICATION_ID,

Line 5515: from per_person_list_stage a

5511: PROGRAM_APPLICATION_ID,
5512: PROGRAM_ID,
5513: PROGRAM_UPDATE_DATE,
5514: GRANTED_USER_ID
5515: from per_person_list_stage a
5516: where not exists (
5517: select 1
5518: from per_person_list
5519: where security_profile_id=a.security_profile_id

Line 5518: from per_person_list

5514: GRANTED_USER_ID
5515: from per_person_list_stage a
5516: where not exists (
5517: select 1
5518: from per_person_list
5519: where security_profile_id=a.security_profile_id
5520: and person_id=a.person_Id
5521: and nvl(granted_user_id,-1) = nvl(a.granted_user_id,-1)
5522: and security_profile_id = p_security_profile_id);

Line 5524: delete from per_person_list a

5520: and person_id=a.person_Id
5521: and nvl(granted_user_id,-1) = nvl(a.granted_user_id,-1)
5522: and security_profile_id = p_security_profile_id);
5523:
5524: delete from per_person_list a
5525: where security_profile_id=p_security_profile_id
5526: and not exists (
5527: select 1
5528: from per_person_list_stage

Line 5528: from per_person_list_stage

5524: delete from per_person_list a
5525: where security_profile_id=p_security_profile_id
5526: and not exists (
5527: select 1
5528: from per_person_list_stage
5529: where person_id=a.person_Id
5530: and nvl(granted_user_id,-1) = nvl(a.granted_user_id,-1));
5531:
5532: commit;

Line 5904: insert into per_person_list_stage(

5900: else
5901:
5902: if g_generation_scope = 'SINGLE_PROF' and g_use_temp_table = 'Y' then
5903: g_static_list_profile := 'N';
5904: insert into per_person_list_stage(
5905: SECURITY_PROFILE_ID,
5906: PERSON_ID,
5907: REQUEST_ID,
5908: PROGRAM_APPLICATION_ID,

Line 5920: from per_person_list

5916: PROGRAM_APPLICATION_ID,
5917: PROGRAM_ID,
5918: PROGRAM_UPDATE_DATE,
5919: GRANTED_USER_ID
5920: from per_person_list
5921: where security_profile_id=sec_rec.security_profile_id;
5922: end if;
5923:
5924: end if;

Line 6047: -- record existing in per_person_list). The additional OR condition

6043: -- are not in use.
6044: --
6045: -- A condition with view_all_contacts_flag = All and
6046: -- view_all_candidates_flag = None, needs caching (ie: similar to
6047: -- record existing in per_person_list). The additional OR condition
6048: -- is included as part of Candidate Security enchancements.
6049: if(sec_rec.view_all_contacts_flag = 'N' or
6050: (sec_rec.view_all_contacts_flag = 'Y' and
6051: sec_rec.view_all_candidates_flag = 'X')) and

Line 6482: from per_person_list

6478:
6479: l_dummy number;
6480: cursor c_per_in_profile is
6481: select 1
6482: from per_person_list
6483: where person_id = p_person_id
6484: and granted_user_id is null
6485: and security_profile_id = p_security_profile_id;
6486: