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_EMPLOYEE_API dependencies on PER_PEOPLE_F

Line 304: l_person_id per_people_f.person_id%type;

300: --
301: l_proc varchar2(72);
302: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;
303: l_person_type_id1 per_person_types.person_type_id%type;
304: l_person_id per_people_f.person_id%type;
305: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
306: l_employee_number per_people_f.employee_number%type;
307: l_emp_num per_people_f.employee_number%type := p_employee_number;
308: l_applicant_number per_people_f.applicant_number%TYPE;

Line 306: l_employee_number per_people_f.employee_number%type;

302: l_person_type_id per_person_types.person_type_id%type := p_person_type_id;
303: l_person_type_id1 per_person_types.person_type_id%type;
304: l_person_id per_people_f.person_id%type;
305: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
306: l_employee_number per_people_f.employee_number%type;
307: l_emp_num per_people_f.employee_number%type := p_employee_number;
308: l_applicant_number per_people_f.applicant_number%TYPE;
309: l_npw_number per_people_f.npw_number%TYPE;
310: l_assignment_sequence per_assignments_f.assignment_sequence%type;

Line 307: l_emp_num per_people_f.employee_number%type := p_employee_number;

303: l_person_type_id1 per_person_types.person_type_id%type;
304: l_person_id per_people_f.person_id%type;
305: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
306: l_employee_number per_people_f.employee_number%type;
307: l_emp_num per_people_f.employee_number%type := p_employee_number;
308: l_applicant_number per_people_f.applicant_number%TYPE;
309: l_npw_number per_people_f.npw_number%TYPE;
310: l_assignment_sequence per_assignments_f.assignment_sequence%type;
311: l_assignment_number per_assignments_f.assignment_number%type;

Line 308: l_applicant_number per_people_f.applicant_number%TYPE;

304: l_person_id per_people_f.person_id%type;
305: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
306: l_employee_number per_people_f.employee_number%type;
307: l_emp_num per_people_f.employee_number%type := p_employee_number;
308: l_applicant_number per_people_f.applicant_number%TYPE;
309: l_npw_number per_people_f.npw_number%TYPE;
310: l_assignment_sequence per_assignments_f.assignment_sequence%type;
311: l_assignment_number per_assignments_f.assignment_number%type;
312: l_hire_date date;

Line 309: l_npw_number per_people_f.npw_number%TYPE;

305: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
306: l_employee_number per_people_f.employee_number%type;
307: l_emp_num per_people_f.employee_number%type := p_employee_number;
308: l_applicant_number per_people_f.applicant_number%TYPE;
309: l_npw_number per_people_f.npw_number%TYPE;
310: l_assignment_sequence per_assignments_f.assignment_sequence%type;
311: l_assignment_number per_assignments_f.assignment_number%type;
312: l_hire_date date;
313: l_discard_number number;

Line 321: l_full_name per_people_f.full_name%type;

317: l_per_object_version_number number;
318: l_asg_object_version_number number;
319: l_per_effective_start_date date;
320: l_per_effective_end_date date;
321: l_full_name per_people_f.full_name%type;
322: l_per_comment_id number;
323: l_name_combination_warning boolean;
324: l_assign_payroll_warning boolean;
325: l_orig_hire_warning boolean;

Line 2532: l_business_group_id per_people_f.business_group_id%type;

2528: --
2529: -- declare local variables
2530: --
2531: l_proc varchar2(72) := g_package||'re_hire_ex_employee';
2532: l_business_group_id per_people_f.business_group_id%type;
2533: l_ovn per_people_f.object_version_number%type := p_per_object_version_number;
2534: l_name_combination_warning boolean;
2535: l_orig_hire_warning boolean;
2536: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;

Line 2533: l_ovn per_people_f.object_version_number%type := p_per_object_version_number;

2529: -- declare local variables
2530: --
2531: l_proc varchar2(72) := g_package||'re_hire_ex_employee';
2532: l_business_group_id per_people_f.business_group_id%type;
2533: l_ovn per_people_f.object_version_number%type := p_per_object_version_number;
2534: l_name_combination_warning boolean;
2535: l_orig_hire_warning boolean;
2536: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
2537: l_person_type_id1 per_people_f.person_type_id%type;

Line 2536: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;

2532: l_business_group_id per_people_f.business_group_id%type;
2533: l_ovn per_people_f.object_version_number%type := p_per_object_version_number;
2534: l_name_combination_warning boolean;
2535: l_orig_hire_warning boolean;
2536: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
2537: l_person_type_id1 per_people_f.person_type_id%type;
2538: l_comment_id per_people_f.comment_id%type;
2539: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2540: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

Line 2537: l_person_type_id1 per_people_f.person_type_id%type;

2533: l_ovn per_people_f.object_version_number%type := p_per_object_version_number;
2534: l_name_combination_warning boolean;
2535: l_orig_hire_warning boolean;
2536: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
2537: l_person_type_id1 per_people_f.person_type_id%type;
2538: l_comment_id per_people_f.comment_id%type;
2539: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2540: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2541: l_current_employee_flag per_people_f.current_employee_flag%type;

Line 2538: l_comment_id per_people_f.comment_id%type;

2534: l_name_combination_warning boolean;
2535: l_orig_hire_warning boolean;
2536: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
2537: l_person_type_id1 per_people_f.person_type_id%type;
2538: l_comment_id per_people_f.comment_id%type;
2539: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2540: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2541: l_current_employee_flag per_people_f.current_employee_flag%type;
2542: l_employee_number per_people_f.employee_number%type;

Line 2539: l_current_applicant_flag per_people_f.current_applicant_flag%type;

2535: l_orig_hire_warning boolean;
2536: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
2537: l_person_type_id1 per_people_f.person_type_id%type;
2538: l_comment_id per_people_f.comment_id%type;
2539: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2540: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2541: l_current_employee_flag per_people_f.current_employee_flag%type;
2542: l_employee_number per_people_f.employee_number%type;
2543: l_applicant_number per_people_f.applicant_number%TYPE;

Line 2540: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

2536: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
2537: l_person_type_id1 per_people_f.person_type_id%type;
2538: l_comment_id per_people_f.comment_id%type;
2539: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2540: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2541: l_current_employee_flag per_people_f.current_employee_flag%type;
2542: l_employee_number per_people_f.employee_number%type;
2543: l_applicant_number per_people_f.applicant_number%TYPE;
2544: l_npw_number per_people_f.npw_number%type;

Line 2541: l_current_employee_flag per_people_f.current_employee_flag%type;

2537: l_person_type_id1 per_people_f.person_type_id%type;
2538: l_comment_id per_people_f.comment_id%type;
2539: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2540: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2541: l_current_employee_flag per_people_f.current_employee_flag%type;
2542: l_employee_number per_people_f.employee_number%type;
2543: l_applicant_number per_people_f.applicant_number%TYPE;
2544: l_npw_number per_people_f.npw_number%type;
2545: l_full_name per_people_f.full_name%type;

Line 2542: l_employee_number per_people_f.employee_number%type;

2538: l_comment_id per_people_f.comment_id%type;
2539: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2540: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2541: l_current_employee_flag per_people_f.current_employee_flag%type;
2542: l_employee_number per_people_f.employee_number%type;
2543: l_applicant_number per_people_f.applicant_number%TYPE;
2544: l_npw_number per_people_f.npw_number%type;
2545: l_full_name per_people_f.full_name%type;
2546: l_object_version_number per_people_f.object_version_number%type;

Line 2543: l_applicant_number per_people_f.applicant_number%TYPE;

2539: l_current_applicant_flag per_people_f.current_applicant_flag%type;
2540: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2541: l_current_employee_flag per_people_f.current_employee_flag%type;
2542: l_employee_number per_people_f.employee_number%type;
2543: l_applicant_number per_people_f.applicant_number%TYPE;
2544: l_npw_number per_people_f.npw_number%type;
2545: l_full_name per_people_f.full_name%type;
2546: l_object_version_number per_people_f.object_version_number%type;
2547: l_period_of_service_id per_periods_of_service.period_of_service_id%type;

