eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EGN_BUS dependencies on HR_API

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

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

Line 119: and egn.ELIG_GNDR_PRTE_id <> nvl(p_ELIG_GNDR_PRTE_id, hr_api.g_number) ;

115: select null
116: from ben_elig_gndr_prte_f egn
117: where egn.eligy_prfl_id = p_eligy_prfl_id
118: and egn.sex = p_sex
119: and egn.ELIG_GNDR_PRTE_id <> nvl(p_ELIG_GNDR_PRTE_id, hr_api.g_number) ;
120: --
121: Begin
122: --
123: hr_utility.set_location('Entering:'||l_proc, 5);

Line 199: <> nvl(ben_egn_shd.g_old_rec.sex ,hr_api.g_varchar2)

195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and p_sex
199: <> nvl(ben_egn_shd.g_old_rec.sex ,hr_api.g_varchar2)
200: or not l_api_updating) then
201: --
202: -- check if value of lookup falls within lookup type.
203: --

Line 205: if hr_api.not_exists_in_hr_lookups

201: --
202: -- check if value of lookup falls within lookup type.
203: --
204: --
205: if hr_api.not_exists_in_hr_lookups
206: (p_lookup_type => 'SEX',
207: p_lookup_code => p_sex,
208: p_effective_date => p_effective_date) then
209: --

Line 326: <> nvl(ben_egn_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

322: p_object_version_number => p_object_version_number);
323: --
324: if (l_api_updating
325: and p_excld_flag
326: <> nvl(ben_egn_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
327: or not l_api_updating) then
328: --
329: -- check if value of lookup falls within lookup type.
330: --

Line 332: if hr_api.not_exists_in_hr_lookups

328: --
329: -- check if value of lookup falls within lookup type.
330: --
331: --
332: if hr_api.not_exists_in_hr_lookups
333: (p_lookup_type => 'YES_NO',
334: p_lookup_code => p_excld_flag,
335: p_effective_date => p_effective_date) then
336: --

Line 381: p_eligy_prfl_id in number default hr_api.g_number,

377: -- {End Of Comments}
378: -- ----------------------------------------------------------------------------
379: Procedure dt_update_validate
380: (
381: p_eligy_prfl_id in number default hr_api.g_number,
382: p_datetrack_mode in varchar2,
383: p_validation_start_date in date,
384: p_validation_end_date in date) Is
385: --

Line 395: hr_api.mandatory_arg_error

391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: -- Ensure that the p_datetrack_mode argument is not null
394: --
395: hr_api.mandatory_arg_error
396: (p_api_name => l_proc,
397: p_argument => 'datetrack_mode',
398: p_argument_value => p_datetrack_mode);
399: --

Line 407: hr_api.mandatory_arg_error

403: --
404: --
405: -- Ensure the arguments are not null
406: --
407: hr_api.mandatory_arg_error
408: (p_api_name => l_proc,
409: p_argument => 'validation_start_date',
410: p_argument_value => p_validation_start_date);
411: --

Line 412: hr_api.mandatory_arg_error

408: (p_api_name => l_proc,
409: p_argument => 'validation_start_date',
410: p_argument_value => p_validation_start_date);
411: --
412: hr_api.mandatory_arg_error
413: (p_api_name => l_proc,
414: p_argument => 'validation_end_date',
415: p_argument_value => p_validation_end_date);
416: --

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

413: (p_api_name => l_proc,
414: p_argument => 'validation_end_date',
415: p_argument_value => p_validation_end_date);
416: --
417: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
418: NOT (dt_api.check_min_max_dates
419: (p_base_table_name => 'ben_eligy_prfl_f',
420: p_base_key_column => 'eligy_prfl_id',
421: p_base_key_value => p_eligy_prfl_id,

Line 499: hr_api.mandatory_arg_error

495: hr_utility.set_location('Entering:'||l_proc, 5);
496: --
497: -- Ensure that the p_datetrack_mode argument is not null
498: --
499: hr_api.mandatory_arg_error
500: (p_api_name => l_proc,
501: p_argument => 'datetrack_mode',
502: p_argument_value => p_datetrack_mode);
503: --

Line 513: hr_api.mandatory_arg_error

509: --
510: --
511: -- Ensure the arguments are not null
512: --
513: hr_api.mandatory_arg_error
514: (p_api_name => l_proc,
515: p_argument => 'validation_start_date',
516: p_argument_value => p_validation_start_date);
517: --

Line 518: hr_api.mandatory_arg_error

514: (p_api_name => l_proc,
515: p_argument => 'validation_start_date',
516: p_argument_value => p_validation_start_date);
517: --
518: hr_api.mandatory_arg_error
519: (p_api_name => l_proc,
520: p_argument => 'validation_end_date',
521: p_argument_value => p_validation_end_date);
522: --

Line 523: hr_api.mandatory_arg_error

519: (p_api_name => l_proc,
520: p_argument => 'validation_end_date',
521: p_argument_value => p_validation_end_date);
522: --
523: hr_api.mandatory_arg_error
524: (p_api_name => l_proc,
525: p_argument => 'ELIG_GNDR_PRTE_id',
526: p_argument_value => p_ELIG_GNDR_PRTE_id);
527: --

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

595: p_effective_date => p_effective_date,
596: p_object_version_number => p_rec.object_version_number);
597: --
598:
599: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 10);
602: End insert_validate;
603: --

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

648: p_effective_date => p_effective_date,
649: p_object_version_number => p_rec.object_version_number);
650: --
651:
652: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
653: --
654: -- Call the datetrack update integrity operation
655: --
656: dt_update_validate

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

716: hr_utility.set_location('Entering:'|| l_proc, 10);
717: --
718: -- Ensure that all the mandatory parameter are not null
719: --
720: hr_api.mandatory_arg_error(p_api_name => l_proc,
721: p_argument => 'ELIG_GNDR_PRTE_id',
722: p_argument_value => p_ELIG_GNDR_PRTE_id);
723: --
724: open csr_leg_code;