DBA Data[Home] [Help]

APPS.HR_MASS_MOVE_API dependencies on PER_ASG_SHD

Line 241: l_api_updating := per_asg_shd.api_updating

237: l_object_version_number := p_object_version_number;
238: --
239: -- Retrieve current Assignment details
240: --
241: l_api_updating := per_asg_shd.api_updating
242: (p_assignment_id => p_assignment_id
243: ,p_effective_date => p_effective_date
244: ,p_object_version_number => l_object_version_number);
245: --

Line 252: and nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>

248: -- Validate that at least one of P_POSITION_ID, P_ORGANIZATION_ID,P_GRADE or
249: -- P_LOCATION_ID is being updated.
250: --
251: if ( ( (nvl(p_organization_id, hr_api.g_number) <> hr_api.g_number )
252: and nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
253: nvl(p_organization_id, hr_api.g_number) )
254: or ( (nvl(p_position_id, hr_api.g_number) <> hr_api.g_number )
255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_id,hr_api.g_number) )
256: or ( (nvl(p_grade_id, hr_api.g_number) <> hr_api.g_number )

Line 255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_id,hr_api.g_number) )

251: if ( ( (nvl(p_organization_id, hr_api.g_number) <> hr_api.g_number )
252: and nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
253: nvl(p_organization_id, hr_api.g_number) )
254: or ( (nvl(p_position_id, hr_api.g_number) <> hr_api.g_number )
255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_id,hr_api.g_number) )
256: or ( (nvl(p_grade_id, hr_api.g_number) <> hr_api.g_number )
257: and nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
258: nvl(p_grade_id,hr_api.g_number) )
259: or ( ( nvl(p_location_id, hr_api.g_number) <> hr_api.g_number )

Line 257: and nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>

253: nvl(p_organization_id, hr_api.g_number) )
254: or ( (nvl(p_position_id, hr_api.g_number) <> hr_api.g_number )
255: and nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <> nvl(p_position_id,hr_api.g_number) )
256: or ( (nvl(p_grade_id, hr_api.g_number) <> hr_api.g_number )
257: and nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
258: nvl(p_grade_id,hr_api.g_number) )
259: or ( ( nvl(p_location_id, hr_api.g_number) <> hr_api.g_number )
260: and nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
261: nvl(p_location_id, hr_api.g_number) ) ) then

Line 260: and nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>

256: or ( (nvl(p_grade_id, hr_api.g_number) <> hr_api.g_number )
257: and nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
258: nvl(p_grade_id,hr_api.g_number) )
259: or ( ( nvl(p_location_id, hr_api.g_number) <> hr_api.g_number )
260: and nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
261: nvl(p_location_id, hr_api.g_number) ) ) then
262: null;
263: else
264: hr_utility.set_message(801, 'HR_51104_MMV_MUST_UPD_ASG');

Line 364: if per_asg_shd.g_old_rec.soft_coding_keyflex_id is not null then

360: hr_utility.set_location( l_proc, 50 );
361: --
362: -- If the assignment currently has SCL information :
363: --
364: if per_asg_shd.g_old_rec.soft_coding_keyflex_id is not null then
365: hr_utility.set_location( l_proc, 55 );
366: --
367: l_scl_api_updating := hr_scl_shd.api_updating
368: (p_soft_coding_keyflex_id =>

Line 369: per_asg_shd.g_old_rec.soft_coding_keyflex_id);

365: hr_utility.set_location( l_proc, 55 );
366: --
367: l_scl_api_updating := hr_scl_shd.api_updating
368: (p_soft_coding_keyflex_id =>
369: per_asg_shd.g_old_rec.soft_coding_keyflex_id);
370: --
371: -- Check whether any of the SCL segments are being updated.
372: --
373: if ( ( (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2)

Line 476: elsif per_asg_shd.g_old_rec.soft_coding_keyflex_id is null then

472: --
473: l_scl_updated_flag := FALSE;
474: --
475: end if;
476: elsif per_asg_shd.g_old_rec.soft_coding_keyflex_id is null then
477: --
478: -- Otherwise, if the assignment does not currently have SCL information
479: -- check whether any of the SCL segments are being set for the first time
480: --

Line 529: and nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>

525: end if;
526: --
527: if ( l_scl_updated_flag
528: or ((nvl(p_frequency, hr_api.g_varchar2) <> hr_api.g_varchar2)
529: and nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
530: nvl(p_frequency, hr_api.g_varchar2) )
531: or ((nvl(p_normal_hours, hr_api.g_number) <> hr_api.g_number)
532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
533: nvl(p_normal_hours, hr_api.g_number) )

Line 532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>

528: or ((nvl(p_frequency, hr_api.g_varchar2) <> hr_api.g_varchar2)
529: and nvl(per_asg_shd.g_old_rec.frequency, hr_api.g_varchar2) <>
530: nvl(p_frequency, hr_api.g_varchar2) )
531: or ((nvl(p_normal_hours, hr_api.g_number) <> hr_api.g_number)
532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
533: nvl(p_normal_hours, hr_api.g_number) )
534: or ((nvl(p_time_normal_finish, hr_api.g_varchar2) <> hr_api.g_varchar2)
535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
536: nvl(p_time_normal_finish,hr_api.g_varchar2) )

Line 535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>

531: or ((nvl(p_normal_hours, hr_api.g_number) <> hr_api.g_number)
532: and nvl(per_asg_shd.g_old_rec.normal_hours, hr_api.g_number) <>
533: nvl(p_normal_hours, hr_api.g_number) )
534: or ((nvl(p_time_normal_finish, hr_api.g_varchar2) <> hr_api.g_varchar2)
535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
536: nvl(p_time_normal_finish,hr_api.g_varchar2) )
537: or ((nvl(p_time_normal_start, hr_api.g_varchar2) <> hr_api.g_varchar2)
538: and nvl(per_asg_shd.g_old_rec.time_normal_start, hr_api.g_varchar2) <>
539: nvl(p_time_normal_start, hr_api.g_varchar2) )

Line 538: and nvl(per_asg_shd.g_old_rec.time_normal_start, hr_api.g_varchar2) <>

534: or ((nvl(p_time_normal_finish, hr_api.g_varchar2) <> hr_api.g_varchar2)
535: and nvl(per_asg_shd.g_old_rec.time_normal_finish,hr_api.g_varchar2) <>
536: nvl(p_time_normal_finish,hr_api.g_varchar2) )
537: or ((nvl(p_time_normal_start, hr_api.g_varchar2) <> hr_api.g_varchar2)
538: and nvl(per_asg_shd.g_old_rec.time_normal_start, hr_api.g_varchar2) <>
539: nvl(p_time_normal_start, hr_api.g_varchar2) )
540: ) then
541: --
542: hr_utility.set_location( l_proc, 85 );