47: (p_routing_list_member_id => p_routing_list_member_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_routing_list_member_id,hr_api.g_number)
52: <> pqh_rlm_shd.g_old_rec.routing_list_member_id) then
53: --
54: -- raise error as PK has changed
55: --
119: (p_routing_list_member_id => p_routing_list_member_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_routing_list_id,hr_api.g_number)
124: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if routing_list_id value exists in pqh_routing_lists table
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_routing_list_id,hr_api.g_number)
124: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if routing_list_id value exists in pqh_routing_lists table
128: --
204: p_object_version_number => p_object_version_number);
205: --
206: --
207: if (l_api_updating
208: and (nvl(p_role_id,hr_api.g_number)
209: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
210: or nvl(p_user_id,hr_api.g_number)
211: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
212: or not l_api_updating) and
205: --
206: --
207: if (l_api_updating
208: and (nvl(p_role_id,hr_api.g_number)
209: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
210: or nvl(p_user_id,hr_api.g_number)
211: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
212: or not l_api_updating) and
213: (p_role_id is not null) then
206: --
207: if (l_api_updating
208: and (nvl(p_role_id,hr_api.g_number)
209: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
210: or nvl(p_user_id,hr_api.g_number)
211: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
212: or not l_api_updating) and
213: (p_role_id is not null) then
214: --
207: if (l_api_updating
208: and (nvl(p_role_id,hr_api.g_number)
209: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
210: or nvl(p_user_id,hr_api.g_number)
211: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
212: or not l_api_updating) and
213: (p_role_id is not null) then
214: --
215: -- check if role_id value exists in pqh_roles table and user is assigned to role
311: (p_routing_list_member_id => p_routing_list_member_id,
312: p_object_version_number => p_object_version_number);
313: --
314: if (l_api_updating
315: and (nvl(p_routing_list_id,hr_api.g_number)
316: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
317: or nvl(p_role_id,hr_api.g_number)
318: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
319: or nvl(p_user_id,hr_api.g_number)
312: p_object_version_number => p_object_version_number);
313: --
314: if (l_api_updating
315: and (nvl(p_routing_list_id,hr_api.g_number)
316: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
317: or nvl(p_role_id,hr_api.g_number)
318: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
319: or nvl(p_user_id,hr_api.g_number)
320: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
313: --
314: if (l_api_updating
315: and (nvl(p_routing_list_id,hr_api.g_number)
316: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
317: or nvl(p_role_id,hr_api.g_number)
318: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
319: or nvl(p_user_id,hr_api.g_number)
320: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
321: or not l_api_updating) and
314: if (l_api_updating
315: and (nvl(p_routing_list_id,hr_api.g_number)
316: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
317: or nvl(p_role_id,hr_api.g_number)
318: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
319: or nvl(p_user_id,hr_api.g_number)
320: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
321: or not l_api_updating) and
322: (p_role_id is not null) then
315: and (nvl(p_routing_list_id,hr_api.g_number)
316: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
317: or nvl(p_role_id,hr_api.g_number)
318: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
319: or nvl(p_user_id,hr_api.g_number)
320: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
321: or not l_api_updating) and
322: (p_role_id is not null) then
323: --
316: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
317: or nvl(p_role_id,hr_api.g_number)
318: <> nvl(pqh_rlm_shd.g_old_rec.role_id,hr_api.g_number)
319: or nvl(p_user_id,hr_api.g_number)
320: <> nvl(pqh_rlm_shd.g_old_rec.user_id,hr_api.g_number) )
321: or not l_api_updating) and
322: (p_role_id is not null) then
323: --
324: -- check if transaction_category_id and template_id value exists in pqh_templates table
392: (p_routing_list_member_id => p_routing_list_member_id,
393: p_object_version_number => p_object_version_number);
394: --
395: if (l_api_updating
396: and (nvl(p_routing_list_id,hr_api.g_number)
397: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
398: or nvl(p_seq_no,hr_api.g_number)
399: <> nvl(pqh_rlm_shd.g_old_rec.seq_no,hr_api.g_number))
400: or not l_api_updating) and
393: p_object_version_number => p_object_version_number);
394: --
395: if (l_api_updating
396: and (nvl(p_routing_list_id,hr_api.g_number)
397: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
398: or nvl(p_seq_no,hr_api.g_number)
399: <> nvl(pqh_rlm_shd.g_old_rec.seq_no,hr_api.g_number))
400: or not l_api_updating) and
401: (p_seq_no is not null) then
394: --
395: if (l_api_updating
396: and (nvl(p_routing_list_id,hr_api.g_number)
397: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
398: or nvl(p_seq_no,hr_api.g_number)
399: <> nvl(pqh_rlm_shd.g_old_rec.seq_no,hr_api.g_number))
400: or not l_api_updating) and
401: (p_seq_no is not null) then
402: --
395: if (l_api_updating
396: and (nvl(p_routing_list_id,hr_api.g_number)
397: <> nvl(pqh_rlm_shd.g_old_rec.routing_list_id,hr_api.g_number)
398: or nvl(p_seq_no,hr_api.g_number)
399: <> nvl(pqh_rlm_shd.g_old_rec.seq_no,hr_api.g_number))
400: or not l_api_updating) and
401: (p_seq_no is not null) then
402: --
403: --
468: p_object_version_number => p_object_version_number);
469: --
470: if (l_api_updating
471: and p_approver_flag
472: <> nvl(pqh_rlm_shd.g_old_rec.approver_flag,hr_api.g_varchar2)
473: or not l_api_updating)
474: and p_approver_flag is not null then
475: --
476: -- check if value of lookup falls within lookup type.
474: and p_approver_flag is not null then
475: --
476: -- check if value of lookup falls within lookup type.
477: --
478: if hr_api.not_exists_in_hr_lookups
479: (p_lookup_type => 'YES_NO',
480: p_lookup_code => p_approver_flag,
481: p_effective_date => p_effective_date) then
482: --
560: p_object_version_number => p_object_version_number);
561: --
562: if (l_api_updating
563: and p_enable_flag
564: <> nvl(pqh_rlm_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
565: or not l_api_updating)
566: and p_enable_flag is not null then
567: --
568: -- check if value of lookup falls within lookup type.
566: and p_enable_flag is not null then
567: --
568: -- check if value of lookup falls within lookup type.
569: --
570: if hr_api.not_exists_in_hr_lookups
571: (p_lookup_type => 'YES_NO',
572: p_lookup_code => p_enable_flag,
573: p_effective_date => p_effective_date) then
574: --