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_ASSIGNMENTS_F

Line 1346: per_Assignments_f asg

1342: Cursor Cur_Par_Asg(p_ssn VARCHAR2) is
1343: select par.first_noa_code
1344: from
1345: ghr_pa_requests par,
1346: per_Assignments_f asg
1347: where asg.assignment_id=par.employee_assignment_id
1348: and par.employee_national_identifier=p_ssn
1349: and noa_family_code not in
1350: ('NON_PAY_DUTY_STATUS','RETURN_TO_DUTY','CANCEL','CORRECT')

Line 1399: per_Assignments_f asg

1395: SELECT
1396: first_noa_information1 NTE_Dates
1397: FROM
1398: ghr_pa_requests par,
1399: per_Assignments_f asg
1400: WHERE
1401: asg.assignment_id= par.employee_assignment_id AND
1402: asg.effective_start_date = par.effective_date AND
1403: par.person_id= c_person_id AND

Line 2751: Elsif p_table_name = 'PER_ASSIGNMENTS_F' then

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
2752: hr_utility.set_location(l_proc,60);
2753: for update_mode in c_update_mode_a loop
2754: hr_utility.set_location(l_proc,65);
2755: l_esd := update_mode.effective_start_date;

Line 2785: hr_utility.set_message_token('TABLE_NAME','per_assignments_f');

2781: hr_utility.set_location(l_proc,105);
2782: hr_utility.set_location('UPDATE_MODE : ' || l_mode,2);
2783: If l_mode is null then
2784: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
2785: hr_utility.set_message_token('TABLE_NAME','per_assignments_f');
2786: hr_utility.raise_error;
2787: End if;
2788: Elsif p_table_name = 'HR_ALL_POSITIONS_F' then
2789: hr_utility.set_location(l_proc,110);

Line 2885: l_asg_upd_effective_start_date per_assignments_f.effective_start_date%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;
2886: l_asg_upd_effective_end_date per_assignments_f.effective_end_date%type;
2887: l_asg_upd_special_ceil_step_id per_assignments_f.special_ceiling_step_id%type;
2888: l_asg_upd_people_group_id per_assignments_f.people_group_id%type;
2889: l_asg_upd_group_name pay_people_groups.group_name%type;

Line 2886: l_asg_upd_effective_end_date per_assignments_f.effective_end_date%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;
2886: l_asg_upd_effective_end_date per_assignments_f.effective_end_date%type;
2887: l_asg_upd_special_ceil_step_id per_assignments_f.special_ceiling_step_id%type;
2888: l_asg_upd_people_group_id per_assignments_f.people_group_id%type;
2889: l_asg_upd_group_name pay_people_groups.group_name%type;
2890: l_asg_upd_org_now_man_warn boolean;

Line 2887: l_asg_upd_special_ceil_step_id per_assignments_f.special_ceiling_step_id%type;

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;
2886: l_asg_upd_effective_end_date per_assignments_f.effective_end_date%type;
2887: l_asg_upd_special_ceil_step_id per_assignments_f.special_ceiling_step_id%type;
2888: l_asg_upd_people_group_id per_assignments_f.people_group_id%type;
2889: l_asg_upd_group_name pay_people_groups.group_name%type;
2890: l_asg_upd_org_now_man_warn boolean;
2891: l_asg_upd_other_manager_warn boolean ;

Line 2888: l_asg_upd_people_group_id per_assignments_f.people_group_id%type;

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;
2886: l_asg_upd_effective_end_date per_assignments_f.effective_end_date%type;
2887: l_asg_upd_special_ceil_step_id per_assignments_f.special_ceiling_step_id%type;
2888: l_asg_upd_people_group_id per_assignments_f.people_group_id%type;
2889: l_asg_upd_group_name pay_people_groups.group_name%type;
2890: l_asg_upd_org_now_man_warn boolean;
2891: l_asg_upd_other_manager_warn boolean ;
2892: l_asg_upd_spp_delete_warning boolean;

Line 2909: l_asg_act_eff_start_date per_assignments_f.effective_start_date%type;

2905: --
2906:
2907: -- Return to duty (active) out variables
2908: --
2909: l_asg_act_eff_start_date per_assignments_f.effective_start_date%type;
2910: l_asg_act_eff_end_date per_assignments_f.effective_end_date%type;
2911: --
2912: --Suspend employee out variables
2913: --

