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.GHR_SF52_DO_UPDATE dependencies on PER_PEOPLE_F

Line 1011: l_business_group_id per_people_f.business_group_id%type;

1007: (p_pa_request_rec in ghr_pa_requests%rowtype
1008: ) is
1009:
1010: l_proc varchar2(72) := 'Generic Sit';
1011: l_business_group_id per_people_f.business_group_id%type;
1012: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1013: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1014: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1015: l_education_level ghr_pa_requests.education_level%type;

Line 2402: p_business_group_id in per_people_f.business_group_id%type,

2398: -- ********************************
2399: --- Bug# 4672772 added Parameter p_assignment_id
2400: Procedure get_asg_status_type
2401: (p_noa_code in ghr_nature_of_actions.code%type,
2402: p_business_group_id in per_people_f.business_group_id%type,
2403: p_assignment_id in number,
2404: p_status_type_id out nocopy per_assignment_status_types.assignment_status_type_id%type,
2405: p_activate_flag out nocopy varchar2,
2406: p_suspend_flag out nocopy varchar2,

Line 2648: (p_id in per_people_f.person_id%type,

2644: -- the effective_date the SF52 is processed.
2645:
2646:
2647: Function return_update_mode
2648: (p_id in per_people_f.person_id%type,
2649: p_effective_date in date,
2650: p_table_name in varchar2
2651: ) return varchar2 is
2652:

Line 2714: If p_table_name = 'PER_PEOPLE_F' then --per

2710:
2711:
2712: Begin
2713: hr_utility.set_location('Entering ' || l_proc,5);
2714: If p_table_name = 'PER_PEOPLE_F' then --per
2715: hr_utility.set_location(l_proc,10);
2716: for update_mode in c_update_mode_p loop
2717: hr_utility.set_location(l_proc,15);
2718: l_esd := update_mode.effective_start_date;

Line 2747: hr_utility.set_message_token('TABLE_NAME','per_people_f');

2743: End if;
2744: End if;
2745: If l_mode is null then
2746: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
2747: hr_utility.set_message_token('TABLE_NAME','per_people_f');
2748: hr_utility.raise_error;
2749: End if;
2750: hr_utility.set_location(l_proc,55);
2751: Elsif p_table_name = 'PER_ASSIGNMENTS_F' then

Line 2869: l_per_upd_employee_number per_people_f.employee_number%type;

2865: l_noa_family_code ghr_noa_families.noa_family_code%type;
2866: --
2867: -- hr_person_api.update_person out variables
2868: --
2869: l_per_upd_employee_number per_people_f.employee_number%type;
2870: l_per_upd_effective_start_date per_people_f.effective_start_date%type;
2871: l_per_upd_effective_end_date per_people_f.effective_end_date%type;
2872: l_per_upd_full_name per_people_f.full_name%type;
2873: l_per_upd_comment_id per_people_f.comment_id%type;

Line 2870: l_per_upd_effective_start_date per_people_f.effective_start_date%type;

2866: --
2867: -- hr_person_api.update_person out variables
2868: --
2869: l_per_upd_employee_number per_people_f.employee_number%type;
2870: l_per_upd_effective_start_date per_people_f.effective_start_date%type;
2871: l_per_upd_effective_end_date per_people_f.effective_end_date%type;
2872: l_per_upd_full_name per_people_f.full_name%type;
2873: l_per_upd_comment_id per_people_f.comment_id%type;
2874: l_per_upd_name_comb_warn boolean;

Line 2871: l_per_upd_effective_end_date per_people_f.effective_end_date%type;

2867: -- hr_person_api.update_person out variables
2868: --
2869: l_per_upd_employee_number per_people_f.employee_number%type;
2870: l_per_upd_effective_start_date per_people_f.effective_start_date%type;
2871: l_per_upd_effective_end_date per_people_f.effective_end_date%type;
2872: l_per_upd_full_name per_people_f.full_name%type;
2873: l_per_upd_comment_id per_people_f.comment_id%type;
2874: l_per_upd_name_comb_warn boolean;
2875: l_per_upd_assgn_payroll_warn boolean;

Line 2872: l_per_upd_full_name per_people_f.full_name%type;

2868: --
2869: l_per_upd_employee_number per_people_f.employee_number%type;
2870: l_per_upd_effective_start_date per_people_f.effective_start_date%type;
2871: l_per_upd_effective_end_date per_people_f.effective_end_date%type;
2872: l_per_upd_full_name per_people_f.full_name%type;
2873: l_per_upd_comment_id per_people_f.comment_id%type;
2874: l_per_upd_name_comb_warn boolean;
2875: l_per_upd_assgn_payroll_warn boolean;
2876: l_per_person_type_id per_people_f.person_type_id%type;

Line 2873: l_per_upd_comment_id per_people_f.comment_id%type;

2869: l_per_upd_employee_number per_people_f.employee_number%type;
2870: l_per_upd_effective_start_date per_people_f.effective_start_date%type;
2871: l_per_upd_effective_end_date per_people_f.effective_end_date%type;
2872: l_per_upd_full_name per_people_f.full_name%type;
2873: l_per_upd_comment_id per_people_f.comment_id%type;
2874: l_per_upd_name_comb_warn boolean;
2875: l_per_upd_assgn_payroll_warn boolean;
2876: l_per_person_type_id per_people_f.person_type_id%type;
2877: l_per_national_identifier per_people_f.national_identifier%type;

Line 2876: l_per_person_type_id per_people_f.person_type_id%type;

2872: l_per_upd_full_name per_people_f.full_name%type;
2873: l_per_upd_comment_id per_people_f.comment_id%type;
2874: l_per_upd_name_comb_warn boolean;
2875: l_per_upd_assgn_payroll_warn boolean;
2876: l_per_person_type_id per_people_f.person_type_id%type;
2877: l_per_national_identifier per_people_f.national_identifier%type;
2878: l_per_first_name per_people_f.first_name%type;
2879: l_per_last_name per_people_f.last_name%type;
2880: l_per_middle_names per_people_f.middle_names%type;

Line 2877: l_per_national_identifier per_people_f.national_identifier%type;

2873: l_per_upd_comment_id per_people_f.comment_id%type;
2874: l_per_upd_name_comb_warn boolean;
2875: l_per_upd_assgn_payroll_warn boolean;
2876: l_per_person_type_id per_people_f.person_type_id%type;
2877: l_per_national_identifier per_people_f.national_identifier%type;
2878: l_per_first_name per_people_f.first_name%type;
2879: l_per_last_name per_people_f.last_name%type;
2880: l_per_middle_names per_people_f.middle_names%type;
2881: l_per_date_of_birth per_people_f.date_of_birth%type;

Line 2878: l_per_first_name per_people_f.first_name%type;

2874: l_per_upd_name_comb_warn boolean;
2875: l_per_upd_assgn_payroll_warn boolean;
2876: l_per_person_type_id per_people_f.person_type_id%type;
2877: l_per_national_identifier per_people_f.national_identifier%type;
2878: l_per_first_name per_people_f.first_name%type;
2879: l_per_last_name per_people_f.last_name%type;
2880: l_per_middle_names per_people_f.middle_names%type;
2881: l_per_date_of_birth per_people_f.date_of_birth%type;
2882:

Line 2879: l_per_last_name per_people_f.last_name%type;

2875: l_per_upd_assgn_payroll_warn boolean;
2876: l_per_person_type_id per_people_f.person_type_id%type;
2877: l_per_national_identifier per_people_f.national_identifier%type;
2878: l_per_first_name per_people_f.first_name%type;
2879: l_per_last_name per_people_f.last_name%type;
2880: l_per_middle_names per_people_f.middle_names%type;
2881: l_per_date_of_birth per_people_f.date_of_birth%type;
2882:
2883: --

Line 2880: l_per_middle_names per_people_f.middle_names%type;

2876: l_per_person_type_id per_people_f.person_type_id%type;
2877: l_per_national_identifier per_people_f.national_identifier%type;
2878: l_per_first_name per_people_f.first_name%type;
2879: l_per_last_name per_people_f.last_name%type;
2880: l_per_middle_names per_people_f.middle_names%type;
2881: l_per_date_of_birth per_people_f.date_of_birth%type;
2882:
2883: --
2884: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%type;

Line 2881: l_per_date_of_birth per_people_f.date_of_birth%type;

2877: l_per_national_identifier per_people_f.national_identifier%type;
2878: l_per_first_name per_people_f.first_name%type;
2879: l_per_last_name per_people_f.last_name%type;
2880: l_per_middle_names per_people_f.middle_names%type;
2881: l_per_date_of_birth per_people_f.date_of_birth%type;
2882:
2883: --
2884: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%type;
2885: l_asg_upd_effective_start_date per_assignments_f.effective_start_date%type;

Line 2899: l_per_hire_employee_number per_people_f.employee_number%type;

2895: --
2896: -- Hire applicant out variables
2897:
2898: --
2899: l_per_hire_employee_number per_people_f.employee_number%type;
2900: l_per_hire_eff_start_date per_people_f.effective_start_date%type;
2901: l_per_hire_eff_end_date per_people_f.effective_end_date%type;
2902: l_per_hire_un_asg_del_warn boolean;
2903: l_per_hire_asg_pay_warn boolean;

Line 2900: l_per_hire_eff_start_date per_people_f.effective_start_date%type;

2896: -- Hire applicant out variables
2897:
2898: --
2899: l_per_hire_employee_number per_people_f.employee_number%type;
2900: l_per_hire_eff_start_date per_people_f.effective_start_date%type;
2901: l_per_hire_eff_end_date per_people_f.effective_end_date%type;
2902: l_per_hire_un_asg_del_warn boolean;
2903: l_per_hire_asg_pay_warn boolean;
2904: l_per_hire_oversubs_vac_id number;

Line 2901: l_per_hire_eff_end_date per_people_f.effective_end_date%type;

2897:
2898: --
2899: l_per_hire_employee_number per_people_f.employee_number%type;
2900: l_per_hire_eff_start_date per_people_f.effective_start_date%type;
2901: l_per_hire_eff_end_date per_people_f.effective_end_date%type;
2902: l_per_hire_un_asg_del_warn boolean;
2903: l_per_hire_asg_pay_warn boolean;
2904: l_per_hire_oversubs_vac_id number;
2905: --

Line 2932: l_per_object_version_number per_people_f.object_version_number%type;

2928: l_asg_fnl_future_chan_warn boolean;
2929: l_asg_fnl_entries_chan_warn varchar2(1);
2930: --
2931: --
2932: l_per_object_version_number per_people_f.object_version_number%type;
2933: l_asg_object_version_number per_assignments_f.object_version_number%type;
2934: l_add_object_version_number per_addresses.object_version_number%type;
2935: l_person_id per_people_f.person_id%type;
2936: l_person_type_id per_people_f.person_type_id%type;

Line 2935: l_person_id per_people_f.person_id%type;

2931: --
2932: l_per_object_version_number per_people_f.object_version_number%type;
2933: l_asg_object_version_number per_assignments_f.object_version_number%type;
2934: l_add_object_version_number per_addresses.object_version_number%type;
2935: l_person_id per_people_f.person_id%type;
2936: l_person_type_id per_people_f.person_type_id%type;
2937: l_date1 ghr_pa_requests.effective_date%type;
2938: l_address_id per_addresses.address_id%type;
2939: l_person_type per_person_types.system_person_type%type;

Line 2936: l_person_type_id per_people_f.person_type_id%type;

2932: l_per_object_version_number per_people_f.object_version_number%type;
2933: l_asg_object_version_number per_assignments_f.object_version_number%type;
2934: l_add_object_version_number per_addresses.object_version_number%type;
2935: l_person_id per_people_f.person_id%type;
2936: l_person_type_id per_people_f.person_type_id%type;
2937: l_date1 ghr_pa_requests.effective_date%type;
2938: l_address_id per_addresses.address_id%type;
2939: l_person_type per_person_types.system_person_type%type;
2940: --l_sec_assignmemt_id per_assignments_f.assignment_id%type;

Line 2972: l_business_group_id per_people_f.business_group_id%type;

2968: l_rehire_ex_emp varchar2(1 ) := 'N';
2969: l_period_of_service_id number;
2970: l_payroll_id pay_payrolls_f.payroll_id%type;
2971: l_payroll_name pay_payrolls_f.payroll_name%type;
2972: l_business_group_id per_people_f.business_group_id%type;
2973: l_orig_hire_warning boolean;
2974:
2975: l_working_hours per_assignments_f.normal_hours%type;
2976:

Line 3374: CURSOR get_segment(c_business_group_id per_people_f.business_group_id%type) IS

3370: FROM hr_all_positions_f pos
3371: WHERE pos.position_id = c_position_id
3372: AND c_effective_date BETWEEN pos.effective_start_date and pos.effective_end_date;
3373:
3374: CURSOR get_segment(c_business_group_id per_people_f.business_group_id%type) IS
3375: SELECT ORG_INFORMATION5
3376: FROM HR_ORGANIZATION_INFORMATION
3377: WHERE ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_INFORMATION'
3378: AND ORGANIZATION_ID = c_business_group_id;

Line 3954: -- Fetch OVN for per_people_f, while processing hire_applicant and name change

3950: -- ***********
3951: -- Calling APIs
3952: -- ***********
3953:
3954: -- Fetch OVN for per_people_f, while processing hire_applicant and name change
3955:
3956: If l_hr_applicant_api_hire = 'Y' or
3957: l_rehire_ex_emp = 'Y' or
3958: l_update_person = 'Y' then

Line 4415: p_table_name => 'PER_PEOPLE_F'

4411: hr_utility.set_location(l_proc,138);
4412: l_update_mode := return_update_mode
4413: (p_id => p_pa_request_rec.person_id,
4414: p_effective_date => p_pa_request_rec.effective_date,
4415: p_table_name => 'PER_PEOPLE_F'
4416: );
4417:
4418: hr_person_api.update_person
4419: (p_effective_date => g_effective_date

Line 4650: p_table_name => 'PER_PEOPLE_F'

4646:
4647: l_update_mode := return_update_mode
4648: (p_id => p_pa_request_rec.person_id,
4649: p_effective_date => p_pa_request_rec.effective_date,
4650: p_table_name => 'PER_PEOPLE_F'
4651: );
4652:
4653: hr_person_api.update_person
4654: (p_effective_date => g_effective_date

Line 4932: per_people_f per

4928:
4929: cursor cur_ex_emp (p_person_id IN Number, p_effective_date IN Date) is
4930: select 1
4931: from per_person_types pet,
4932: per_people_f per
4933: where pet.person_type_id = per.person_type_id
4934: and per.person_id = p_person_id
4935: and p_effective_date
4936: between per.effective_start_date and per.effective_end_date

Line 8214: l_object_version_number per_people_f.object_version_number%type;

8210: )
8211: is
8212:
8213: l_proc varchar2(72) := 'Generic Update SIT';
8214: l_object_version_number per_people_f.object_version_number%type;
8215: l_session ghr_history_api.g_session_var_type;
8216: l_multiple varchar2(1);
8217: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
8218: l_person_analysis_id per_person_analyses.person_analysis_id%type;

Line 8219: l_business_group_id per_people_f.business_group_id%type;

8215: l_session ghr_history_api.g_session_var_type;
8216: l_multiple varchar2(1);
8217: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
8218: l_person_analysis_id per_person_analyses.person_analysis_id%type;
8219: l_business_group_id per_people_f.business_group_id%type;
8220: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
8221: -- Bug#4054110,4069798 Added l_date_from variable
8222: l_date_from DATE;
8223: