DBA Data[Home] [Help]

APPS.BEN_VRR_BUS dependencies on HR_API

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

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

Line 266: and nvl(p_formula_id,hr_api.g_number)

262: p_effective_date => p_effective_date,
263: p_object_version_number => p_object_version_number);
264: --
265: if (l_api_updating
266: and nvl(p_formula_id,hr_api.g_number)
267: <> ben_vrr_shd.g_old_rec.formula_id
268: or not l_api_updating)
269: ---and p_formula_id is not null --bug 3960415
270: then

Line 348: and vrr.vrbl_rt_rl_id <> nvl(p_vrbl_rt_rl_id, hr_api.g_number)

344: select null
345: from ben_vrbl_rt_rl_f vrr
346: where vrr.acty_base_rt_id = p_acty_base_rt_id
347: and vrr.formula_id = p_formula_id
348: and vrr.vrbl_rt_rl_id <> nvl(p_vrbl_rt_rl_id, hr_api.g_number)
349: and vrr.business_group_id = p_business_group_id
350: and p_effective_date between vrr.effective_start_date and vrr.effective_end_date;
351: --
352: Begin

Line 409: p_acty_base_rt_id in number default hr_api.g_number,

405: -- {End Of Comments}
406: -- ----------------------------------------------------------------------------
407: Procedure dt_update_validate
408: (
409: p_acty_base_rt_id in number default hr_api.g_number,
410: p_datetrack_mode in varchar2,
411: p_validation_start_date in date,
412: p_validation_end_date in date) Is
413: --

Line 423: hr_api.mandatory_arg_error

419: hr_utility.set_location('Entering:'||l_proc, 5);
420: --
421: -- Ensure that the p_datetrack_mode argument is not null
422: --
423: hr_api.mandatory_arg_error
424: (p_api_name => l_proc,
425: p_argument => 'datetrack_mode',
426: p_argument_value => p_datetrack_mode);
427: --

Line 435: hr_api.mandatory_arg_error

431: --
432: --
433: -- Ensure the arguments are not null
434: --
435: hr_api.mandatory_arg_error
436: (p_api_name => l_proc,
437: p_argument => 'validation_start_date',
438: p_argument_value => p_validation_start_date);
439: --

Line 440: hr_api.mandatory_arg_error

436: (p_api_name => l_proc,
437: p_argument => 'validation_start_date',
438: p_argument_value => p_validation_start_date);
439: --
440: hr_api.mandatory_arg_error
441: (p_api_name => l_proc,
442: p_argument => 'validation_end_date',
443: p_argument_value => p_validation_end_date);
444: --

Line 445: /*If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and

441: (p_api_name => l_proc,
442: p_argument => 'validation_end_date',
443: p_argument_value => p_validation_end_date);
444: --
445: /*If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
446: NOT (dt_api.check_min_max_dates
447: (p_base_table_name => 'ben_actl_prem_f',
448: p_base_key_column => 'actl_prem_id',
449: p_base_key_value => p_actl_prem_id,

Line 455: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and

451: p_to_date => p_validation_end_date))) Then
452: l_table_name := 'ben_actl_prem_f';
453: Raise l_integrity_error;
454: End If;*/
455: If ((nvl(p_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
456: NOT (dt_api.check_min_max_dates
457: (p_base_table_name => 'ben_acty_base_rt_f',
458: p_base_key_column => 'acty_base_rt_id',
459: p_base_key_value => p_acty_base_rt_id,

Line 540: hr_api.mandatory_arg_error

536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: -- Ensure that the p_datetrack_mode argument is not null
539: --
540: hr_api.mandatory_arg_error
541: (p_api_name => l_proc,
542: p_argument => 'datetrack_mode',
543: p_argument_value => p_datetrack_mode);
544: --

Line 554: hr_api.mandatory_arg_error

550: --
551: --
552: -- Ensure the arguments are not null
553: --
554: hr_api.mandatory_arg_error
555: (p_api_name => l_proc,
556: p_argument => 'validation_start_date',
557: p_argument_value => p_validation_start_date);
558: --

Line 559: hr_api.mandatory_arg_error

555: (p_api_name => l_proc,
556: p_argument => 'validation_start_date',
557: p_argument_value => p_validation_start_date);
558: --
559: hr_api.mandatory_arg_error
560: (p_api_name => l_proc,
561: p_argument => 'validation_end_date',
562: p_argument_value => p_validation_end_date);
563: --

Line 564: hr_api.mandatory_arg_error

560: (p_api_name => l_proc,
561: p_argument => 'validation_end_date',
562: p_argument_value => p_validation_end_date);
563: --
564: hr_api.mandatory_arg_error
565: (p_api_name => l_proc,
566: p_argument => 'vrbl_rt_rl_id',
567: p_argument_value => p_vrbl_rt_rl_id);
568: --

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

609: --
610: -- Call all supporting business operations
611: --
612: --
613: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
614: --
615: chk_vrbl_rt_rl_id
616: (p_vrbl_rt_rl_id => p_rec.vrbl_rt_rl_id,
617: p_effective_date => p_effective_date,

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

665: --
666: -- Call all supporting business operations
667: --
668: --
669: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
670: --
671: chk_vrbl_rt_rl_id
672: (p_vrbl_rt_rl_id => p_rec.vrbl_rt_rl_id,
673: p_effective_date => p_effective_date,

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

760: hr_utility.set_location('Entering:'|| l_proc, 10);
761: --
762: -- Ensure that all the mandatory parameter are not null
763: --
764: hr_api.mandatory_arg_error(p_api_name => l_proc,
765: p_argument => 'vrbl_rt_rl_id',
766: p_argument_value => p_vrbl_rt_rl_id);
767: --
768: open csr_leg_code;