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

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

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

Line 124: <> nvl(ben_pyr_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_pyr_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 258: and pyrl_rt_id <> nvl(p_pyrl_rt_id,hr_api.g_number)

254: select null
255: from ben_pyrl_rt_f
256: where payroll_id = p_payroll_id
257: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
258: and pyrl_rt_id <> nvl(p_pyrl_rt_id,hr_api.g_number)
259: and business_group_id + 0 = p_business_group_id
260: and p_validation_start_date <= effective_end_date
261: and p_validation_end_date >= effective_start_date;
262: --

Line 273: and p_payroll_id <> nvl(ben_pyr_shd.g_old_rec.payroll_id,hr_api.g_number)

269: p_effective_date => p_effective_date,
270: p_object_version_number => p_object_version_number);
271: --
272: if (l_api_updating
273: and p_payroll_id <> nvl(ben_pyr_shd.g_old_rec.payroll_id,hr_api.g_number)
274: or not l_api_updating) then
275:
276: open c_dup;
277: fetch c_dup into l_exists;

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

394: --
395: -- {End Of Comments}
396: -- ----------------------------------------------------------------------------
397: Procedure dt_update_validate
398: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
399: p_payroll_id in number,
400: p_datetrack_mode in varchar2,
401: p_validation_start_date in date,
402: p_validation_end_date in date) Is

Line 413: hr_api.mandatory_arg_error

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

Line 425: hr_api.mandatory_arg_error

421: --
422: --
423: -- Ensure the arguments are not null
424: --
425: hr_api.mandatory_arg_error
426: (p_api_name => l_proc,
427: p_argument => 'validation_start_date',
428: p_argument_value => p_validation_start_date);
429: --

Line 430: hr_api.mandatory_arg_error

426: (p_api_name => l_proc,
427: p_argument => 'validation_start_date',
428: p_argument_value => p_validation_start_date);
429: --
430: hr_api.mandatory_arg_error
431: (p_api_name => l_proc,
432: p_argument => 'validation_end_date',
433: p_argument_value => p_validation_end_date);
434: --

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

431: (p_api_name => l_proc,
432: p_argument => 'validation_end_date',
433: p_argument_value => p_validation_end_date);
434: --
435: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
436: NOT (dt_api.check_min_max_dates
437: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
438: p_base_key_column => 'vrbl_rt_prfl_id',
439: p_base_key_value => p_vrbl_rt_prfl_id,

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

444: End If;
445: --
446: --Check for Bug 3219987
447: --
448: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
449: NOT (dt_api.check_min_max_dates
450: (p_base_table_name => 'pay_payrolls_f',
451: p_base_key_column => 'payroll_id',
452: p_base_key_value => p_payroll_id,

Line 532: hr_api.mandatory_arg_error

528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: -- Ensure that the p_datetrack_mode argument is not null
531: --
532: hr_api.mandatory_arg_error
533: (p_api_name => l_proc,
534: p_argument => 'datetrack_mode',
535: p_argument_value => p_datetrack_mode);
536: --

Line 546: hr_api.mandatory_arg_error

542: --
543: --
544: -- Ensure the arguments are not null
545: --
546: hr_api.mandatory_arg_error
547: (p_api_name => l_proc,
548: p_argument => 'validation_start_date',
549: p_argument_value => p_validation_start_date);
550: --

Line 551: hr_api.mandatory_arg_error

547: (p_api_name => l_proc,
548: p_argument => 'validation_start_date',
549: p_argument_value => p_validation_start_date);
550: --
551: hr_api.mandatory_arg_error
552: (p_api_name => l_proc,
553: p_argument => 'validation_end_date',
554: p_argument_value => p_validation_end_date);
555: --

Line 556: hr_api.mandatory_arg_error

552: (p_api_name => l_proc,
553: p_argument => 'validation_end_date',
554: p_argument_value => p_validation_end_date);
555: --
556: hr_api.mandatory_arg_error
557: (p_api_name => l_proc,
558: p_argument => 'pyrl_rt_id',
559: p_argument_value => p_pyrl_rt_id);
560: --

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

600: --
601: -- Call all supporting business operations
602: --
603: --
604: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
605: --
606: chk_pyrl_rt_id
607: (p_pyrl_rt_id => p_rec.pyrl_rt_id,
608: p_effective_date => p_effective_date,

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

661: --
662: -- Call all supporting business operations
663: --
664: --
665: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
666: --
667: chk_pyrl_rt_id
668: (p_pyrl_rt_id => p_rec.pyrl_rt_id,
669: p_effective_date => p_effective_date,

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

771: hr_utility.set_location('Entering:'|| l_proc, 10);
772: --
773: -- Ensure that all the mandatory parameter are not null
774: --
775: hr_api.mandatory_arg_error(p_api_name => l_proc,
776: p_argument => 'pyrl_rt_id',
777: p_argument_value => p_pyrl_rt_id);
778: --
779: open csr_leg_code;