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 1362: per_Assignments_f asg

1358: Cursor Cur_Par_Asg(p_ssn VARCHAR2) is
1359: select par.first_noa_code
1360: from
1361: ghr_pa_requests par,
1362: per_Assignments_f asg
1363: where asg.assignment_id=par.employee_assignment_id
1364: and par.employee_national_identifier=p_ssn
1365: and noa_family_code not in
1366: ('NON_PAY_DUTY_STATUS','RETURN_TO_DUTY','CANCEL','CORRECT')

Line 1415: per_Assignments_f asg

1411: SELECT
1412: first_noa_information1 NTE_Dates
1413: FROM
1414: ghr_pa_requests par,
1415: per_Assignments_f asg
1416: WHERE
1417: asg.assignment_id= par.employee_assignment_id AND
1418: asg.effective_start_date = par.effective_date AND
1419: par.person_id= c_person_id AND

Line 2592: and gph.table_name = 'PER_ASSIGNMENTS_F'

2588: where gph.assignment_id = p_assignment_id
2589: and ghr_general.return_number(gph.information5) = ast.assignment_status_type_id
2590: and ast.user_status <> 'Detail NTE'
2591: and ast.per_system_status <> 'SUSP_ASSIGN' --Bug# 13087709
2592: and gph.table_name = 'PER_ASSIGNMENTS_F'
2593: and gph.effective_date < =
2594: (select asg.effective_start_date
2595: from per_assignment_status_types ast,
2596: per_all_assignments_f asg

Line 2955: Elsif p_table_name = 'PER_ASSIGNMENTS_F' then

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
2956: hr_utility.set_location(l_proc,60);
2957: for update_mode in c_update_mode_a loop
2958: hr_utility.set_location(l_proc,65);
2959: l_esd := update_mode.effective_start_date;

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

2985: hr_utility.set_location(l_proc,105);
2986: hr_utility.set_location('UPDATE_MODE : ' || l_mode,2);
2987: If l_mode is null then
2988: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
2989: hr_utility.set_message_token('TABLE_NAME','per_assignments_f');
2990: hr_utility.raise_error;
2991: End if;
2992: Elsif p_table_name = 'HR_ALL_POSITIONS_F' then
2993: hr_utility.set_location(l_proc,110);

Line 3089: l_asg_upd_effective_start_date per_assignments_f.effective_start_date%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;
3090: l_asg_upd_effective_end_date per_assignments_f.effective_end_date%type;
3091: l_asg_upd_special_ceil_step_id per_assignments_f.special_ceiling_step_id%type;
3092: l_asg_upd_people_group_id per_assignments_f.people_group_id%type;
3093: l_asg_upd_group_name pay_people_groups.group_name%type;

Line 3090: l_asg_upd_effective_end_date per_assignments_f.effective_end_date%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;
3090: l_asg_upd_effective_end_date per_assignments_f.effective_end_date%type;
3091: l_asg_upd_special_ceil_step_id per_assignments_f.special_ceiling_step_id%type;
3092: l_asg_upd_people_group_id per_assignments_f.people_group_id%type;
3093: l_asg_upd_group_name pay_people_groups.group_name%type;
3094: l_asg_upd_org_now_man_warn boolean;

Line 3091: l_asg_upd_special_ceil_step_id per_assignments_f.special_ceiling_step_id%type;

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;
3090: l_asg_upd_effective_end_date per_assignments_f.effective_end_date%type;
3091: l_asg_upd_special_ceil_step_id per_assignments_f.special_ceiling_step_id%type;
3092: l_asg_upd_people_group_id per_assignments_f.people_group_id%type;
3093: l_asg_upd_group_name pay_people_groups.group_name%type;
3094: l_asg_upd_org_now_man_warn boolean;
3095: l_asg_upd_other_manager_warn boolean ;

Line 3092: l_asg_upd_people_group_id per_assignments_f.people_group_id%type;

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;
3090: l_asg_upd_effective_end_date per_assignments_f.effective_end_date%type;
3091: l_asg_upd_special_ceil_step_id per_assignments_f.special_ceiling_step_id%type;
3092: l_asg_upd_people_group_id per_assignments_f.people_group_id%type;
3093: l_asg_upd_group_name pay_people_groups.group_name%type;
3094: l_asg_upd_org_now_man_warn boolean;
3095: l_asg_upd_other_manager_warn boolean ;
3096: l_asg_upd_spp_delete_warning boolean;

Line 3113: l_asg_act_eff_start_date per_assignments_f.effective_start_date%type;

3109: --
3110:
3111: -- Return to duty (active) out variables
3112: --
3113: l_asg_act_eff_start_date per_assignments_f.effective_start_date%type;
3114: l_asg_act_eff_end_date per_assignments_f.effective_end_date%type;
3115: --
3116: --Suspend employee out variables
3117: --

Line 3114: l_asg_act_eff_end_date per_assignments_f.effective_end_date%type;

3110:
3111: -- Return to duty (active) out variables
3112: --
3113: l_asg_act_eff_start_date per_assignments_f.effective_start_date%type;
3114: l_asg_act_eff_end_date per_assignments_f.effective_end_date%type;
3115: --
3116: --Suspend employee out variables
3117: --
3118: l_asg_sus_eff_start_date per_assignments_f.effective_start_date%type;

Line 3118: l_asg_sus_eff_start_date per_assignments_f.effective_start_date%type;

3114: l_asg_act_eff_end_date per_assignments_f.effective_end_date%type;
3115: --
3116: --Suspend employee out variables
3117: --
3118: l_asg_sus_eff_start_date per_assignments_f.effective_start_date%type;
3119: l_asg_sus_eff_end_date per_assignments_f.effective_end_date%type;--
3120:
3121: -- Create addresses out variables
3122: --

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

3115: --
3116: --Suspend employee out variables
3117: --
3118: l_asg_sus_eff_start_date per_assignments_f.effective_start_date%type;
3119: l_asg_sus_eff_end_date per_assignments_f.effective_end_date%type;--
3120:
3121: -- Create addresses out variables
3122: --
3123: l_per_add_address_id per_addresses.address_id%type;

Line 3129: l_asg_fnl_eff_start_date per_assignments_f.effective_start_date%type;

3125: --
3126:
3127: -- Final Process out variables
3128: --
3129: l_asg_fnl_eff_start_date per_assignments_f.effective_start_date%type;
3130: l_asg_fnl_eff_end_date per_assignments_f.effective_end_date%type;
3131: l_asg_fnl_org_now_no_manager boolean;
3132: l_asg_fnl_future_chan_warn boolean;
3133: l_asg_fnl_entries_chan_warn varchar2(1);

Line 3130: l_asg_fnl_eff_end_date per_assignments_f.effective_end_date%type;

3126:
3127: -- Final Process out variables
3128: --
3129: l_asg_fnl_eff_start_date per_assignments_f.effective_start_date%type;
3130: l_asg_fnl_eff_end_date per_assignments_f.effective_end_date%type;
3131: l_asg_fnl_org_now_no_manager boolean;
3132: l_asg_fnl_future_chan_warn boolean;
3133: l_asg_fnl_entries_chan_warn varchar2(1);
3134: --

Line 3137: l_asg_object_version_number per_assignments_f.object_version_number%type;

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

Line 3144: --l_sec_assignmemt_id per_assignments_f.assignment_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;
3145: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;
3146: --
3147: l_asg_trm_eff_start_date per_assignments_f.effective_start_date%type;
3148: l_asg_trm_eff_end_date per_assignments_f.effective_end_date%type;

Line 3147: l_asg_trm_eff_start_date per_assignments_f.effective_start_date%type;

3143: l_person_type per_person_types.system_person_type%type;
3144: --l_sec_assignmemt_id per_assignments_f.assignment_id%type;
3145: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;
3146: --
3147: l_asg_trm_eff_start_date per_assignments_f.effective_start_date%type;
3148: l_asg_trm_eff_end_date per_assignments_f.effective_end_date%type;
3149: l_emp_trm_eff_end_date per_assignments_f.effective_end_date%type;
3150: l_asg_future_changes_warning boolean;
3151: l_supervisor_warning boolean;

Line 3148: l_asg_trm_eff_end_date per_assignments_f.effective_end_date%type;

3144: --l_sec_assignmemt_id per_assignments_f.assignment_id%type;
3145: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;
3146: --
3147: l_asg_trm_eff_start_date per_assignments_f.effective_start_date%type;
3148: l_asg_trm_eff_end_date per_assignments_f.effective_end_date%type;
3149: l_emp_trm_eff_end_date per_assignments_f.effective_end_date%type;
3150: l_asg_future_changes_warning boolean;
3151: l_supervisor_warning boolean;
3152: l_event_warning boolean;

Line 3149: l_emp_trm_eff_end_date per_assignments_f.effective_end_date%type;

3145: --l_assignment_status_type_id per_assignment_status_types.assignment_status_type_id%type;
3146: --
3147: l_asg_trm_eff_start_date per_assignments_f.effective_start_date%type;
3148: l_asg_trm_eff_end_date per_assignments_f.effective_end_date%type;
3149: l_emp_trm_eff_end_date per_assignments_f.effective_end_date%type;
3150: l_asg_future_changes_warning boolean;
3151: l_supervisor_warning boolean;
3152: l_event_warning boolean;
3153: l_interview_warning boolean;

Line 3164: l_assignment_id per_assignments_f.assignment_id%type;

3160: --asg_future_changes_warning boolean;
3161: --l_entries_changed_warning boolean;
3162: l_pds_object_version_number number;
3163:
3164: l_assignment_id per_assignments_f.assignment_id%type;
3165: l_asg_status_type_id number(9);
3166: l_update_mode varchar2(30) := 'UPDATE';
3167: l_activate_flag varchar2(1) := 'N';
3168: l_suspend_flag varchar2(1) := 'N';

Line 3179: l_working_hours per_assignments_f.normal_hours%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:
3181: l_SOFT_CODING_KEYFLEX_ID NUMBER;
3182: l_COMMENT_ID NUMBER;
3183: l_EFFECTIVE_START_DATE DATE ;

Line 3501: from per_assignments_f asg

3497:
3498: /****** Bug 5923426 Commented the cursor and wrote a modified one.
3499: Cursor c_user_old_status is
3500: Select asg.assignment_status_type_id
3501: from per_assignments_f asg
3502: where asg.assignment_id = l_assignment_id
3503: and l_old_effective_start_date between asg.effective_start_date
3504: and asg.effective_end_date;
3505: ********/

Line 3510: from per_assignments_f asg,per_assignment_status_types past

3506: --- Bug 5923426 start
3507: /****** Bug 13057211 Commented the cursor and wrote a modified one.
3508: Cursor c_user_old_status is
3509: Select past.per_system_status ,asg.assignment_status_type_id
3510: from per_assignments_f asg,per_assignment_status_types past
3511: where asg.assignment_id = l_assignment_id
3512: and asg.assignment_status_type_id = past.assignment_status_type_id
3513: order by asg.effective_start_date desc;
3514: ********/

Line 3524: and gph.table_name = 'PER_ASSIGNMENTS_F'

3520: from per_assignment_status_types ast,
3521: ghr_pa_history gph
3522: where gph.assignment_id = l_assignment_id
3523: and ghr_general.return_number(gph.information5) = ast.assignment_status_type_id
3524: and gph.table_name = 'PER_ASSIGNMENTS_F'
3525: and gph.effective_date < = l_old_effective_start_date
3526: order by gph.pa_history_id desc;
3527: --- Bug 13057211 end
3528:

Line 4417: p_table_name => 'PER_ASSIGNMENTS_F'

4413: -- Function to determine update_mode
4414: l_update_mode := return_update_mode
4415: (p_id => p_pa_request_rec.employee_assignment_id,
4416: p_effective_date => p_pa_request_rec.effective_date,
4417: p_table_name => 'PER_ASSIGNMENTS_F'
4418: );
4419: hr_utility.set_location(l_proc,90);
4420: hr_utility.set_location('Asg id ' || to_char(l_assignment_id),3);
4421: hr_utility.set_location('pay id ' || to_char(l_payroll_id),4);

Line 4495: p_table_name => 'PER_ASSIGNMENTS_F'

4491: hr_utility.set_location(l_proc,120);
4492: l_update_mode := return_update_mode
4493: (p_id => p_pa_request_rec.employee_assignment_id,
4494: p_effective_date => p_pa_request_rec.effective_date,
4495: p_table_name => 'PER_ASSIGNMENTS_F'
4496: );
4497: Begin
4498: savepoint activate;
4499: -- Begin Bug# 9849900

Line 4533: p_table_name => 'PER_ASSIGNMENTS_F'

4529: hr_utility.set_location(l_proc,125);
4530: l_update_mode := return_update_mode
4531: (p_id => p_pa_request_rec.employee_assignment_id,
4532: p_effective_date => p_pa_request_rec.effective_date,
4533: p_table_name => 'PER_ASSIGNMENTS_F'
4534: );
4535: Begin
4536: savepoint suspend;
4537: hr_assignment_api.suspend_emp_asg

Line 5100: from per_assignments_f

5096: -- Start of code for Payroll Integration
5097: -- Payroll Integration
5098: Cursor Cur_bg(p_assignment_id NUMBER,p_eff_date DATE) is
5099: Select distinct business_group_id bg
5100: from per_assignments_f
5101: where assignment_id = p_assignment_id
5102: and p_eff_date between effective_start_date
5103: and effective_end_date;
5104:

Line 5127: from per_assignments_f

5123: soft_coding_keyflex_id scl_kff_id,
5124: effective_start_date start_date,
5125: effective_end_date end_date,
5126: payroll_id
5127: from per_assignments_f
5128: where assignment_id=p_asg_id
5129: -- and position_id = p_pa_request_rec.to_position_id
5130: and p_eff_date
5131: between effective_start_date and effective_end_date;

Line 5133: l_SB_ovn per_assignments_f.object_version_number%type;

5129: -- and position_id = p_pa_request_rec.to_position_id
5130: and p_eff_date
5131: between effective_start_date and effective_end_date;
5132:
5133: l_SB_ovn per_assignments_f.object_version_number%type;
5134: l_ppl_grp_id per_assignments_f.people_group_id%type;
5135: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
5136: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
5137: l_eff_start_date per_assignments_f.effective_start_date%type;

Line 5134: l_ppl_grp_id per_assignments_f.people_group_id%type;

5130: and p_eff_date
5131: between effective_start_date and effective_end_date;
5132:
5133: l_SB_ovn per_assignments_f.object_version_number%type;
5134: l_ppl_grp_id per_assignments_f.people_group_id%type;
5135: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
5136: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
5137: l_eff_start_date per_assignments_f.effective_start_date%type;
5138: l_eff_end_date per_assignments_f.effective_end_date%type;

Line 5135: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;

5131: between effective_start_date and effective_end_date;
5132:
5133: l_SB_ovn per_assignments_f.object_version_number%type;
5134: l_ppl_grp_id per_assignments_f.people_group_id%type;
5135: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
5136: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
5137: l_eff_start_date per_assignments_f.effective_start_date%type;
5138: l_eff_end_date per_assignments_f.effective_end_date%type;
5139: l_payroll_id per_assignments_f.payroll_id%type;

Line 5136: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;

5132:
5133: l_SB_ovn per_assignments_f.object_version_number%type;
5134: l_ppl_grp_id per_assignments_f.people_group_id%type;
5135: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
5136: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
5137: l_eff_start_date per_assignments_f.effective_start_date%type;
5138: l_eff_end_date per_assignments_f.effective_end_date%type;
5139: l_payroll_id per_assignments_f.payroll_id%type;
5140: l_group_name pay_people_groups.group_name%type;

Line 5137: l_eff_start_date per_assignments_f.effective_start_date%type;

5133: l_SB_ovn per_assignments_f.object_version_number%type;
5134: l_ppl_grp_id per_assignments_f.people_group_id%type;
5135: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
5136: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
5137: l_eff_start_date per_assignments_f.effective_start_date%type;
5138: l_eff_end_date per_assignments_f.effective_end_date%type;
5139: l_payroll_id per_assignments_f.payroll_id%type;
5140: l_group_name pay_people_groups.group_name%type;
5141: l_org_now_man_warn boolean;

Line 5138: l_eff_end_date per_assignments_f.effective_end_date%type;

5134: l_ppl_grp_id per_assignments_f.people_group_id%type;
5135: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
5136: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
5137: l_eff_start_date per_assignments_f.effective_start_date%type;
5138: l_eff_end_date per_assignments_f.effective_end_date%type;
5139: l_payroll_id per_assignments_f.payroll_id%type;
5140: l_group_name pay_people_groups.group_name%type;
5141: l_org_now_man_warn boolean;
5142: l_other_manager_warn boolean;

Line 5139: l_payroll_id per_assignments_f.payroll_id%type;

5135: l_spcl_clng_stp_id per_assignments_f.special_ceiling_step_id%type;
5136: l_scl_kff_id per_assignments_f.soft_coding_keyflex_id%type;
5137: l_eff_start_date per_assignments_f.effective_start_date%type;
5138: l_eff_end_date per_assignments_f.effective_end_date%type;
5139: l_payroll_id per_assignments_f.payroll_id%type;
5140: l_group_name pay_people_groups.group_name%type;
5141: l_org_now_man_warn boolean;
5142: l_other_manager_warn boolean;
5143: l_spp_delete_warning boolean;

Line 5441: p_table_name => 'PER_ASSIGNMENTS_F'

5437: --
5438: l_dt_mode := return_update_mode
5439: (p_id => p_pa_request_rec.employee_assignment_id,
5440: p_effective_date => l_effective_date,
5441: p_table_name => 'PER_ASSIGNMENTS_F'
5442: );
5443:
5444: hr_utility.trace('l_dt_mode is :'||l_dt_mode);
5445: