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

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

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

Line 129: and nvl(p_hrs_wkd_in_perd_fctr_id,hr_api.g_number)

125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_hrs_wkd_in_perd_fctr_id,hr_api.g_number)
130: <> nvl(ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_hrs_wkd_in_perd_fctr_id is not null then
133: --

Line 130: <> nvl(ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_hrs_wkd_in_perd_fctr_id,hr_api.g_number)
130: <> nvl(ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_hrs_wkd_in_perd_fctr_id is not null then
133: --
134: -- check if hrs_wkd_in_perd_fctr_id value exists in ben_hrs_wkd_in_perd_fctr table

Line 207: and hrs_wkd_in_perd_rt_id <> nvl(p_hrs_wkd_in_perd_rt_id,hr_api.g_number)

203: select null
204: from ben_hrs_wkd_in_perd_rt_f
205: where hrs_wkd_in_perd_fctr_id = p_hrs_wkd_in_perd_fctr_id
206: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
207: and hrs_wkd_in_perd_rt_id <> nvl(p_hrs_wkd_in_perd_rt_id,hr_api.g_number)
208: and business_group_id + 0 = p_business_group_id
209: and p_validation_start_date <= effective_end_date
210: and p_validation_end_date >= effective_start_date;
211: --

Line 222: and p_hrs_wkd_in_perd_fctr_id <> nvl(ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)

218: p_effective_date => p_effective_date,
219: p_object_version_number => p_object_version_number);
220: --
221: if (l_api_updating
222: and p_hrs_wkd_in_perd_fctr_id <> nvl(ben_hwr_shd.g_old_rec.hrs_wkd_in_perd_fctr_id,hr_api.g_number)
223: or not l_api_updating) then
224:
225: open c_dup;
226: fetch c_dup into l_exists;

Line 355: <> nvl(ben_hwr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and p_excld_flag
355: <> nvl(ben_hwr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
356: or not l_api_updating) then
357: --
358: -- check if value of lookup falls within lookup type.
359: --

Line 361: if hr_api.not_exists_in_hr_lookups

357: --
358: -- check if value of lookup falls within lookup type.
359: --
360: --
361: if hr_api.not_exists_in_hr_lookups
362: (p_lookup_type => 'YES_NO',
363: p_lookup_code => p_excld_flag,
364: p_effective_date => p_effective_date) then
365: --

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

459: --
460: -- {End Of Comments}
461: -- ----------------------------------------------------------------------------
462: Procedure dt_update_validate
463: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
464: p_datetrack_mode in varchar2,
465: p_validation_start_date in date,
466: p_validation_end_date in date) Is
467: --

Line 477: hr_api.mandatory_arg_error

473: hr_utility.set_location('Entering:'||l_proc, 5);
474: --
475: -- Ensure that the p_datetrack_mode argument is not null
476: --
477: hr_api.mandatory_arg_error
478: (p_api_name => l_proc,
479: p_argument => 'datetrack_mode',
480: p_argument_value => p_datetrack_mode);
481: --

Line 489: hr_api.mandatory_arg_error

485: --
486: --
487: -- Ensure the arguments are not null
488: --
489: hr_api.mandatory_arg_error
490: (p_api_name => l_proc,
491: p_argument => 'validation_start_date',
492: p_argument_value => p_validation_start_date);
493: --

Line 494: hr_api.mandatory_arg_error

490: (p_api_name => l_proc,
491: p_argument => 'validation_start_date',
492: p_argument_value => p_validation_start_date);
493: --
494: hr_api.mandatory_arg_error
495: (p_api_name => l_proc,
496: p_argument => 'validation_end_date',
497: p_argument_value => p_validation_end_date);
498: --

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

495: (p_api_name => l_proc,
496: p_argument => 'validation_end_date',
497: p_argument_value => p_validation_end_date);
498: --
499: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
500: NOT (dt_api.check_min_max_dates
501: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
502: p_base_key_column => 'vrbl_rt_prfl_id',
503: p_base_key_value => p_vrbl_rt_prfl_id,

Line 582: hr_api.mandatory_arg_error

578: hr_utility.set_location('Entering:'||l_proc, 5);
579: --
580: -- Ensure that the p_datetrack_mode argument is not null
581: --
582: hr_api.mandatory_arg_error
583: (p_api_name => l_proc,
584: p_argument => 'datetrack_mode',
585: p_argument_value => p_datetrack_mode);
586: --

Line 596: hr_api.mandatory_arg_error

592: --
593: --
594: -- Ensure the arguments are not null
595: --
596: hr_api.mandatory_arg_error
597: (p_api_name => l_proc,
598: p_argument => 'validation_start_date',
599: p_argument_value => p_validation_start_date);
600: --

Line 601: hr_api.mandatory_arg_error

597: (p_api_name => l_proc,
598: p_argument => 'validation_start_date',
599: p_argument_value => p_validation_start_date);
600: --
601: hr_api.mandatory_arg_error
602: (p_api_name => l_proc,
603: p_argument => 'validation_end_date',
604: p_argument_value => p_validation_end_date);
605: --

Line 606: hr_api.mandatory_arg_error

602: (p_api_name => l_proc,
603: p_argument => 'validation_end_date',
604: p_argument_value => p_validation_end_date);
605: --
606: hr_api.mandatory_arg_error
607: (p_api_name => l_proc,
608: p_argument => 'hrs_wkd_in_perd_rt_id',
609: p_argument_value => p_hrs_wkd_in_perd_rt_id);
610: --

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

650: --
651: -- Call all supporting business operations
652: --
653: --
654: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
655: --
656: chk_hrs_wkd_in_perd_rt_id
657: (p_hrs_wkd_in_perd_rt_id => p_rec.hrs_wkd_in_perd_rt_id,
658: p_effective_date => p_effective_date,

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

712: --
713: -- Call all supporting business operations
714: --
715: --
716: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
717: --
718: chk_hrs_wkd_in_perd_rt_id
719: (p_hrs_wkd_in_perd_rt_id => p_rec.hrs_wkd_in_perd_rt_id,
720: p_effective_date => p_effective_date,

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

818: hr_utility.set_location('Entering:'|| l_proc, 10);
819: --
820: -- Ensure that all the mandatory parameter are not null
821: --
822: hr_api.mandatory_arg_error(p_api_name => l_proc,
823: p_argument => 'hrs_wkd_in_perd_rt_id',
824: p_argument_value => p_hrs_wkd_in_perd_rt_id);
825: --
826: open csr_leg_code;