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

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

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

Line 133: WHERE ler_rltd_per_cs_ler_id <> nvl(p_ler_rltd_per_cs_ler_id, hr_api.g_number)

129: ,p_validation_start_date date
130: ,p_validation_end_date date) IS
131: SELECT 'x'
132: FROM ben_ler_rltd_per_cs_ler_f
133: WHERE ler_rltd_per_cs_ler_id <> nvl(p_ler_rltd_per_cs_ler_id, hr_api.g_number)
134: AND rltd_per_chg_cs_ler_id = p_rltd_per_chg_cs_ler_id
135: AND ler_id = p_ler_id
136: AND business_group_id + 0 = p_business_group_id
137: AND p_validation_start_date <= effective_end_date

Line 156: and nvl(p_rltd_per_chg_cs_ler_id,hr_api.g_number)

152: p_object_version_number => p_object_version_number);
153:
154: --
155: if (l_api_updating
156: and nvl(p_rltd_per_chg_cs_ler_id,hr_api.g_number)
157: <> nvl(ben_lrc_shd.g_old_rec.rltd_per_chg_cs_ler_id,hr_api.g_number)
158: or not l_api_updating) then
159: --
160: -- check if rltd_per_chg_cs_ler_id value exists in

Line 157: <> nvl(ben_lrc_shd.g_old_rec.rltd_per_chg_cs_ler_id,hr_api.g_number)

153:
154: --
155: if (l_api_updating
156: and nvl(p_rltd_per_chg_cs_ler_id,hr_api.g_number)
157: <> nvl(ben_lrc_shd.g_old_rec.rltd_per_chg_cs_ler_id,hr_api.g_number)
158: or not l_api_updating) then
159: --
160: -- check if rltd_per_chg_cs_ler_id value exists in
161: -- ben_rltd_per_chg_cs_ler_f table

Line 255: and nvl(p_ler_rltd_per_cs_chg_rl,hr_api.g_number)

251: p_effective_date => p_effective_date,
252: p_object_version_number => p_object_version_number);
253: --
254: if (l_api_updating
255: and nvl(p_ler_rltd_per_cs_chg_rl,hr_api.g_number)
256: <> ben_lrc_shd.g_old_rec.ler_rltd_per_cs_chg_rl
257: or not l_api_updating)
258: and p_ler_rltd_per_cs_chg_rl is not null then
259: --

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

313: --
314: -- {End Of Comments}
315: -- ----------------------------------------------------------------------------
316: Procedure dt_update_validate
317: (p_formula_id in number default hr_api.g_number,
318: p_datetrack_mode in varchar2,
319: p_validation_start_date in date,
320: p_validation_end_date in date) Is
321: --

Line 331: hr_api.mandatory_arg_error

327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: -- Ensure that the p_datetrack_mode argument is not null
330: --
331: hr_api.mandatory_arg_error
332: (p_api_name => l_proc,
333: p_argument => 'datetrack_mode',
334: p_argument_value => p_datetrack_mode);
335: --

Line 343: hr_api.mandatory_arg_error

339: --
340: --
341: -- Ensure the arguments are not null
342: --
343: hr_api.mandatory_arg_error
344: (p_api_name => l_proc,
345: p_argument => 'validation_start_date',
346: p_argument_value => p_validation_start_date);
347: --

Line 348: hr_api.mandatory_arg_error

344: (p_api_name => l_proc,
345: p_argument => 'validation_start_date',
346: p_argument_value => p_validation_start_date);
347: --
348: hr_api.mandatory_arg_error
349: (p_api_name => l_proc,
350: p_argument => 'validation_end_date',
351: p_argument_value => p_validation_end_date);
352: --

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

349: (p_api_name => l_proc,
350: p_argument => 'validation_end_date',
351: p_argument_value => p_validation_end_date);
352: --
353: If ((nvl(p_formula_id, hr_api.g_number) <> hr_api.g_number) and
354: NOT (dt_api.check_min_max_dates
355: (p_base_table_name => 'ff_formulas_f',
356: p_base_key_column => 'formula_id',
357: p_base_key_value => p_formula_id,

Line 435: hr_api.mandatory_arg_error

431: hr_utility.set_location('Entering:'||l_proc, 5);
432: --
433: -- Ensure that the p_datetrack_mode argument is not null
434: --
435: hr_api.mandatory_arg_error
436: (p_api_name => l_proc,
437: p_argument => 'datetrack_mode',
438: p_argument_value => p_datetrack_mode);
439: --

Line 449: hr_api.mandatory_arg_error

445: --
446: --
447: -- Ensure the arguments are not null
448: --
449: hr_api.mandatory_arg_error
450: (p_api_name => l_proc,
451: p_argument => 'validation_start_date',
452: p_argument_value => p_validation_start_date);
453: --

Line 454: hr_api.mandatory_arg_error

450: (p_api_name => l_proc,
451: p_argument => 'validation_start_date',
452: p_argument_value => p_validation_start_date);
453: --
454: hr_api.mandatory_arg_error
455: (p_api_name => l_proc,
456: p_argument => 'validation_end_date',
457: p_argument_value => p_validation_end_date);
458: --

Line 459: hr_api.mandatory_arg_error

455: (p_api_name => l_proc,
456: p_argument => 'validation_end_date',
457: p_argument_value => p_validation_end_date);
458: --
459: hr_api.mandatory_arg_error
460: (p_api_name => l_proc,
461: p_argument => 'ler_rltd_per_cs_ler_id',
462: p_argument_value => p_ler_rltd_per_cs_ler_id);
463: --

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

501: --
502: -- Call all supporting business operations
503: --
504: --
505: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
506: --
507: chk_ler_rltd_per_cs_ler_id
508: (p_ler_rltd_per_cs_ler_id => p_rec.ler_rltd_per_cs_ler_id,
509: p_effective_date => p_effective_date,

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

565: --
566: -- Call all supporting business operations
567: --
568: --
569: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
570: --
571: chk_ler_rltd_per_cs_ler_id
572: (p_ler_rltd_per_cs_ler_id => p_rec.ler_rltd_per_cs_ler_id,
573: p_effective_date => p_effective_date,

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

665: hr_utility.set_location('Entering:'|| l_proc, 10);
666: --
667: -- Ensure that all the mandatory parameter are not null
668: --
669: hr_api.mandatory_arg_error(p_api_name => l_proc,
670: p_argument => 'ler_rltd_per_cs_ler_id',
671: p_argument_value => p_ler_rltd_per_cs_ler_id);
672: --
673: open csr_leg_code;