APPS.BEN_BEC_BUS dependencies on HR_API

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

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

Line 128: and nvl(p_person_id,hr_api.g_number)

124: (p_batch_elctbl_id => p_batch_elctbl_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_person_id,hr_api.g_number)
129: <> nvl(ben_bec_shd.g_old_rec.person_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if person_id value exists in per_all_people_f table

Line 129: <> nvl(ben_bec_shd.g_old_rec.person_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_person_id,hr_api.g_number)
129: <> nvl(ben_bec_shd.g_old_rec.person_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if person_id value exists in per_all_people_f table
133: --

Line 208: and nvl(p_oipl_id,hr_api.g_number)

204: (p_batch_elctbl_id => p_batch_elctbl_id,
205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and nvl(p_oipl_id,hr_api.g_number)
209: <> nvl(ben_bec_shd.g_old_rec.oipl_id,hr_api.g_number)
210: or not l_api_updating) and
211: p_oipl_id is not null then
212: --

Line 209: <> nvl(ben_bec_shd.g_old_rec.oipl_id,hr_api.g_number)

205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and nvl(p_oipl_id,hr_api.g_number)
209: <> nvl(ben_bec_shd.g_old_rec.oipl_id,hr_api.g_number)
210: or not l_api_updating) and
211: p_oipl_id is not null then
212: --
213: -- check if oipl_id value exists in ben_oipl_f table

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

285: (p_batch_elctbl_id => p_batch_elctbl_id,
286: p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating
289: and nvl(p_pl_id,hr_api.g_number)
290: <> nvl(ben_bec_shd.g_old_rec.pl_id,hr_api.g_number)
291: or not l_api_updating) and
292: p_pl_id is not null then
293: --

Line 290: <> nvl(ben_bec_shd.g_old_rec.pl_id,hr_api.g_number)

286: p_object_version_number => p_object_version_number);
287: --
288: if (l_api_updating
289: and nvl(p_pl_id,hr_api.g_number)
290: <> nvl(ben_bec_shd.g_old_rec.pl_id,hr_api.g_number)
291: or not l_api_updating) and
292: p_pl_id is not null then
293: --
294: -- check if pl_id value exists in ben_pl_f table

Line 370: and nvl(p_pgm_id,hr_api.g_number)

366: (p_batch_elctbl_id => p_batch_elctbl_id,
367: p_object_version_number => p_object_version_number);
368: --
369: if (l_api_updating
370: and nvl(p_pgm_id,hr_api.g_number)
371: <> nvl(ben_bec_shd.g_old_rec.pgm_id,hr_api.g_number)
372: or not l_api_updating) and
373: p_pgm_id is not null then
374: --

Line 371: <> nvl(ben_bec_shd.g_old_rec.pgm_id,hr_api.g_number)

367: p_object_version_number => p_object_version_number);
368: --
369: if (l_api_updating
370: and nvl(p_pgm_id,hr_api.g_number)
371: <> nvl(ben_bec_shd.g_old_rec.pgm_id,hr_api.g_number)
372: or not l_api_updating) and
373: p_pgm_id is not null then
374: --
375: -- check if pgm_id value exists in ben_pgm_f table

Line 446: and nvl(p_benefit_action_id,hr_api.g_number)

442: (p_batch_elctbl_id => p_batch_elctbl_id,
443: p_object_version_number => p_object_version_number);
444: --
445: if (l_api_updating
446: and nvl(p_benefit_action_id,hr_api.g_number)
447: <> nvl(ben_bec_shd.g_old_rec.benefit_action_id,hr_api.g_number)
448: or not l_api_updating) then
449: --
450: -- check if benefit_action_id value exists in ben_benefit_actions table

Line 447: <> nvl(ben_bec_shd.g_old_rec.benefit_action_id,hr_api.g_number)

443: p_object_version_number => p_object_version_number);
444: --
445: if (l_api_updating
446: and nvl(p_benefit_action_id,hr_api.g_number)
447: <> nvl(ben_bec_shd.g_old_rec.benefit_action_id,hr_api.g_number)
448: or not l_api_updating) then
449: --
450: -- check if benefit_action_id value exists in ben_benefit_actions table
451: --