Line 2544: l_npw_number per_people_f.npw_number%type;

2540: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
2541: l_current_employee_flag per_people_f.current_employee_flag%type;
2542: l_employee_number per_people_f.employee_number%type;
2543: l_applicant_number per_people_f.applicant_number%TYPE;
2544: l_npw_number per_people_f.npw_number%type;
2545: l_full_name per_people_f.full_name%type;
2546: l_object_version_number per_people_f.object_version_number%type;
2547: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
2548: l_pds_object_version_number per_periods_of_service.object_version_number%type;

Line 2545: l_full_name per_people_f.full_name%type;

2541: l_current_employee_flag per_people_f.current_employee_flag%type;
2542: l_employee_number per_people_f.employee_number%type;
2543: l_applicant_number per_people_f.applicant_number%TYPE;
2544: l_npw_number per_people_f.npw_number%type;
2545: l_full_name per_people_f.full_name%type;
2546: l_object_version_number per_people_f.object_version_number%type;
2547: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
2548: l_pds_object_version_number per_periods_of_service.object_version_number%type;
2549: l_datetrack_mode varchar2(12);

Line 2546: l_object_version_number per_people_f.object_version_number%type;

2542: l_employee_number per_people_f.employee_number%type;
2543: l_applicant_number per_people_f.applicant_number%TYPE;
2544: l_npw_number per_people_f.npw_number%type;
2545: l_full_name per_people_f.full_name%type;
2546: l_object_version_number per_people_f.object_version_number%type;
2547: l_period_of_service_id per_periods_of_service.period_of_service_id%type;
2548: l_pds_object_version_number per_periods_of_service.object_version_number%type;
2549: l_datetrack_mode varchar2(12);
2550: l_effective_date date;

Line 2621: per_people_f per

2617: per.employee_number,
2618: per.effective_start_date,
2619: pet.system_person_type
2620: from per_person_types pet,
2621: per_people_f per
2622: where per.person_id = p_person_id
2623: and pet.person_type_id = per.person_type_id
2624: and pet.business_group_id + 0 = per.business_group_id
2625: and p_effective_date

Line 2633: per_people_f per,

2629: per.employee_number,
2630: per.effective_start_date,
2631: pet.system_person_type
2632: from per_person_types pet,
2633: per_people_f per,
2634: per_person_type_usages_f ptu
2635: where per.person_id = p_person_id
2636: and pet.person_type_id = ptu.person_type_id
2637: and ptu.person_id = per.person_id

Line 2695: -- the current person type (per_people_f.person_type_id) has a

2691: -- This procedure controls and performs the following business process
2692: -- validation:
2693: -- 1) ensure that the p_person_id and p_hire_date parameters are not null.
2694: -- 2) check that this person (p_person_id) exists as of p_hire_date and
2695: -- the current person type (per_people_f.person_type_id) has a
2696: -- corresponding system person type of EX_EMP.
2697: -- 3) ensure the most recent period of service for this person has been
2698: -- completely terminated.
2699: --

Line 2711: l_effective_start_date per_people_f.effective_start_date%type;

2707: --
2708: l_proc varchar2(72) := g_package||'perform_validation';
2709: l_system_person_type per_person_types.system_person_type%type;
2710: l_final_process_date per_periods_of_service.final_process_date%type;
2711: l_effective_start_date per_people_f.effective_start_date%type;
2712: l_dummy_number number;
2713: l_dummy_emp_number varchar2(30);
2714: l_dummy_date date;
2715: --

Line 2744: FROM per_people_f per

2740: (p_person_id IN per_all_people_f.person_id%TYPE
2741: ,p_effective_date IN DATE
2742: ) IS
2743: SELECT bus.legislation_code
2744: FROM per_people_f per
2745: ,per_business_groups bus
2746: WHERE per.person_id = csr_per_legislation.p_person_id
2747: AND per.business_group_id+0 = bus.business_group_id
2748: AND csr_per_legislation.p_effective_date BETWEEN per.effective_start_date

