DBA Data[Home] [Help]

APPS.BEN_BTR_BUS dependencies on HR_API

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

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

Line 129: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)

125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
130: <> nvl(ben_btr_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table

Line 130: <> nvl(ben_btr_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
130: <> nvl(ben_btr_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table
134: --

Line 202: <> nvl(ben_btr_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

198: p_object_version_number => p_object_version_number);
199: --
200: if (l_api_updating
201: and p_dflt_flag
202: <> nvl(ben_btr_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
203: or not l_api_updating) then
204: --
205: -- check if value of lookup falls within lookup type.
206: --

Line 208: if hr_api.not_exists_in_hr_lookups

204: --
205: -- check if value of lookup falls within lookup type.
206: --
207: --
208: if hr_api.not_exists_in_hr_lookups
209: (p_lookup_type => 'YES_NO',
210: p_lookup_code => p_dflt_flag,
211: p_effective_date => p_effective_date) then
212: --

Line 288: -- <> nvl(ben_btr_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

284: p_object_version_number => p_object_version_number);
285: --
286: if (l_api_updating or not l_api_updating)
287: and p_dflt_flag = 'Y' then
288: -- <> nvl(ben_btr_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
289: -- or not l_api_updating) then
290:
291: -- Check if a record with default flag 'Y' already exists for acty_base_rt.
292: --

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

340: --
341: -- {End Of Comments}
342: -- ----------------------------------------------------------------------------
343: Procedure dt_update_validate
344: (p_acty_base_rt_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_acty_base_rt_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_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
381: NOT (dt_api.check_min_max_dates
382: (p_base_table_name => 'ben_acty_base_rt_f',
383: p_base_key_column => 'acty_base_rt_id',
384: p_base_key_value => p_acty_base_rt_id,

Line 462: hr_api.mandatory_arg_error

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

Line 476: hr_api.mandatory_arg_error

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

Line 481: hr_api.mandatory_arg_error

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

Line 486: hr_api.mandatory_arg_error

482: (p_api_name => l_proc,
483: p_argument => 'validation_end_date',
484: p_argument_value => p_validation_end_date);
485: --
486: hr_api.mandatory_arg_error
487: (p_api_name => l_proc,
488: p_argument => 'comp_lvl_acty_rt_id',
489: p_argument_value => p_comp_lvl_acty_rt_id);
490: --

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

528: --
529: -- Call all supporting business operations
530: --
531: --
532: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
533: --
534: chk_comp_lvl_acty_rt_id
535: (p_comp_lvl_acty_rt_id => p_rec.comp_lvl_acty_rt_id,
536: p_effective_date => p_effective_date,

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

577: --
578: -- Call all supporting business operations
579: --
580: --
581: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
582: --
583: chk_comp_lvl_acty_rt_id
584: (p_comp_lvl_acty_rt_id => p_rec.comp_lvl_acty_rt_id,
585: p_effective_date => p_effective_date,

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

669: hr_utility.set_location('Entering:'|| l_proc, 10);
670: --
671: -- Ensure that all the mandatory parameter are not null
672: --
673: hr_api.mandatory_arg_error(p_api_name => l_proc,
674: p_argument => 'comp_lvl_acty_rt_id',
675: p_argument_value => p_comp_lvl_acty_rt_id);
676: --
677: open csr_leg_code;