APPS.BEN_ELS_BUS dependencies on HR_API

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

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

Line 124: and elig_los_prte_id <> nvl(p_elig_los_prte_id,hr_api.g_number)

120: select null
121: from ben_elig_los_prte_f
122: where los_fctr_id = p_los_fctr_id
123: and eligy_prfl_id = p_eligy_prfl_id
124: and elig_los_prte_id <> nvl(p_elig_los_prte_id,hr_api.g_number)
125: and business_group_id + 0 = p_business_group_id
126: and p_validation_start_date <= effective_end_date
127: and p_validation_end_date >= effective_start_date
128: ;

Line 147: and nvl(p_los_fctr_id,hr_api.g_number)

143: p_effective_date => p_effective_date,
144: p_object_version_number => p_object_version_number);
145: --
146: if (l_api_updating
147: and nvl(p_los_fctr_id,hr_api.g_number)
148: <> nvl(ben_els_shd.g_old_rec.los_fctr_id,hr_api.g_number)
149: or not l_api_updating) then
150: --
151: -- check if los_fctr_id value exists in ben_los_fctr table

Line 148: <> nvl(ben_els_shd.g_old_rec.los_fctr_id,hr_api.g_number)

144: p_object_version_number => p_object_version_number);
145: --
146: if (l_api_updating
147: and nvl(p_los_fctr_id,hr_api.g_number)
148: <> nvl(ben_els_shd.g_old_rec.los_fctr_id,hr_api.g_number)
149: or not l_api_updating) then
150: --
151: -- check if los_fctr_id value exists in ben_los_fctr table
152: --

Line 234: <> nvl(ben_els_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

230: p_object_version_number => p_object_version_number);
231: --
232: if (l_api_updating
233: and p_excld_flag
234: <> nvl(ben_els_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
235: or not l_api_updating)
236: and p_excld_flag is not null then
237: --
238: -- check if value of lookup falls within lookup type.

Line 240: if hr_api.not_exists_in_hr_lookups

236: and p_excld_flag is not null then
237: --
238: -- check if value of lookup falls within lookup type.
239: --
240: if hr_api.not_exists_in_hr_lookups
241: (p_lookup_type => 'YES_NO',
242: p_lookup_code => p_excld_flag,
243: p_effective_date => p_effective_date) then
244: --

Line 346: (p_eligy_prfl_id in number default hr_api.g_number,

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

Line 360: hr_api.mandatory_arg_error

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

Line 372: hr_api.mandatory_arg_error

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

Line 377: hr_api.mandatory_arg_error

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

Line 382: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

378: (p_api_name => l_proc,
379: p_argument => 'validation_end_date',
380: p_argument_value => p_validation_end_date);
381: --
382: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
383: NOT (dt_api.check_min_max_dates
384: (p_base_table_name => 'ben_eligy_prfl_f',
385: p_base_key_column => 'eligy_prfl_id',
386: p_base_key_value => p_eligy_prfl_id,

Line 466: hr_api.mandatory_arg_error

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

Line 480: hr_api.mandatory_arg_error

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

Line 485: hr_api.mandatory_arg_error

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

Line 490: hr_api.mandatory_arg_error

486: (p_api_name => l_proc,
487: p_argument => 'validation_end_date',
488: p_argument_value => p_validation_end_date);
489: --
490: hr_api.mandatory_arg_error
491: (p_api_name => l_proc,
492: p_argument => 'elig_los_prte_id',
493: p_argument_value => p_elig_los_prte_id);
494: --

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

534: --
535: -- Call all supporting business operations
536: --
537: --
538: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
539: --
540: chk_elig_los_prte_id
541: (p_elig_los_prte_id => p_rec.elig_los_prte_id,
542: p_effective_date => p_effective_date,

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

584: --
585: -- Call all supporting business operations
586: --
587: --
588: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
589: --
590: chk_elig_los_prte_id
591: (p_elig_los_prte_id => p_rec.elig_los_prte_id,
592: p_effective_date => p_effective_date,

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

678: hr_utility.set_location('Entering:'|| l_proc, 10);
679: --
680: -- Ensure that all the mandatory parameter are not null
681: --
682: hr_api.mandatory_arg_error(p_api_name => l_proc,
683: p_argument => 'elig_los_prte_id',
684: p_argument_value => p_elig_los_prte_id);
685: --
686: open csr_leg_code;