[Home] [Help]
28: l_status := 'N';
29: if p_person_type = 'APL' then
30: SELECT 'N'
31: INTO l_status
32: FROM sys.dual
33: WHERE exists (SELECT 'Y'
34: FROM per_all_people_f pp
35: WHERE (p_person_id IS NULL
36: OR p_person_id <> pp.person_id)
45: -- the CWK numbering method if Use Employee Numbering.
46: --
47: /* SELECT 'N'
48: INTO l_status
49: FROM sys.dual
50: WHERE exists (select 'Y'
51: FROM per_all_people_f pp
52: WHERE (p_person_id IS NULL
53: OR p_person_id <> pp.person_id)
65: -- Fix for the bug#12597557
66:
67: SELECT 'N'
68: INTO l_status
69: FROM sys.dual
70: WHERE exists (select NULL
71: FROM per_all_people_f pp
72: WHERE (p_person_id IS NULL
73: OR p_person_id <> pp.person_id)
93:
94: /*
95: SELECT 'N'
96: INTO l_status
97: FROM sys.dual
98: WHERE exists (select 'Y'
99: FROM per_all_people_f pp
100: WHERE (p_person_id IS NULL
101: OR p_person_id <> pp.person_id)
113: -- Fix for the bug#12597557
114:
115: SELECT 'N'
116: INTO l_status
117: FROM sys.dual
118: WHERE exists (select NULL
119: FROM per_all_people_f pp
120: WHERE (p_person_id IS NULL
121: OR p_person_id <> pp.person_id)
419: if p_applicant_number is NOT NULL then
420: begin
421: select null
422: into p_applicant_number
423: from sys.dual
424: where (p_person_id is not null
425: and not exists (select '1'
426: from per_assignments_f paf
427: where assignment_type = 'A'
555: if p_employee_number is NOT NULL then
556: begin
557: select null
558: into p_employee_number
559: from sys.dual
560: where (p_person_id is not null
561: and not exists (select '1'
562: from per_assignments_f paf
563: where assignment_type = 'E'
690: end if;
691: begin
692: select null
693: into p_npw_number
694: from sys.dual
695: where (p_person_id is not null
696: and not exists (select '1'
697: from per_assignments_f paf
698: where assignment_type = 'C'
999: DECODE(p_suffix,'','',' '||p_suffix)||
1000: DECODE(p_known_as,'','',
1001: ' ('||p_known_as||')'),1,240))
1002: INTO l_full_name
1003: FROM sys.dual ;
1004: --
1005: -- Performing rtrim to remove any blank spaces from the full name, see bug 2042825 for details
1006: --
1007: p_full_name := rtrim(l_full_name);
1045: l_proc_call := l_proc_call||':p_per_information11,:p_per_information12,:p_per_information13,:p_per_information14,:p_per_information15,:p_per_information16,:p_per_information17,';
1046:
1047: l_proc_call := l_proc_call||':p_per_information18,:p_per_information19,:p_per_information20,:p_per_information21,:p_per_information22,:p_per_information23,:p_per_information24,';
1048:
1049: l_proc_call := l_proc_call||':p_per_information25,:p_per_information26,:p_per_information27,:p_per_information28,:p_per_information29,:p_per_information30),1,240)) FROM sys.dual ';
1050:
1051: /* #1858645 replaced dbms_sql with native dynamic sql call
1052:
1053: -- Parse the statment
1182: hr_utility.set_location('hr_person.derive_full_name',3);
1183: end if;
1184: SELECT 'Y'
1185: INTO l_status
1186: FROM sys.dual
1187: WHERE EXISTS (SELECT 'Duplicate Person Exists'
1188: FROM per_all_people_f pp
1189: WHERE /* Perform case insensitive check on last name */
1190: /* trying to use the index on last name */
1437: --
1438: begin
1439: SELECT 'Y'
1440: INTO l_status
1441: FROM sys.dual
1442: WHERE exists(SELECT '1'
1443: FROM per_all_people_f pp
1444: WHERE (p_person_id IS NULL
1445: OR p_person_id <> pp.person_id)
1680: -- #2660279:
1681: -- --> delete this code
1682: -- SELECT 'Y'
1683: -- INTO l_status
1684: -- FROM sys.dual
1685: -- WHERE exists (SELECT 'Y'
1686: -- FROM per_all_people_f pp
1687: -- WHERE (p_person_id IS NULL
1688: -- OR p_person_id <> pp.person_id)
1733: --
1734:
1735: -- SELECT 'Y'
1736: -- INTO l_status
1737: -- FROM sys.dual
1738: -- WHERE exists (select 'Y'
1739: -- FROM per_all_people_f pp
1740: -- WHERE (p_person_id IS NULL
1741: -- OR p_person_id <> pp.person_id)
1770: -- #2660279:
1771: -- >> delete code
1772: -- SELECT 'Y'
1773: -- INTO l_status
1774: -- FROM sys.dual
1775: -- WHERE exists (select 'Y'
1776: -- FROM per_all_people_f pp
1777: -- WHERE (p_person_id IS NULL
1778: -- OR p_person_id <> pp.person_id)
2036: IF (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') THEN
2037:
2038: SELECT 'Y'
2039: INTO p_test_func
2040: FROM sys.dual
2041: WHERE EXISTS
2042: (
2043: SELECT 'Future Person Type exists'
2044: FROM per_person_type_usages_f ptu
2058: ELSE
2059:
2060: select 'Y'
2061: into p_test_func
2062: from sys.dual
2063: where exists(
2064: select 'Future Person Type exists'
2065: from per_person_type_usages_f ptu
2066: ,per_person_types ppt
2141: -- rather than per_people_f
2142:
2143: /*select 'Y'
2144: into p_test_func
2145: from sys.dual
2146: where exists(
2147: select 'Future Person Type exists'
2148: from per_people_f ppf
2149: ,per_person_types ppt
2173:
2174:
2175: select 'Y'
2176: into p_test_func
2177: from sys.dual
2178: where exists(
2179: select 'Future Person Type exists'
2180: from per_person_type_usages_f ptu
2181: ,per_person_types ppt
2237: end if;
2238:
2239: select 'Y'
2240: into p_test_func
2241: from sys.dual
2242: where exists
2243: (
2244: -- code change start for bug 3957689
2245: select 'Previous Person type exists'
2339: --
2340: --
2341: select 'Error : Primary address exists'
2342: into v_dummy
2343: from sys.dual
2344: where exists (select 'address exists'
2345: from per_addresses pa
2346: where pa.person_id = p_person_id
2347: and pa.business_group_id +0 = p_business_group_id