DBA Data[Home] [Help]

APPS.BEN_BRR_BUS dependencies on HR_API

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

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

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

278: p_effective_date => p_effective_date,
279: p_object_version_number => p_object_version_number);
280: --
281: if (l_api_updating
282: and nvl(p_formula_id,hr_api.g_number)
283: <> ben_brr_shd.g_old_rec.formula_id
284: or not l_api_updating)
285: and p_formula_id is not null then
286: --

Line 344: (p_cvg_amt_calc_mthd_id in number default hr_api.g_number,

340: --
341: -- {End Of Comments}
342: -- ----------------------------------------------------------------------------
343: Procedure dt_update_validate
344: (p_cvg_amt_calc_mthd_id in number default hr_api.g_number,
345: p_datetrack_mode in varchar2,
346: p_validation_start_date in date,
347: p_validation_end_date in date) Is
348: --

Line 358: hr_api.mandatory_arg_error

354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: -- Ensure that the p_datetrack_mode argument is not null
357: --
358: hr_api.mandatory_arg_error
359: (p_api_name => l_proc,
360: p_argument => 'datetrack_mode',
361: p_argument_value => p_datetrack_mode);
362: --

Line 370: hr_api.mandatory_arg_error

366: --
367: --
368: -- Ensure the arguments are not null
369: --
370: hr_api.mandatory_arg_error
371: (p_api_name => l_proc,
372: p_argument => 'validation_start_date',
373: p_argument_value => p_validation_start_date);
374: --

Line 375: hr_api.mandatory_arg_error

371: (p_api_name => l_proc,
372: p_argument => 'validation_start_date',
373: p_argument_value => p_validation_start_date);
374: --
375: hr_api.mandatory_arg_error
376: (p_api_name => l_proc,
377: p_argument => 'validation_end_date',
378: p_argument_value => p_validation_end_date);
379: --

Line 380: If ((nvl(p_cvg_amt_calc_mthd_id, hr_api.g_number) <> hr_api.g_number) and

376: (p_api_name => l_proc,
377: p_argument => 'validation_end_date',
378: p_argument_value => p_validation_end_date);
379: --
380: If ((nvl(p_cvg_amt_calc_mthd_id, hr_api.g_number) <> hr_api.g_number) and
381: NOT (dt_api.check_min_max_dates
382: (p_base_table_name => 'ben_cvg_amt_calc_mthd_f',
383: p_base_key_column => 'cvg_amt_calc_mthd_id',
384: p_base_key_value => p_cvg_amt_calc_mthd_id,

Line 464: hr_api.mandatory_arg_error

460: hr_utility.set_location('Entering:'||l_proc, 5);
461: --
462: -- Ensure that the p_datetrack_mode argument is not null
463: --
464: hr_api.mandatory_arg_error
465: (p_api_name => l_proc,
466: p_argument => 'datetrack_mode',
467: p_argument_value => p_datetrack_mode);
468: --

Line 478: hr_api.mandatory_arg_error

474: --
475: --
476: -- Ensure the arguments are not null
477: --
478: hr_api.mandatory_arg_error
479: (p_api_name => l_proc,
480: p_argument => 'validation_start_date',
481: p_argument_value => p_validation_start_date);
482: --

Line 483: hr_api.mandatory_arg_error

479: (p_api_name => l_proc,
480: p_argument => 'validation_start_date',
481: p_argument_value => p_validation_start_date);
482: --
483: hr_api.mandatory_arg_error
484: (p_api_name => l_proc,
485: p_argument => 'validation_end_date',
486: p_argument_value => p_validation_end_date);
487: --

Line 488: hr_api.mandatory_arg_error

484: (p_api_name => l_proc,
485: p_argument => 'validation_end_date',
486: p_argument_value => p_validation_end_date);
487: --
488: hr_api.mandatory_arg_error
489: (p_api_name => l_proc,
490: p_argument => 'bnft_vrbl_rt_rl_id',
491: p_argument_value => p_bnft_vrbl_rt_rl_id);
492: --

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

532: --
533: -- Call all supporting business operations
534: --
535: --
536: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
537: --
538: chk_bnft_vrbl_rt_rl_id
539: (p_bnft_vrbl_rt_rl_id => p_rec.bnft_vrbl_rt_rl_id,
540: p_effective_date => p_effective_date,

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

580: --
581: -- Call all supporting business operations
582: --
583: --
584: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
585: --
586: chk_bnft_vrbl_rt_rl_id
587: (p_bnft_vrbl_rt_rl_id => p_rec.bnft_vrbl_rt_rl_id,
588: p_effective_date => p_effective_date,

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

672: hr_utility.set_location('Entering:'|| l_proc, 10);
673: --
674: -- Ensure that all the mandatory parameter are not null
675: --
676: hr_api.mandatory_arg_error(p_api_name => l_proc,
677: p_argument => 'bnft_vrbl_rt_rl_id',
678: p_argument_value => p_bnft_vrbl_rt_rl_id);
679: --
680: open csr_leg_code;