48: (p_prtt_clm_gd_or_svc_typ_id => p_prtt_clm_gd_or_svc_typ_id,
49: p_object_version_number => p_object_version_number);
50: --
51: if (l_api_updating
52: and nvl(p_prtt_clm_gd_or_svc_typ_id,hr_api.g_number)
53: <> ben_pcg_shd.g_old_rec.prtt_clm_gd_or_svc_typ_id) then
54: --
55: -- raise error as PK has changed
56: --
126: (p_prtt_clm_gd_or_svc_typ_id => p_prtt_clm_gd_or_svc_typ_id,
127: p_object_version_number => p_object_version_number);
128: --
129: if (l_api_updating
130: and nvl(p_prtt_reimbmt_rqst_id,hr_api.g_number)
131: <> nvl(ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id,hr_api.g_number)
132: or not l_api_updating) then
133: --
134: -- check if prtt_reimbmt_rqst_id value exists in ben_prtt_reimbmt_rqst_f table
127: p_object_version_number => p_object_version_number);
128: --
129: if (l_api_updating
130: and nvl(p_prtt_reimbmt_rqst_id,hr_api.g_number)
131: <> nvl(ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id,hr_api.g_number)
132: or not l_api_updating) then
133: --
134: -- check if prtt_reimbmt_rqst_id value exists in ben_prtt_reimbmt_rqst_f table
135: --
207: (p_prtt_clm_gd_or_svc_typ_id => p_prtt_clm_gd_or_svc_typ_id,
208: p_object_version_number => p_object_version_number);
209: --
210: if (l_api_updating
211: and nvl(p_pl_gd_or_svc_id,hr_api.g_number)
212: <> nvl(ben_pcg_shd.g_old_rec.pl_gd_or_svc_id,hr_api.g_number)
213: or not l_api_updating) then
214: --
215: -- check if prtt_reimbmt_rqst_id value exists in ben_prtt_reimbmt_rqst_f table
208: p_object_version_number => p_object_version_number);
209: --
210: if (l_api_updating
211: and nvl(p_pl_gd_or_svc_id,hr_api.g_number)
212: <> nvl(ben_pcg_shd.g_old_rec.pl_gd_or_svc_id,hr_api.g_number)
213: or not l_api_updating) then
214: --
215: -- check if prtt_reimbmt_rqst_id value exists in ben_prtt_reimbmt_rqst_f table
216: --
285: (p_prtt_clm_gd_or_svc_typ_id => p_prtt_clm_gd_or_svc_typ_id,
286: p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating
289: and nvl(p_gd_or_svc_typ_id,hr_api.g_number)
290: <> nvl(ben_pcg_shd.g_old_rec.gd_or_svc_typ_id,hr_api.g_number)
291: or not l_api_updating) and
292: p_gd_or_svc_typ_id is not null then
293: --
286: p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating
289: and nvl(p_gd_or_svc_typ_id,hr_api.g_number)
290: <> nvl(ben_pcg_shd.g_old_rec.gd_or_svc_typ_id,hr_api.g_number)
291: or not l_api_updating) and
292: p_gd_or_svc_typ_id is not null then
293: --
294: -- check if gd_or_svc_typ_id value exists in ben_gd_or_svc_typ table
327: --
328: -- Call all supporting business operations
329: --
330: --
331: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
332: --
333: chk_prtt_clm_gd_or_svc_typ_id
334: (p_prtt_clm_gd_or_svc_typ_id => p_rec.prtt_clm_gd_or_svc_typ_id,
335: p_object_version_number => p_rec.object_version_number);
354: --
355: -- Call all supporting business operations
356: --
357: --
358: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
359: --
360: chk_prtt_clm_gd_or_svc_typ_id
361: (p_prtt_clm_gd_or_svc_typ_id => p_rec.prtt_clm_gd_or_svc_typ_id,
362: p_object_version_number => p_rec.object_version_number);
411: hr_utility.set_location('Entering:'|| l_proc, 10);
412: --
413: -- Ensure that all the mandatory parameter are not null
414: --
415: hr_api.mandatory_arg_error(p_api_name => l_proc,
416: p_argument => 'prtt_clm_gd_or_svc_typ_id',
417: p_argument_value => p_prtt_clm_gd_or_svc_typ_id);
418: --
419: open csr_leg_code;