DBA Data[Home] [Help]

APPS.BEN_VMR_BUS dependencies on HR_API

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

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

Line 182: <> nvl(ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag,hr_api.g_varchar2)

178: p_object_version_number => p_object_version_number);
179: --
180: if (l_api_updating
181: and p_no_mx_amt_of_py_num_flag
182: <> nvl(ben_vmr_shd.g_old_rec.no_mx_amt_of_py_num_flag,hr_api.g_varchar2)
183: or not l_api_updating) then
184: --
185: -- check if value of lookup falls within lookup type.
186: --

Line 188: if hr_api.not_exists_in_hr_lookups

184: --
185: -- check if value of lookup falls within lookup type.
186: --
187: --
188: if hr_api.not_exists_in_hr_lookups
189: (p_lookup_type => 'YES_NO',
190: p_lookup_code => p_no_mx_amt_of_py_num_flag,
191: p_effective_date => p_effective_date) then
192: --

Line 251: <> nvl(ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag,hr_api.g_varchar2)

247: p_object_version_number => p_object_version_number);
248: --
249: if (l_api_updating
250: and p_no_mx_pct_of_py_num_flag
251: <> nvl(ben_vmr_shd.g_old_rec.no_mx_pct_of_py_num_flag,hr_api.g_varchar2)
252: or not l_api_updating) then
253: --
254: -- check if value of lookup falls within lookup type.
255: --

Line 257: if hr_api.not_exists_in_hr_lookups

253: --
254: -- check if value of lookup falls within lookup type.
255: --
256: --
257: if hr_api.not_exists_in_hr_lookups
258: (p_lookup_type => 'YES_NO',
259: p_lookup_code => p_no_mx_pct_of_py_num_flag,
260: p_effective_date => p_effective_date) then
261: --

Line 320: <> nvl(ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag,hr_api.g_varchar2)

316: p_object_version_number => p_object_version_number);
317: --
318: if (l_api_updating
319: and p_cntnu_mtch_aftr_max_rl_flag
320: <> nvl(ben_vmr_shd.g_old_rec.cntnu_mtch_aftr_max_rl_flag,hr_api.g_varchar2)
321: or not l_api_updating) then
322: --
323: -- check if value of lookup falls within lookup type.
324: --

Line 326: if hr_api.not_exists_in_hr_lookups

322: --
323: -- check if value of lookup falls within lookup type.
324: --
325: --
326: if hr_api.not_exists_in_hr_lookups
327: (p_lookup_type => 'YES_NO',
328: p_lookup_code => p_cntnu_mtch_aftr_max_rl_flag,
329: p_effective_date => p_effective_date) then
330: --

Line 405: and nvl(p_mtchg_rt_calc_rl,hr_api.g_number)

401: p_effective_date => p_effective_date,
402: p_object_version_number => p_object_version_number);
403: --
404: if (l_api_updating
405: and nvl(p_mtchg_rt_calc_rl,hr_api.g_number)
406: <> ben_vmr_shd.g_old_rec.mtchg_rt_calc_rl
407: or not l_api_updating)
408: and p_mtchg_rt_calc_rl is not null then
409: --

Line 485: <> nvl(ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag,hr_api.g_varchar2)

481: p_object_version_number => p_object_version_number);
482: --
483: if (l_api_updating
484: and p_no_mx_mtch_amt_flag
485: <> nvl(ben_vmr_shd.g_old_rec.no_mx_mtch_amt_flag,hr_api.g_varchar2)
486: or not l_api_updating) then
487: --
488: -- check if value of lookup falls within lookup type.
489: --

Line 491: if hr_api.not_exists_in_hr_lookups

487: --
488: -- check if value of lookup falls within lookup type.
489: --
490: --
491: if hr_api.not_exists_in_hr_lookups
492: (p_lookup_type => 'YES_NO',
493: p_lookup_code => p_no_mx_mtch_amt_flag,
494: p_effective_date => p_effective_date) then
495: --

Line 539: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

