DBA Data[Home] [Help]

APPS.HR_POSITION_API dependencies on HR_PSF_SHD

Line 1151: if ( nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>

1147: -- fnd_message.set_name('PQH','DATE-'||l_object_version_number);
1148: -- fnd_message.raise_error;
1149:
1150: -- changed it for bugfix 2997103
1151: if ( nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>
1152: nvl(p_date_end, hr_api.g_date)
1153: and p_date_end is not null) then
1154:
1155: create_eliminated_rec(

Line 1741: hr_psf_shd.lck

1737: l_ovn := p_object_version_number;
1738: --
1739: /*
1740: if p_datetrack_mode is not null then
1741: hr_psf_shd.lck
1742: (p_position_id => p_position_id
1743: ,p_datetrack_mode => l_lck_mode
1744: ,p_effective_Date => p_effective_Date - 1
1745: ,p_object_version_number => l_ovn

Line 3536: l_api_updating := hr_psf_shd.api_updating

3532: -- Validation in addition to Table Handlers
3533: --
3534: -- Retrieve current position details from position
3535: --
3536: l_api_updating := hr_psf_shd.api_updating
3537: (p_position_id => p_position_id
3538: ,p_effective_Date => p_effective_Date
3539: ,p_object_version_number => l_object_version_number);
3540: --

Line 3562: l_position_definition_id := hr_psf_shd.g_old_rec.position_definition_id;

3558: end if;
3559: --
3560: if l_null_ind = 0
3561: then
3562: l_position_definition_id := hr_psf_shd.g_old_rec.position_definition_id;
3563: end if;
3564: end if;
3565: --
3566: open csr_idsel;

Line 3696: -- hr_psf_shd.lck(p_position_id => p_position_id

3692: --
3693: -- Because we may need to maintain the valid grade dates, need to
3694: -- explicitly lock the hr_all_positions_f row.
3695: --
3696: -- hr_psf_shd.lck(p_position_id => p_position_id
3697: -- ,p_object_version_number => l_object_version_number);
3698: --
3699: if g_debug then
3700: hr_utility.set_location(l_proc, 85);

Line 3708: hr_psf_shd.g_old_rec.date_effective <>

3704: -- If date_effective is being updated , then need to maintain valid grades
3705: -- accordingly for that position.
3706: --
3707: IF ((nvl(p_date_effective, hr_api.g_date) <> hr_api.g_date) and
3708: hr_psf_shd.g_old_rec.date_effective <>
3709: nvl(p_date_effective, hr_api.g_date)) THEN
3710: --
3711:
3712: PER_POSITIONS_PKG.maintain_valid_grades

Line 3730: nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>

3726: -- If date_end is being updated , then need to maintain valid grades
3727: -- accordingly for that position.
3728: --
3729: IF ((nvl(p_date_end, hr_api.g_date) <> hr_api.g_date) and
3730: nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>
3731: nvl(p_date_end, hr_api.g_date)) THEN
3732: --
3733: pER_POSITIONS_PKG.maintain_valid_grades
3734: (p_validate => p_validate

Line 3895: hr_psf_shd.g_old_rec.position_definition_id <> l_position_definition_id

3891: -- position_definition_id has been updated.
3892: --
3893: if ( l_effective_end_date = hr_api.g_eot
3894: AND (
3895: hr_psf_shd.g_old_rec.position_definition_id <> l_position_definition_id
3896: or
3897: hr_psf_shd.g_old_rec.name <> l_name
3898: )
3899: ) then

Line 3897: hr_psf_shd.g_old_rec.name <> l_name

3893: if ( l_effective_end_date = hr_api.g_eot
3894: AND (
3895: hr_psf_shd.g_old_rec.position_definition_id <> l_position_definition_id
3896: or
3897: hr_psf_shd.g_old_rec.name <> l_name
3898: )
3899: ) then
3900: hr_pft_upd.upd_tl
3901: ( p_language_code => l_language_code

Line 4121: -- hr_psf_shd.lck(p_position_id => p_position_id

4117: --
4118: -- Because we may need to maintain the valid grade dates, need to
4119: -- explicitly lock the hr_all_positions_f row.
4120: --
4121: -- hr_psf_shd.lck(p_position_id => p_position_id
4122: -- ,p_object_version_number => l_object_version_number);
4123: --
4124: if g_debug then
4125: hr_utility.set_location(l_proc, 85);

Line 4132: hr_psf_shd.g_old_rec.date_effective <>

4128: -- If date_effective is being updated , then need to maintain valid grades
4129: -- accordingly for that position.
4130: --
4131: IF ((nvl(p_date_effective, hr_api.g_date) <> hr_api.g_date) and
4132: hr_psf_shd.g_old_rec.date_effective <>
4133: nvl(p_date_effective, hr_api.g_date)) THEN
4134: --
4135:
4136: maintain_valid_grades

Line 4154: nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>

4150: -- If date_end is being updated , then need to maintain valid grades
4151: -- accordingly for that position.
4152: --
4153: IF ((nvl(p_date_end, hr_api.g_date) <> hr_api.g_date) and
4154: nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>
4155: nvl(p_date_end, hr_api.g_date)) THEN
4156: --
4157: maintain_valid_grades
4158: (p_validate => p_validate

Line 4502: hr_psf_shd.lck

4498: l_proc := g_package||'lck';
4499: hr_utility.set_location('Entering:'|| l_proc, 10);
4500: end if;
4501: --
4502: hr_psf_shd.lck
4503: (
4504: p_position_id => p_position_id
4505: ,p_validation_start_date => l_validation_start_date
4506: ,p_validation_end_date => l_validation_end_date