Line 518: <> nvl(ben_bec_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

514: p_object_version_number => p_object_version_number);
515: --
516: if (l_api_updating
517: and p_dflt_flag
518: <> nvl(ben_bec_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
519: or not l_api_updating) then
520: --
521: -- check if value of lookup falls within lookup type.
522: --

Line 524: if hr_api.not_exists_in_hr_lookups

520: --
521: -- check if value of lookup falls within lookup type.
522: --
523: --
524: if hr_api.not_exists_in_hr_lookups
525: (p_lookup_type => 'YES_NO',
526: p_lookup_code => p_dflt_flag,
527: p_effective_date => p_effective_date) then
528: --

Line 588: <> nvl(ben_bec_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)

584: p_object_version_number => p_object_version_number);
585: --
586: if (l_api_updating
587: and p_mndtry_flag
588: <> nvl(ben_bec_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)
589: or not l_api_updating) then
590: --
591: -- check if value of lookup falls within lookup type.
592: --

Line 594: if hr_api.not_exists_in_hr_lookups

590: --
591: -- check if value of lookup falls within lookup type.
592: --
593: --
594: if hr_api.not_exists_in_hr_lookups
595: (p_lookup_type => 'YES_NO',
596: p_lookup_code => p_mndtry_flag,
597: p_effective_date => p_effective_date) then
598: --

Line 658: <> nvl(ben_bec_shd.g_old_rec.comp_lvl_cd,hr_api.g_varchar2)

654: p_object_version_number => p_object_version_number);
655: --
656: if (l_api_updating
657: and p_comp_lvl_cd
658: <> nvl(ben_bec_shd.g_old_rec.comp_lvl_cd,hr_api.g_varchar2)
659: or not l_api_updating)
660: and p_comp_lvl_cd is not null then
661: --
662: -- check if value of lookup falls within lookup type.

Line 664: if hr_api.not_exists_in_hr_lookups

660: and p_comp_lvl_cd is not null then
661: --
662: -- check if value of lookup falls within lookup type.
663: --
664: if hr_api.not_exists_in_hr_lookups
665: (p_lookup_type => 'BEN_COMP_LVL',
666: p_lookup_code => p_comp_lvl_cd,
667: p_effective_date => p_effective_date) then
668: --

Line 728: <> nvl(ben_bec_shd.g_old_rec.enrt_typ_cycl_cd,hr_api.g_varchar2)

724: p_object_version_number => p_object_version_number);
725: --
726: if (l_api_updating
727: and p_enrt_typ_cycl_cd
728: <> nvl(ben_bec_shd.g_old_rec.enrt_typ_cycl_cd,hr_api.g_varchar2)
729: or not l_api_updating)
730: and p_enrt_typ_cycl_cd is not null then
731: --
732: -- check if value of lookup falls within lookup type.

Line 734: if hr_api.not_exists_in_hr_lookups

730: and p_enrt_typ_cycl_cd is not null then
731: --
732: -- check if value of lookup falls within lookup type.
733: --
734: if hr_api.not_exists_in_hr_lookups
735: (p_lookup_type => 'BEN_ENRT_TYP_CYCL',
736: p_lookup_code => p_enrt_typ_cycl_cd,
737: p_effective_date => p_effective_date) then
738: --

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

764: --
765: -- Call all supporting business operations
766: --
767: --
768: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
769: --
770: chk_batch_elctbl_id
771: (p_batch_elctbl_id => p_rec.batch_elctbl_id,
772: p_object_version_number => p_rec.object_version_number);

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

840: --
841: -- Call all supporting business operations
842: --
843: --
844: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
845: --
846: chk_batch_elctbl_id
847: (p_batch_elctbl_id => p_rec.batch_elctbl_id,
848: p_object_version_number => p_rec.object_version_number);

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

946: hr_utility.set_location('Entering:'|| l_proc, 10);
947: --
948: -- Ensure that all the mandatory parameter are not null
949: --
950: hr_api.mandatory_arg_error(p_api_name => l_proc,
951: p_argument => 'batch_elctbl_id',
952: p_argument_value => p_batch_elctbl_id);
953: --
954: open csr_leg_code;