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_EDB_BUS dependencies on HR_API

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

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

Line 182: <> nvl(ben_edb_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

178: p_object_version_number => p_object_version_number);
179: --
180: if (l_api_updating
181: and p_excld_flag
182: <> nvl(ben_edb_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
183: or not l_api_updating) then
184: --
185: -- check if value of lookup falls within lookup type.
186: --

Line 188: if hr_api.not_exists_in_hr_lookups

184: --
185: -- check if value of lookup falls within lookup type.
186: --
187: --
188: if hr_api.not_exists_in_hr_lookups
189: (p_lookup_type => 'YES_NO',
190: p_lookup_code => p_excld_flag,
191: p_effective_date => p_effective_date) then
192: --

Line 251: <> nvl(ben_edb_shd.g_old_rec.dsbld_cd,hr_api.g_varchar2)

247: p_object_version_number => p_object_version_number);
248: --
249: if (l_api_updating
250: and p_dsbld_cd
251: <> nvl(ben_edb_shd.g_old_rec.dsbld_cd,hr_api.g_varchar2)
252: or not l_api_updating) then
253: --
254: -- check if value of lookup falls within lookup type.
255: --

Line 257: if hr_api.not_exists_in_hr_lookups

253: --
254: -- check if value of lookup falls within lookup type.
255: --
256: --
257: if hr_api.not_exists_in_hr_lookups
258: (p_lookup_type => 'REGISTERED_DISABLED',
259: p_lookup_code => p_dsbld_cd,
260: p_effective_date => p_effective_date) then
261: --

Line 315: and edb.elig_dsbld_prte_id <> nvl(p_elig_dsbld_prte_id, hr_api.g_number) ;

311: select null
312: from ben_elig_dsbld_prte_f edb
313: where edb.eligy_prfl_id = p_eligy_prfl_id
314: and edb.dsbld_cd = p_dsbld_cd
315: and edb.elig_dsbld_prte_id <> nvl(p_elig_dsbld_prte_id, hr_api.g_number) ;
316: --
317: Begin
318: --
319: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

Line 392: hr_api.mandatory_arg_error

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

Line 404: hr_api.mandatory_arg_error

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

Line 409: hr_api.mandatory_arg_error

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

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

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

Line 497: hr_api.mandatory_arg_error

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

Line 511: hr_api.mandatory_arg_error

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

Line 516: hr_api.mandatory_arg_error

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

Line 521: hr_api.mandatory_arg_error

517: (p_api_name => l_proc,
518: p_argument => 'validation_end_date',
519: p_argument_value => p_validation_end_date);
520: --
521: hr_api.mandatory_arg_error
522: (p_api_name => l_proc,
523: p_argument => 'elig_dsbld_prte_id',
524: p_argument_value => p_elig_dsbld_prte_id);
525: --

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

564: hr_utility.set_location('Entering:'||l_proc, 5);
565: --
566: -- Call all supporting business operations
567: --
568: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
569: --
570: chk_elig_dsbld_prte_id
571: (p_elig_dsbld_prte_id => p_rec.elig_dsbld_prte_id,
572: p_effective_date => p_effective_date,

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

616: hr_utility.set_location('Entering:'||l_proc, 5);
617: --
618: -- Call all supporting business operations
619: --
620: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
621: --
622: chk_elig_dsbld_prte_id
623: (p_elig_dsbld_prte_id => p_rec.elig_dsbld_prte_id,
624: p_effective_date => p_effective_date,

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

713: hr_utility.set_location('Entering:'|| l_proc, 10);
714: --
715: -- Ensure that all the mandatory parameter are not null
716: --
717: hr_api.mandatory_arg_error(p_api_name => l_proc,
718: p_argument => 'elig_dsbld_prte_id',
719: p_argument_value => p_elig_dsbld_prte_id);
720: --
721: open csr_leg_code;