Line 2910: l_asg_act_eff_end_date per_assignments_f.effective_end_date%type;

2906:
2907: -- Return to duty (active) out variables
2908: --
2909: l_asg_act_eff_start_date per_assignments_f.effective_start_date%type;
2910: l_asg_act_eff_end_date per_assignments_f.effective_end_date%type;
2911: --
2912: --Suspend employee out variables
2913: --
2914: l_asg_sus_eff_start_date per_assignments_f.effective_start_date%type;

Line 2914: l_asg_sus_eff_start_date per_assignments_f.effective_start_date%type;

2910: l_asg_act_eff_end_date per_assignments_f.effective_end_date%type;
2911: --
2912: --Suspend employee out variables
2913: --
2914: l_asg_sus_eff_start_date per_assignments_f.effective_start_date%type;
2915: l_asg_sus_eff_end_date per_assignments_f.effective_end_date%type;--
2916:
2917: -- Create addresses out variables
2918: --

Line 2915: l_asg_sus_eff_end_date per_assignments_f.effective_end_date%type;--

2911: --
2912: --Suspend employee out variables
2913: --
2914: l_asg_sus_eff_start_date per_assignments_f.effective_start_date%type;
2915: l_asg_sus_eff_end_date per_assignments_f.effective_end_date%type;--
2916:
2917: -- Create addresses out variables
2918: --
2919: l_per_add_address_id per_addresses.address_id%type;

Line 2925: l_asg_fnl_eff_start_date per_assignments_f.effective_start_date%type;

2921: --
2922:
2923: -- Final Process out variables
2924: --
2925: l_asg_fnl_eff_start_date per_assignments_f.effective_start_date%type;
2926: l_asg_fnl_eff_end_date per_assignments_f.effective_end_date%type;
2927: l_asg_fnl_org_now_no_manager boolean;
2928: l_asg_fnl_future_chan_warn boolean;
2929: l_asg_fnl_entries_chan_warn varchar2(1);

Line 2926: l_asg_fnl_eff_end_date per_assignments_f.effective_end_date%type;

2922:
2923: -- Final Process out variables
2924: --
2925: l_asg_fnl_eff_start_date per_assignments_f.effective_start_date%type;
2926: l_asg_fnl_eff_end_date per_assignments_f.effective_end_date%type;
2927: l_asg_fnl_org_now_no_manager boolean;
2928: l_asg_fnl_future_chan_warn boolean;
2929: l_asg_fnl_entries_chan_warn varchar2(1);
2930: --

Line 2933: l_asg_object_version_number per_assignments_f.object_version_number%type;

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;
2937: l_date1 ghr_pa_requests.effective_date%type;

Line 2940: --l_sec_assignmemt_id per_assignments_f.assignment_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;
2941: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;
2942: --
2943: l_asg_trm_eff_start_date per_assignments_f.effective_start_date%type;
2944: l_asg_trm_eff_end_date per_assignments_f.effective_end_date%type;

Line 2943: l_asg_trm_eff_start_date per_assignments_f.effective_start_date%type;

2939: l_person_type per_person_types.system_person_type%type;
2940: --l_sec_assignmemt_id per_assignments_f.assignment_id%type;
2941: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;
2942: --
2943: l_asg_trm_eff_start_date per_assignments_f.effective_start_date%type;
2944: l_asg_trm_eff_end_date per_assignments_f.effective_end_date%type;
2945: l_emp_trm_eff_end_date per_assignments_f.effective_end_date%type;
2946: l_asg_future_changes_warning boolean;
2947: l_supervisor_warning boolean;

Line 2944: l_asg_trm_eff_end_date per_assignments_f.effective_end_date%type;

2940: --l_sec_assignmemt_id per_assignments_f.assignment_id%type;
2941: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;
2942: --
2943: l_asg_trm_eff_start_date per_assignments_f.effective_start_date%type;
2944: l_asg_trm_eff_end_date per_assignments_f.effective_end_date%type;
2945: l_emp_trm_eff_end_date per_assignments_f.effective_end_date%type;
2946: l_asg_future_changes_warning boolean;
2947: l_supervisor_warning boolean;
2948: l_event_warning boolean;

