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

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

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

Line 124: <> nvl(ben_hsr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_excld_flag
124: <> nvl(ben_hsr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 130: if hr_api.not_exists_in_hr_lookups

126: --
127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_excld_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 193: <> nvl(ben_hsr_shd.g_old_rec.hrly_slrd_cd,hr_api.g_varchar2)

189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and p_hrly_slrd_cd
193: <> nvl(ben_hsr_shd.g_old_rec.hrly_slrd_cd,hr_api.g_varchar2)
194: or not l_api_updating)
195: and p_hrly_slrd_cd is not null then
196: --
197: -- check if value of lookup falls within lookup type.

Line 199: if hr_api.not_exists_in_hr_lookups

195: and p_hrly_slrd_cd is not null then
196: --
197: -- check if value of lookup falls within lookup type.
198: --
199: if hr_api.not_exists_in_hr_lookups
200: (p_lookup_type => 'HOURLY_SALARIED_CODE',
201: p_lookup_code => p_hrly_slrd_cd,
202: p_effective_date => p_effective_date) then
203: --

Line 269: and hrly_slrd_rt_id <> nvl(p_hrly_slrd_rt_id,hr_api.g_number)

265: select null
266: from ben_hrly_slrd_rt_f
267: where hrly_slrd_cd = p_hrly_slrd_cd
268: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
269: and hrly_slrd_rt_id <> nvl(p_hrly_slrd_rt_id,hr_api.g_number)
270: and business_group_id + 0 = p_business_group_id
271: and p_validation_start_date <= effective_end_date
272: and p_validation_end_date >= effective_start_date;
273: --

Line 284: and p_hrly_slrd_cd <> nvl(ben_hsr_shd.g_old_rec.hrly_slrd_cd,hr_api.g_varchar2)

280: p_effective_date => p_effective_date,
281: p_object_version_number => p_object_version_number);
282: --
283: if (l_api_updating
284: and p_hrly_slrd_cd <> nvl(ben_hsr_shd.g_old_rec.hrly_slrd_cd,hr_api.g_varchar2)
285: or not l_api_updating) then
286:
287: open c_dup;
288: fetch c_dup into l_exists;

Line 405: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

401: --
402: -- {End Of Comments}
403: -- ----------------------------------------------------------------------------
404: Procedure dt_update_validate
405: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
406: p_datetrack_mode in varchar2,
407: p_validation_start_date in date,
408: p_validation_end_date in date) Is
409: --

Line 419: hr_api.mandatory_arg_error

415: hr_utility.set_location('Entering:'||l_proc, 5);
416: --
417: -- Ensure that the p_datetrack_mode argument is not null
418: --
419: hr_api.mandatory_arg_error
420: (p_api_name => l_proc,
421: p_argument => 'datetrack_mode',
422: p_argument_value => p_datetrack_mode);
423: --

Line 431: hr_api.mandatory_arg_error

427: --
428: --
429: -- Ensure the arguments are not null
430: --
431: hr_api.mandatory_arg_error
432: (p_api_name => l_proc,
433: p_argument => 'validation_start_date',
434: p_argument_value => p_validation_start_date);
435: --

Line 436: hr_api.mandatory_arg_error

432: (p_api_name => l_proc,
433: p_argument => 'validation_start_date',
434: p_argument_value => p_validation_start_date);
435: --
436: hr_api.mandatory_arg_error
437: (p_api_name => l_proc,
438: p_argument => 'validation_end_date',
439: p_argument_value => p_validation_end_date);
440: --

Line 441: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

437: (p_api_name => l_proc,
438: p_argument => 'validation_end_date',
439: p_argument_value => p_validation_end_date);
440: --
441: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
442: NOT (dt_api.check_min_max_dates
443: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
444: p_base_key_column => 'vrbl_rt_prfl_id',
445: p_base_key_value => p_vrbl_rt_prfl_id,

Line 525: hr_api.mandatory_arg_error

521: hr_utility.set_location('Entering:'||l_proc, 5);
522: --
523: -- Ensure that the p_datetrack_mode argument is not null
524: --
525: hr_api.mandatory_arg_error
526: (p_api_name => l_proc,
527: p_argument => 'datetrack_mode',
528: p_argument_value => p_datetrack_mode);
529: --

Line 539: hr_api.mandatory_arg_error

535: --
536: --
537: -- Ensure the arguments are not null
538: --
539: hr_api.mandatory_arg_error
540: (p_api_name => l_proc,
541: p_argument => 'validation_start_date',
542: p_argument_value => p_validation_start_date);
543: --

Line 544: hr_api.mandatory_arg_error

540: (p_api_name => l_proc,
541: p_argument => 'validation_start_date',
542: p_argument_value => p_validation_start_date);
543: --
544: hr_api.mandatory_arg_error
545: (p_api_name => l_proc,
546: p_argument => 'validation_end_date',
547: p_argument_value => p_validation_end_date);
548: --

Line 549: hr_api.mandatory_arg_error

545: (p_api_name => l_proc,
546: p_argument => 'validation_end_date',
547: p_argument_value => p_validation_end_date);
548: --
549: hr_api.mandatory_arg_error
550: (p_api_name => l_proc,
551: p_argument => 'hrly_slrd_rt_id',
552: p_argument_value => p_hrly_slrd_rt_id);
553: --

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

593: --
594: -- Call all supporting business operations
595: --
596: --
597: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
598: --
599: chk_hrly_slrd_rt_id
600: (p_hrly_slrd_rt_id => p_rec.hrly_slrd_rt_id,
601: p_effective_date => p_effective_date,

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

654: --
655: -- Call all supporting business operations
656: --
657: --
658: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
659: --
660: chk_hrly_slrd_rt_id
661: (p_hrly_slrd_rt_id => p_rec.hrly_slrd_rt_id,
662: p_effective_date => p_effective_date,

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

759: hr_utility.set_location('Entering:'|| l_proc, 10);
760: --
761: -- Ensure that all the mandatory parameter are not null
762: --
763: hr_api.mandatory_arg_error(p_api_name => l_proc,
764: p_argument => 'hrly_slrd_rt_id',
765: p_argument_value => p_hrly_slrd_rt_id);
766: --
767: open csr_leg_code;