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

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

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

Line 125: and lee_rsn_rl_id <> nvl(p_lee_rsn_rl_id, hr_api.g_number)

121: cursor chk_unique is
122: select null
123: from ben_lee_rsn_rl_f
124: where ordr_to_aply_num = p_ordr_to_aply_num
125: and lee_rsn_rl_id <> nvl(p_lee_rsn_rl_id, hr_api.g_number)
126: and lee_rsn_id = p_lee_rsn_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_lrr_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_lrr_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 227: and lee_rsn_rl_id <> nvl(p_lee_rsn_rl_id, hr_api.g_number)

223: cursor chk_unique is
224: select null
225: from ben_lee_rsn_rl_f
226: where formula_id = p_formula_id
227: and lee_rsn_rl_id <> nvl(p_lee_rsn_rl_id, hr_api.g_number)
228: and lee_rsn_id = p_lee_rsn_id --parent
229: and business_group_id + 0 = p_business_group_id
230: and p_validation_start_date <= effective_end_date
231: and p_validation_end_date >= effective_start_date;

Line 244: <> nvl(ben_lrr_shd.g_old_rec.formula_id,hr_api.g_number)

240: p_object_version_number => p_object_version_number);
241: --
242: if (l_api_updating
243: and p_formula_id
244: <> nvl(ben_lrr_shd.g_old_rec.formula_id,hr_api.g_number)
245: or not l_api_updating)
246: and p_formula_id is not null then
247: --
248: -- check if value of lookup falls within lookup type.

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_lee_rsn_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_lee_rsn_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_lee_rsn_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 365: If ((nvl(p_lee_rsn_id, hr_api.g_number) <> hr_api.g_number) and

361: p_to_date => p_validation_end_date))) Then
362: l_table_name := 'ff_formulas_f';
363: Raise l_integrity_error;
364: End If;
365: If ((nvl(p_lee_rsn_id, hr_api.g_number) <> hr_api.g_number) and
366: NOT (dt_api.check_min_max_dates
367: (p_base_table_name => 'ben_lee_rsn_f',
368: p_base_key_column => 'lee_rsn_id',
369: p_base_key_value => p_lee_rsn_id,

Line 447: hr_api.mandatory_arg_error

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

Line 461: hr_api.mandatory_arg_error

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

Line 466: hr_api.mandatory_arg_error

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

Line 471: hr_api.mandatory_arg_error

467: (p_api_name => l_proc,
468: p_argument => 'validation_end_date',
469: p_argument_value => p_validation_end_date);
470: --
471: hr_api.mandatory_arg_error
472: (p_api_name => l_proc,
473: p_argument => 'lee_rsn_rl_id',
474: p_argument_value => p_lee_rsn_rl_id);
475: --

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

513: --
514: -- Call all supporting business operations
515: --
516: --
517: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
518: --
519: chk_lee_rsn_rl_id
520: (p_lee_rsn_rl_id => p_rec.lee_rsn_rl_id,
521: p_effective_date => p_effective_date,

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

561: --
562: -- Call all supporting business operations
563: --
564: --
565: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
566: --
567: chk_lee_rsn_rl_id
568: (p_lee_rsn_rl_id => p_rec.lee_rsn_rl_id,
569: p_effective_date => p_effective_date,

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

654: hr_utility.set_location('Entering:'|| l_proc, 10);
655: --
656: -- Ensure that all the mandatory parameter are not null
657: --
658: hr_api.mandatory_arg_error(p_api_name => l_proc,
659: p_argument => 'lee_rsn_rl_id',
660: p_argument_value => p_lee_rsn_rl_id);
661: --
662: open csr_leg_code;