[Home] [Help]
1022: (p_pa_request_rec in ghr_pa_requests%rowtype
1023: ) is
1024:
1025: l_proc varchar2(72) := 'Generic Sit';
1026: l_business_group_id per_people_f.business_group_id%type;
1027: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1028: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
1029: l_personal_analysis_id per_person_analyses.person_analysis_id%type;
1030: l_education_level ghr_pa_requests.education_level%type;
2495: -- ********************************
2496: --- Bug# 4672772 added Parameter p_assignment_id
2497: Procedure get_asg_status_type
2498: (p_noa_code in ghr_nature_of_actions.code%type,
2499: p_business_group_id in per_people_f.business_group_id%type,
2500: p_assignment_id in number,
2501: p_pa_request_id in ghr_pa_requests.pa_request_id%type, --Bug# 8724192
2502: p_status_type_id out nocopy per_assignment_status_types.assignment_status_type_id%type,
2503: p_activate_flag out nocopy varchar2,
2848: -- the effective_date the SF52 is processed.
2849:
2850:
2851: Function return_update_mode
2852: (p_id in per_people_f.person_id%type,
2853: p_effective_date in date,
2854: p_table_name in varchar2
2855: ) return varchar2 is
2856:
2914:
2915:
2916: Begin
2917: hr_utility.set_location('Entering ' || l_proc,5);
2918: If p_table_name = 'PER_PEOPLE_F' then --per
2919: hr_utility.set_location(l_proc,10);
2920: for update_mode in c_update_mode_p loop
2921: hr_utility.set_location(l_proc,15);
2922: l_esd := update_mode.effective_start_date;
2947: End if;
2948: End if;
2949: If l_mode is null then
2950: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
2951: hr_utility.set_message_token('TABLE_NAME','per_people_f');
2952: hr_utility.raise_error;
2953: End if;
2954: hr_utility.set_location(l_proc,55);
2955: Elsif p_table_name = 'PER_ASSIGNMENTS_F' then
3069: l_noa_family_code ghr_noa_families.noa_family_code%type;
3070: --
3071: -- hr_person_api.update_person out variables
3072: --
3073: l_per_upd_employee_number per_people_f.employee_number%type;
3074: l_per_upd_effective_start_date per_people_f.effective_start_date%type;
3075: l_per_upd_effective_end_date per_people_f.effective_end_date%type;
3076: l_per_upd_full_name per_people_f.full_name%type;
3077: l_per_upd_comment_id per_people_f.comment_id%type;
3070: --
3071: -- hr_person_api.update_person out variables
3072: --
3073: l_per_upd_employee_number per_people_f.employee_number%type;
3074: l_per_upd_effective_start_date per_people_f.effective_start_date%type;
3075: l_per_upd_effective_end_date per_people_f.effective_end_date%type;
3076: l_per_upd_full_name per_people_f.full_name%type;
3077: l_per_upd_comment_id per_people_f.comment_id%type;
3078: l_per_upd_name_comb_warn boolean;
3071: -- hr_person_api.update_person out variables
3072: --
3073: l_per_upd_employee_number per_people_f.employee_number%type;
3074: l_per_upd_effective_start_date per_people_f.effective_start_date%type;
3075: l_per_upd_effective_end_date per_people_f.effective_end_date%type;
3076: l_per_upd_full_name per_people_f.full_name%type;
3077: l_per_upd_comment_id per_people_f.comment_id%type;
3078: l_per_upd_name_comb_warn boolean;
3079: l_per_upd_assgn_payroll_warn boolean;
3072: --
3073: l_per_upd_employee_number per_people_f.employee_number%type;
3074: l_per_upd_effective_start_date per_people_f.effective_start_date%type;
3075: l_per_upd_effective_end_date per_people_f.effective_end_date%type;
3076: l_per_upd_full_name per_people_f.full_name%type;
3077: l_per_upd_comment_id per_people_f.comment_id%type;
3078: l_per_upd_name_comb_warn boolean;
3079: l_per_upd_assgn_payroll_warn boolean;
3080: l_per_person_type_id per_people_f.person_type_id%type;
3073: l_per_upd_employee_number per_people_f.employee_number%type;
3074: l_per_upd_effective_start_date per_people_f.effective_start_date%type;
3075: l_per_upd_effective_end_date per_people_f.effective_end_date%type;
3076: l_per_upd_full_name per_people_f.full_name%type;
3077: l_per_upd_comment_id per_people_f.comment_id%type;
3078: l_per_upd_name_comb_warn boolean;
3079: l_per_upd_assgn_payroll_warn boolean;
3080: l_per_person_type_id per_people_f.person_type_id%type;
3081: l_per_national_identifier per_people_f.national_identifier%type;
3076: l_per_upd_full_name per_people_f.full_name%type;
3077: l_per_upd_comment_id per_people_f.comment_id%type;
3078: l_per_upd_name_comb_warn boolean;
3079: l_per_upd_assgn_payroll_warn boolean;
3080: l_per_person_type_id per_people_f.person_type_id%type;
3081: l_per_national_identifier per_people_f.national_identifier%type;
3082: l_per_first_name per_people_f.first_name%type;
3083: l_per_last_name per_people_f.last_name%type;
3084: l_per_middle_names per_people_f.middle_names%type;
3077: l_per_upd_comment_id per_people_f.comment_id%type;
3078: l_per_upd_name_comb_warn boolean;
3079: l_per_upd_assgn_payroll_warn boolean;
3080: l_per_person_type_id per_people_f.person_type_id%type;
3081: l_per_national_identifier per_people_f.national_identifier%type;
3082: l_per_first_name per_people_f.first_name%type;
3083: l_per_last_name per_people_f.last_name%type;
3084: l_per_middle_names per_people_f.middle_names%type;
3085: l_per_date_of_birth per_people_f.date_of_birth%type;
3078: l_per_upd_name_comb_warn boolean;
3079: l_per_upd_assgn_payroll_warn boolean;
3080: l_per_person_type_id per_people_f.person_type_id%type;
3081: l_per_national_identifier per_people_f.national_identifier%type;
3082: l_per_first_name per_people_f.first_name%type;
3083: l_per_last_name per_people_f.last_name%type;
3084: l_per_middle_names per_people_f.middle_names%type;
3085: l_per_date_of_birth per_people_f.date_of_birth%type;
3086:
3079: l_per_upd_assgn_payroll_warn boolean;
3080: l_per_person_type_id per_people_f.person_type_id%type;
3081: l_per_national_identifier per_people_f.national_identifier%type;
3082: l_per_first_name per_people_f.first_name%type;
3083: l_per_last_name per_people_f.last_name%type;
3084: l_per_middle_names per_people_f.middle_names%type;
3085: l_per_date_of_birth per_people_f.date_of_birth%type;
3086:
3087: --
3080: l_per_person_type_id per_people_f.person_type_id%type;
3081: l_per_national_identifier per_people_f.national_identifier%type;
3082: l_per_first_name per_people_f.first_name%type;
3083: l_per_last_name per_people_f.last_name%type;
3084: l_per_middle_names per_people_f.middle_names%type;
3085: l_per_date_of_birth per_people_f.date_of_birth%type;
3086:
3087: --
3088: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%type;
3081: l_per_national_identifier per_people_f.national_identifier%type;
3082: l_per_first_name per_people_f.first_name%type;
3083: l_per_last_name per_people_f.last_name%type;
3084: l_per_middle_names per_people_f.middle_names%type;
3085: l_per_date_of_birth per_people_f.date_of_birth%type;
3086:
3087: --
3088: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%type;
3089: l_asg_upd_effective_start_date per_assignments_f.effective_start_date%type;
3099: --
3100: -- Hire applicant out variables
3101:
3102: --
3103: l_per_hire_employee_number per_people_f.employee_number%type;
3104: l_per_hire_eff_start_date per_people_f.effective_start_date%type;
3105: l_per_hire_eff_end_date per_people_f.effective_end_date%type;
3106: l_per_hire_un_asg_del_warn boolean;
3107: l_per_hire_asg_pay_warn boolean;
3100: -- Hire applicant out variables
3101:
3102: --
3103: l_per_hire_employee_number per_people_f.employee_number%type;
3104: l_per_hire_eff_start_date per_people_f.effective_start_date%type;
3105: l_per_hire_eff_end_date per_people_f.effective_end_date%type;
3106: l_per_hire_un_asg_del_warn boolean;
3107: l_per_hire_asg_pay_warn boolean;
3108: l_per_hire_oversubs_vac_id number;
3101:
3102: --
3103: l_per_hire_employee_number per_people_f.employee_number%type;
3104: l_per_hire_eff_start_date per_people_f.effective_start_date%type;
3105: l_per_hire_eff_end_date per_people_f.effective_end_date%type;
3106: l_per_hire_un_asg_del_warn boolean;
3107: l_per_hire_asg_pay_warn boolean;
3108: l_per_hire_oversubs_vac_id number;
3109: --
3132: l_asg_fnl_future_chan_warn boolean;
3133: l_asg_fnl_entries_chan_warn varchar2(1);
3134: --
3135: --
3136: l_per_object_version_number per_people_f.object_version_number%type;
3137: l_asg_object_version_number per_assignments_f.object_version_number%type;
3138: l_add_object_version_number per_addresses.object_version_number%type;
3139: l_person_id per_people_f.person_id%type;
3140: l_person_type_id per_people_f.person_type_id%type;
3135: --
3136: l_per_object_version_number per_people_f.object_version_number%type;
3137: l_asg_object_version_number per_assignments_f.object_version_number%type;
3138: l_add_object_version_number per_addresses.object_version_number%type;
3139: l_person_id per_people_f.person_id%type;
3140: l_person_type_id per_people_f.person_type_id%type;
3141: l_date1 ghr_pa_requests.effective_date%type;
3142: l_address_id per_addresses.address_id%type;
3143: l_person_type per_person_types.system_person_type%type;
3136: l_per_object_version_number per_people_f.object_version_number%type;
3137: l_asg_object_version_number per_assignments_f.object_version_number%type;
3138: l_add_object_version_number per_addresses.object_version_number%type;
3139: l_person_id per_people_f.person_id%type;
3140: l_person_type_id per_people_f.person_type_id%type;
3141: l_date1 ghr_pa_requests.effective_date%type;
3142: l_address_id per_addresses.address_id%type;
3143: l_person_type per_person_types.system_person_type%type;
3144: --l_sec_assignmemt_id per_assignments_f.assignment_id%type;
3172: l_rehire_ex_emp varchar2(1 ) := 'N';
3173: l_period_of_service_id number;
3174: l_payroll_id pay_payrolls_f.payroll_id%type;
3175: l_payroll_name pay_payrolls_f.payroll_name%type;
3176: l_business_group_id per_people_f.business_group_id%type;
3177: l_orig_hire_warning boolean;
3178:
3179: l_working_hours per_assignments_f.normal_hours%type;
3180:
3590: FROM hr_all_positions_f pos
3591: WHERE pos.position_id = c_position_id
3592: AND c_effective_date BETWEEN pos.effective_start_date and pos.effective_end_date;
3593:
3594: CURSOR get_segment(c_business_group_id per_people_f.business_group_id%type) IS
3595: SELECT ORG_INFORMATION5
3596: FROM HR_ORGANIZATION_INFORMATION
3597: WHERE ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_INFORMATION'
3598: AND ORGANIZATION_ID = c_business_group_id;
4178: -- ***********
4179: -- Calling APIs
4180: -- ***********
4181:
4182: -- Fetch OVN for per_people_f, while processing hire_applicant and name change
4183:
4184: If l_hr_applicant_api_hire = 'Y' or
4185: l_rehire_ex_emp = 'Y' or
4186: l_update_person = 'Y' then
4670: hr_utility.set_location(l_proc,138);
4671: l_update_mode := return_update_mode
4672: (p_id => p_pa_request_rec.person_id,
4673: p_effective_date => p_pa_request_rec.effective_date,
4674: p_table_name => 'PER_PEOPLE_F'
4675: );
4676:
4677: hr_person_api.update_person
4678: (p_effective_date => g_effective_date
4905:
4906: l_update_mode := return_update_mode
4907: (p_id => p_pa_request_rec.person_id,
4908: p_effective_date => p_pa_request_rec.effective_date,
4909: p_table_name => 'PER_PEOPLE_F'
4910: );
4911:
4912: hr_person_api.update_person
4913: (p_effective_date => g_effective_date
5187:
5188: cursor cur_ex_emp (p_person_id IN Number, p_effective_date IN Date) is
5189: select 1
5190: from per_person_types pet,
5191: per_people_f per
5192: where pet.person_type_id = per.person_type_id
5193: and per.person_id = p_person_id
5194: and p_effective_date
5195: between per.effective_start_date and per.effective_end_date
8513: )
8514: is
8515:
8516: l_proc varchar2(72) := 'Generic Update SIT';
8517: l_object_version_number per_people_f.object_version_number%type;
8518: l_session ghr_history_api.g_session_var_type;
8519: l_multiple varchar2(1);
8520: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
8521: l_person_analysis_id per_person_analyses.person_analysis_id%type;
8518: l_session ghr_history_api.g_session_var_type;
8519: l_multiple varchar2(1);
8520: l_analysis_criteria_id per_analysis_criteria.analysis_criteria_id%type;
8521: l_person_analysis_id per_person_analyses.person_analysis_id%type;
8522: l_business_group_id per_people_f.business_group_id%type;
8523: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
8524: -- Bug#4054110,4069798 Added l_date_from variable
8525: l_date_from DATE;
8526: