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

Line 55: and nvl(p_ler_per_info_cs_ler_id,hr_api.g_number)

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

Line 136: WHERE ler_per_info_cs_ler_id <> nvl(p_ler_per_info_cs_ler_id, hr_api.g_number)

132: ,p_validation_start_date date
133: ,p_validation_end_date date) IS
134: SELECT 'x'
135: FROM ben_ler_per_info_cs_ler_f
136: WHERE ler_per_info_cs_ler_id <> nvl(p_ler_per_info_cs_ler_id, hr_api.g_number)
137: AND per_info_chg_cs_ler_id = p_per_info_chg_cs_ler_id
138: AND ler_id = p_ler_id
139: AND business_group_id + 0 = p_business_group_id
140: AND p_validation_start_date <= effective_end_date

Line 159: and nvl(p_per_info_chg_cs_ler_id,hr_api.g_number)

155: p_object_version_number => p_object_version_number);
156:
157: --
158: if (l_api_updating
159: and nvl(p_per_info_chg_cs_ler_id,hr_api.g_number)
160: <> nvl(ben_lpl_shd.g_old_rec.per_info_chg_cs_ler_id,hr_api.g_number)
161: or not l_api_updating) then
162: --
163: -- check if per_info_chg_cs_ler_id value exists in

Line 160: <> nvl(ben_lpl_shd.g_old_rec.per_info_chg_cs_ler_id,hr_api.g_number)

156:
157: --
158: if (l_api_updating
159: and nvl(p_per_info_chg_cs_ler_id,hr_api.g_number)
160: <> nvl(ben_lpl_shd.g_old_rec.per_info_chg_cs_ler_id,hr_api.g_number)
161: or not l_api_updating) then
162: --
163: -- check if per_info_chg_cs_ler_id value exists in
164: -- ben_per_info_chg_cs_ler_f table

Line 257: and nvl(p_ler_per_info_cs_ler_rl,hr_api.g_number)

253: p_effective_date => p_effective_date,
254: p_object_version_number => p_object_version_number);
255: --
256: if (l_api_updating
257: and nvl(p_ler_per_info_cs_ler_rl,hr_api.g_number)
258: <> ben_lpl_shd.g_old_rec.ler_per_info_cs_ler_rl
259: or not l_api_updating)
260: and p_ler_per_info_cs_ler_rl is not null then
261: --

Line 544: and nvl(p_per_info_chg_cs_ler_id,hr_api.g_number)

540: p_effective_date => p_effective_date,
541: p_object_version_number => p_object_version_number);
542: --
543: if (l_api_updating
544: and nvl(p_per_info_chg_cs_ler_id,hr_api.g_number)
545: <> ben_lpl_shd.g_old_rec.per_info_chg_cs_ler_id
546: or not l_api_updating)
547: and p_per_info_chg_cs_ler_id is not null then
548: --

Line 609: (p_formula_id in number default hr_api.g_number,

605: --
606: -- {End Of Comments}
607: -- ----------------------------------------------------------------------------
608: Procedure dt_update_validate
609: (p_formula_id in number default hr_api.g_number,
610: p_datetrack_mode in varchar2,
611: p_validation_start_date in date,
612: p_validation_end_date in date) Is
613: --

Line 623: hr_api.mandatory_arg_error

619: hr_utility.set_location('Entering:'||l_proc, 5);
620: --
621: -- Ensure that the p_datetrack_mode argument is not null
622: --
623: hr_api.mandatory_arg_error
624: (p_api_name => l_proc,
625: p_argument => 'datetrack_mode',
626: p_argument_value => p_datetrack_mode);
627: --

Line 635: hr_api.mandatory_arg_error

631: --
632: --
633: -- Ensure the arguments are not null
634: --
635: hr_api.mandatory_arg_error
636: (p_api_name => l_proc,
637: p_argument => 'validation_start_date',
638: p_argument_value => p_validation_start_date);
639: --

Line 640: hr_api.mandatory_arg_error

636: (p_api_name => l_proc,
637: p_argument => 'validation_start_date',
638: p_argument_value => p_validation_start_date);
639: --
640: hr_api.mandatory_arg_error
641: (p_api_name => l_proc,
642: p_argument => 'validation_end_date',
643: p_argument_value => p_validation_end_date);
644: --

Line 645: If ((nvl(p_formula_id, hr_api.g_number) <> hr_api.g_number) and

641: (p_api_name => l_proc,
642: p_argument => 'validation_end_date',
643: p_argument_value => p_validation_end_date);
644: --
645: If ((nvl(p_formula_id, hr_api.g_number) <> hr_api.g_number) and
646: NOT (dt_api.check_min_max_dates
647: (p_base_table_name => 'ff_formulas_f',
648: p_base_key_column => 'formula_id',
649: p_base_key_value => p_formula_id,

Line 727: hr_api.mandatory_arg_error

723: hr_utility.set_location('Entering:'||l_proc, 5);
724: --
725: -- Ensure that the p_datetrack_mode argument is not null
726: --
727: hr_api.mandatory_arg_error
728: (p_api_name => l_proc,
729: p_argument => 'datetrack_mode',
730: p_argument_value => p_datetrack_mode);
731: --

Line 741: hr_api.mandatory_arg_error

737: --
738: --
739: -- Ensure the arguments are not null
740: --
741: hr_api.mandatory_arg_error
742: (p_api_name => l_proc,
743: p_argument => 'validation_start_date',
744: p_argument_value => p_validation_start_date);
745: --

Line 746: hr_api.mandatory_arg_error

742: (p_api_name => l_proc,
743: p_argument => 'validation_start_date',
744: p_argument_value => p_validation_start_date);
745: --
746: hr_api.mandatory_arg_error
747: (p_api_name => l_proc,
748: p_argument => 'validation_end_date',
749: p_argument_value => p_validation_end_date);
750: --

Line 751: hr_api.mandatory_arg_error

747: (p_api_name => l_proc,
748: p_argument => 'validation_end_date',
749: p_argument_value => p_validation_end_date);
750: --
751: hr_api.mandatory_arg_error
752: (p_api_name => l_proc,
753: p_argument => 'ler_per_info_cs_ler_id',
754: p_argument_value => p_ler_per_info_cs_ler_id);
755: --

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

793: --
794: -- Call all supporting business operations
795: --
796: --
797: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
798: --
799: chk_ler_per_info_cs_ler_id
800: (p_ler_per_info_cs_ler_id => p_rec.ler_per_info_cs_ler_id,
801: p_effective_date => p_effective_date,

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

854: --
855: -- Call all supporting business operations
856: --
857: --
858: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
859: --
860: chk_ler_per_info_cs_ler_id
861: (p_ler_per_info_cs_ler_id => p_rec.ler_per_info_cs_ler_id,
862: p_effective_date => p_effective_date,

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

952: hr_utility.set_location('Entering:'|| l_proc, 10);
953: --
954: -- Ensure that all the mandatory parameter are not null
955: --
956: hr_api.mandatory_arg_error(p_api_name => l_proc,
957: p_argument => 'ler_per_info_cs_ler_id',
958: p_argument_value => p_ler_per_info_cs_ler_id);
959: --
960: open csr_leg_code;