DBA Data[Home] [Help]

APPS.BEN_BNR_BUS dependencies on HR_API

Line 111: and nvl(p_rptg_grp_id,hr_api.g_number)

107: (p_rptg_grp_id => p_rptg_grp_id,
108: p_object_version_number => p_object_version_number);
109: --
110: if (l_api_updating
111: and nvl(p_rptg_grp_id,hr_api.g_number)
112: <> ben_bnr_shd.g_old_rec.rptg_grp_id) then
113: --
114: -- raise error as PK has changed
115: --

Line 180: <> nvl(ben_bnr_shd.g_old_rec.rptg_prps_cd,hr_api.g_varchar2)

176: p_object_version_number => p_object_version_number);
177: --
178: if (l_api_updating
179: and p_rptg_prps_cd
180: <> nvl(ben_bnr_shd.g_old_rec.rptg_prps_cd,hr_api.g_varchar2)
181: or not l_api_updating)
182: and p_rptg_prps_cd is not null then
183: --
184: -- check if value of lookup falls within lookup type.

Line 186: if hr_api.not_exists_in_hr_lookups

182: and p_rptg_prps_cd is not null then
183: --
184: -- check if value of lookup falls within lookup type.
185: --
186: if hr_api.not_exists_in_hr_lookups
187: (p_lookup_type => 'BEN_RPTG_PRPS',
188: p_lookup_code => p_rptg_prps_cd,
189: p_effective_date => p_effective_date) then
190: --

Line 275: <> nvl(ben_bnr_shd.g_old_rec.rptg_prps_cd,hr_api.g_varchar2))

271: p_object_version_number => p_object_version_number);
272: --
273: if (l_api_updating
274: and p_rptg_prps_cd
275: <> nvl(ben_bnr_shd.g_old_rec.rptg_prps_cd,hr_api.g_varchar2))
276: and p_rptg_prps_cd is not null then
277: --
278: if p_rptg_prps_cd = 'IREC' then
279: --

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

387: p_object_version_number => p_object_version_number);
388: --
389: -- Check whether name is null
390: --
391: hr_api.mandatory_arg_error(p_api_name => l_proc,
392: p_argument => 'name',
393: p_argument_value => p_name);
394: --
395:

Line 397: and nvl(p_name,hr_api.g_varchar2)

393: p_argument_value => p_name);
394: --
395:
396: if ((l_api_updating
397: and nvl(p_name,hr_api.g_varchar2)
398: <> ben_bnr_shd.g_old_rec.name
399: or not l_api_updating)
400: OR
401: (l_api_updating

Line 402: and nvl(p_business_group_id,hr_api.g_number)

398: <> ben_bnr_shd.g_old_rec.name
399: or not l_api_updating)
400: OR
401: (l_api_updating
402: and nvl(p_business_group_id,hr_api.g_number)
403: <> ben_bnr_shd.g_old_rec.business_group_id
404: or not l_api_updating)
405: )
406: and p_name is not null then

Line 573: hr_api.mandatory_arg_error

569: --
570: -- Ensure that the p_datetrack_mode argument is not null
571:
572: --
573: hr_api.mandatory_arg_error
574: (p_api_name => l_proc,
575: p_argument => 'datetrack_mode',
576: p_argument_value => p_datetrack_mode);
577: --

Line 588: hr_api.mandatory_arg_error

584: --
585: -- Ensure the arguments are not null
586: --
587:
588: hr_api.mandatory_arg_error
589: (p_api_name => l_proc,
590: p_argument => 'validation_start_date',
591: p_argument_value => p_validation_start_date);
592: --

Line 593: hr_api.mandatory_arg_error

589: (p_api_name => l_proc,
590: p_argument => 'validation_start_date',
591: p_argument_value => p_validation_start_date);
592: --
593: hr_api.mandatory_arg_error
594: (p_api_name => l_proc,
595: p_argument => 'validation_end_date',
596: p_argument_value => p_validation_end_date);
597: --

Line 598: hr_api.mandatory_arg_error

594: (p_api_name => l_proc,
595: p_argument => 'validation_end_date',
596: p_argument_value => p_validation_end_date);
597: --
598: hr_api.mandatory_arg_error
599: (p_api_name => l_proc,
600: p_argument => 'rptg_grp_id',
601: p_argument_value => p_rptg_grp_id);
602:

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

673: --
674: -- CWB Changes
675: if p_rec.business_group_id is not null then
676: --
677: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
678: --
679: end if;
680: --
681: chk_rptg_grp_id

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

720: --
721: --
722: if p_rec.business_group_id is not null then
723: --
724: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
725: --
726: end if;
727: --
728: chk_rptg_grp_id

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

820: hr_utility.set_location('Entering:'|| l_proc, 10);
821: --
822: -- Ensure that all the mandatory parameter are not null
823: --
824: hr_api.mandatory_arg_error(p_api_name => l_proc,
825: p_argument => 'rptg_grp_id',
826: p_argument_value => p_rptg_grp_id);
827: --
828: open csr_leg_code;