DBA Data[Home] [Help]

APPS.PQH_PTI_BUS dependencies on HR_API

Line 51: and nvl(p_information_type,hr_api.g_number)

47: (p_information_type => p_information_type,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_information_type,hr_api.g_number)
52: <> pqh_pti_shd.g_old_rec.information_type) then
53: --
54: -- raise error as PK has changed
55: --

Line 120: <> nvl(pqh_pti_shd.g_old_rec.multiple_occurences_flag,hr_api.g_varchar2)

116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating
119: and p_multiple_occurences_flag
120: <> nvl(pqh_pti_shd.g_old_rec.multiple_occurences_flag,hr_api.g_varchar2)
121: or not l_api_updating) then
122: --
123: -- check if value of lookup falls within lookup type.
124: --

Line 126: if hr_api.not_exists_in_hr_lookups

122: --
123: -- check if value of lookup falls within lookup type.
124: --
125: --
126: if hr_api.not_exists_in_hr_lookups
127: (p_lookup_type => 'ENTER-LKP-TYPE',
128: p_lookup_code => p_multiple_occurences_flag,
129: p_effective_date => p_effective_date) then
130: --

Line 188: <> nvl(pqh_pti_shd.g_old_rec.active_inactive_flag,hr_api.g_varchar2)

184: p_object_version_number => p_object_version_number);
185: --
186: if (l_api_updating
187: and p_active_inactive_flag
188: <> nvl(pqh_pti_shd.g_old_rec.active_inactive_flag,hr_api.g_varchar2)
189: or not l_api_updating) then
190: --
191: -- check if value of lookup falls within lookup type.
192: --

Line 194: if hr_api.not_exists_in_hr_lookups

190: --
191: -- check if value of lookup falls within lookup type.
192: --
193: --
194: if hr_api.not_exists_in_hr_lookups
195: (p_lookup_type => 'ENTER-LKP-TYPE',
196: p_lookup_code => p_active_inactive_flag,
197: p_effective_date => p_effective_date) then
198: --