APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_ASG_SHD

Line 205: per_asg_shd.find_dt_upd_modes

201: --
202: -- Determine the datetrack mode to use for the assignment table handler
203: -- update call.
204: --
205: per_asg_shd.find_dt_upd_modes
206: (p_effective_date => p_actual_termination_date + 1
207: ,p_base_key_value => p_assignment_id
208: ,p_correction => l_correction
209: ,p_update => l_update

Line 246: per_asg_shd.lck

242: -- Lock the current row as of ATD+1, using correction mode.
243: -- This validates the object version number passed in and obtains the
244: -- validation_start_date and validation_end_date.
245: --
246: per_asg_shd.lck
247: (p_effective_date => p_actual_termination_date + 1
248: ,p_datetrack_mode => 'CORRECTION'
249: ,p_assignment_id => p_assignment_id
250: ,p_object_version_number => l_object_version_number

Line 1111: per_asg_shd.find_dt_upd_modes

1107: close csr_asg_values;*/
1108: /* commented the changes made by bug 5026287*/
1109: /*if p_actual_termination_date = l_effective_start_date1 then
1110:
1111: per_asg_shd.find_dt_upd_modes
1112: (p_effective_date => p_actual_termination_date
1113: ,p_base_key_value => p_assignment_id
1114: ,p_correction => l_correction
1115: ,p_update => l_update

Line 1120: per_asg_shd.find_dt_upd_modes

1116: ,p_update_override => l_update_override
1117: ,p_update_change_insert => l_update_change_insert
1118: );
1119: else
1120: per_asg_shd.find_dt_upd_modes
1121: (p_effective_date => p_actual_termination_date + 1
1122: ,p_base_key_value => p_assignment_id
1123: ,p_correction => l_correction
1124: ,p_update => l_update

Line 1130: per_asg_shd.find_dt_upd_modes

1126: ,p_update_change_insert => l_update_change_insert
1127: );
1128: end if;*/
1129:
1130: per_asg_shd.find_dt_upd_modes
1131: (p_effective_date => p_actual_termination_date + 1
1132: ,p_base_key_value => p_assignment_id
1133: ,p_correction => l_correction
1134: ,p_update => l_update

Line 1174: per_asg_shd.lck

1170: -- Lock the current row as of ATD+1, using correction mode.
1171: -- This validates the object version number passed in and obtains the
1172: -- validation_start_date and validation_end_date.
1173: --
1174: per_asg_shd.lck
1175: (p_effective_date => p_actual_termination_date + 1
1176: ,p_datetrack_mode => 'CORRECTION'
1177: ,p_assignment_id => p_assignment_id
1178: ,p_object_version_number => l_object_version_number

Line 5942: /* if per_asg_shd.g_old_rec.assignment_type = 'O' then

5938: if g_debug then
5939: hr_utility.set_location('Entering:'|| l_proc, 10);
5940: end if;
5941: --
5942: /* if per_asg_shd.g_old_rec.assignment_type = 'O' then
5943: if g_debug then
5944: hr_utility.set_location('Assignment of type O is found', 20);
5945: end if;
5946: --

Line 5951: if ((p_datetrack_mode = 'ZAP') and ( per_asg_shd.g_old_rec.assignment_type = 'A')) then

5947: fnd_message.set_name('PER', 'ERROR_TO_BE_REPLACED_BY_IRC_1');
5948: fnd_message.raise_error;
5949: end if;
5950: --
5951: if ((p_datetrack_mode = 'ZAP') and ( per_asg_shd.g_old_rec.assignment_type = 'A')) then
5952: open irc_offers;
5953: fetch irc_offers into temp;
5954: close irc_offers;
5955: --

Line 6031: (p_rec in per_asg_shd.g_rec_type,

6027: --
6028: --surendra
6029: --
6030: procedure pre_delete
6031: (p_rec in per_asg_shd.g_rec_type,
6032: p_effective_date in date,
6033: p_datetrack_mode in varchar2,
6034: p_validation_start_date in date,
6035: p_validation_end_date in date,

Line 6098: where assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id;

6094: --
6095: cursor csr_ass_sys_type is
6096: select per_system_status
6097: from per_assignment_status_types
6098: where assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id;
6099: --
6100: cursor csr_ass_step_sequence is
6101: select sequence
6102: from per_spinal_point_steps_f

Line 6103: where step_id = per_asg_shd.g_old_rec.special_ceiling_step_id

6099: --
6100: cursor csr_ass_step_sequence is
6101: select sequence
6102: from per_spinal_point_steps_f
6103: where step_id = per_asg_shd.g_old_rec.special_ceiling_step_id
6104: and p_effective_date between effective_start_date and effective_end_date;
6105: --
6106: cursor csr_ass_row_id is
6107: select rowid from per_all_assignments_f

Line 6114: where location_id = per_asg_shd.g_old_rec.location_id;

6110: --
6111: cursor csr_ass_loc_code is
6112: select location_code
6113: from hr_locations
6114: where location_id = per_asg_shd.g_old_rec.location_id;
6115: --
6116: --start changes for bug 6917728
6117: cursor csr_get_legislation_code is
6118: select bus.legislation_code

Line 6120: where bus.business_group_id = per_asg_shd.g_old_rec.business_group_id;

6116: --start changes for bug 6917728
6117: cursor csr_get_legislation_code is
6118: select bus.legislation_code
6119: from per_business_groups bus
6120: where bus.business_group_id = per_asg_shd.g_old_rec.business_group_id;
6121: --start changes for bug 6917728
6122:
6123: l_proc varchar2(72) := g_package||'pre_delete';
6124: --

Line 6176: if per_asg_shd.g_old_rec.assignment_type = 'A' then

6172: (p_assignment_id => p_rec.assignment_id
6173: ,p_datetrack_mode => p_datetrack_mode
6174: ,p_life_events_exists => p_life_events_exists );
6175: --
6176: if per_asg_shd.g_old_rec.assignment_type = 'A' then
6177: ---
6178: if g_debug then
6179: hr_utility.set_location('Applicant type Assignment', 20);
6180: end if;

Line 6183: p_business_group_id => per_asg_shd.g_old_rec.business_group_id,

6179: hr_utility.set_location('Applicant type Assignment', 20);
6180: end if;
6181: --
6182: per_app_asg_pkg.pre_delete_validation (
6183: p_business_group_id => per_asg_shd.g_old_rec.business_group_id,
6184: p_assignment_id => p_rec.assignment_id,
6185: p_application_id => per_asg_shd.g_old_rec.application_id,
6186: p_person_id => per_asg_shd.g_old_rec.person_id,
6187: p_session_date => p_effective_date, --:ctl_globals.session_date,

Line 6185: p_application_id => per_asg_shd.g_old_rec.application_id,

6181: --
6182: per_app_asg_pkg.pre_delete_validation (
6183: p_business_group_id => per_asg_shd.g_old_rec.business_group_id,
6184: p_assignment_id => p_rec.assignment_id,
6185: p_application_id => per_asg_shd.g_old_rec.application_id,
6186: p_person_id => per_asg_shd.g_old_rec.person_id,
6187: p_session_date => p_effective_date, --:ctl_globals.session_date,
6188: p_validation_start_date => p_validation_start_date,
6189: p_validation_end_date => p_validation_end_date,

Line 6186: p_person_id => per_asg_shd.g_old_rec.person_id,

6182: per_app_asg_pkg.pre_delete_validation (
6183: p_business_group_id => per_asg_shd.g_old_rec.business_group_id,
6184: p_assignment_id => p_rec.assignment_id,
6185: p_application_id => per_asg_shd.g_old_rec.application_id,
6186: p_person_id => per_asg_shd.g_old_rec.person_id,
6187: p_session_date => p_effective_date, --:ctl_globals.session_date,
6188: p_validation_start_date => p_validation_start_date,
6189: p_validation_end_date => p_validation_end_date,
6190: p_delete_mode => p_datetrack_mode,

Line 6193: elsif ((per_asg_shd.g_old_rec.assignment_type = 'E') OR (per_asg_shd.g_old_rec.assignment_type = 'C')) then

6189: p_validation_end_date => p_validation_end_date,
6190: p_delete_mode => p_datetrack_mode,
6191: p_new_end_date => p_appl_asg_new_end_date); -- :assgt.c_new_end_date ) ;
6192: ---
6193: elsif ((per_asg_shd.g_old_rec.assignment_type = 'E') OR (per_asg_shd.g_old_rec.assignment_type = 'C')) then
6194: ---
6195: if g_debug then
6196: hr_utility.set_location('EMP/CWK type Assignment', 30);
6197: end if;

Line 6221: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,

6217: --
6218: per_assignments_f2_pkg.pre_delete(
6219: p_datetrack_mode, -- p_del_mode,
6220: p_validation_start_date, -- p_val_st_date,
6221: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6222: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6223: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6224: l_sys_status_type, -- p_per_sys_st,
6225: p_rec.assignment_id, -- p_ass_id,

Line 6222: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,

6218: per_assignments_f2_pkg.pre_delete(
6219: p_datetrack_mode, -- p_del_mode,
6220: p_validation_start_date, -- p_val_st_date,
6221: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6222: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6223: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6224: l_sys_status_type, -- p_per_sys_st,
6225: p_rec.assignment_id, -- p_ass_id,
6226: p_effective_date, -- p_sess_date,

Line 6223: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,

6219: p_datetrack_mode, -- p_del_mode,
6220: p_validation_start_date, -- p_val_st_date,
6221: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6222: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6223: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6224: l_sys_status_type, -- p_per_sys_st,
6225: p_rec.assignment_id, -- p_ass_id,
6226: p_effective_date, -- p_sess_date,
6227: p_new_end_date, -- need this in post_delete()

Line 6229: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,

6225: p_rec.assignment_id, -- p_ass_id,
6226: p_effective_date, -- p_sess_date,
6227: p_new_end_date, -- need this in post_delete()
6228: p_validation_end_date, -- p_val_end_date,
6229: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,
6230: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6231: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6232: l_ceil_seq, -- p_ceil_seq,
6233: per_asg_shd.g_old_rec.person_id, -- p_per_id,

Line 6230: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,

6226: p_effective_date, -- p_sess_date,
6227: p_new_end_date, -- need this in post_delete()
6228: p_validation_end_date, -- p_val_end_date,
6229: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,
6230: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6231: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6232: l_ceil_seq, -- p_ceil_seq,
6233: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6234: per_asg_shd.g_old_rec.primary_flag, -- p_prim_flag,

Line 6231: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,

6227: p_new_end_date, -- need this in post_delete()
6228: p_validation_end_date, -- p_val_end_date,
6229: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,
6230: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6231: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6232: l_ceil_seq, -- p_ceil_seq,
6233: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6234: per_asg_shd.g_old_rec.primary_flag, -- p_prim_flag,
6235: p_prim_change_flag, -- need this in post_delete()

Line 6233: per_asg_shd.g_old_rec.person_id, -- p_per_id,

6229: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,
6230: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6231: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6232: l_ceil_seq, -- p_ceil_seq,
6233: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6234: per_asg_shd.g_old_rec.primary_flag, -- p_prim_flag,
6235: p_prim_change_flag, -- need this in post_delete()
6236: p_new_primary_flag, -- need this in post_delete()
6237: l_re_entry_point, -- no change

Line 6234: per_asg_shd.g_old_rec.primary_flag, -- p_prim_flag,

6230: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6231: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6232: l_ceil_seq, -- p_ceil_seq,
6233: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6234: per_asg_shd.g_old_rec.primary_flag, -- p_prim_flag,
6235: p_prim_change_flag, -- need this in post_delete()
6236: p_new_primary_flag, -- need this in post_delete()
6237: l_re_entry_point, -- no change
6238: l_returned_warning, -- no change

Line 6298: per_asg_shd.g_old_rec.location_id, -- p_loc_id ,

6294: IF l_legislation_code = 'US' then
6295: l_warning_text := pay_us_emp_dt_tax_val.check_payroll_run(
6296: p_rec.assignment_id, -- p_ass_id ,
6297: l_loc_code, -- p_loc_code,
6298: per_asg_shd.g_old_rec.location_id, -- p_loc_id ,
6299: p_effective_date, -- p_sess_date ,
6300: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6301: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6302: p_datetrack_mode -- l_del_mode

Line 6300: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,

6296: p_rec.assignment_id, -- p_ass_id ,
6297: l_loc_code, -- p_loc_code,
6298: per_asg_shd.g_old_rec.location_id, -- p_loc_id ,
6299: p_effective_date, -- p_sess_date ,
6300: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6301: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6302: p_datetrack_mode -- l_del_mode
6303: );
6304: --

Line 6301: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,

6297: l_loc_code, -- p_loc_code,
6298: per_asg_shd.g_old_rec.location_id, -- p_loc_id ,
6299: p_effective_date, -- p_sess_date ,
6300: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6301: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6302: p_datetrack_mode -- l_del_mode
6303: );
6304: --
6305: if l_warning_text is not null then

Line 6322: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,

6318: --
6319: per_assignments_f2_pkg.key_delrec(
6320: p_datetrack_mode, -- l_del_mode,
6321: p_validation_start_date, -- p_val_st_date,
6322: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6323: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6324: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6325: l_sys_status_type, -- p_per_sys_st,
6326: p_rec.assignment_id, -- p_ass_id ,

Line 6323: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,

6319: per_assignments_f2_pkg.key_delrec(
6320: p_datetrack_mode, -- l_del_mode,
6321: p_validation_start_date, -- p_val_st_date,
6322: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6323: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6324: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6325: l_sys_status_type, -- p_per_sys_st,
6326: p_rec.assignment_id, -- p_ass_id ,
6327: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,

Line 6324: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,

6320: p_datetrack_mode, -- l_del_mode,
6321: p_validation_start_date, -- p_val_st_date,
6322: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6323: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6324: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6325: l_sys_status_type, -- p_per_sys_st,
6326: p_rec.assignment_id, -- p_ass_id ,
6327: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6328: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,

Line 6327: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,

6323: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6324: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6325: l_sys_status_type, -- p_per_sys_st,
6326: p_rec.assignment_id, -- p_ass_id ,
6327: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6328: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6329: l_ceil_seq, -- p_ceil_seq,
6330: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6331: p_effective_date, -- p_sess_date ,

Line 6328: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,

6324: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6325: l_sys_status_type, -- p_per_sys_st,
6326: p_rec.assignment_id, -- p_ass_id ,
6327: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6328: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6329: l_ceil_seq, -- p_ceil_seq,
6330: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6331: p_effective_date, -- p_sess_date ,
6332: l_new_end_date, -- no change

Line 6330: per_asg_shd.g_old_rec.person_id, -- p_per_id,

6326: p_rec.assignment_id, -- p_ass_id ,
6327: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6328: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6329: l_ceil_seq, -- p_ceil_seq,
6330: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6331: p_effective_date, -- p_sess_date ,
6332: l_new_end_date, -- no change
6333: p_validation_end_date, -- p_val_end_date,
6334: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,

Line 6334: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,

6330: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6331: p_effective_date, -- p_sess_date ,
6332: l_new_end_date, -- no change
6333: p_validation_end_date, -- p_val_end_date,
6334: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,
6335: l_pay_basis_id -- added for bug 4764140
6336: );
6337: --
6338: -- CHECK_TERM_BY_POS changes (called in per_assignments_f2_pkg.key_delrec)

Line 6341: l_rec2 per_asg_shd.g_rec_type;

6337: --
6338: -- CHECK_TERM_BY_POS changes (called in per_assignments_f2_pkg.key_delrec)
6339: --
6340: declare
6341: l_rec2 per_asg_shd.g_rec_type;
6342: begin
6343: --
6344: l_rec2.assignment_id := p_rec.assignment_id; -- p_ass_id;
6345: l_rec2.position_id := per_asg_shd.g_old_rec.position_id; -- name_in('ASSGT.POSITION_ID');

Line 6345: l_rec2.position_id := per_asg_shd.g_old_rec.position_id; -- name_in('ASSGT.POSITION_ID');

6341: l_rec2 per_asg_shd.g_rec_type;
6342: begin
6343: --
6344: l_rec2.assignment_id := p_rec.assignment_id; -- p_ass_id;
6345: l_rec2.position_id := per_asg_shd.g_old_rec.position_id; -- name_in('ASSGT.POSITION_ID');
6346: --
6347: if g_debug then
6348: hr_utility.set_location('Before per_pqh_shr.per_asg_bus call ', 70);
6349: end if;

Line 6376: (p_rec in per_asg_shd.g_rec_type,

6372: --
6373: --surendra
6374: --
6375: procedure post_delete
6376: (p_rec in per_asg_shd.g_rec_type,
6377: p_effective_date in date,
6378: p_datetrack_mode in varchar2,
6379: p_validation_start_date in date,
6380: p_validation_end_date in date,

Line 6434: if per_asg_shd.g_old_rec.assignment_type = 'A' then

6430: --
6431: l_new_prim_ass_id := p_new_prim_ass_id;
6432: l_prim_change_flag := p_prim_change_flag;
6433: --
6434: if per_asg_shd.g_old_rec.assignment_type = 'A' then
6435: ---
6436: if g_debug then
6437: hr_utility.set_location('Applicant type Assignment', 20);
6438: end if;

Line 6446: per_asg_shd.g_old_rec.effective_end_date, -- p_effective_end_date,

6442: if ( p_validation_end_date = hr_api.g_eot ) then
6443: hr_assignment.tidy_up_ref_int ( p_rec.assignment_id, -- p_assignment_id,
6444: 'FUTURE',
6445: p_validation_end_date, -- p_validation_end_date,
6446: per_asg_shd.g_old_rec.effective_end_date, -- p_effective_end_date,
6447: null,
6448: null ,
6449: l_appl_cost_warning) ; -- used to catch the cost warning
6450: -- but as Apl asg's can't have costing

Line 6456: per_asg_shd.g_old_rec.effective_end_date, -- p_effective_end_date,

6452: end if;
6453: else hr_assignment.tidy_up_ref_int ( p_rec.assignment_id, -- p_assignment_id,
6454: 'FUTURE',
6455: p_validation_end_date, -- p_new_end_date,
6456: per_asg_shd.g_old_rec.effective_end_date, -- p_effective_end_date,
6457: null,
6458: null,
6459: l_appl_cost_warning ) ;
6460: end if;

Line 6488: elsif ((per_asg_shd.g_old_rec.assignment_type = 'E') OR (per_asg_shd.g_old_rec.assignment_type = 'C')) then

6484: per_app_asg_pkg.post_delete ( p_assignment_id => p_rec.assignment_id, -- :ASSGT.ASSIGNMENT_ID,
6485: p_validation_start_date => p_validation_start_date); -- :ASSGT.VALIDATION_START_DATE ) ;
6486: end if; -- end of code for 'ZAP' mode.
6487: ---
6488: elsif ((per_asg_shd.g_old_rec.assignment_type = 'E') OR (per_asg_shd.g_old_rec.assignment_type = 'C')) then
6489: ---
6490: if g_debug then
6491: hr_utility.set_location('EMP/CWK type assignment checks ', 40);
6492: end if;

Line 6496: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,

6492: end if;
6493: --
6494: per_assignments_f1_pkg.post_delete(
6495: p_rec.assignment_id, -- p_ass_id,
6496: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6497: p_effective_date, -- p_sess_date,
6498: p_new_end_date, -- from pre_del()
6499: p_validation_end_date, -- p_val_end_date,
6500: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,

Line 6500: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,

6496: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6497: p_effective_date, -- p_sess_date,
6498: p_new_end_date, -- from pre_del()
6499: p_validation_end_date, -- p_val_end_date,
6500: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6501: p_datetrack_mode, -- p_del_mode,
6502: p_validation_start_date, -- p_val_st_date,
6503: p_new_primary_flag, -- from pre_del()
6504: hr_api.g_eot, -- p_eot,

Line 6505: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,

6501: p_datetrack_mode, -- p_del_mode,
6502: p_validation_start_date, -- p_val_st_date,
6503: p_new_primary_flag, -- from pre_del()
6504: hr_api.g_eot, -- p_eot,
6505: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6506: l_new_prim_ass_id, -- l_new_prim_ass_id,
6507: l_prim_change_flag, -- l_prim_change_flag,
6508: l_sys_status_type, -- p_per_sys_st,
6509: per_asg_shd.g_old_rec.business_group_id, -- p_bg_id,

Line 6509: per_asg_shd.g_old_rec.business_group_id, -- p_bg_id,

6505: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6506: l_new_prim_ass_id, -- l_new_prim_ass_id,
6507: l_prim_change_flag, -- l_prim_change_flag,
6508: l_sys_status_type, -- p_per_sys_st,
6509: per_asg_shd.g_old_rec.business_group_id, -- p_bg_id,
6510: p_s_pay_id, -- p_old_pay_id,
6511: per_asg_shd.g_old_rec.payroll_id, -- p_new_pay_id,
6512: p_cancel_atd, -- from pre_del()
6513: p_cancel_lspd, -- from pre_del()

Line 6511: per_asg_shd.g_old_rec.payroll_id, -- p_new_pay_id,

6507: l_prim_change_flag, -- l_prim_change_flag,
6508: l_sys_status_type, -- p_per_sys_st,
6509: per_asg_shd.g_old_rec.business_group_id, -- p_bg_id,
6510: p_s_pay_id, -- p_old_pay_id,
6511: per_asg_shd.g_old_rec.payroll_id, -- p_new_pay_id,
6512: p_cancel_atd, -- from pre_del()
6513: p_cancel_lspd, -- from pre_del()
6514: p_reterm_atd, -- from pre_del()
6515: p_reterm_lspd, -- from pre_del()