DBA Data[Home] [Help]

APPS.BEN_PCG_BUS dependencies on HR_API

Line 52: and nvl(p_prtt_clm_gd_or_svc_typ_id,hr_api.g_number)

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: --

Line 130: and nvl(p_prtt_reimbmt_rqst_id,hr_api.g_number)

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

Line 131: <> nvl(ben_pcg_shd.g_old_rec.prtt_reimbmt_rqst_id,hr_api.g_number)

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: --

Line 211: and nvl(p_pl_gd_or_svc_id,hr_api.g_number)

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

Line 212: <> nvl(ben_pcg_shd.g_old_rec.pl_gd_or_svc_id,hr_api.g_number)

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: --

Line 289: and nvl(p_gd_or_svc_typ_id,hr_api.g_number)

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: --

Line 290: <> nvl(ben_pcg_shd.g_old_rec.gd_or_svc_typ_id,hr_api.g_number)

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

Line 331: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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);

Line 358: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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);

Line 415: hr_api.mandatory_arg_error(p_api_name => l_proc,

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;