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.HR_APPLICANT_API dependencies on PER_ALL_PEOPLE_F

Line 12: (p_person_id IN per_all_people_f.person_id%TYPE

8: --
9: -- Package cursor
10: --
11: CURSOR csr_future_asgs
12: (p_person_id IN per_all_people_f.person_id%TYPE
13: ,p_effective_date IN DATE
14: )
15: IS
16: SELECT asg.assignment_id

Line 53: (p_person_id IN per_all_people_f.person_id%TYPE

49: --
50: -- {End Of Comments}
51: --
52: FUNCTION future_asgs_count
53: (p_person_id IN per_all_people_f.person_id%TYPE
54: ,p_effective_date IN DATE
55: )
56: RETURN INTEGER
57: IS

Line 232: l_applicant_number per_all_people_f.applicant_number%TYPE;

228: -- Declare cursors and local variables
229: --
230: l_proc varchar2(72) := g_package||'create_applicant';
231: l_date_received per_applications.date_received%TYPE;
232: l_applicant_number per_all_people_f.applicant_number%TYPE;
233: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;
234: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
235: l_background_date_check per_all_people_f.background_date_check%TYPE;
236: l_hold_applicant_date_until per_all_people_f.hold_applicant_date_until%TYPE;

Line 233: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;

229: --
230: l_proc varchar2(72) := g_package||'create_applicant';
231: l_date_received per_applications.date_received%TYPE;
232: l_applicant_number per_all_people_f.applicant_number%TYPE;
233: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;
234: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
235: l_background_date_check per_all_people_f.background_date_check%TYPE;
236: l_hold_applicant_date_until per_all_people_f.hold_applicant_date_until%TYPE;
237: l_projected_start_date per_all_people_f.projected_start_date%TYPE;

Line 234: l_date_of_birth per_all_people_f.date_of_birth%TYPE;

230: l_proc varchar2(72) := g_package||'create_applicant';
231: l_date_received per_applications.date_received%TYPE;
232: l_applicant_number per_all_people_f.applicant_number%TYPE;
233: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;
234: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
235: l_background_date_check per_all_people_f.background_date_check%TYPE;
236: l_hold_applicant_date_until per_all_people_f.hold_applicant_date_until%TYPE;
237: l_projected_start_date per_all_people_f.projected_start_date%TYPE;
238: l_resume_last_updated per_all_people_f.resume_last_updated%TYPE;

Line 235: l_background_date_check per_all_people_f.background_date_check%TYPE;

231: l_date_received per_applications.date_received%TYPE;
232: l_applicant_number per_all_people_f.applicant_number%TYPE;
233: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;
234: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
235: l_background_date_check per_all_people_f.background_date_check%TYPE;
236: l_hold_applicant_date_until per_all_people_f.hold_applicant_date_until%TYPE;
237: l_projected_start_date per_all_people_f.projected_start_date%TYPE;
238: l_resume_last_updated per_all_people_f.resume_last_updated%TYPE;
239: l_person_id per_all_people_f.person_id%TYPE;

Line 236: l_hold_applicant_date_until per_all_people_f.hold_applicant_date_until%TYPE;

232: l_applicant_number per_all_people_f.applicant_number%TYPE;
233: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;
234: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
235: l_background_date_check per_all_people_f.background_date_check%TYPE;
236: l_hold_applicant_date_until per_all_people_f.hold_applicant_date_until%TYPE;
237: l_projected_start_date per_all_people_f.projected_start_date%TYPE;
238: l_resume_last_updated per_all_people_f.resume_last_updated%TYPE;
239: l_person_id per_all_people_f.person_id%TYPE;
240: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 237: l_projected_start_date per_all_people_f.projected_start_date%TYPE;

233: l_date_employee_data_verified per_all_people_f.date_employee_data_verified%TYPE;
234: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
235: l_background_date_check per_all_people_f.background_date_check%TYPE;
236: l_hold_applicant_date_until per_all_people_f.hold_applicant_date_until%TYPE;
237: l_projected_start_date per_all_people_f.projected_start_date%TYPE;
238: l_resume_last_updated per_all_people_f.resume_last_updated%TYPE;
239: l_person_id per_all_people_f.person_id%TYPE;
240: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
241: l_application_id per_applications.application_id%TYPE;

Line 238: l_resume_last_updated per_all_people_f.resume_last_updated%TYPE;

234: l_date_of_birth per_all_people_f.date_of_birth%TYPE;
235: l_background_date_check per_all_people_f.background_date_check%TYPE;
236: l_hold_applicant_date_until per_all_people_f.hold_applicant_date_until%TYPE;
237: l_projected_start_date per_all_people_f.projected_start_date%TYPE;
238: l_resume_last_updated per_all_people_f.resume_last_updated%TYPE;
239: l_person_id per_all_people_f.person_id%TYPE;
240: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
241: l_application_id per_applications.application_id%TYPE;
242: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

Line 239: l_person_id per_all_people_f.person_id%TYPE;

235: l_background_date_check per_all_people_f.background_date_check%TYPE;
236: l_hold_applicant_date_until per_all_people_f.hold_applicant_date_until%TYPE;
237: l_projected_start_date per_all_people_f.projected_start_date%TYPE;
238: l_resume_last_updated per_all_people_f.resume_last_updated%TYPE;
239: l_person_id per_all_people_f.person_id%TYPE;
240: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
241: l_application_id per_applications.application_id%TYPE;
242: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
243: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 242: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

238: l_resume_last_updated per_all_people_f.resume_last_updated%TYPE;
239: l_person_id per_all_people_f.person_id%TYPE;
240: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
241: l_application_id per_applications.application_id%TYPE;
242: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
243: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
244: l_apl_object_version_number per_applications.object_version_number%TYPE;
245: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
246: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

Line 245: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

241: l_application_id per_applications.application_id%TYPE;
242: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
243: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
244: l_apl_object_version_number per_applications.object_version_number%TYPE;
245: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
246: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
247: l_full_name per_all_people_f.full_name%TYPE;
248: l_per_comment_id per_all_people_f.comment_id%TYPE;
249: l_employee_number per_all_people_f.employee_number%TYPE;

Line 246: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

242: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
243: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
244: l_apl_object_version_number per_applications.object_version_number%TYPE;
245: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
246: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
247: l_full_name per_all_people_f.full_name%TYPE;
248: l_per_comment_id per_all_people_f.comment_id%TYPE;
249: l_employee_number per_all_people_f.employee_number%TYPE;
250: l_npw_number per_all_people_f.npw_number%TYPE;

Line 247: l_full_name per_all_people_f.full_name%TYPE;

243: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
244: l_apl_object_version_number per_applications.object_version_number%TYPE;
245: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
246: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
247: l_full_name per_all_people_f.full_name%TYPE;
248: l_per_comment_id per_all_people_f.comment_id%TYPE;
249: l_employee_number per_all_people_f.employee_number%TYPE;
250: l_npw_number per_all_people_f.npw_number%TYPE;
251: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

Line 248: l_per_comment_id per_all_people_f.comment_id%TYPE;

244: l_apl_object_version_number per_applications.object_version_number%TYPE;
245: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
246: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
247: l_full_name per_all_people_f.full_name%TYPE;
248: l_per_comment_id per_all_people_f.comment_id%TYPE;
249: l_employee_number per_all_people_f.employee_number%TYPE;
250: l_npw_number per_all_people_f.npw_number%TYPE;
251: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
252: l_name_combination_warning boolean;

Line 249: l_employee_number per_all_people_f.employee_number%TYPE;

245: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
246: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
247: l_full_name per_all_people_f.full_name%TYPE;
248: l_per_comment_id per_all_people_f.comment_id%TYPE;
249: l_employee_number per_all_people_f.employee_number%TYPE;
250: l_npw_number per_all_people_f.npw_number%TYPE;
251: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
252: l_name_combination_warning boolean;
253: l_orig_hire_warning boolean;

Line 250: l_npw_number per_all_people_f.npw_number%TYPE;

246: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
247: l_full_name per_all_people_f.full_name%TYPE;
248: l_per_comment_id per_all_people_f.comment_id%TYPE;
249: l_employee_number per_all_people_f.employee_number%TYPE;
250: l_npw_number per_all_people_f.npw_number%TYPE;
251: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
252: l_name_combination_warning boolean;
253: l_orig_hire_warning boolean;
254: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

Line 254: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

250: l_npw_number per_all_people_f.npw_number%TYPE;
251: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
252: l_name_combination_warning boolean;
253: l_orig_hire_warning boolean;
254: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
255: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
256: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
257: l_date_of_death per_all_people_f.date_of_death%TYPE;
258: l_receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%TYPE;

Line 255: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;

251: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
252: l_name_combination_warning boolean;
253: l_orig_hire_warning boolean;
254: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
255: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
256: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
257: l_date_of_death per_all_people_f.date_of_death%TYPE;
258: l_receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%TYPE;
259: l_dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%TYPE;

Line 256: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

252: l_name_combination_warning boolean;
253: l_orig_hire_warning boolean;
254: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
255: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
256: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
257: l_date_of_death per_all_people_f.date_of_death%TYPE;
258: l_receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%TYPE;
259: l_dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%TYPE;
260: l_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;

Line 257: l_date_of_death per_all_people_f.date_of_death%TYPE;

253: l_orig_hire_warning boolean;
254: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
255: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
256: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
257: l_date_of_death per_all_people_f.date_of_death%TYPE;
258: l_receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%TYPE;
259: l_dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%TYPE;
260: l_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
261: l_person_type_id per_all_people_f.person_type_id%TYPE;

Line 258: l_receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%TYPE;

254: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
255: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
256: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
257: l_date_of_death per_all_people_f.date_of_death%TYPE;
258: l_receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%TYPE;
259: l_dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%TYPE;
260: l_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
261: l_person_type_id per_all_people_f.person_type_id%TYPE;
262: l_person_type_id1 per_all_people_f.person_type_id%TYPE;

Line 259: l_dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%TYPE;

255: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
256: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
257: l_date_of_death per_all_people_f.date_of_death%TYPE;
258: l_receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%TYPE;
259: l_dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%TYPE;
260: l_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
261: l_person_type_id per_all_people_f.person_type_id%TYPE;
262: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
263: l_dob_null_warning boolean;

Line 260: l_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;

256: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
257: l_date_of_death per_all_people_f.date_of_death%TYPE;
258: l_receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%TYPE;
259: l_dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%TYPE;
260: l_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
261: l_person_type_id per_all_people_f.person_type_id%TYPE;
262: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
263: l_dob_null_warning boolean;
264: l_phn_object_version_number per_phones.object_version_number%TYPE;

Line 261: l_person_type_id per_all_people_f.person_type_id%TYPE;

257: l_date_of_death per_all_people_f.date_of_death%TYPE;
258: l_receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%TYPE;
259: l_dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%TYPE;
260: l_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
261: l_person_type_id per_all_people_f.person_type_id%TYPE;
262: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
263: l_dob_null_warning boolean;
264: l_phn_object_version_number per_phones.object_version_number%TYPE;
265: l_phone_id per_phones.phone_id%TYPE;

Line 262: l_person_type_id1 per_all_people_f.person_type_id%TYPE;

258: l_receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%TYPE;
259: l_dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%TYPE;
260: l_original_date_of_hire per_all_people_f.original_date_of_hire%TYPE;
261: l_person_type_id per_all_people_f.person_type_id%TYPE;
262: l_person_type_id1 per_all_people_f.person_type_id%TYPE;
263: l_dob_null_warning boolean;
264: l_phn_object_version_number per_phones.object_version_number%TYPE;
265: l_phone_id per_phones.phone_id%TYPE;
266: --

Line 626: ,p_parent_table => 'PER_ALL_PEOPLE_F'

622: ,p_date_to => null
623: ,p_phone_type => 'W1'
624: ,p_phone_number => p_work_telephone
625: ,p_parent_id => l_person_id
626: ,p_parent_table => 'PER_ALL_PEOPLE_F'
627: ,p_validate => FALSE
628: ,p_effective_date => l_date_received
629: ,p_object_version_number => l_phn_object_version_number --out
630: ,p_phone_id => l_phone_id --out

Line 792: FROM per_all_people_f

788: -- Start of fix for bug 3062967
789: --
790: SELECT object_version_number
791: INTO p_per_object_Version_number
792: FROM per_all_people_f
793: WHERE person_id = l_person_id
794: And effective_start_Date = l_per_effective_start_date
795: and effective_end_Date = l_per_effective_end_date;
796: --

Line 1679: p_person_id in per_all_people_f.person_id%TYPE,

1675: -- base release
1676: procedure hire_applicant
1677: (p_validate in boolean , --default false,
1678: p_hire_date in date,
1679: p_person_id in per_all_people_f.person_id%TYPE,
1680: p_assignment_id in number, --default null,
1681: p_person_type_id in number, --default null,
1682: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1683: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,

Line 1682: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

1678: p_hire_date in date,
1679: p_person_id in per_all_people_f.person_id%TYPE,
1680: p_assignment_id in number, --default null,
1681: p_person_type_id in number, --default null,
1682: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1683: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1684: p_per_effective_start_date out nocopy date,
1685: p_per_effective_end_date out nocopy date,
1686: p_unaccepted_asg_del_warning out nocopy boolean,

Line 1683: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,

1679: p_person_id in per_all_people_f.person_id%TYPE,
1680: p_assignment_id in number, --default null,
1681: p_person_type_id in number, --default null,
1682: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1683: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1684: p_per_effective_start_date out nocopy date,
1685: p_per_effective_end_date out nocopy date,
1686: p_unaccepted_asg_del_warning out nocopy boolean,
1687: p_assign_payroll_warning out nocopy boolean,

Line 1698: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

1694: -- Declare cursors and local variables
1695: --
1696: l_proc varchar2(72) := g_package||'hire__applicant';
1697: --
1698: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1699: l_employee_number per_all_people_f.employee_number%TYPE;
1700: l_per_effective_start_date date;
1701: l_per_effective_end_date date;
1702: l_unaccepted_asg_del_warning boolean;

Line 1699: l_employee_number per_all_people_f.employee_number%TYPE;

1695: --
1696: l_proc varchar2(72) := g_package||'hire__applicant';
1697: --
1698: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1699: l_employee_number per_all_people_f.employee_number%TYPE;
1700: l_per_effective_start_date date;
1701: l_per_effective_end_date date;
1702: l_unaccepted_asg_del_warning boolean;
1703: l_assign_payroll_warning boolean;

Line 1753: p_person_id in per_all_people_f.person_id%TYPE,

1749: -- base release
1750: procedure hire_applicant
1751: (p_validate in boolean, --default false,
1752: p_hire_date in date,
1753: p_person_id in per_all_people_f.person_id%TYPE,
1754: p_assignment_id in number, --default null,
1755: p_person_type_id in number, --default null,
1756: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,
1757: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

Line 1756: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,

1752: p_hire_date in date,
1753: p_person_id in per_all_people_f.person_id%TYPE,
1754: p_assignment_id in number, --default null,
1755: p_person_type_id in number, --default null,
1756: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,
1757: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1758: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1759: p_per_effective_start_date out nocopy date,
1760: p_per_effective_end_date out nocopy date,

Line 1757: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

1753: p_person_id in per_all_people_f.person_id%TYPE,
1754: p_assignment_id in number, --default null,
1755: p_person_type_id in number, --default null,
1756: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,
1757: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1758: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1759: p_per_effective_start_date out nocopy date,
1760: p_per_effective_end_date out nocopy date,
1761: p_unaccepted_asg_del_warning out nocopy boolean,

Line 1758: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,

1754: p_assignment_id in number, --default null,
1755: p_person_type_id in number, --default null,
1756: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,
1757: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1758: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1759: p_per_effective_start_date out nocopy date,
1760: p_per_effective_end_date out nocopy date,
1761: p_unaccepted_asg_del_warning out nocopy boolean,
1762: p_assign_payroll_warning out nocopy boolean,

Line 1805: p_person_id in per_all_people_f.person_id%TYPE,

1801: --
1802: procedure hire_applicant
1803: (p_validate in boolean, --default false,
1804: p_hire_date in date,
1805: p_person_id in per_all_people_f.person_id%TYPE,
1806: p_assignment_id in number, --default null,
1807: p_person_type_id in number, --default null,
1808: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,
1809: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

Line 1808: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,

1804: p_hire_date in date,
1805: p_person_id in per_all_people_f.person_id%TYPE,
1806: p_assignment_id in number, --default null,
1807: p_person_type_id in number, --default null,
1808: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,
1809: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1810: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1811: p_per_effective_start_date out nocopy date,
1812: p_per_effective_end_date out nocopy date,

Line 1809: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

1805: p_person_id in per_all_people_f.person_id%TYPE,
1806: p_assignment_id in number, --default null,
1807: p_person_type_id in number, --default null,
1808: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,
1809: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1810: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1811: p_per_effective_start_date out nocopy date,
1812: p_per_effective_end_date out nocopy date,
1813: p_unaccepted_asg_del_warning out nocopy boolean,

Line 1810: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,

1806: p_assignment_id in number, --default null,
1807: p_person_type_id in number, --default null,
1808: p_national_identifier in per_all_people_f.national_identifier%type, --default hr_api.g_varchar2,
1809: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1810: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
1811: p_per_effective_start_date out nocopy date,
1812: p_per_effective_end_date out nocopy date,
1813: p_unaccepted_asg_del_warning out nocopy boolean,
1814: p_assign_payroll_warning out nocopy boolean,

Line 1831: l_chk_person_id per_all_people_f.person_id%TYPE;

1827: l_exists varchar2(1);
1828: l_count number;
1829: l_multi_flag boolean;
1830: l_chk_system_status per_assignment_status_types.per_system_status%TYPE;
1831: l_chk_person_id per_all_people_f.person_id%TYPE;
1832: --
1833: l_person_type_id number := p_person_type_id;
1834: l_person_type_id1 number;
1835: l_unaccepted_asg_del_warning boolean;

Line 1838: l_business_group_id per_all_people_f.business_group_id%TYPE;

1834: l_person_type_id1 number;
1835: l_unaccepted_asg_del_warning boolean;
1836: --
1837: l_system_person_type per_person_types.system_person_type%TYPE;
1838: l_business_group_id per_all_people_f.business_group_id%TYPE;
1839: l_legislation_code per_business_groups.legislation_code%TYPE;
1840: l_applicant_number per_all_people_f.applicant_number%TYPE;
1841: l_application_id per_applications.application_id%TYPE;
1842: l_apl_object_version_number per_applications.application_id%TYPE;

Line 1840: l_applicant_number per_all_people_f.applicant_number%TYPE;

1836: --
1837: l_system_person_type per_person_types.system_person_type%TYPE;
1838: l_business_group_id per_all_people_f.business_group_id%TYPE;
1839: l_legislation_code per_business_groups.legislation_code%TYPE;
1840: l_applicant_number per_all_people_f.applicant_number%TYPE;
1841: l_application_id per_applications.application_id%TYPE;
1842: l_apl_object_version_number per_applications.application_id%TYPE;
1843: --
1844: l_hire_date date;

Line 1851: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

1847: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
1848: l_assignment_id per_assignments_f.assignment_id%TYPE;
1849: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
1850: --
1851: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1852: l_employee_number per_all_people_f.employee_number%TYPE;
1853: l_npw_number per_all_people_f.npw_number%TYPE;
1854: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1855: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

Line 1852: l_employee_number per_all_people_f.employee_number%TYPE;

1848: l_assignment_id per_assignments_f.assignment_id%TYPE;
1849: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
1850: --
1851: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1852: l_employee_number per_all_people_f.employee_number%TYPE;
1853: l_npw_number per_all_people_f.npw_number%TYPE;
1854: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1855: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
1856: l_comment_id per_assignments_f.comment_id%TYPE;

Line 1853: l_npw_number per_all_people_f.npw_number%TYPE;

1849: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
1850: --
1851: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1852: l_employee_number per_all_people_f.employee_number%TYPE;
1853: l_npw_number per_all_people_f.npw_number%TYPE;
1854: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1855: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
1856: l_comment_id per_assignments_f.comment_id%TYPE;
1857: l_current_applicant_flag varchar2(1);

Line 1854: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

1850: --
1851: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1852: l_employee_number per_all_people_f.employee_number%TYPE;
1853: l_npw_number per_all_people_f.npw_number%TYPE;
1854: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1855: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
1856: l_comment_id per_assignments_f.comment_id%TYPE;
1857: l_current_applicant_flag varchar2(1);
1858: l_current_emp_or_apl_flag varchar2(1);

Line 1855: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

1851: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1852: l_employee_number per_all_people_f.employee_number%TYPE;
1853: l_npw_number per_all_people_f.npw_number%TYPE;
1854: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1855: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
1856: l_comment_id per_assignments_f.comment_id%TYPE;
1857: l_current_applicant_flag varchar2(1);
1858: l_current_emp_or_apl_flag varchar2(1);
1859: l_current_employee_flag varchar2(1);

Line 1860: l_full_name per_all_people_f.full_name%TYPE;

1856: l_comment_id per_assignments_f.comment_id%TYPE;
1857: l_current_applicant_flag varchar2(1);
1858: l_current_emp_or_apl_flag varchar2(1);
1859: l_current_employee_flag varchar2(1);
1860: l_full_name per_all_people_f.full_name%TYPE;
1861: l_name_combination_warning boolean;
1862: l_assign_payroll_warning boolean;
1863: l_orig_hire_warning boolean;
1864: l_hourly_salaried_warning boolean;

Line 1967: and exists (select null from per_all_people_f where person_id = p_person_id and effective_start_date = l_hire_date);

1963: where asg.assignment_status_type_id = pas.assignment_status_type_id
1964: and asg.person_id = p_person_id
1965: and pas.per_system_status = 'ACCEPTED'
1966: and l_hire_date - 1 between asg.effective_start_date and asg.effective_end_date
1967: and exists (select null from per_all_people_f where person_id = p_person_id and effective_start_date = l_hire_date);
1968: -- bug 14523339
1969:
1970: lv_per_object_version_number per_all_people_f.object_version_number%TYPE := p_per_object_version_number ;
1971: lv_employee_number per_all_people_f.employee_number%TYPE := p_employee_number ;

Line 1970: lv_per_object_version_number per_all_people_f.object_version_number%TYPE := p_per_object_version_number ;

1966: and l_hire_date - 1 between asg.effective_start_date and asg.effective_end_date
1967: and exists (select null from per_all_people_f where person_id = p_person_id and effective_start_date = l_hire_date);
1968: -- bug 14523339
1969:
1970: lv_per_object_version_number per_all_people_f.object_version_number%TYPE := p_per_object_version_number ;
1971: lv_employee_number per_all_people_f.employee_number%TYPE := p_employee_number ;
1972: --
1973: --
1974: -- Bug# 2273304 Start Here

Line 1971: lv_employee_number per_all_people_f.employee_number%TYPE := p_employee_number ;

1967: and exists (select null from per_all_people_f where person_id = p_person_id and effective_start_date = l_hire_date);
1968: -- bug 14523339
1969:
1970: lv_per_object_version_number per_all_people_f.object_version_number%TYPE := p_per_object_version_number ;
1971: lv_employee_number per_all_people_f.employee_number%TYPE := p_employee_number ;
1972: --
1973: --
1974: -- Bug# 2273304 Start Here
1975: --

Line 1983: from per_all_people_f ppf

1979: l_maximum_age number(3); --2273304
1980: --
1981: cursor csr_date_of_birth is
1982: select date_of_birth
1983: from per_all_people_f ppf
1984: where ppf.person_id = p_person_id
1985: and l_business_group_id = ppf.business_group_id
1986: and p_hire_date between effective_start_date
1987: and nvl(effective_end_date,p_hire_date);

Line 2021: from per_all_people_f per,

2017: pap.application_id,
2018: pap.object_version_number,
2019: per.npw_number,
2020: per.original_date_of_hire -- #2978566
2021: from per_all_people_f per,
2022: per_business_groups bus,
2023: per_person_types ppt,
2024: per_applications pap
2025: where per.person_type_id = ppt.person_type_id

Line 2047: from per_all_people_f per,

2043: --
2044: cursor csr_chk_assignment_id is
2045: select per.person_id,
2046: pas.per_system_status
2047: from per_all_people_f per,
2048: per_assignments_f asg,
2049: per_assignment_status_types pas
2050: where asg.assignment_status_type_id = pas.assignment_status_type_id
2051: and per.person_id = asg.person_id

Line 2206: ,per_all_people_f ppf

2202: --
2203: cursor csr_get_legislation_code is
2204: select legislation_code
2205: from per_business_groups_perf pbg
2206: ,per_all_people_f ppf
2207: where ppf.person_id = p_person_id
2208: and pbg.business_group_id+0 = ppf.business_group_id;
2209:
2210: cursor csr_get_new_hire_code is

Line 2212: FROM per_all_people_f

2208: and pbg.business_group_id+0 = ppf.business_group_id;
2209:
2210: cursor csr_get_new_hire_code is
2211: SELECT per_information7
2212: FROM per_all_people_f
2213: WHERE person_id = p_person_id
2214: AND effective_start_date =
2215: (select max(effective_start_date)
2216: from per_all_people_f

Line 2216: from per_all_people_f

2212: FROM per_all_people_f
2213: WHERE person_id = p_person_id
2214: AND effective_start_date =
2215: (select max(effective_start_date)
2216: from per_all_people_f
2217: where person_id = p_person_id
2218: );
2219: -- end of bug3572499
2220:

Line 2761: -- Lock the person record in PER_ALL_PEOPLE_F ready for UPDATE at a later point.

2757: close chk_hire_date;
2758: -- bug 14523339
2759: hr_utility.set_location(l_proc,175);
2760: --
2761: -- Lock the person record in PER_ALL_PEOPLE_F ready for UPDATE at a later point.
2762: -- (Note: This is necessary because calling the table handlers in locking
2763: -- ladder order invokes an error in per_apl_upd.upd due to the person
2764: -- being modified by the per_per_upd.upd table handler.)
2765: per_per_shd.lck

Line 2794: l_parent_table := 'PER_ALL_PEOPLE_F';

2790: hr_utility.set_location(l_proc,181);
2791: --
2792: for phn_rec in csr_phn(per_per_shd.g_old_rec.party_id) loop
2793: l_phn_ovn:=phn_rec.object_version_number;
2794: l_parent_table := 'PER_ALL_PEOPLE_F';
2795: per_phn_upd.upd(p_phone_id => phn_rec.phone_id
2796: ,p_parent_id => per_per_shd.g_old_rec.person_id
2797: ,p_parent_table => l_parent_table
2798: ,p_object_version_number => l_phn_ovn

Line 3083: -- the per_all_people_f table.

3079: -- enf of bug3572499
3080:
3081: --
3082: -- Update the person details by calling upd procedure in
3083: -- the per_all_people_f table.
3084: --
3085: l_person_type_id1 :=
3086: hr_person_type_usage_info.get_default_person_type_id
3087: (l_business_group_id

Line 3225: from per_all_people_f

3221: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id
3222: (l_business_group_id,'EMP_APL');
3223:
3224: select object_version_number into l_per_latest_ovn
3225: from per_all_people_f
3226: where person_id= p_person_id
3227: and l_apln_date_start between effective_start_date and effective_end_date;
3228:
3229: -- creating EMP_APL records in PER table

Line 3274: from per_all_people_f

3270: ,p_person_type_id => l_person_type_id2
3271: );
3272:
3273: select object_version_number into l_per_latest_ovn
3274: from per_all_people_f
3275: where person_id= p_person_id
3276: and l_hire_date between effective_start_date and effective_end_date;
3277:
3278: l_person_type_id2 := hr_person_type_usage_info.get_default_person_type_id

Line 4110: ,p_person_id IN per_all_people_f.person_id%TYPE

4106: -- OLD
4107: PROCEDURE terminate_applicant
4108: (p_validate IN BOOLEAN --DEFAULT FALSE
4109: ,p_effective_date IN DATE
4110: ,p_person_id IN per_all_people_f.person_id%TYPE
4111: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4112: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT hr_api.g_number
4113: ,p_termination_reason IN per_applications.termination_reason%TYPE --DEFAULT NULL
4114: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

Line 4111: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

4107: PROCEDURE terminate_applicant
4108: (p_validate IN BOOLEAN --DEFAULT FALSE
4109: ,p_effective_date IN DATE
4110: ,p_person_id IN per_all_people_f.person_id%TYPE
4111: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4112: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT hr_api.g_number
4113: ,p_termination_reason IN per_applications.termination_reason%TYPE --DEFAULT NULL
4114: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4115: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 4114: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

4110: ,p_person_id IN per_all_people_f.person_id%TYPE
4111: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4112: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT hr_api.g_number
4113: ,p_termination_reason IN per_applications.termination_reason%TYPE --DEFAULT NULL
4114: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4115: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4116: )
4117: IS
4118: Begin

Line 4115: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

4111: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4112: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT hr_api.g_number
4113: ,p_termination_reason IN per_applications.termination_reason%TYPE --DEFAULT NULL
4114: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4115: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4116: )
4117: IS
4118: Begin
4119: hr_applicant_api.terminate_applicant

Line 4139: ,p_person_id IN per_all_people_f.person_id%TYPE

4135: --
4136: PROCEDURE terminate_applicant
4137: (p_validate IN BOOLEAN
4138: ,p_effective_date IN DATE
4139: ,p_person_id IN per_all_people_f.person_id%TYPE
4140: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4141: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4142: ,p_termination_reason IN per_applications.termination_reason%TYPE
4143: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

Line 4140: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

4136: PROCEDURE terminate_applicant
4137: (p_validate IN BOOLEAN
4138: ,p_effective_date IN DATE
4139: ,p_person_id IN per_all_people_f.person_id%TYPE
4140: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4141: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4142: ,p_termination_reason IN per_applications.termination_reason%TYPE
4143: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4144: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

Line 4144: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

4140: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4141: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4142: ,p_termination_reason IN per_applications.termination_reason%TYPE
4143: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4144: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4145: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4146: )
4147: IS
4148: l_warning boolean;

Line 4145: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

4141: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4142: ,p_termination_reason IN per_applications.termination_reason%TYPE
4143: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4144: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4145: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4146: )
4147: IS
4148: l_warning boolean;
4149: BEGIN

Line 4171: ,p_person_id IN per_all_people_f.person_id%TYPE

4167: --
4168: PROCEDURE terminate_applicant
4169: (p_validate IN BOOLEAN
4170: ,p_effective_date IN DATE
4171: ,p_person_id IN per_all_people_f.person_id%TYPE
4172: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4173: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4174: ,p_termination_reason IN per_applications.termination_reason%TYPE
4175: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

Line 4172: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

4168: PROCEDURE terminate_applicant
4169: (p_validate IN BOOLEAN
4170: ,p_effective_date IN DATE
4171: ,p_person_id IN per_all_people_f.person_id%TYPE
4172: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4173: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4174: ,p_termination_reason IN per_applications.termination_reason%TYPE
4175: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4176: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

Line 4176: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

4172: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4173: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4174: ,p_termination_reason IN per_applications.termination_reason%TYPE
4175: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4176: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4177: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4178: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
4179: )
4180: IS

Line 4177: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

4173: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4174: ,p_termination_reason IN per_applications.termination_reason%TYPE
4175: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4176: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4177: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4178: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
4179: )
4180: IS
4181: BEGIN

Line 4204: ,p_person_id IN per_all_people_f.person_id%TYPE

4200: --
4201: PROCEDURE terminate_applicant
4202: (p_validate IN BOOLEAN
4203: ,p_effective_date IN DATE
4204: ,p_person_id IN per_all_people_f.person_id%TYPE
4205: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4206: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4207: ,p_termination_reason IN per_applications.termination_reason%TYPE
4208: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

Line 4205: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

4201: PROCEDURE terminate_applicant
4202: (p_validate IN BOOLEAN
4203: ,p_effective_date IN DATE
4204: ,p_person_id IN per_all_people_f.person_id%TYPE
4205: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4206: ,p_person_type_id IN per_person_types.person_type_id%TYPE
4207: ,p_termination_reason IN per_applications.termination_reason%TYPE
4208: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4209: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579

Line 4211: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

4207: ,p_termination_reason IN per_applications.termination_reason%TYPE
4208: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4209: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
4210: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE -- 8732296
4211: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4212: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4213: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
4214: )
4215: IS

Line 4212: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

4208: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
4209: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE -- 4066579
4210: ,p_status_change_comments IN irc_assignment_statuses.status_change_comments%TYPE -- 8732296
4211: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4212: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4213: ,p_remove_fut_asg_warning OUT NOCOPY BOOLEAN -- 3652025
4214: )
4215: IS
4216: --

Line 4225: l_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_object_version_number;

4221: l_legislation_code varchar2(30);
4222: l_asg_status_ovn number;
4223: l_effective_date DATE;
4224: --
4225: l_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_object_version_number;
4226: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
4227: l_person_type_id1 per_person_types.person_type_id%TYPE;
4228: --
4229: l_assignment_status_id number;

Line 4240: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

4236: l_business_group_id hr_all_organization_units.organization_id%TYPE;
4237: l_org_now_no_manager_warning BOOLEAN;
4238: l_system_person_type per_person_types.system_person_type%TYPE;
4239: l_comment_id hr_comments.comment_id%TYPE;
4240: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
4241: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4242: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4243: l_full_name per_all_people_f.full_name%TYPE;
4244: l_name_combination_warning BOOLEAN;

Line 4241: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;

4237: l_org_now_no_manager_warning BOOLEAN;
4238: l_system_person_type per_person_types.system_person_type%TYPE;
4239: l_comment_id hr_comments.comment_id%TYPE;
4240: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
4241: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4242: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4243: l_full_name per_all_people_f.full_name%TYPE;
4244: l_name_combination_warning BOOLEAN;
4245: l_dob_null_warning BOOLEAN;

Line 4242: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

4238: l_system_person_type per_person_types.system_person_type%TYPE;
4239: l_comment_id hr_comments.comment_id%TYPE;
4240: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
4241: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4242: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4243: l_full_name per_all_people_f.full_name%TYPE;
4244: l_name_combination_warning BOOLEAN;
4245: l_dob_null_warning BOOLEAN;
4246: l_orig_hire_warning BOOLEAN;

Line 4243: l_full_name per_all_people_f.full_name%TYPE;

4239: l_comment_id hr_comments.comment_id%TYPE;
4240: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
4241: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4242: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4243: l_full_name per_all_people_f.full_name%TYPE;
4244: l_name_combination_warning BOOLEAN;
4245: l_dob_null_warning BOOLEAN;
4246: l_orig_hire_warning BOOLEAN;
4247: --

Line 4248: lv_object_version_number per_all_people_f.object_version_number%TYPE := p_object_version_number ;

4244: l_name_combination_warning BOOLEAN;
4245: l_dob_null_warning BOOLEAN;
4246: l_orig_hire_warning BOOLEAN;
4247: --
4248: lv_object_version_number per_all_people_f.object_version_number%TYPE := p_object_version_number ;
4249: l_remove_future_asg_warning BOOLEAN;
4250: l_count NUMBER;
4251: --fix for bug 7229710 Starts here.
4252: l_vacancy_id number;

Line 4268: ,p_person_id IN per_all_people_f.person_id%TYPE

4264: --fix for bug 7229710 Ends here.
4265:
4266: CURSOR csr_applications
4267: (p_effective_date IN DATE
4268: ,p_person_id IN per_all_people_f.person_id%TYPE
4269: )
4270: IS
4271: SELECT apl.application_id
4272: ,apl.object_version_number

Line 4292: ,p_person_id IN per_all_people_f.person_id%TYPE

4288: l_application csr_applications%ROWTYPE;
4289: --
4290: CURSOR csr_assignments
4291: (p_effective_date IN DATE
4292: ,p_person_id IN per_all_people_f.person_id%TYPE
4293: )
4294: IS
4295: SELECT asg.assignment_id
4296: ,asg.object_version_number

Line 4324: FROM per_all_people_f

4320: ORDER BY as2.effective_start_date, as2.assignment_id ASC;
4321:
4322: CURSOR csr_lock_person(cp_person_id number, cp_termination_date date) IS
4323: SELECT null
4324: FROM per_all_people_f
4325: WHERE person_id = cp_person_id
4326: AND (effective_start_date > cp_termination_date
4327: OR
4328: cp_termination_date between effective_start_date

Line 4813: ,p_person_id IN per_all_people_f.person_id%TYPE

4809: -- OLD
4810: PROCEDURE convert_to_applicant
4811: (p_validate IN BOOLEAN --DEFAULT FALSE
4812: ,p_effective_date IN DATE
4813: ,p_person_id IN per_all_people_f.person_id%TYPE
4814: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4815: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
4816: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
4817: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

Line 4814: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

4810: PROCEDURE convert_to_applicant
4811: (p_validate IN BOOLEAN --DEFAULT FALSE
4812: ,p_effective_date IN DATE
4813: ,p_person_id IN per_all_people_f.person_id%TYPE
4814: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4815: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
4816: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
4817: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4818: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 4815: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE

4811: (p_validate IN BOOLEAN --DEFAULT FALSE
4812: ,p_effective_date IN DATE
4813: ,p_person_id IN per_all_people_f.person_id%TYPE
4814: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4815: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
4816: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
4817: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4818: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4819: ) IS

Line 4817: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

4813: ,p_person_id IN per_all_people_f.person_id%TYPE
4814: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4815: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
4816: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
4817: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4818: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4819: ) IS
4820: l_warning boolean;
4821: BEGIN

Line 4818: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

4814: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4815: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
4816: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
4817: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4818: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4819: ) IS
4820: l_warning boolean;
4821: BEGIN
4822: hr_applicant_api.convert_to_applicant

Line 4842: ,p_person_id IN per_all_people_f.person_id%TYPE

4838: -- NEW
4839: PROCEDURE convert_to_applicant
4840: (p_validate IN BOOLEAN --DEFAULT FALSE
4841: ,p_effective_date IN DATE
4842: ,p_person_id IN per_all_people_f.person_id%TYPE
4843: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4844: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
4845: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
4846: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

Line 4843: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

4839: PROCEDURE convert_to_applicant
4840: (p_validate IN BOOLEAN --DEFAULT FALSE
4841: ,p_effective_date IN DATE
4842: ,p_person_id IN per_all_people_f.person_id%TYPE
4843: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4844: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
4845: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
4846: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4847: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

Line 4844: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE

4840: (p_validate IN BOOLEAN --DEFAULT FALSE
4841: ,p_effective_date IN DATE
4842: ,p_person_id IN per_all_people_f.person_id%TYPE
4843: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4844: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
4845: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
4846: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4847: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4848: ,p_appl_override_warning OUT NOCOPY boolean -- 3652025

Line 4846: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

4842: ,p_person_id IN per_all_people_f.person_id%TYPE
4843: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4844: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
4845: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
4846: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4847: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4848: ,p_appl_override_warning OUT NOCOPY boolean -- 3652025
4849: )
4850: IS

Line 4847: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

4843: ,p_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
4844: ,p_applicant_number IN OUT NOCOPY per_all_people_f.applicant_number%TYPE
4845: ,p_person_type_id IN per_person_types.person_type_id%TYPE --DEFAULT NULL
4846: ,p_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
4847: ,p_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
4848: ,p_appl_override_warning OUT NOCOPY boolean -- 3652025
4849: )
4850: IS
4851: --

Line 4859: l_applicant_number CONSTANT per_all_people_f.applicant_number%TYPE := p_applicant_number;

4855: --
4856: l_effective_date DATE;
4857: --
4858: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
4859: l_applicant_number CONSTANT per_all_people_f.applicant_number%TYPE := p_applicant_number;
4860: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4861: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4862: --
4863: l_person_type_id per_person_types.person_type_id%TYPE;

Line 4860: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

4856: l_effective_date DATE;
4857: --
4858: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
4859: l_applicant_number CONSTANT per_all_people_f.applicant_number%TYPE := p_applicant_number;
4860: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4861: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4862: --
4863: l_person_type_id per_person_types.person_type_id%TYPE;
4864: l_person_type_id1 per_person_types.person_type_id%TYPE;

Line 4861: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

4857: --
4858: l_object_version_number CONSTANT per_all_assignments_f.object_version_number%TYPE := p_object_version_number;
4859: l_applicant_number CONSTANT per_all_people_f.applicant_number%TYPE := p_applicant_number;
4860: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4861: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4862: --
4863: l_person_type_id per_person_types.person_type_id%TYPE;
4864: l_person_type_id1 per_person_types.person_type_id%TYPE;
4865: --

Line 4871: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

4867: l_system_person_type per_person_types.system_person_type%TYPE;
4868: l_effective_start_date DATE;
4869: l_effective_end_date DATE;
4870: l_comment_id hr_comments.comment_id%TYPE;
4871: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
4872: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4873: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4874: l_full_name per_all_people_f.full_name%TYPE;
4875: l_name_combination_warning BOOLEAN;

Line 4872: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;

4868: l_effective_start_date DATE;
4869: l_effective_end_date DATE;
4870: l_comment_id hr_comments.comment_id%TYPE;
4871: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
4872: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4873: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4874: l_full_name per_all_people_f.full_name%TYPE;
4875: l_name_combination_warning BOOLEAN;
4876: l_dob_null_warning BOOLEAN;

Line 4873: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

4869: l_effective_end_date DATE;
4870: l_comment_id hr_comments.comment_id%TYPE;
4871: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
4872: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4873: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4874: l_full_name per_all_people_f.full_name%TYPE;
4875: l_name_combination_warning BOOLEAN;
4876: l_dob_null_warning BOOLEAN;
4877: l_orig_hire_warning BOOLEAN;

Line 4874: l_full_name per_all_people_f.full_name%TYPE;

4870: l_comment_id hr_comments.comment_id%TYPE;
4871: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
4872: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
4873: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
4874: l_full_name per_all_people_f.full_name%TYPE;
4875: l_name_combination_warning BOOLEAN;
4876: l_dob_null_warning BOOLEAN;
4877: l_orig_hire_warning BOOLEAN;
4878: l_application_id per_applications.application_id%TYPE;

Line 4886: lv_object_version_number per_all_people_f.object_version_number%TYPE := p_object_version_number ;

4882: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
4883: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
4884: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
4885: --
4886: lv_object_version_number per_all_people_f.object_version_number%TYPE := p_object_version_number ;
4887: lv_applicant_number per_all_people_f.applicant_number%TYPE := p_applicant_number ;
4888: l_datetrack_mode varchar2(30); -- Bug 2738584
4889: --
4890: l_per_effective_start_date per_all_people_f.effective_end_date%TYPE;

Line 4887: lv_applicant_number per_all_people_f.applicant_number%TYPE := p_applicant_number ;

4883: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
4884: l_ptu_object_version_number per_person_type_usages.object_version_number%TYPE;
4885: --
4886: lv_object_version_number per_all_people_f.object_version_number%TYPE := p_object_version_number ;
4887: lv_applicant_number per_all_people_f.applicant_number%TYPE := p_applicant_number ;
4888: l_datetrack_mode varchar2(30); -- Bug 2738584
4889: --
4890: l_per_effective_start_date per_all_people_f.effective_end_date%TYPE;
4891: l_per_effective_end_date per_all_people_f.effective_start_date%TYPE;

Line 4890: l_per_effective_start_date per_all_people_f.effective_end_date%TYPE;

4886: lv_object_version_number per_all_people_f.object_version_number%TYPE := p_object_version_number ;
4887: lv_applicant_number per_all_people_f.applicant_number%TYPE := p_applicant_number ;
4888: l_datetrack_mode varchar2(30); -- Bug 2738584
4889: --
4890: l_per_effective_start_date per_all_people_f.effective_end_date%TYPE;
4891: l_per_effective_end_date per_all_people_f.effective_start_date%TYPE;
4892: l_appl_override_warning boolean;
4893: --
4894: -- Local cursors

Line 4891: l_per_effective_end_date per_all_people_f.effective_start_date%TYPE;

4887: lv_applicant_number per_all_people_f.applicant_number%TYPE := p_applicant_number ;
4888: l_datetrack_mode varchar2(30); -- Bug 2738584
4889: --
4890: l_per_effective_start_date per_all_people_f.effective_end_date%TYPE;
4891: l_per_effective_end_date per_all_people_f.effective_start_date%TYPE;
4892: l_appl_override_warning boolean;
4893: --
4894: -- Local cursors
4895: --

Line 4897: (p_person_id IN per_all_people_f.person_id%TYPE

4893: --
4894: -- Local cursors
4895: --
4896: CURSOR csr_per_details
4897: (p_person_id IN per_all_people_f.person_id%TYPE
4898: ,p_effective_date IN DATE
4899: )
4900: IS
4901: SELECT pet.person_type_id

Line 5243: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

5239: -- apply_for_job_anytime
5240: --
5241: l_apl_object_version_number per_applications.object_version_number%TYPE;
5242: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
5243: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
5244: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
5245: --
5246: --
5247: -- select and validate the person

Line 5244: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

5240: --
5241: l_apl_object_version_number per_applications.object_version_number%TYPE;
5242: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
5243: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
5244: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
5245: --
5246: --
5247: -- select and validate the person
5248: --