535: --
536: -- {End Of Comments}
537: -- ----------------------------------------------------------------------------
538: Procedure dt_update_validate
539: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
540: p_datetrack_mode in varchar2,
541: p_validation_start_date in date,
542: p_validation_end_date in date) Is
543: --

Line 553: hr_api.mandatory_arg_error

549: hr_utility.set_location('Entering:'||l_proc, 5);
550: --
551: -- Ensure that the p_datetrack_mode argument is not null
552: --
553: hr_api.mandatory_arg_error
554: (p_api_name => l_proc,
555: p_argument => 'datetrack_mode',
556: p_argument_value => p_datetrack_mode);
557: --

Line 565: hr_api.mandatory_arg_error

561: --
562: --
563: -- Ensure the arguments are not null
564: --
565: hr_api.mandatory_arg_error
566: (p_api_name => l_proc,
567: p_argument => 'validation_start_date',
568: p_argument_value => p_validation_start_date);
569: --

Line 570: hr_api.mandatory_arg_error

566: (p_api_name => l_proc,
567: p_argument => 'validation_start_date',
568: p_argument_value => p_validation_start_date);
569: --
570: hr_api.mandatory_arg_error
571: (p_api_name => l_proc,
572: p_argument => 'validation_end_date',
573: p_argument_value => p_validation_end_date);
574: --

Line 575: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

571: (p_api_name => l_proc,
572: p_argument => 'validation_end_date',
573: p_argument_value => p_validation_end_date);
574: --
575: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
576: NOT (dt_api.check_min_max_dates
577: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
578: p_base_key_column => 'vrbl_rt_prfl_id',
579: p_base_key_value => p_vrbl_rt_prfl_id,

Line 659: hr_api.mandatory_arg_error

655: hr_utility.set_location('Entering:'||l_proc, 5);
656: --
657: -- Ensure that the p_datetrack_mode argument is not null
658: --
659: hr_api.mandatory_arg_error
660: (p_api_name => l_proc,
661: p_argument => 'datetrack_mode',
662: p_argument_value => p_datetrack_mode);
663: --

Line 673: hr_api.mandatory_arg_error

669: --
670: --
671: -- Ensure the arguments are not null
672: --
673: hr_api.mandatory_arg_error
674: (p_api_name => l_proc,
675: p_argument => 'validation_start_date',
676: p_argument_value => p_validation_start_date);
677: --

Line 678: hr_api.mandatory_arg_error

674: (p_api_name => l_proc,
675: p_argument => 'validation_start_date',
676: p_argument_value => p_validation_start_date);
677: --
678: hr_api.mandatory_arg_error
679: (p_api_name => l_proc,
680: p_argument => 'validation_end_date',
681: p_argument_value => p_validation_end_date);
682: --

Line 683: hr_api.mandatory_arg_error

679: (p_api_name => l_proc,
680: p_argument => 'validation_end_date',
681: p_argument_value => p_validation_end_date);
682: --
683: hr_api.mandatory_arg_error
684: (p_api_name => l_proc,
685: p_argument => 'vrbl_mtchg_rt_id',
686: p_argument_value => p_vrbl_mtchg_rt_id);
687: --

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

727: --
728: -- Call all supporting business operations
729: --
730: --
731: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
732: --
733: chk_vrbl_mtchg_rt_id
734: (p_vrbl_mtchg_rt_id => p_rec.vrbl_mtchg_rt_id,
735: p_effective_date => p_effective_date,

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

792: --
793: -- Call all supporting business operations
794: --
795: --
796: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
797: --
798: chk_vrbl_mtchg_rt_id
799: (p_vrbl_mtchg_rt_id => p_rec.vrbl_mtchg_rt_id,
800: p_effective_date => p_effective_date,

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

901: hr_utility.set_location('Entering:'|| l_proc, 10);
902: --
903: -- Ensure that all the mandatory parameter are not null
904: --
905: hr_api.mandatory_arg_error(p_api_name => l_proc,
906: p_argument => 'vrbl_mtchg_rt_id',
907: p_argument_value => p_vrbl_mtchg_rt_id);
908: --
909: open csr_leg_code;