DBA Data[Home] [Help]

APPS.BEN_CBS_BUS dependencies on HR_API

Line 54: and nvl(p_prem_cstg_by_sgmt_id,hr_api.g_number)

50: p_prem_cstg_by_sgmt_id => p_prem_cstg_by_sgmt_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_prem_cstg_by_sgmt_id,hr_api.g_number)
55: <> ben_cbs_shd.g_old_rec.prem_cstg_by_sgmt_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 132: and nvl(p_sgmt_cstg_mthd_rl,hr_api.g_number)

128: p_effective_date => p_effective_date,
129: p_object_version_number => p_object_version_number);
130: --
131: if (l_api_updating
132: and nvl(p_sgmt_cstg_mthd_rl,hr_api.g_number)
133: <> ben_cbs_shd.g_old_rec.sgmt_cstg_mthd_rl
134: or not l_api_updating)
135: and p_sgmt_cstg_mthd_rl is not null then
136: --

Line 209: <> nvl(ben_cbs_shd.g_old_rec.sgmt_cstg_mthd_cd,hr_api.g_varchar2)

205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and p_sgmt_cstg_mthd_cd
209: <> nvl(ben_cbs_shd.g_old_rec.sgmt_cstg_mthd_cd,hr_api.g_varchar2)
210: or not l_api_updating) then
211: --
212: -- check if value of lookup falls within lookup type.
213: --

Line 215: if hr_api.not_exists_in_hr_lookups

211: --
212: -- check if value of lookup falls within lookup type.
213: --
214: --
215: if hr_api.not_exists_in_hr_lookups
216: (p_lookup_type => 'BEN_SGMT_CSTG_MTHD',
217: p_lookup_code => p_sgmt_cstg_mthd_cd,
218: p_effective_date => p_effective_date) then
219: --

Line 521: (p_actl_prem_id in number default hr_api.g_number,

517: --
518: -- {End Of Comments}
519: -- ----------------------------------------------------------------------------
520: Procedure dt_update_validate
521: (p_actl_prem_id in number default hr_api.g_number,
522: p_datetrack_mode in varchar2,
523: p_validation_start_date in date,
524: p_validation_end_date in date) Is
525: --

Line 535: hr_api.mandatory_arg_error

531: hr_utility.set_location('Entering:'||l_proc, 5);
532: --
533: -- Ensure that the p_datetrack_mode argument is not null
534: --
535: hr_api.mandatory_arg_error
536: (p_api_name => l_proc,
537: p_argument => 'datetrack_mode',
538: p_argument_value => p_datetrack_mode);
539: --

Line 547: hr_api.mandatory_arg_error

543: --
544: --
545: -- Ensure the arguments are not null
546: --
547: hr_api.mandatory_arg_error
548: (p_api_name => l_proc,
549: p_argument => 'validation_start_date',
550: p_argument_value => p_validation_start_date);
551: --

Line 552: hr_api.mandatory_arg_error

548: (p_api_name => l_proc,
549: p_argument => 'validation_start_date',
550: p_argument_value => p_validation_start_date);
551: --
552: hr_api.mandatory_arg_error
553: (p_api_name => l_proc,
554: p_argument => 'validation_end_date',
555: p_argument_value => p_validation_end_date);
556: --

Line 557: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and

553: (p_api_name => l_proc,
554: p_argument => 'validation_end_date',
555: p_argument_value => p_validation_end_date);
556: --
557: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
558: NOT (dt_api.check_min_max_dates
559: (p_base_table_name => 'ben_actl_prem_f',
560: p_base_key_column => 'actl_prem_id',
561: p_base_key_value => p_actl_prem_id,

Line 639: hr_api.mandatory_arg_error

635: hr_utility.set_location('Entering:'||l_proc, 5);
636: --
637: -- Ensure that the p_datetrack_mode argument is not null
638: --
639: hr_api.mandatory_arg_error
640: (p_api_name => l_proc,
641: p_argument => 'datetrack_mode',
642: p_argument_value => p_datetrack_mode);
643: --

Line 653: hr_api.mandatory_arg_error

649: --
650: --
651: -- Ensure the arguments are not null
652: --
653: hr_api.mandatory_arg_error
654: (p_api_name => l_proc,
655: p_argument => 'validation_start_date',
656: p_argument_value => p_validation_start_date);
657: --

Line 658: hr_api.mandatory_arg_error

654: (p_api_name => l_proc,
655: p_argument => 'validation_start_date',
656: p_argument_value => p_validation_start_date);
657: --
658: hr_api.mandatory_arg_error
659: (p_api_name => l_proc,
660: p_argument => 'validation_end_date',
661: p_argument_value => p_validation_end_date);
662: --

Line 663: hr_api.mandatory_arg_error

659: (p_api_name => l_proc,
660: p_argument => 'validation_end_date',
661: p_argument_value => p_validation_end_date);
662: --
663: hr_api.mandatory_arg_error
664: (p_api_name => l_proc,
665: p_argument => 'prem_cstg_by_sgmt_id',
666: p_argument_value => p_prem_cstg_by_sgmt_id);
667: --

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

707: --
708: -- Call all supporting business operations
709: --
710: --
711: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
712: --
713: chk_prem_cstg_by_sgmt_id
714: (p_prem_cstg_by_sgmt_id => p_rec.prem_cstg_by_sgmt_id,
715: p_effective_date => p_effective_date,

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

769: --
770: -- Call all supporting business operations
771: --
772: --
773: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
774: --
775: chk_prem_cstg_by_sgmt_id
776: (p_prem_cstg_by_sgmt_id => p_rec.prem_cstg_by_sgmt_id,
777: p_effective_date => p_effective_date,

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

874: hr_utility.set_location('Entering:'|| l_proc, 10);
875: --
876: -- Ensure that all the mandatory parameter are not null
877: --
878: hr_api.mandatory_arg_error(p_api_name => l_proc,
879: p_argument => 'prem_cstg_by_sgmt_id',
880: p_argument_value => p_prem_cstg_by_sgmt_id);
881: --
882: open csr_leg_code;