APPS.BEN_BRI_BUS dependencies on HR_API

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

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

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

124: (p_batch_rt_id => p_batch_rt_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_oipl_id,hr_api.g_number)
129: <> nvl(ben_bri_shd.g_old_rec.oipl_id,hr_api.g_number)
130: or not l_api_updating) and
131: p_oipl_id is not null then
132: --

Line 129: <> nvl(ben_bri_shd.g_old_rec.oipl_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_oipl_id,hr_api.g_number)
129: <> nvl(ben_bri_shd.g_old_rec.oipl_id,hr_api.g_number)
130: or not l_api_updating) and
131: p_oipl_id is not null then
132: --
133: -- check if oipl_id value exists in ben_oipl_f table

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

205: (p_batch_rt_id => p_batch_rt_id,
206: p_object_version_number => p_object_version_number);
207: --
208: if (l_api_updating
209: and nvl(p_pl_id,hr_api.g_number)
210: <> nvl(ben_bri_shd.g_old_rec.pl_id,hr_api.g_number)
211: or not l_api_updating) and
212: p_pl_id is not null then
213: --

Line 210: <> nvl(ben_bri_shd.g_old_rec.pl_id,hr_api.g_number)

206: p_object_version_number => p_object_version_number);
207: --
208: if (l_api_updating
209: and nvl(p_pl_id,hr_api.g_number)
210: <> nvl(ben_bri_shd.g_old_rec.pl_id,hr_api.g_number)
211: or not l_api_updating) and
212: p_pl_id is not null then
213: --
214: -- check if pl_id value exists in ben_pl_f table

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

286: (p_batch_rt_id => p_batch_rt_id,
287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and nvl(p_pgm_id,hr_api.g_number)
291: <> nvl(ben_bri_shd.g_old_rec.pgm_id,hr_api.g_number)
292: or not l_api_updating) and
293: p_pgm_id is not null then
294: --

Line 291: <> nvl(ben_bri_shd.g_old_rec.pgm_id,hr_api.g_number)

287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and nvl(p_pgm_id,hr_api.g_number)
291: <> nvl(ben_bri_shd.g_old_rec.pgm_id,hr_api.g_number)
292: or not l_api_updating) and
293: p_pgm_id is not null then
294: --
295: -- check if pgm_id value exists in ben_pgm_f table

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

367: (p_batch_rt_id => p_batch_rt_id,
368: p_object_version_number => p_object_version_number);
369: --
370: if (l_api_updating
371: and nvl(p_person_id,hr_api.g_number)
372: <> nvl(ben_bri_shd.g_old_rec.person_id,hr_api.g_number)
373: or not l_api_updating) then
374: --
375: -- check if person_id value exists in per_all_people_f table

Line 372: <> nvl(ben_bri_shd.g_old_rec.person_id,hr_api.g_number)

368: p_object_version_number => p_object_version_number);
369: --
370: if (l_api_updating
371: and nvl(p_person_id,hr_api.g_number)
372: <> nvl(ben_bri_shd.g_old_rec.person_id,hr_api.g_number)
373: or not l_api_updating) then
374: --
375: -- check if person_id value exists in per_all_people_f table
376: --

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

442: (p_batch_rt_id => p_batch_rt_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_bri_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_bri_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_bri_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_bri_shd.g_old_rec.acty_typ_cd,hr_api.g_varchar2)

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

Line 524: if hr_api.not_exists_in_hr_lookups

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

Line 588: <> nvl(ben_bri_shd.g_old_rec.tx_typ_cd,hr_api.g_varchar2)

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

Line 594: if hr_api.not_exists_in_hr_lookups

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

Line 658: <> nvl(ben_bri_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

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

Line 664: if hr_api.not_exists_in_hr_lookups

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

Line 728: <> nvl(ben_bri_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)

724: p_object_version_number => p_object_version_number);
725: --
726: if (l_api_updating
727: and p_bnft_rt_typ_cd
728: <> nvl(ben_bri_shd.g_old_rec.bnft_rt_typ_cd,hr_api.g_varchar2)
729: or not l_api_updating)
730: and p_bnft_rt_typ_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_bnft_rt_typ_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_BNFT_RT_TYP',
736: p_lookup_code => p_bnft_rt_typ_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_rt_id
771: (p_batch_rt_id => p_rec.batch_rt_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_rt_id
847: (p_batch_rt_id => p_rec.batch_rt_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_rt_id',
952: p_argument_value => p_batch_rt_id);
953: --
954: open csr_leg_code;