APPS.BEN_EAP_BUS dependencies on HR_API

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

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

Line 131: and elig_age_prte_id <> nvl(p_elig_age_prte_id,hr_api.g_number)

127: select null
128: from ben_elig_age_prte_f
129: where age_fctr_id = p_age_fctr_id
130: and eligy_prfl_id = p_eligy_prfl_id
131: and elig_age_prte_id <> nvl(p_elig_age_prte_id,hr_api.g_number)
132: and business_group_id + 0 = p_business_group_id
133: and p_validation_start_date <= effective_end_date
134: and p_validation_end_date >= effective_start_date
135: ;

Line 147: and nvl(p_age_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_age_fctr_id,hr_api.g_number)
148: <> nvl(ben_eap_shd.g_old_rec.age_fctr_id,hr_api.g_number)
149: or not l_api_updating) then
150: --
151: -- check if age_fctr_id value exists in ben_age_fctr table

Line 148: <> nvl(ben_eap_shd.g_old_rec.age_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_age_fctr_id,hr_api.g_number)
148: <> nvl(ben_eap_shd.g_old_rec.age_fctr_id,hr_api.g_number)
149: or not l_api_updating) then
150: --
151: -- check if age_fctr_id value exists in ben_age_fctr table
152: --

Line 234: <> nvl(ben_eap_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_eap_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
235: or not l_api_updating) then
236: --
237: -- check if value of lookup falls within lookup type.
238: --

Line 240: if hr_api.not_exists_in_hr_lookups

236: --
237: -- check if value of lookup falls within lookup type.
238: --
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 465: hr_api.mandatory_arg_error

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

Line 479: hr_api.mandatory_arg_error

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

Line 484: hr_api.mandatory_arg_error

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

Line 489: hr_api.mandatory_arg_error

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

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_elig_age_prte_id
539: (p_elig_age_prte_id => p_rec.elig_age_prte_id,
540: p_effective_date => p_effective_date,

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

582: --
583: -- Call all supporting business operations
584: --
585: --
586: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
587: --
588: chk_elig_age_prte_id
589: (p_elig_age_prte_id => p_rec.elig_age_prte_id,
590: p_effective_date => p_effective_date,

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

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