DBA Data[Home] [Help]

APPS.BEN_ECC_BUS dependencies on HR_API

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

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

Line 124: and nvl(p_enrt_bnft_id,hr_api.g_number)

120: (p_enrt_bnft_id => p_enrt_bnft_id,
121: p_object_version_number => null);
122: --
123: if (l_api_updating
124: and nvl(p_enrt_bnft_id,hr_api.g_number)
125: <> nvl(ben_ecc_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)
126: or not l_api_updating) and
127: p_enrt_bnft_id is not null then
128: --

Line 125: <> nvl(ben_ecc_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)

121: p_object_version_number => null);
122: --
123: if (l_api_updating
124: and nvl(p_enrt_bnft_id,hr_api.g_number)
125: <> nvl(ben_ecc_shd.g_old_rec.enrt_bnft_id,hr_api.g_number)
126: or not l_api_updating) and
127: p_enrt_bnft_id is not null then
128: --
129: -- check if enrt_bnft_id value exists in ben_enrt_bnft table

Line 197: <> nvl(ben_ecc_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and p_rqd_flag
197: <> nvl(ben_ecc_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
198: or not l_api_updating) then
199: --
200: -- check if value of lookup falls within lookup type.
201: --

Line 203: if hr_api.not_exists_in_hr_lookups

199: --
200: -- check if value of lookup falls within lookup type.
201: --
202: --
203: if hr_api.not_exists_in_hr_lookups
204: (p_lookup_type => 'YES_NO',
205: p_lookup_code => p_rqd_flag,
206: p_effective_date => p_effective_date) then
207: --

Line 265: <> nvl(ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)

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

Line 271: if hr_api.not_exists_in_hr_lookups

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

Line 307: <> nvl(ben_ecc_shd.g_old_rec.ctfn_determine_cd,hr_api.g_varchar2)

303: p_object_version_number => p_object_version_number);
304: --
305: if (l_api_updating
306: and p_ctfn_determine_cd
307: <> nvl(ben_ecc_shd.g_old_rec.ctfn_determine_cd,hr_api.g_varchar2)
308: or not l_api_updating) then
309: --
310: -- check if value of lookup falls within lookup type.
311: --

Line 313: if hr_api.not_exists_in_hr_lookups

309: --
310: -- check if value of lookup falls within lookup type.
311: --
312: --
313: if hr_api.not_exists_in_hr_lookups
314: (p_lookup_type => 'BEN_DET_CTFN',
315: p_lookup_code => p_ctfn_determine_cd,
316: p_effective_date => p_effective_date) then
317: --

Line 350: <> nvl(ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag,hr_api.g_varchar2)

346: p_object_version_number => p_object_version_number);
347: --
348: if (l_api_updating
349: and p_susp_if_ctfn_not_prvd_flag
350: <> nvl(ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag,hr_api.g_varchar2)
351: or not l_api_updating) then
352: --
353: -- check if value of lookup falls within lookup type.
354: --

Line 356: if hr_api.not_exists_in_hr_lookups

352: --
353: -- check if value of lookup falls within lookup type.
354: --
355: --
356: if hr_api.not_exists_in_hr_lookups
357: (p_lookup_type => 'YES_NO',
358: p_lookup_code => p_susp_if_ctfn_not_prvd_flag ,
359: p_effective_date => p_effective_date) then
360: --

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

384: --
385: -- Call all supporting business operations
386: --
387: --
388: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
389: --
390: chk_elctbl_chc_ctfn_id
391: (p_elctbl_chc_ctfn_id => p_rec.elctbl_chc_ctfn_id,
392: p_object_version_number => p_rec.object_version_number);

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

436: --
437: -- Call all supporting business operations
438: --
439: --
440: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
441: --
442: chk_elctbl_chc_ctfn_id
443: (p_elctbl_chc_ctfn_id => p_rec.elctbl_chc_ctfn_id,
444: p_object_version_number => p_rec.object_version_number);

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

520: hr_utility.set_location('Entering:'|| l_proc, 10);
521: --
522: -- Ensure that all the mandatory parameter are not null
523: --
524: hr_api.mandatory_arg_error(p_api_name => l_proc,
525: p_argument => 'elctbl_chc_ctfn_id',
526: p_argument_value => p_elctbl_chc_ctfn_id);
527: --
528: open csr_leg_code;