Line 2945: l_emp_trm_eff_end_date per_assignments_f.effective_end_date%type;

2941: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;
2942: --
2943: l_asg_trm_eff_start_date per_assignments_f.effective_start_date%type;
2944: l_asg_trm_eff_end_date per_assignments_f.effective_end_date%type;
2945: l_emp_trm_eff_end_date per_assignments_f.effective_end_date%type;
2946: l_asg_future_changes_warning boolean;
2947: l_supervisor_warning boolean;
2948: l_event_warning boolean;
2949: l_interview_warning boolean;

Line 2960: l_assignment_id per_assignments_f.assignment_id%type;

2956: --asg_future_changes_warning boolean;
2957: --l_entries_changed_warning boolean;
2958: l_pds_object_version_number number;
2959:
2960: l_assignment_id per_assignments_f.assignment_id%type;
2961: l_asg_status_type_id number(9);
2962: l_update_mode varchar2(30) := 'UPDATE';
2963: l_activate_flag varchar2(1) := 'N';
2964: l_suspend_flag varchar2(1) := 'N';

Line 2975: l_working_hours per_assignments_f.normal_hours%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:
2977: l_SOFT_CODING_KEYFLEX_ID NUMBER;
2978: l_COMMENT_ID NUMBER;
2979: l_EFFECTIVE_START_DATE DATE ;

Line 3296: from per_assignments_f asg

3292:
3293: /****** Bug 5923426 Commented the cursor and wrote a modified one.
3294: Cursor c_user_old_status is
3295: Select asg.assignment_status_type_id
3296: from per_assignments_f asg
3297: where asg.assignment_id = l_assignment_id
3298: and l_old_effective_start_date between asg.effective_start_date
3299: and asg.effective_end_date;
3300: ********/

Line 3305: from per_assignments_f asg,per_assignment_status_types past

3301: --- Bug 5923426 start
3302:
3303: Cursor c_user_old_status is
3304: Select past.per_system_status ,asg.assignment_status_type_id
3305: from per_assignments_f asg,per_assignment_status_types past
3306: where asg.assignment_id = l_assignment_id
3307: and asg.assignment_status_type_id = past.assignment_status_type_id
3308: order by asg.effective_start_date desc;
3309:

Line 4173: p_table_name => 'PER_ASSIGNMENTS_F'

4169: -- Function to determine update_mode
4170: l_update_mode := return_update_mode
4171: (p_id => p_pa_request_rec.employee_assignment_id,
4172: p_effective_date => p_pa_request_rec.effective_date,
4173: p_table_name => 'PER_ASSIGNMENTS_F'
4174: );
4175: hr_utility.set_location(l_proc,90);
4176: hr_utility.set_location('Asg id ' || to_char(l_assignment_id),3);
4177: hr_utility.set_location('pay id ' || to_char(l_payroll_id),4);

Line 4251: p_table_name => 'PER_ASSIGNMENTS_F'

4247: hr_utility.set_location(l_proc,120);
4248: l_update_mode := return_update_mode
4249: (p_id => p_pa_request_rec.employee_assignment_id,
4250: p_effective_date => p_pa_request_rec.effective_date,
4251: p_table_name => 'PER_ASSIGNMENTS_F'
4252: );
4253: Begin
4254: savepoint activate;
4255:

Line 4275: p_table_name => 'PER_ASSIGNMENTS_F'

4271: hr_utility.set_location(l_proc,125);
4272: l_update_mode := return_update_mode
4273: (p_id => p_pa_request_rec.employee_assignment_id,
4274: p_effective_date => p_pa_request_rec.effective_date,
4275: p_table_name => 'PER_ASSIGNMENTS_F'
4276: );
4277: Begin
4278: savepoint suspend;
4279: hr_assignment_api.suspend_emp_asg

Line 4841: from per_assignments_f

4837: -- Start of code for Payroll Integration
4838: -- Payroll Integration
4839: Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
4840: Select distinct business_group_id bg
4841: from per_assignments_f
4842: where assignment_id = p_assignment_id
4843: and p_eff_date between effective_start_date
4844: and effective_end_date;
4845:

Line 4868: from per_assignments_f