Line 2775: -- the current person type (per_people_f.person_type_id) has a

2771: ,p_argument => 'hire date'
2772: ,p_argument_value => p_hire_date);
2773: --
2774: -- 2. check that this person (p_person_id) exists as of p_hire_date and the
2775: -- the current person type (per_people_f.person_type_id) has a
2776: -- corresponding system person type of EX_EMP.
2777: --
2778: get_person_details
2779: (p_person_id => p_person_id,

Line 3295: l_business_group_id per_people_f.business_group_id%type;

3291: --
3292: -- declare local variables
3293: --
3294: l_proc varchar2(72) := g_package||'apply_for_internal_vacancy';
3295: l_business_group_id per_people_f.business_group_id%type;
3296: l_name_combination_warning boolean;
3297: l_dob_null_warning boolean;
3298: l_orig_hire_warning boolean;
3299: l_organization_id per_business_groups.organization_id%type;

Line 3301: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;

3297: l_dob_null_warning boolean;
3298: l_orig_hire_warning boolean;
3299: l_organization_id per_business_groups.organization_id%type;
3300: l_legislation_code per_business_groups.legislation_code%type;
3301: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
3302: l_person_type_id1 per_people_f.person_type_id%type;
3303: l_application_id per_applications.application_id%type;
3304: l_comment_id per_assignments_f.comment_id%type;
3305: l_assignment_sequence per_assignments_f.assignment_sequence%type;

Line 3302: l_person_type_id1 per_people_f.person_type_id%type;

3298: l_orig_hire_warning boolean;
3299: l_organization_id per_business_groups.organization_id%type;
3300: l_legislation_code per_business_groups.legislation_code%type;
3301: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
3302: l_person_type_id1 per_people_f.person_type_id%type;
3303: l_application_id per_applications.application_id%type;
3304: l_comment_id per_assignments_f.comment_id%type;
3305: l_assignment_sequence per_assignments_f.assignment_sequence%type;
3306: l_assignment_id per_assignments_f.assignment_id%type;

Line 3308: l_current_applicant_flag per_people_f.current_applicant_flag%type;

3304: l_comment_id per_assignments_f.comment_id%type;
3305: l_assignment_sequence per_assignments_f.assignment_sequence%type;
3306: l_assignment_id per_assignments_f.assignment_id%type;
3307: l_object_version_number per_assignments_f.object_version_number%type;
3308: l_current_applicant_flag per_people_f.current_applicant_flag%type;
3309: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
3310: l_current_employee_flag per_people_f.current_employee_flag%type;
3311: l_employee_number per_people_f.employee_number%type;
3312: l_applicant_number per_people_f.applicant_number%TYPE;

Line 3309: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

3305: l_assignment_sequence per_assignments_f.assignment_sequence%type;
3306: l_assignment_id per_assignments_f.assignment_id%type;
3307: l_object_version_number per_assignments_f.object_version_number%type;
3308: l_current_applicant_flag per_people_f.current_applicant_flag%type;
3309: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
3310: l_current_employee_flag per_people_f.current_employee_flag%type;
3311: l_employee_number per_people_f.employee_number%type;
3312: l_applicant_number per_people_f.applicant_number%TYPE;
3313: l_npw_number per_people_f.npw_number%TYPE;

Line 3310: l_current_employee_flag per_people_f.current_employee_flag%type;

3306: l_assignment_id per_assignments_f.assignment_id%type;
3307: l_object_version_number per_assignments_f.object_version_number%type;
3308: l_current_applicant_flag per_people_f.current_applicant_flag%type;
3309: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
3310: l_current_employee_flag per_people_f.current_employee_flag%type;
3311: l_employee_number per_people_f.employee_number%type;
3312: l_applicant_number per_people_f.applicant_number%TYPE;
3313: l_npw_number per_people_f.npw_number%TYPE;
3314: l_per_object_version_number per_people_f.object_version_number%TYPE;

Line 3311: l_employee_number per_people_f.employee_number%type;

3307: l_object_version_number per_assignments_f.object_version_number%type;
3308: l_current_applicant_flag per_people_f.current_applicant_flag%type;
3309: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
3310: l_current_employee_flag per_people_f.current_employee_flag%type;
3311: l_employee_number per_people_f.employee_number%type;
3312: l_applicant_number per_people_f.applicant_number%TYPE;
3313: l_npw_number per_people_f.npw_number%TYPE;
3314: l_per_object_version_number per_people_f.object_version_number%TYPE;
3315: l_full_name per_people_f.full_name%type;

Line 3312: l_applicant_number per_people_f.applicant_number%TYPE;

3308: l_current_applicant_flag per_people_f.current_applicant_flag%type;
3309: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
3310: l_current_employee_flag per_people_f.current_employee_flag%type;
3311: l_employee_number per_people_f.employee_number%type;
3312: l_applicant_number per_people_f.applicant_number%TYPE;
3313: l_npw_number per_people_f.npw_number%TYPE;
3314: l_per_object_version_number per_people_f.object_version_number%TYPE;
3315: l_full_name per_people_f.full_name%type;
3316: l_system_person_type per_person_types.system_person_type%type;

Line 3313: l_npw_number per_people_f.npw_number%TYPE;

3309: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
3310: l_current_employee_flag per_people_f.current_employee_flag%type;
3311: l_employee_number per_people_f.employee_number%type;
3312: l_applicant_number per_people_f.applicant_number%TYPE;
3313: l_npw_number per_people_f.npw_number%TYPE;
3314: l_per_object_version_number per_people_f.object_version_number%TYPE;
3315: l_full_name per_people_f.full_name%type;
3316: l_system_person_type per_person_types.system_person_type%type;
3317: l_effective_date date;

Line 3314: l_per_object_version_number per_people_f.object_version_number%TYPE;

3310: l_current_employee_flag per_people_f.current_employee_flag%type;
3311: l_employee_number per_people_f.employee_number%type;
3312: l_applicant_number per_people_f.applicant_number%TYPE;
3313: l_npw_number per_people_f.npw_number%TYPE;
3314: l_per_object_version_number per_people_f.object_version_number%TYPE;
3315: l_full_name per_people_f.full_name%type;
3316: l_system_person_type per_person_types.system_person_type%type;
3317: l_effective_date date;
3318: l_effective_start_date date;

Line 3315: l_full_name per_people_f.full_name%type;

3311: l_employee_number per_people_f.employee_number%type;
3312: l_applicant_number per_people_f.applicant_number%TYPE;
3313: l_npw_number per_people_f.npw_number%TYPE;
3314: l_per_object_version_number per_people_f.object_version_number%TYPE;
3315: l_full_name per_people_f.full_name%type;
3316: l_system_person_type per_person_types.system_person_type%type;
3317: l_effective_date date;
3318: l_effective_start_date date;
3319: l_effective_end_date date;

Line 3354: ,per_people_f ppf

3350: ,ppf.employee_number
3351: ,ppf.npw_number
3352: ,ppt.system_person_type
3353: from per_person_types ppt
3354: ,per_people_f ppf
3355: where ppf.person_id = p_person_id
3356: and ppt.person_type_id = ppf.person_type_id
3357: and ppt.business_group_id + 0 = ppf.business_group_id
3358: and l_effective_date

Line 3436: -- the current person type (per_people_f.person_type_id) has a

3432: hr_utility.set_location(' Leaving:'||l_proc, 10);
3433: end if;
3434: --
3435: -- Check that this person (p_person_id) exists as of l_effective_date
3436: -- the current person type (per_people_f.person_type_id) has a
3437: -- corresponding system person type of EMP.
3438: --
3439: open csr_chk_person_exists;
3440: fetch csr_chk_person_exists into

Line 3855: FROM per_people_f per

3851: ,per.employee_number
3852: ,per.npw_number
3853: ,bus.business_group_id
3854: ,bus.legislation_code
3855: FROM per_people_f per
3856: ,per_business_groups bus
3857: ,per_person_types pet
3858: WHERE per.person_type_id = pet.person_type_id
3859: AND per.business_group_id+0 = bus.business_group_id