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

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

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

Line 135: WHERE eligy_prfl_rl_id <> nvl(p_eligy_prfl_rl_id, hr_api.g_number)

131:
132: cursor c3 is
133: SELECT 'x'
134: FROM ben_eligy_prfl_rl_f
135: WHERE eligy_prfl_rl_id <> nvl(p_eligy_prfl_rl_id, hr_api.g_number)
136: AND eligy_prfl_id = p_eligy_prfl_id
137: AND formula_id = p_formula_id
138: AND p_validation_start_date <= effective_end_date
139: AND p_validation_end_date >= effective_start_date;

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

152: p_effective_date => p_effective_date,
153: p_object_version_number => p_object_version_number);
154: --
155: if (l_api_updating
156: and nvl(p_formula_id,hr_api.g_number)
157: <> ben_erl_shd.g_old_rec.formula_id
158: or not l_api_updating)
159: and p_formula_id is not null then
160: --

Line 240: WHERE eligy_prfl_rl_id <> nvl(p_eligy_prfl_rl_id, hr_api.g_number)

236: ,p_validation_start_date date
237: ,p_validation_end_date date) IS
238: SELECT 'x'
239: FROM ben_eligy_prfl_rl_f
240: WHERE eligy_prfl_rl_id <> nvl(p_eligy_prfl_rl_id, hr_api.g_number)
241: AND eligy_prfl_id = p_eligy_prfl_id
242: AND business_group_id + 0 = p_business_group_id
243: AND ordr_to_aply_num = nvl(p_ordr_to_aply_num,hr_api.g_number)
244: AND p_validation_start_date <= effective_end_date

Line 243: AND ordr_to_aply_num = nvl(p_ordr_to_aply_num,hr_api.g_number)

239: FROM ben_eligy_prfl_rl_f
240: WHERE eligy_prfl_rl_id <> nvl(p_eligy_prfl_rl_id, hr_api.g_number)
241: AND eligy_prfl_id = p_eligy_prfl_id
242: AND business_group_id + 0 = p_business_group_id
243: AND ordr_to_aply_num = nvl(p_ordr_to_aply_num,hr_api.g_number)
244: AND p_validation_start_date <= effective_end_date
245: AND p_validation_end_date >= effective_start_date;
246: --
247: l_db_rl_row l_csr_rl%rowtype;

Line 261: and nvl(p_ordr_to_aply_num,hr_api.g_number)

257: p_effective_date => p_effective_date,
258: p_object_version_number => p_object_version_number);
259:
260: if (l_api_updating
261: and nvl(p_ordr_to_aply_num,hr_api.g_number)
262: <> ben_erl_shd.g_old_rec.ordr_to_aply_num
263: or not l_api_updating) then
264:
265: open l_csr_rl

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

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

Line 319: p_eligy_prfl_id in number default hr_api.g_number,

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

Line 333: hr_api.mandatory_arg_error

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

Line 345: hr_api.mandatory_arg_error

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

Line 350: hr_api.mandatory_arg_error

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

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

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

Line 366: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

362: l_table_name := 'ff_formulas_f';
363: Raise l_integrity_error;
364: End If;
365: --
366: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
367: NOT (dt_api.check_min_max_dates
368: (p_base_table_name => 'ben_eligy_prfl_f',
369: p_base_key_column => 'eligy_prfl_id',
370: p_base_key_value => p_eligy_prfl_id,

Line 449: hr_api.mandatory_arg_error

445: hr_utility.set_location('Entering:'||l_proc, 5);
446: --
447: -- Ensure that the p_datetrack_mode argument is not null
448: --
449: hr_api.mandatory_arg_error
450: (p_api_name => l_proc,
451: p_argument => 'datetrack_mode',
452: p_argument_value => p_datetrack_mode);
453: --

Line 463: hr_api.mandatory_arg_error

459: --
460: --
461: -- Ensure the arguments are not null
462: --
463: hr_api.mandatory_arg_error
464: (p_api_name => l_proc,
465: p_argument => 'validation_start_date',
466: p_argument_value => p_validation_start_date);
467: --

Line 468: hr_api.mandatory_arg_error

464: (p_api_name => l_proc,
465: p_argument => 'validation_start_date',
466: p_argument_value => p_validation_start_date);
467: --
468: hr_api.mandatory_arg_error
469: (p_api_name => l_proc,
470: p_argument => 'validation_end_date',
471: p_argument_value => p_validation_end_date);
472: --

Line 473: hr_api.mandatory_arg_error

469: (p_api_name => l_proc,
470: p_argument => 'validation_end_date',
471: p_argument_value => p_validation_end_date);
472: --
473: hr_api.mandatory_arg_error
474: (p_api_name => l_proc,
475: p_argument => 'eligy_prfl_rl_id',
476: p_argument_value => p_eligy_prfl_rl_id);
477: --

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

524: --
525: -- Call all supporting business operations
526: --
527: --
528: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
529: --
530: chk_eligy_prfl_rl_id
531: (p_eligy_prfl_rl_id => p_rec.eligy_prfl_rl_id,
532: p_effective_date => p_effective_date,

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

552: p_validation_start_date => p_validation_start_date,
553: p_validation_end_date => p_validation_end_date,
554: p_object_version_number => p_rec.object_version_number);
555: --
556: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
557: --
558: hr_utility.set_location(' Leaving:'||l_proc, 10);
559: End insert_validate;
560: --

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_eligy_prfl_rl_id
582: (p_eligy_prfl_rl_id => p_rec.eligy_prfl_rl_id,
583: p_effective_date => p_effective_date,

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

669: hr_utility.set_location('Entering:'|| l_proc, 10);
670: --
671: -- Ensure that all the mandatory parameter are not null
672: --
673: hr_api.mandatory_arg_error(p_api_name => l_proc,
674: p_argument => 'eligy_prfl_rl_id',
675: p_argument_value => p_eligy_prfl_rl_id);
676: --
677: open csr_leg_code;