4864: soft_coding_keyflex_id scl_kff_id,
4865: effective_start_date start_date,
4866: effective_end_date end_date,
4867: payroll_id
4868: from per_assignments_f
4869: where assignment_id=p_asg_id
4870: -- and position_id = p_pa_request_rec.to_position_id
4871: and p_eff_date
4872: between effective_start_date and effective_end_date;

Line 4874: l_SB_ovn per_assignments_f.object_version_number%type;

4870: -- and position_id = p_pa_request_rec.to_position_id
4871: and p_eff_date
4872: between effective_start_date and effective_end_date;
4873:
4874: l_SB_ovn per_assignments_f.object_version_number%type;
4875: l_ppl_grp_id per_assignments_f.people_group_id%type;
4876: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
4877: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
4878: l_eff_start_date per_assignments_f.effective_start_date%type;

Line 4875: l_ppl_grp_id per_assignments_f.people_group_id%type;

4871: and p_eff_date
4872: between effective_start_date and effective_end_date;
4873:
4874: l_SB_ovn per_assignments_f.object_version_number%type;
4875: l_ppl_grp_id per_assignments_f.people_group_id%type;
4876: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
4877: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
4878: l_eff_start_date per_assignments_f.effective_start_date%type;
4879: l_eff_end_date per_assignments_f.effective_end_date%type;

Line 4876: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;

4872: between effective_start_date and effective_end_date;
4873:
4874: l_SB_ovn per_assignments_f.object_version_number%type;
4875: l_ppl_grp_id per_assignments_f.people_group_id%type;
4876: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
4877: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
4878: l_eff_start_date per_assignments_f.effective_start_date%type;
4879: l_eff_end_date per_assignments_f.effective_end_date%type;
4880: l_payroll_id per_assignments_f.payroll_id%type;

Line 4877: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;

4873:
4874: l_SB_ovn per_assignments_f.object_version_number%type;
4875: l_ppl_grp_id per_assignments_f.people_group_id%type;
4876: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
4877: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
4878: l_eff_start_date per_assignments_f.effective_start_date%type;
4879: l_eff_end_date per_assignments_f.effective_end_date%type;
4880: l_payroll_id per_assignments_f.payroll_id%type;
4881: l_group_name pay_people_groups.group_name%type;

Line 4878: l_eff_start_date per_assignments_f.effective_start_date%type;

4874: l_SB_ovn per_assignments_f.object_version_number%type;
4875: l_ppl_grp_id per_assignments_f.people_group_id%type;
4876: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
4877: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
4878: l_eff_start_date per_assignments_f.effective_start_date%type;
4879: l_eff_end_date per_assignments_f.effective_end_date%type;
4880: l_payroll_id per_assignments_f.payroll_id%type;
4881: l_group_name pay_people_groups.group_name%type;
4882: l_org_now_man_warn boolean;

Line 4879: l_eff_end_date per_assignments_f.effective_end_date%type;

4875: l_ppl_grp_id per_assignments_f.people_group_id%type;
4876: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
4877: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
4878: l_eff_start_date per_assignments_f.effective_start_date%type;
4879: l_eff_end_date per_assignments_f.effective_end_date%type;
4880: l_payroll_id per_assignments_f.payroll_id%type;
4881: l_group_name pay_people_groups.group_name%type;
4882: l_org_now_man_warn boolean;
4883: l_other_manager_warn boolean;

Line 4880: l_payroll_id per_assignments_f.payroll_id%type;

4876: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
4877: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
4878: l_eff_start_date per_assignments_f.effective_start_date%type;
4879: l_eff_end_date per_assignments_f.effective_end_date%type;
4880: l_payroll_id per_assignments_f.payroll_id%type;
4881: l_group_name pay_people_groups.group_name%type;
4882: l_org_now_man_warn boolean;
4883: l_other_manager_warn boolean;
4884: l_spp_delete_warning boolean;

Line 5182: p_table_name => 'PER_ASSIGNMENTS_F'

5178: --
5179: l_dt_mode := return_update_mode
5180: (p_id => p_pa_request_rec.employee_assignment_id,
5181: p_effective_date => l_effective_date,
5182: p_table_name => 'PER_ASSIGNMENTS_F'
5183: );
5184:
5185: hr_utility.trace('l_dt_mode is :'||l_dt_mode);
5186: