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

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

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

Line 125: and ler_chg_plip_enrt_rl_id <> nvl(p_ler_chg_plip_enrt_rl_id, hr_api.g_number)

121: cursor chk_unique is
122: select null
123: from ben_ler_chg_plip_enrt_rl_f
124: where ordr_to_aply_num = p_ordr_to_aply_num
125: and ler_chg_plip_enrt_rl_id <> nvl(p_ler_chg_plip_enrt_rl_id, hr_api.g_number)
126: and ler_chg_plip_enrt_id = p_ler_chg_plip_enrt_id --parent
127: and business_group_id + 0 = p_business_group_id
128: and p_validation_start_date <= effective_end_date
129: and p_validation_end_date >= effective_start_date;

Line 142: <> nvl(ben_lor_shd.g_old_rec.ordr_to_aply_num,hr_api.g_number)

138: p_object_version_number => p_object_version_number);
139: --
140: if (l_api_updating
141: and p_ordr_to_aply_num
142: <> nvl(ben_lor_shd.g_old_rec.ordr_to_aply_num,hr_api.g_number)
143: or not l_api_updating) then
144: --
145: -- this value must be unique
146: --

Line 213: and ler_chg_plip_enrt_rl_id <> nvl(p_ler_chg_plip_enrt_rl_id, hr_api.g_number)

209: cursor chk_unique is
210: select null
211: from ben_ler_chg_plip_enrt_rl_f
212: where formula_id = p_formula_id
213: and ler_chg_plip_enrt_rl_id <> nvl(p_ler_chg_plip_enrt_rl_id, hr_api.g_number)
214: and ler_chg_plip_enrt_id = p_ler_chg_plip_enrt_id --parent
215: and business_group_id + 0 = p_business_group_id
216: and p_validation_start_date <= effective_end_date
217: and p_validation_end_date >= effective_start_date;

Line 230: <> nvl(ben_lor_shd.g_old_rec.formula_id,hr_api.g_number)

226: p_object_version_number => p_object_version_number);
227: --
228: if (l_api_updating
229: and p_formula_id
230: <> nvl(ben_lor_shd.g_old_rec.formula_id,hr_api.g_number)
231: or not l_api_updating) then
232: --
233: -- check if value of lookup falls within lookup type.
234: --

Line 318: and nvl(p_formula_id ,hr_api.g_number)

314: p_effective_date => p_effective_date,
315: p_object_version_number => p_object_version_number);
316: --
317: if (l_api_updating
318: and nvl(p_formula_id ,hr_api.g_number)
319: <> ben_lor_shd.g_old_rec.formula_id
320: or not l_api_updating)
321: and p_formula_id is not null then
322: --

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

376: --
377: -- {End Of Comments}
378: -- ----------------------------------------------------------------------------
379: Procedure dt_update_validate
380: (p_formula_id in number default hr_api.g_number,
381: p_ler_chg_plip_enrt_id in number default hr_api.g_number,
382: p_datetrack_mode in varchar2,
383: p_validation_start_date in date,
384: p_validation_end_date in date) Is

Line 381: p_ler_chg_plip_enrt_id in number default hr_api.g_number,

377: -- {End Of Comments}
378: -- ----------------------------------------------------------------------------
379: Procedure dt_update_validate
380: (p_formula_id in number default hr_api.g_number,
381: p_ler_chg_plip_enrt_id in number default hr_api.g_number,
382: p_datetrack_mode in varchar2,
383: p_validation_start_date in date,
384: p_validation_end_date in date) Is
385: --

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 407: hr_api.mandatory_arg_error

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

Line 412: hr_api.mandatory_arg_error

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

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

413: (p_api_name => l_proc,
414: p_argument => 'validation_end_date',
415: p_argument_value => p_validation_end_date);
416: --
417: If ((nvl(p_formula_id, hr_api.g_number) <> hr_api.g_number) and
418: NOT (dt_api.check_min_max_dates
419: (p_base_table_name => 'ff_formulas_f',
420: p_base_key_column => 'formula_id',
421: p_base_key_value => p_formula_id,

Line 427: If ((nvl(p_ler_chg_plip_enrt_id, hr_api.g_number) <> hr_api.g_number) and

423: p_to_date => p_validation_end_date))) Then
424: l_table_name := 'ff_formulas_f';
425: Raise l_integrity_error;
426: End If;
427: If ((nvl(p_ler_chg_plip_enrt_id, hr_api.g_number) <> hr_api.g_number) and
428: NOT (dt_api.check_min_max_dates
429: (p_base_table_name => 'ben_ler_chg_plip_enrt_f',
430: p_base_key_column => 'ler_chg_plip_enrt_id',
431: p_base_key_value => p_ler_chg_plip_enrt_id,

Line 509: hr_api.mandatory_arg_error

505: hr_utility.set_location('Entering:'||l_proc, 5);
506: --
507: -- Ensure that the p_datetrack_mode argument is not null
508: --
509: hr_api.mandatory_arg_error
510: (p_api_name => l_proc,
511: p_argument => 'datetrack_mode',
512: p_argument_value => p_datetrack_mode);
513: --

Line 523: hr_api.mandatory_arg_error

519: --
520: --
521: -- Ensure the arguments are not null
522: --
523: hr_api.mandatory_arg_error
524: (p_api_name => l_proc,
525: p_argument => 'validation_start_date',
526: p_argument_value => p_validation_start_date);
527: --

Line 528: hr_api.mandatory_arg_error

524: (p_api_name => l_proc,
525: p_argument => 'validation_start_date',
526: p_argument_value => p_validation_start_date);
527: --
528: hr_api.mandatory_arg_error
529: (p_api_name => l_proc,
530: p_argument => 'validation_end_date',
531: p_argument_value => p_validation_end_date);
532: --

Line 533: hr_api.mandatory_arg_error

529: (p_api_name => l_proc,
530: p_argument => 'validation_end_date',
531: p_argument_value => p_validation_end_date);
532: --
533: hr_api.mandatory_arg_error
534: (p_api_name => l_proc,
535: p_argument => 'ler_chg_plip_enrt_rl_id',
536: p_argument_value => p_ler_chg_plip_enrt_rl_id);
537: --

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

575: --
576: -- Call all supporting business operations
577: --
578: --
579: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
580: --
581: chk_ler_chg_plip_enrt_rl_id
582: (p_ler_chg_plip_enrt_rl_id => p_rec.ler_chg_plip_enrt_rl_id,
583: p_effective_date => p_effective_date,

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

630: --
631: -- Call all supporting business operations
632: --
633: --
634: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
635: --
636: chk_ler_chg_plip_enrt_rl_id
637: (p_ler_chg_plip_enrt_rl_id => p_rec.ler_chg_plip_enrt_rl_id,
638: p_effective_date => p_effective_date,

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

730: hr_utility.set_location('Entering:'|| l_proc, 10);
731: --
732: -- Ensure that all the mandatory parameter are not null
733: --
734: hr_api.mandatory_arg_error(p_api_name => l_proc,
735: p_argument => 'ler_chg_plip_enrt_rl_id',
736: p_argument_value => p_ler_chg_plip_enrt_rl_id);
737: --
738: open csr_leg_code;