APPS.PQH_PLG_BUS dependencies on HR_API

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

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

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

119: (p_process_log_id => p_process_log_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_txn_table_route_id,hr_api.g_number)
124: <> nvl(pqh_plg_shd.g_old_rec.txn_table_route_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_txn_table_route_id is not null then
127: --

Line 124: <> nvl(pqh_plg_shd.g_old_rec.txn_table_route_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_txn_table_route_id,hr_api.g_number)
124: <> nvl(pqh_plg_shd.g_old_rec.txn_table_route_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_txn_table_route_id is not null then
127: --
128: -- check if txn_table_route_id value exists in pqh_table_route table

Line 199: and nvl(p_master_process_log_id,hr_api.g_number)

195: (p_process_log_id => p_process_log_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_master_process_log_id,hr_api.g_number)
200: <> nvl(pqh_plg_shd.g_old_rec.master_process_log_id,hr_api.g_number)
201: or not l_api_updating) and
202: p_master_process_log_id is not null then
203: --

Line 200: <> nvl(pqh_plg_shd.g_old_rec.master_process_log_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_master_process_log_id,hr_api.g_number)
200: <> nvl(pqh_plg_shd.g_old_rec.master_process_log_id,hr_api.g_number)
201: or not l_api_updating) and
202: p_master_process_log_id is not null then
203: --
204: -- check if master_process_log_id value exists in pqh_process_log table

Line 272: <> nvl(pqh_plg_shd.g_old_rec.message_type_cd,hr_api.g_varchar2)

268: p_object_version_number => p_object_version_number);
269: --
270: if (l_api_updating
271: and p_message_type_cd
272: <> nvl(pqh_plg_shd.g_old_rec.message_type_cd,hr_api.g_varchar2)
273: or not l_api_updating) then
274: --
275: -- check if value of lookup falls within lookup type.
276: --

Line 278: if hr_api.not_exists_in_hr_lookups

274: --
275: -- check if value of lookup falls within lookup type.
276: --
277: --
278: if hr_api.not_exists_in_hr_lookups
279: (p_lookup_type => 'PQH_MESSAGE_TYPE',
280: p_lookup_code => p_message_type_cd,
281: p_effective_date => p_effective_date) then
282: --