DBA Data[Home] [Help]

APPS.BEN_EOP_BUS dependencies on HR_API

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

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

Line 133: and nvl(p_pl_id,hr_api.g_number)

129: p_effective_date => p_effective_date,
130: p_object_version_number => p_object_version_number);
131: --
132: if (l_api_updating
133: and nvl(p_pl_id,hr_api.g_number)
134: <> nvl(ben_eop_shd.g_old_rec.pl_id,hr_api.g_number)
135: or not l_api_updating)
136: and p_pl_id is not null then
137: --

Line 134: <> nvl(ben_eop_shd.g_old_rec.pl_id,hr_api.g_number)

130: p_object_version_number => p_object_version_number);
131: --
132: if (l_api_updating
133: and nvl(p_pl_id,hr_api.g_number)
134: <> nvl(ben_eop_shd.g_old_rec.pl_id,hr_api.g_number)
135: or not l_api_updating)
136: and p_pl_id is not null then
137: --
138: -- check if pl_id value exists in

Line 208: <> nvl(ben_eop_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

204: p_object_version_number => p_object_version_number);
205: --
206: if (l_api_updating
207: and p_excld_flag
208: <> nvl(ben_eop_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
209: or not l_api_updating) then
210: --
211: -- check if value of lookup falls within lookup type.
212: --

Line 214: if hr_api.not_exists_in_hr_lookups

210: --
211: -- check if value of lookup falls within lookup type.
212: --
213: --
214: if hr_api.not_exists_in_hr_lookups
215: (p_lookup_type => 'YES_NO',
216: p_lookup_code => p_excld_flag,
217: p_effective_date => p_effective_date) then
218: --

Line 272: and eop.ELIG_ANTHR_PL_PRTE_id <> nvl(p_ELIG_ANTHR_PL_PRTE_id, hr_api.g_number) ;

268: select null
269: from ben_ELIG_ANTHR_PL_PRTE_f eop
270: where eop.eligy_prfl_id = p_eligy_prfl_id
271: and eop.pl_id = p_pl_id
272: and eop.ELIG_ANTHR_PL_PRTE_id <> nvl(p_ELIG_ANTHR_PL_PRTE_id, hr_api.g_number) ;
273: --
274: Begin
275: --
276: hr_utility.set_location('Entering:'||l_proc, 5);

Line 394: p_eligy_prfl_id in number default hr_api.g_number,

390: -- {End Of Comments}
391: -- ----------------------------------------------------------------------------
392: Procedure dt_update_validate
393: (
394: p_eligy_prfl_id in number default hr_api.g_number,
395: p_pl_id in number default hr_api.g_number,
396: p_datetrack_mode in varchar2,
397: p_validation_start_date in date,
398: p_validation_end_date in date) Is

Line 395: p_pl_id in number default hr_api.g_number,

391: -- ----------------------------------------------------------------------------
392: Procedure dt_update_validate
393: (
394: p_eligy_prfl_id in number default hr_api.g_number,
395: p_pl_id in number default hr_api.g_number,
396: p_datetrack_mode in varchar2,
397: p_validation_start_date in date,
398: p_validation_end_date in date) Is
399: --

Line 409: hr_api.mandatory_arg_error

405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: -- Ensure that the p_datetrack_mode argument is not null
408: --
409: hr_api.mandatory_arg_error
410: (p_api_name => l_proc,
411: p_argument => 'datetrack_mode',
412: p_argument_value => p_datetrack_mode);
413: --

Line 421: hr_api.mandatory_arg_error

417: --
418: --
419: -- Ensure the arguments are not null
420: --
421: hr_api.mandatory_arg_error
422: (p_api_name => l_proc,
423: p_argument => 'validation_start_date',
424: p_argument_value => p_validation_start_date);
425: --

Line 426: hr_api.mandatory_arg_error

422: (p_api_name => l_proc,
423: p_argument => 'validation_start_date',
424: p_argument_value => p_validation_start_date);
425: --
426: hr_api.mandatory_arg_error
427: (p_api_name => l_proc,
428: p_argument => 'validation_end_date',
429: p_argument_value => p_validation_end_date);
430: --

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

427: (p_api_name => l_proc,
428: p_argument => 'validation_end_date',
429: p_argument_value => p_validation_end_date);
430: --
431: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
432: NOT (dt_api.check_min_max_dates
433: (p_base_table_name => 'ben_eligy_prfl_f',
434: p_base_key_column => 'eligy_prfl_id',
435: p_base_key_value => p_eligy_prfl_id,

Line 513: hr_api.mandatory_arg_error

509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Ensure that the p_datetrack_mode argument is not null
512: --
513: hr_api.mandatory_arg_error
514: (p_api_name => l_proc,
515: p_argument => 'datetrack_mode',
516: p_argument_value => p_datetrack_mode);
517: --

Line 527: hr_api.mandatory_arg_error

523: --
524: --
525: -- Ensure the arguments are not null
526: --
527: hr_api.mandatory_arg_error
528: (p_api_name => l_proc,
529: p_argument => 'validation_start_date',
530: p_argument_value => p_validation_start_date);
531: --

Line 532: hr_api.mandatory_arg_error

528: (p_api_name => l_proc,
529: p_argument => 'validation_start_date',
530: p_argument_value => p_validation_start_date);
531: --
532: hr_api.mandatory_arg_error
533: (p_api_name => l_proc,
534: p_argument => 'validation_end_date',
535: p_argument_value => p_validation_end_date);
536: --

Line 537: hr_api.mandatory_arg_error

533: (p_api_name => l_proc,
534: p_argument => 'validation_end_date',
535: p_argument_value => p_validation_end_date);
536: --
537: hr_api.mandatory_arg_error
538: (p_api_name => l_proc,
539: p_argument => 'ELIG_ANTHR_PL_PRTE_id',
540: p_argument_value => p_ELIG_ANTHR_PL_PRTE_id);
541: --

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

609: p_pl_id => p_rec.pl_id,
610: p_effective_date => p_effective_date,
611: p_object_version_number => p_rec.object_version_number);
612: --
613: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
614: --
615: hr_utility.set_location(' Leaving:'||l_proc, 10);
616: End insert_validate;
617: --

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

662: p_pl_id => p_rec.pl_id,
663: p_effective_date => p_effective_date,
664: p_object_version_number => p_rec.object_version_number);
665: --
666: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
667: --
668: -- Call the datetrack update integrity operation
669: --
670: dt_update_validate

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

731: hr_utility.set_location('Entering:'|| l_proc, 10);
732: --
733: -- Ensure that all the mandatory parameter are not null
734: --
735: hr_api.mandatory_arg_error(p_api_name => l_proc,
736: p_argument => 'ELIG_ANTHR_PL_PRTE_id',
737: p_argument_value => p_ELIG_ANTHR_PL_PRTE_id);
738: --
739: open csr_leg_code;