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

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

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

Line 124: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)

120: p_effective_date => p_effective_date,
121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
125: <> ben_lre_shd.g_old_rec.ctfn_rqd_when_rl
126: or not l_api_updating)
127: and p_ctfn_rqd_when_rl is not null then
128: --

Line 197: <> nvl(ben_lre_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and p_excld_flag
197: <> nvl(ben_lre_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
198: or not l_api_updating) then
199: --
200: -- check if value of lookup falls within lookup type.
201: --

Line 203: if hr_api.not_exists_in_hr_lookups

199: --
200: -- check if value of lookup falls within lookup type.
201: --
202: --
203: if hr_api.not_exists_in_hr_lookups
204: (p_lookup_type => 'YES_NO',
205: p_lookup_code => p_excld_flag,
206: p_effective_date => p_effective_date) then
207: --

Line 253: (p_pl_id in number default hr_api.g_number,

249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure dt_update_validate
253: (p_pl_id in number default hr_api.g_number,
254: p_oipl_id in number default hr_api.g_number,
255: p_ler_id in number default hr_api.g_number,
256: p_datetrack_mode in varchar2,
257: p_validation_start_date in date,

Line 254: p_oipl_id in number default hr_api.g_number,

250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure dt_update_validate
253: (p_pl_id in number default hr_api.g_number,
254: p_oipl_id in number default hr_api.g_number,
255: p_ler_id in number default hr_api.g_number,
256: p_datetrack_mode in varchar2,
257: p_validation_start_date in date,
258: p_validation_end_date in date) Is

Line 255: p_ler_id in number default hr_api.g_number,

251: -- ----------------------------------------------------------------------------
252: Procedure dt_update_validate
253: (p_pl_id in number default hr_api.g_number,
254: p_oipl_id in number default hr_api.g_number,
255: p_ler_id in number default hr_api.g_number,
256: p_datetrack_mode in varchar2,
257: p_validation_start_date in date,
258: p_validation_end_date in date) Is
259: --

Line 269: hr_api.mandatory_arg_error

265: hr_utility.set_location('Entering:'||l_proc, 5);
266: --
267: -- Ensure that the p_datetrack_mode argument is not null
268: --
269: hr_api.mandatory_arg_error
270: (p_api_name => l_proc,
271: p_argument => 'datetrack_mode',
272: p_argument_value => p_datetrack_mode);
273: --

Line 281: hr_api.mandatory_arg_error

277: --
278: --
279: -- Ensure the arguments are not null
280: --
281: hr_api.mandatory_arg_error
282: (p_api_name => l_proc,
283: p_argument => 'validation_start_date',
284: p_argument_value => p_validation_start_date);
285: --

Line 286: hr_api.mandatory_arg_error

282: (p_api_name => l_proc,
283: p_argument => 'validation_start_date',
284: p_argument_value => p_validation_start_date);
285: --
286: hr_api.mandatory_arg_error
287: (p_api_name => l_proc,
288: p_argument => 'validation_end_date',
289: p_argument_value => p_validation_end_date);
290: --

Line 291: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

287: (p_api_name => l_proc,
288: p_argument => 'validation_end_date',
289: p_argument_value => p_validation_end_date);
290: --
291: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
292: NOT (dt_api.check_min_max_dates
293: (p_base_table_name => 'ben_pl_f',
294: p_base_key_column => 'pl_id',
295: p_base_key_value => p_pl_id,

Line 301: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and

297: p_to_date => p_validation_end_date))) Then
298: l_table_name := 'ben_pl_f';
299: Raise l_integrity_error;
300: End If;
301: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
302: NOT (dt_api.check_min_max_dates
303: (p_base_table_name => 'ben_oipl_f',
304: p_base_key_column => 'oipl_id',
305: p_base_key_value => p_oipl_id,

Line 311: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and

307: p_to_date => p_validation_end_date))) Then
308: l_table_name := 'ben_oipl_f';
309: Raise l_integrity_error;
310: End If;
311: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and
312: NOT (dt_api.check_min_max_dates
313: (p_base_table_name => 'ben_ler_f',
314: p_base_key_column => 'ler_id',
315: p_base_key_value => p_ler_id,

Line 395: hr_api.mandatory_arg_error

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

Line 409: hr_api.mandatory_arg_error

405: --
406: --
407: -- Ensure the arguments are not null
408: --
409: hr_api.mandatory_arg_error
410: (p_api_name => l_proc,
411: p_argument => 'validation_start_date',
412: p_argument_value => p_validation_start_date);
413: --

Line 414: hr_api.mandatory_arg_error

410: (p_api_name => l_proc,
411: p_argument => 'validation_start_date',
412: p_argument_value => p_validation_start_date);
413: --
414: hr_api.mandatory_arg_error
415: (p_api_name => l_proc,
416: p_argument => 'validation_end_date',
417: p_argument_value => p_validation_end_date);
418: --

Line 419: hr_api.mandatory_arg_error

415: (p_api_name => l_proc,
416: p_argument => 'validation_end_date',
417: p_argument_value => p_validation_end_date);
418: --
419: hr_api.mandatory_arg_error
420: (p_api_name => l_proc,
421: p_argument => 'ler_rqrs_enrt_ctfn_id',
422: p_argument_value => p_ler_rqrs_enrt_ctfn_id);
423: --

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

471: --
472: -- Call all supporting business operations
473: --
474: --
475: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
476: --
477: chk_ler_rqrs_enrt_ctfn_id
478: (p_ler_rqrs_enrt_ctfn_id => p_rec.ler_rqrs_enrt_ctfn_id,
479: p_effective_date => p_effective_date,

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

512: --
513: -- Call all supporting business operations
514: --
515: --
516: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
517: --
518: chk_ler_rqrs_enrt_ctfn_id
519: (p_ler_rqrs_enrt_ctfn_id => p_rec.ler_rqrs_enrt_ctfn_id,
520: p_effective_date => p_effective_date,

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

599: hr_utility.set_location('Entering:'|| l_proc, 10);
600: --
601: -- Ensure that all the mandatory parameter are not null
602: --
603: hr_api.mandatory_arg_error(p_api_name => l_proc,
604: p_argument => 'ler_rqrs_enrt_ctfn_id',
605: p_argument_value => p_ler_rqrs_enrt_ctfn_id);
606: --
607: open csr_leg_code;