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

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

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

Line 125: and schedd_enrt_rl_id <> nvl(p_schedd_enrt_rl_id, hr_api.g_number)

121: cursor chk_unique is
122: select null
123: from ben_schedd_enrt_rl_f
124: where ordr_to_aply_num = p_ordr_to_aply_num
125: and schedd_enrt_rl_id <> nvl(p_schedd_enrt_rl_id, hr_api.g_number)
126: and enrt_perd_id = p_enrt_perd_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_ser_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_ser_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 schedd_enrt_rl_id <> nvl(p_schedd_enrt_rl_id, hr_api.g_number)

209: cursor chk_unique is
210: select null
211: from ben_schedd_enrt_rl_f
212: where formula_id = p_formula_id
213: and schedd_enrt_rl_id <> nvl(p_schedd_enrt_rl_id, hr_api.g_number)
214: and enrt_perd_id = p_enrt_perd_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_ser_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_ser_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 287: (p_formula_id in number default hr_api.g_number,

283: --
284: -- {End Of Comments}
285: -- ----------------------------------------------------------------------------
286: Procedure dt_update_validate
287: (p_formula_id in number default hr_api.g_number,
288: p_enrt_perd_id in number default hr_api.g_number,
289: p_datetrack_mode in varchar2,
290: p_validation_start_date in date,
291: p_validation_end_date in date) Is

Line 288: p_enrt_perd_id in number default hr_api.g_number,

284: -- {End Of Comments}
285: -- ----------------------------------------------------------------------------
286: Procedure dt_update_validate
287: (p_formula_id in number default hr_api.g_number,
288: p_enrt_perd_id in number default hr_api.g_number,
289: p_datetrack_mode in varchar2,
290: p_validation_start_date in date,
291: p_validation_end_date in date) Is
292: --

Line 302: hr_api.mandatory_arg_error

298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: -- Ensure that the p_datetrack_mode argument is not null
301: --
302: hr_api.mandatory_arg_error
303: (p_api_name => l_proc,
304: p_argument => 'datetrack_mode',
305: p_argument_value => p_datetrack_mode);
306: --

Line 314: hr_api.mandatory_arg_error

310: --
311: --
312: -- Ensure the arguments are not null
313: --
314: hr_api.mandatory_arg_error
315: (p_api_name => l_proc,
316: p_argument => 'validation_start_date',
317: p_argument_value => p_validation_start_date);
318: --

Line 319: hr_api.mandatory_arg_error

315: (p_api_name => l_proc,
316: p_argument => 'validation_start_date',
317: p_argument_value => p_validation_start_date);
318: --
319: hr_api.mandatory_arg_error
320: (p_api_name => l_proc,
321: p_argument => 'validation_end_date',
322: p_argument_value => p_validation_end_date);
323: --

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

320: (p_api_name => l_proc,
321: p_argument => 'validation_end_date',
322: p_argument_value => p_validation_end_date);
323: --
324: If ((nvl(p_formula_id, hr_api.g_number) <> hr_api.g_number) and
325: NOT (dt_api.check_min_max_dates
326: (p_base_table_name => 'ff_formulas_f',
327: p_base_key_column => 'formula_id',
328: p_base_key_value => p_formula_id,

Line 406: hr_api.mandatory_arg_error

402: hr_utility.set_location('Entering:'||l_proc, 5);
403: --
404: -- Ensure that the p_datetrack_mode argument is not null
405: --
406: hr_api.mandatory_arg_error
407: (p_api_name => l_proc,
408: p_argument => 'datetrack_mode',
409: p_argument_value => p_datetrack_mode);
410: --

Line 420: hr_api.mandatory_arg_error

416: --
417: --
418: -- Ensure the arguments are not null
419: --
420: hr_api.mandatory_arg_error
421: (p_api_name => l_proc,
422: p_argument => 'validation_start_date',
423: p_argument_value => p_validation_start_date);
424: --

Line 425: hr_api.mandatory_arg_error

421: (p_api_name => l_proc,
422: p_argument => 'validation_start_date',
423: p_argument_value => p_validation_start_date);
424: --
425: hr_api.mandatory_arg_error
426: (p_api_name => l_proc,
427: p_argument => 'validation_end_date',
428: p_argument_value => p_validation_end_date);
429: --

Line 430: hr_api.mandatory_arg_error

426: (p_api_name => l_proc,
427: p_argument => 'validation_end_date',
428: p_argument_value => p_validation_end_date);
429: --
430: hr_api.mandatory_arg_error
431: (p_api_name => l_proc,
432: p_argument => 'schedd_enrt_rl_id',
433: p_argument_value => p_schedd_enrt_rl_id);
434: --

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

472: --
473: -- Call all supporting business operations
474: --
475: --
476: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
477: --
478: chk_schedd_enrt_rl_id
479: (p_schedd_enrt_rl_id => p_rec.schedd_enrt_rl_id,
480: p_effective_date => p_effective_date,

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

520: --
521: -- Call all supporting business operations
522: --
523: --
524: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
525: --
526: chk_schedd_enrt_rl_id
527: (p_schedd_enrt_rl_id => p_rec.schedd_enrt_rl_id,
528: p_effective_date => p_effective_date,

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

613: hr_utility.set_location('Entering:'|| l_proc, 10);
614: --
615: -- Ensure that all the mandatory parameter are not null
616: --
617: hr_api.mandatory_arg_error(p_api_name => l_proc,
618: p_argument => 'schedd_enrt_rl_id',
619: p_argument_value => p_schedd_enrt_rl_id);
620: --
621: open csr_leg_code;