DBA Data[Home] [Help]

APPS.BEN_ENB_BUS dependencies on HR_API

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

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

Line 120: <> nvl(ben_enb_shd.g_old_rec.bndry_perd_cd,hr_api.g_varchar2)

116: p_object_version_number => p_object_version_number);
117: --
118: if (l_api_updating
119: and p_bndry_perd_cd
120: <> nvl(ben_enb_shd.g_old_rec.bndry_perd_cd,hr_api.g_varchar2)
121: or not l_api_updating)
122: and p_bndry_perd_cd is not null then
123: --
124: -- check if value of lookup falls within lookup type.

Line 126: if hr_api.not_exists_in_hr_lookups

122: and p_bndry_perd_cd is not null then
123: --
124: -- check if value of lookup falls within lookup type.
125: --
126: if hr_api.not_exists_in_hr_lookups
127: (p_lookup_type => 'BEN_BNDRY_PERD',
128: p_lookup_code => p_bndry_perd_cd,
129: p_effective_date => p_effective_date) then
130: --

Line 190: <> nvl(ben_enb_shd.g_old_rec.cvg_mlt_cd,hr_api.g_varchar2)

186: p_object_version_number => p_object_version_number);
187: --
188: if (l_api_updating
189: and p_cvg_mlt_cd
190: <> nvl(ben_enb_shd.g_old_rec.cvg_mlt_cd,hr_api.g_varchar2)
191: or not l_api_updating)
192: and p_cvg_mlt_cd is not null then
193: --
194: -- check if value of lookup falls within lookup type.

Line 196: if hr_api.not_exists_in_hr_lookups

192: and p_cvg_mlt_cd is not null then
193: --
194: -- check if value of lookup falls within lookup type.
195: --
196: if hr_api.not_exists_in_hr_lookups
197: (p_lookup_type => 'BEN_CVG_MLT',
198: p_lookup_code => p_cvg_mlt_cd,
199: p_effective_date => p_effective_date) then
200: --

Line 260: <> nvl(ben_enb_shd.g_old_rec.crntly_enrld_flag,hr_api.g_varchar2)

256: p_object_version_number => p_object_version_number);
257: --
258: if (l_api_updating
259: and p_crntly_enrld_flag
260: <> nvl(ben_enb_shd.g_old_rec.crntly_enrld_flag,hr_api.g_varchar2)
261: or not l_api_updating) then
262: --
263: -- check if value of lookup falls within lookup type.
264: --

Line 266: if hr_api.not_exists_in_hr_lookups

262: --
263: -- check if value of lookup falls within lookup type.
264: --
265: --
266: if hr_api.not_exists_in_hr_lookups
267: (p_lookup_type => 'YES_NO',
268: p_lookup_code => p_crntly_enrld_flag,
269: p_effective_date => p_effective_date) then
270: --

Line 329: <> nvl(ben_enb_shd.g_old_rec.val_has_bn_prortd_flag,hr_api.g_varchar2)

325: p_object_version_number => p_object_version_number);
326: --
327: if (l_api_updating
328: and p_val_has_bn_prortd_flag
329: <> nvl(ben_enb_shd.g_old_rec.val_has_bn_prortd_flag,hr_api.g_varchar2)
330: or not l_api_updating) then
331: --
332: -- check if value of lookup falls within lookup type.
333: --

Line 335: if hr_api.not_exists_in_hr_lookups

331: --
332: -- check if value of lookup falls within lookup type.
333: --
334: --
335: if hr_api.not_exists_in_hr_lookups
336: (p_lookup_type => 'YES_NO',
337: p_lookup_code => p_val_has_bn_prortd_flag,
338: p_effective_date => p_effective_date) then
339: --

Line 399: <> nvl(ben_enb_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

395: p_object_version_number => p_object_version_number);
396: --
397: if (l_api_updating
398: and p_dflt_flag
399: <> nvl(ben_enb_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
400: or not l_api_updating) then
401: --
402: -- check if value of lookup falls within lookup type.
403: --

Line 405: if hr_api.not_exists_in_hr_lookups

401: --
402: -- check if value of lookup falls within lookup type.
403: --
404: --
405: if hr_api.not_exists_in_hr_lookups
406: (p_lookup_type => 'YES_NO',
407: p_lookup_code => p_dflt_flag,
408: p_effective_date => p_effective_date) then
409: --

Line 469: <> nvl(ben_enb_shd.g_old_rec.bnft_typ_cd,hr_api.g_varchar2)

465: p_object_version_number => p_object_version_number);
466: --
467: if (l_api_updating
468: and p_bnft_typ_cd
469: <> nvl(ben_enb_shd.g_old_rec.bnft_typ_cd,hr_api.g_varchar2)
470: or not l_api_updating)
471: and p_bnft_typ_cd is not null then
472: --
473: -- check if value of lookup falls within lookup type.

Line 475: if hr_api.not_exists_in_hr_lookups

471: and p_bnft_typ_cd is not null then
472: --
473: -- check if value of lookup falls within lookup type.
474: --
475: if hr_api.not_exists_in_hr_lookups
476: (p_lookup_type => 'BEN_BNFT_TYP',
477: p_lookup_code => p_bnft_typ_cd,
478: p_effective_date => p_effective_date) then
479: --

Line 539: <> nvl(ben_enb_shd.g_old_rec.nnmntry_uom,hr_api.g_varchar2)

535: p_object_version_number => p_object_version_number);
536: --
537: if (l_api_updating
538: and p_nnmntry_uom
539: <> nvl(ben_enb_shd.g_old_rec.nnmntry_uom,hr_api.g_varchar2)
540: or not l_api_updating)
541: and p_nnmntry_uom is not null then
542: --
543: -- check if value of lookup falls within lookup type.

Line 545: if hr_api.not_exists_in_hr_lookups

541: and p_nnmntry_uom is not null then
542: --
543: -- check if value of lookup falls within lookup type.
544: --
545: if hr_api.not_exists_in_hr_lookups
546: (p_lookup_type => 'BEN_NNMNTRY_UOM',
547: p_lookup_code => p_nnmntry_uom,
548: p_effective_date => p_effective_date) then
549: --

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

575: --
576: -- Call all supporting business operations
577: --
578: --
579: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
580: --
581: chk_enrt_bnft_id
582: (p_enrt_bnft_id => p_rec.enrt_bnft_id,
583: p_object_version_number => p_rec.object_version_number);

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

640: --
641: -- Call all supporting business operations
642: --
643: --
644: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
645: --
646: chk_enrt_bnft_id
647: (p_enrt_bnft_id => p_rec.enrt_bnft_id,
648: p_object_version_number => p_rec.object_version_number);

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

735: hr_utility.set_location('Entering:'|| l_proc, 10);
736: --
737: -- Ensure that all the mandatory parameter are not null
738: --
739: hr_api.mandatory_arg_error(p_api_name => l_proc,
740: p_argument => 'enrt_bnft_id',
741: p_argument_value => p_enrt_bnft_id);
742: --
743: open csr_leg_code;