APPS.HR_ASSIGNMENT_INTERNAL dependencies on PER_ASG_SHD

Line 225: per_asg_shd.find_dt_upd_modes

221: --
222: -- Determine the datetrack mode to use for the assignment table handler
223: -- update call.
224: --
225: per_asg_shd.find_dt_upd_modes
226: (p_effective_date => p_actual_termination_date + 1
227: ,p_base_key_value => p_assignment_id
228: ,p_correction => l_correction
229: ,p_update => l_update

Line 266: per_asg_shd.lck

262: -- Lock the current row as of ATD+1, using correction mode.
263: -- This validates the object version number passed in and obtains the
264: -- validation_start_date and validation_end_date.
265: --
266: per_asg_shd.lck
267: (p_effective_date => p_actual_termination_date + 1
268: ,p_datetrack_mode => 'CORRECTION'
269: ,p_assignment_id => p_assignment_id
270: ,p_object_version_number => l_object_version_number

Line 1197: per_asg_shd.find_dt_upd_modes

1193: close csr_asg_values;*/
1194: /* commented the changes made by bug 5026287*/
1195: /*if p_actual_termination_date = l_effective_start_date1 then
1196:
1197: per_asg_shd.find_dt_upd_modes
1198: (p_effective_date => p_actual_termination_date
1199: ,p_base_key_value => p_assignment_id
1200: ,p_correction => l_correction
1201: ,p_update => l_update

Line 1206: per_asg_shd.find_dt_upd_modes

1202: ,p_update_override => l_update_override
1203: ,p_update_change_insert => l_update_change_insert
1204: );
1205: else
1206: per_asg_shd.find_dt_upd_modes
1207: (p_effective_date => p_actual_termination_date + 1
1208: ,p_base_key_value => p_assignment_id
1209: ,p_correction => l_correction
1210: ,p_update => l_update

Line 1216: per_asg_shd.find_dt_upd_modes

1212: ,p_update_change_insert => l_update_change_insert
1213: );
1214: end if;*/
1215:
1216: per_asg_shd.find_dt_upd_modes
1217: (p_effective_date => p_actual_termination_date + 1
1218: ,p_base_key_value => p_assignment_id
1219: ,p_correction => l_correction
1220: ,p_update => l_update

Line 1260: per_asg_shd.lck

1256: -- Lock the current row as of ATD+1, using correction mode.
1257: -- This validates the object version number passed in and obtains the
1258: -- validation_start_date and validation_end_date.
1259: --
1260: per_asg_shd.lck
1261: (p_effective_date => p_actual_termination_date + 1
1262: ,p_datetrack_mode => 'CORRECTION'
1263: ,p_assignment_id => p_assignment_id
1264: ,p_object_version_number => l_object_version_number

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

6149: if g_debug then
6150: hr_utility.set_location('Entering:'|| l_proc, 10);
6151: end if;
6152: --
6153: /* if per_asg_shd.g_old_rec.assignment_type = 'O' then
6154: if g_debug then
6155: hr_utility.set_location('Assignment of type O is found', 20);
6156: end if;
6157: --

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

6158: fnd_message.set_name('PER', 'ERROR_TO_BE_REPLACED_BY_IRC_1');
6159: fnd_message.raise_error;
6160: end if;
6161: --
6162: if ((p_datetrack_mode = 'ZAP') and ( per_asg_shd.g_old_rec.assignment_type = 'A')) then
6163: open irc_offers;
6164: fetch irc_offers into temp;
6165: close irc_offers;
6166: --

Line 6242: (p_rec in per_asg_shd.g_rec_type,

6238: --
6239: --surendra
6240: --
6241: procedure pre_delete
6242: (p_rec in per_asg_shd.g_rec_type,
6243: p_effective_date in date,
6244: p_datetrack_mode in varchar2,
6245: p_validation_start_date in date,
6246: p_validation_end_date in date,

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

6308: --
6309: cursor csr_ass_sys_type is
6310: select per_system_status
6311: from per_assignment_status_types
6312: where assignment_status_type_id = per_asg_shd.g_old_rec.assignment_status_type_id;
6313: --
6314: cursor csr_ass_step_sequence is
6315: select sequence
6316: from per_spinal_point_steps_f

Line 6317: where step_id = per_asg_shd.g_old_rec.special_ceiling_step_id

6313: --
6314: cursor csr_ass_step_sequence is
6315: select sequence
6316: from per_spinal_point_steps_f
6317: where step_id = per_asg_shd.g_old_rec.special_ceiling_step_id
6318: and p_effective_date between effective_start_date and effective_end_date;
6319: --
6320: cursor csr_ass_row_id is
6321: select rowid from per_all_assignments_f

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

6324: --
6325: cursor csr_ass_loc_code is
6326: select location_code
6327: from hr_locations
6328: where location_id = per_asg_shd.g_old_rec.location_id;
6329: --
6330: --start changes for bug 6917728
6331: cursor csr_get_legislation_code is
6332: select bus.legislation_code

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

6330: --start changes for bug 6917728
6331: cursor csr_get_legislation_code is
6332: select bus.legislation_code
6333: from per_business_groups bus
6334: where bus.business_group_id = per_asg_shd.g_old_rec.business_group_id;
6335: --start changes for bug 6917728
6336:
6337: l_proc varchar2(72) := g_package||'pre_delete';
6338: --

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

6386: (p_assignment_id => p_rec.assignment_id
6387: ,p_datetrack_mode => p_datetrack_mode
6388: ,p_life_events_exists => p_life_events_exists );
6389: --
6390: if per_asg_shd.g_old_rec.assignment_type = 'A' then
6391: ---
6392: if g_debug then
6393: hr_utility.set_location('Applicant type Assignment', 20);
6394: end if;

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

6393: hr_utility.set_location('Applicant type Assignment', 20);
6394: end if;
6395: --
6396: per_app_asg_pkg.pre_delete_validation (
6397: p_business_group_id => per_asg_shd.g_old_rec.business_group_id,
6398: p_assignment_id => p_rec.assignment_id,
6399: p_application_id => per_asg_shd.g_old_rec.application_id,
6400: p_person_id => per_asg_shd.g_old_rec.person_id,
6401: p_session_date => p_effective_date, --:ctl_globals.session_date,

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

6395: --
6396: per_app_asg_pkg.pre_delete_validation (
6397: p_business_group_id => per_asg_shd.g_old_rec.business_group_id,
6398: p_assignment_id => p_rec.assignment_id,
6399: p_application_id => per_asg_shd.g_old_rec.application_id,
6400: p_person_id => per_asg_shd.g_old_rec.person_id,
6401: p_session_date => p_effective_date, --:ctl_globals.session_date,
6402: p_validation_start_date => p_validation_start_date,
6403: p_validation_end_date => p_validation_end_date,

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

6396: per_app_asg_pkg.pre_delete_validation (
6397: p_business_group_id => per_asg_shd.g_old_rec.business_group_id,
6398: p_assignment_id => p_rec.assignment_id,
6399: p_application_id => per_asg_shd.g_old_rec.application_id,
6400: p_person_id => per_asg_shd.g_old_rec.person_id,
6401: p_session_date => p_effective_date, --:ctl_globals.session_date,
6402: p_validation_start_date => p_validation_start_date,
6403: p_validation_end_date => p_validation_end_date,
6404: p_delete_mode => p_datetrack_mode,

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

6403: p_validation_end_date => p_validation_end_date,
6404: p_delete_mode => p_datetrack_mode,
6405: p_new_end_date => p_appl_asg_new_end_date); -- :assgt.c_new_end_date ) ;
6406: ---
6407: elsif ((per_asg_shd.g_old_rec.assignment_type = 'E') OR (per_asg_shd.g_old_rec.assignment_type = 'C')) then
6408: ---
6409: if g_debug then
6410: hr_utility.set_location('EMP/CWK type Assignment', 30);
6411: end if;

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

6431: --
6432: per_assignments_f2_pkg.pre_delete(
6433: p_datetrack_mode, -- p_del_mode,
6434: p_validation_start_date, -- p_val_st_date,
6435: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6436: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6437: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6438: l_sys_status_type, -- p_per_sys_st,
6439: p_rec.assignment_id, -- p_ass_id,

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

6432: per_assignments_f2_pkg.pre_delete(
6433: p_datetrack_mode, -- p_del_mode,
6434: p_validation_start_date, -- p_val_st_date,
6435: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6436: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6437: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6438: l_sys_status_type, -- p_per_sys_st,
6439: p_rec.assignment_id, -- p_ass_id,
6440: p_effective_date, -- p_sess_date,

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

6433: p_datetrack_mode, -- p_del_mode,
6434: p_validation_start_date, -- p_val_st_date,
6435: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6436: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6437: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6438: l_sys_status_type, -- p_per_sys_st,
6439: p_rec.assignment_id, -- p_ass_id,
6440: p_effective_date, -- p_sess_date,
6441: p_new_end_date, -- need this in post_delete()

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

6439: p_rec.assignment_id, -- p_ass_id,
6440: p_effective_date, -- p_sess_date,
6441: p_new_end_date, -- need this in post_delete()
6442: p_validation_end_date, -- p_val_end_date,
6443: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,
6444: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6445: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6446: l_ceil_seq, -- p_ceil_seq,
6447: per_asg_shd.g_old_rec.person_id, -- p_per_id,

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

6440: p_effective_date, -- p_sess_date,
6441: p_new_end_date, -- need this in post_delete()
6442: p_validation_end_date, -- p_val_end_date,
6443: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,
6444: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6445: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6446: l_ceil_seq, -- p_ceil_seq,
6447: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6448: per_asg_shd.g_old_rec.primary_flag, -- p_prim_flag,

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

6441: p_new_end_date, -- need this in post_delete()
6442: p_validation_end_date, -- p_val_end_date,
6443: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,
6444: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6445: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6446: l_ceil_seq, -- p_ceil_seq,
6447: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6448: per_asg_shd.g_old_rec.primary_flag, -- p_prim_flag,
6449: p_prim_change_flag, -- need this in post_delete()

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

6443: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,
6444: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6445: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6446: l_ceil_seq, -- p_ceil_seq,
6447: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6448: per_asg_shd.g_old_rec.primary_flag, -- p_prim_flag,
6449: p_prim_change_flag, -- need this in post_delete()
6450: p_new_primary_flag, -- need this in post_delete()
6451: l_re_entry_point, -- no change

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

6444: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6445: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6446: l_ceil_seq, -- p_ceil_seq,
6447: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6448: per_asg_shd.g_old_rec.primary_flag, -- p_prim_flag,
6449: p_prim_change_flag, -- need this in post_delete()
6450: p_new_primary_flag, -- need this in post_delete()
6451: l_re_entry_point, -- no change
6452: l_returned_warning, -- no change

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

6512: and not (hr_utility.chk_product_install ( 'GHR','US') ) then
6513: l_warning_text := pay_us_emp_dt_tax_val.check_payroll_run(
6514: p_rec.assignment_id, -- p_ass_id ,
6515: l_loc_code, -- p_loc_code,
6516: per_asg_shd.g_old_rec.location_id, -- p_loc_id ,
6517: p_effective_date, -- p_sess_date ,
6518: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6519: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6520: p_datetrack_mode -- l_del_mode

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

6514: p_rec.assignment_id, -- p_ass_id ,
6515: l_loc_code, -- p_loc_code,
6516: per_asg_shd.g_old_rec.location_id, -- p_loc_id ,
6517: p_effective_date, -- p_sess_date ,
6518: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6519: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6520: p_datetrack_mode -- l_del_mode
6521: );
6522: --

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

6515: l_loc_code, -- p_loc_code,
6516: per_asg_shd.g_old_rec.location_id, -- p_loc_id ,
6517: p_effective_date, -- p_sess_date ,
6518: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6519: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6520: p_datetrack_mode -- l_del_mode
6521: );
6522: --
6523: if l_warning_text is not null then

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

6536: --
6537: per_assignments_f2_pkg.key_delrec(
6538: p_datetrack_mode, -- l_del_mode,
6539: p_validation_start_date, -- p_val_st_date,
6540: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6541: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6542: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6543: l_sys_status_type, -- p_per_sys_st,
6544: p_rec.assignment_id, -- p_ass_id ,

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

6537: per_assignments_f2_pkg.key_delrec(
6538: p_datetrack_mode, -- l_del_mode,
6539: p_validation_start_date, -- p_val_st_date,
6540: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6541: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6542: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6543: l_sys_status_type, -- p_per_sys_st,
6544: p_rec.assignment_id, -- p_ass_id ,
6545: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,

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

6538: p_datetrack_mode, -- l_del_mode,
6539: p_validation_start_date, -- p_val_st_date,
6540: per_asg_shd.g_old_rec.effective_start_date, -- p_eff_st_date,
6541: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6542: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6543: l_sys_status_type, -- p_per_sys_st,
6544: p_rec.assignment_id, -- p_ass_id ,
6545: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6546: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,

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

6541: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6542: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6543: l_sys_status_type, -- p_per_sys_st,
6544: p_rec.assignment_id, -- p_ass_id ,
6545: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6546: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6547: l_ceil_seq, -- p_ceil_seq,
6548: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6549: p_effective_date, -- p_sess_date ,

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

6542: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6543: l_sys_status_type, -- p_per_sys_st,
6544: p_rec.assignment_id, -- p_ass_id ,
6545: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6546: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6547: l_ceil_seq, -- p_ceil_seq,
6548: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6549: p_effective_date, -- p_sess_date ,
6550: l_new_end_date, -- no change

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

6544: p_rec.assignment_id, -- p_ass_id ,
6545: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6546: per_asg_shd.g_old_rec.special_ceiling_step_id, -- p_sp_ceil_st_id,
6547: l_ceil_seq, -- p_ceil_seq,
6548: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6549: p_effective_date, -- p_sess_date ,
6550: l_new_end_date, -- no change
6551: p_validation_end_date, -- p_val_end_date,
6552: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,

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

6548: per_asg_shd.g_old_rec.person_id, -- p_per_id,
6549: p_effective_date, -- p_sess_date ,
6550: l_new_end_date, -- no change
6551: p_validation_end_date, -- p_val_end_date,
6552: per_asg_shd.g_old_rec.payroll_id, -- p_pay_id,
6553: l_pay_basis_id -- added for bug 4764140
6554: );
6555: --
6556: -- CHECK_TERM_BY_POS changes (called in per_assignments_f2_pkg.key_delrec)

Line 6559: l_rec2 per_asg_shd.g_rec_type;

6555: --
6556: -- CHECK_TERM_BY_POS changes (called in per_assignments_f2_pkg.key_delrec)
6557: --
6558: declare
6559: l_rec2 per_asg_shd.g_rec_type;
6560: begin
6561: --
6562: l_rec2.assignment_id := p_rec.assignment_id; -- p_ass_id;
6563: l_rec2.position_id := per_asg_shd.g_old_rec.position_id; -- name_in('ASSGT.POSITION_ID');

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

6559: l_rec2 per_asg_shd.g_rec_type;
6560: begin
6561: --
6562: l_rec2.assignment_id := p_rec.assignment_id; -- p_ass_id;
6563: l_rec2.position_id := per_asg_shd.g_old_rec.position_id; -- name_in('ASSGT.POSITION_ID');
6564: --
6565: if g_debug then
6566: hr_utility.set_location('Before per_pqh_shr.per_asg_bus call ', 70);
6567: end if;

Line 6594: (p_rec in per_asg_shd.g_rec_type,

6590: --
6591: --surendra
6592: --
6593: procedure post_delete
6594: (p_rec in per_asg_shd.g_rec_type,
6595: p_effective_date in date,
6596: p_datetrack_mode in varchar2,
6597: p_validation_start_date in date,
6598: p_validation_end_date in date,

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

6648: --
6649: l_new_prim_ass_id := p_new_prim_ass_id;
6650: l_prim_change_flag := p_prim_change_flag;
6651: --
6652: if per_asg_shd.g_old_rec.assignment_type = 'A' then
6653: ---
6654: if g_debug then
6655: hr_utility.set_location('Applicant type Assignment', 20);
6656: end if;

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

6660: if ( p_validation_end_date = hr_api.g_eot ) then
6661: hr_assignment.tidy_up_ref_int ( p_rec.assignment_id, -- p_assignment_id,
6662: 'FUTURE',
6663: p_validation_end_date, -- p_validation_end_date,
6664: per_asg_shd.g_old_rec.effective_end_date, -- p_effective_end_date,
6665: null,
6666: null ,
6667: l_appl_cost_warning) ; -- used to catch the cost warning
6668: -- but as Apl asg's can't have costing

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

6670: end if;
6671: else hr_assignment.tidy_up_ref_int ( p_rec.assignment_id, -- p_assignment_id,
6672: 'FUTURE',
6673: p_validation_end_date, -- p_new_end_date,
6674: per_asg_shd.g_old_rec.effective_end_date, -- p_effective_end_date,
6675: null,
6676: null,
6677: l_appl_cost_warning ) ;
6678: end if;

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

6702: per_app_asg_pkg.post_delete ( p_assignment_id => p_rec.assignment_id, -- :ASSGT.ASSIGNMENT_ID,
6703: p_validation_start_date => p_validation_start_date); -- :ASSGT.VALIDATION_START_DATE ) ;
6704: end if; -- end of code for 'ZAP' mode.
6705: ---
6706: elsif ((per_asg_shd.g_old_rec.assignment_type = 'E') OR (per_asg_shd.g_old_rec.assignment_type = 'C')) then
6707: ---
6708: if g_debug then
6709: hr_utility.set_location('EMP/CWK type assignment checks ', 40);
6710: end if;

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

6710: end if;
6711: --
6712: per_assignments_f1_pkg.post_delete(
6713: p_rec.assignment_id, -- p_ass_id,
6714: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6715: p_effective_date, -- p_sess_date,
6716: p_new_end_date, -- from pre_del()
6717: p_validation_end_date, -- p_val_end_date,
6718: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,

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

6714: per_asg_shd.g_old_rec.grade_id, -- p_grd_id,
6715: p_effective_date, -- p_sess_date,
6716: p_new_end_date, -- from pre_del()
6717: p_validation_end_date, -- p_val_end_date,
6718: per_asg_shd.g_old_rec.effective_end_date, -- p_eff_end_date,
6719: p_datetrack_mode, -- p_del_mode,
6720: p_validation_start_date, -- p_val_st_date,
6721: p_new_primary_flag, -- from pre_del()
6722: hr_api.g_eot, -- p_eot,

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

6719: p_datetrack_mode, -- p_del_mode,
6720: p_validation_start_date, -- p_val_st_date,
6721: p_new_primary_flag, -- from pre_del()
6722: hr_api.g_eot, -- p_eot,
6723: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6724: l_new_prim_ass_id, -- l_new_prim_ass_id,
6725: l_prim_change_flag, -- l_prim_change_flag,
6726: l_sys_status_type, -- p_per_sys_st,
6727: per_asg_shd.g_old_rec.business_group_id, -- p_bg_id,

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

6723: per_asg_shd.g_old_rec.period_of_service_id, -- p_pd_os_id,
6724: l_new_prim_ass_id, -- l_new_prim_ass_id,
6725: l_prim_change_flag, -- l_prim_change_flag,
6726: l_sys_status_type, -- p_per_sys_st,
6727: per_asg_shd.g_old_rec.business_group_id, -- p_bg_id,
6728: p_s_pay_id, -- p_old_pay_id,
6729: per_asg_shd.g_old_rec.payroll_id, -- p_new_pay_id,
6730: p_cancel_atd, -- from pre_del()
6731: p_cancel_lspd, -- from pre_del()

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

6725: l_prim_change_flag, -- l_prim_change_flag,
6726: l_sys_status_type, -- p_per_sys_st,
6727: per_asg_shd.g_old_rec.business_group_id, -- p_bg_id,
6728: p_s_pay_id, -- p_old_pay_id,
6729: per_asg_shd.g_old_rec.payroll_id, -- p_new_pay_id,
6730: p_cancel_atd, -- from pre_del()
6731: p_cancel_lspd, -- from pre_del()
6732: p_reterm_atd, -- from pre_del()
6733: p_reterm_lspd, -- from pre_del()