APPS.PQH_FYN_BUS dependencies on HR_API

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

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

Line 123: and nvl(p_transaction_category_id,hr_api.g_number)

119: (p_fyi_notified_id => p_fyi_notified_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_transaction_category_id,hr_api.g_number)
124: <> nvl(pqh_fyn_shd.g_old_rec.transaction_category_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if transaction_category_id value exists in pqh_transaction_categories table

Line 124: <> nvl(pqh_fyn_shd.g_old_rec.transaction_category_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_transaction_category_id,hr_api.g_number)
124: <> nvl(pqh_fyn_shd.g_old_rec.transaction_category_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if transaction_category_id value exists in pqh_transaction_categories table
128: --

Line 195: <> nvl(pqh_fyn_shd.g_old_rec.notified_type_cd,hr_api.g_varchar2)

191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_notified_type_cd
195: <> nvl(pqh_fyn_shd.g_old_rec.notified_type_cd,hr_api.g_varchar2)
196: or not l_api_updating) then
197: --
198: -- check if value of lookup falls within lookup type.
199: --

Line 202: if hr_api.not_exists_in_hr_lookups

198: -- check if value of lookup falls within lookup type.
199: --
200: hr_utility.set_location('Type Cd: '||p_notified_type_cd, 10);
201: --
202: if hr_api.not_exists_in_hr_lookups
203: (p_lookup_type => 'PQH_NOTIFIED_TYPE_CD',
204: p_lookup_code => p_notified_type_cd,
205: p_effective_date => p_effective_date) then
206: --

Line 264: <> nvl(pqh_fyn_shd.g_old_rec.notification_event_cd,hr_api.g_varchar2)

260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating
263: and p_notification_event_cd
264: <> nvl(pqh_fyn_shd.g_old_rec.notification_event_cd,hr_api.g_varchar2)
265: or not l_api_updating) then
266: --
267: -- check if value of lookup falls within lookup type.
268: --

Line 270: if hr_api.not_exists_in_hr_lookups

266: --
267: -- check if value of lookup falls within lookup type.
268: --
269: --
270: if hr_api.not_exists_in_hr_lookups
271: (p_lookup_type => 'PQH_NOTIFICATION_EVENT_CD',
272: p_lookup_code => p_notification_event_cd,
273: p_effective_date => p_effective_date) then
274: --