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

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

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

Line 130: and ee_stat_rt_id <> nvl(p_ee_stat_rt_id,hr_api.g_number)

126: select null
127: from ben_ee_stat_rt_f
128: where assignment_status_type_id = p_assignment_status_type_id
129: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
130: and ee_stat_rt_id <> nvl(p_ee_stat_rt_id,hr_api.g_number)
131: and business_group_id + 0 = p_business_group_id
132: and p_validation_start_date <= effective_end_date
133: and p_validation_end_date >= effective_start_date;
134: --

Line 145: and p_assignment_status_type_id <> nvl(ben_esr_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)

141: p_effective_date => p_effective_date,
142: p_object_version_number => p_object_version_number);
143: --
144: if (l_api_updating
145: and p_assignment_status_type_id <> nvl(ben_esr_shd.g_old_rec.assignment_status_type_id,hr_api.g_number)
146: or not l_api_updating) then
147:
148: open c_dup;
149: fetch c_dup into l_exists;

Line 272: <> nvl(ben_esr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

268: p_object_version_number => p_object_version_number);
269: --
270: if (l_api_updating
271: and p_excld_flag
272: <> nvl(ben_esr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
273: or not l_api_updating) then
274: --
275: -- check if value of lookup falls within lookup type.
276: --

Line 278: if hr_api.not_exists_in_hr_lookups

274: --
275: -- check if value of lookup falls within lookup type.
276: --
277: --
278: if hr_api.not_exists_in_hr_lookups
279: (p_lookup_type => 'YES_NO',
280: p_lookup_code => p_excld_flag,
281: p_effective_date => p_effective_date) then
282: --

Line 326: (p_vrbl_rt_prfl_id in number default hr_api.g_number,

322: --
323: -- {End Of Comments}
324: -- ----------------------------------------------------------------------------
325: Procedure dt_update_validate
326: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
327: p_assignment_status_type_id in number default hr_api.g_number,
328: p_datetrack_mode in varchar2,
329: p_validation_start_date in date,
330: p_validation_end_date in date) Is

Line 327: p_assignment_status_type_id in number default hr_api.g_number,

323: -- {End Of Comments}
324: -- ----------------------------------------------------------------------------
325: Procedure dt_update_validate
326: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
327: p_assignment_status_type_id in number default hr_api.g_number,
328: p_datetrack_mode in varchar2,
329: p_validation_start_date in date,
330: p_validation_end_date in date) Is
331: --

Line 341: hr_api.mandatory_arg_error

337: hr_utility.set_location('Entering:'||l_proc, 5);
338: --
339: -- Ensure that the p_datetrack_mode argument is not null
340: --
341: hr_api.mandatory_arg_error
342: (p_api_name => l_proc,
343: p_argument => 'datetrack_mode',
344: p_argument_value => p_datetrack_mode);
345: --

Line 353: hr_api.mandatory_arg_error

349: --
350: --
351: -- Ensure the arguments are not null
352: --
353: hr_api.mandatory_arg_error
354: (p_api_name => l_proc,
355: p_argument => 'validation_start_date',
356: p_argument_value => p_validation_start_date);
357: --

Line 358: hr_api.mandatory_arg_error

354: (p_api_name => l_proc,
355: p_argument => 'validation_start_date',
356: p_argument_value => p_validation_start_date);
357: --
358: hr_api.mandatory_arg_error
359: (p_api_name => l_proc,
360: p_argument => 'validation_end_date',
361: p_argument_value => p_validation_end_date);
362: --

Line 363: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

359: (p_api_name => l_proc,
360: p_argument => 'validation_end_date',
361: p_argument_value => p_validation_end_date);
362: --
363: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
364: NOT (dt_api.check_min_max_dates
365: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
366: p_base_key_column => 'vrbl_rt_prfl_id',
367: p_base_key_value => p_vrbl_rt_prfl_id,

Line 374: /*If ((nvl(p_assignment_status_type_id, hr_api.g_number) <> hr_api.g_number) and

370: l_table_name := 'ben_vrbl_rt_prfl_f';
371: Raise l_integrity_error;
372: End If;
373: --
374: /*If ((nvl(p_assignment_status_type_id, hr_api.g_number) <> hr_api.g_number) and
375: NOT (dt_api.check_min_max_dates
376: (p_base_table_name => 'per_assignment_status_types',
377: p_base_key_column => 'assignment_status_type_id',
378: p_base_key_value => p_assignment_status_type_id,

Line 457: hr_api.mandatory_arg_error

453: hr_utility.set_location('Entering:'||l_proc, 5);
454: --
455: -- Ensure that the p_datetrack_mode argument is not null
456: --
457: hr_api.mandatory_arg_error
458: (p_api_name => l_proc,
459: p_argument => 'datetrack_mode',
460: p_argument_value => p_datetrack_mode);
461: --

Line 471: hr_api.mandatory_arg_error

467: --
468: --
469: -- Ensure the arguments are not null
470: --
471: hr_api.mandatory_arg_error
472: (p_api_name => l_proc,
473: p_argument => 'validation_start_date',
474: p_argument_value => p_validation_start_date);
475: --

Line 476: hr_api.mandatory_arg_error

472: (p_api_name => l_proc,
473: p_argument => 'validation_start_date',
474: p_argument_value => p_validation_start_date);
475: --
476: hr_api.mandatory_arg_error
477: (p_api_name => l_proc,
478: p_argument => 'validation_end_date',
479: p_argument_value => p_validation_end_date);
480: --

Line 481: hr_api.mandatory_arg_error

477: (p_api_name => l_proc,
478: p_argument => 'validation_end_date',
479: p_argument_value => p_validation_end_date);
480: --
481: hr_api.mandatory_arg_error
482: (p_api_name => l_proc,
483: p_argument => 'ee_stat_rt_id',
484: p_argument_value => p_ee_stat_rt_id);
485: --

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_ee_stat_rt_id
531: (p_ee_stat_rt_id => p_rec.ee_stat_rt_id,
532: p_effective_date => p_effective_date,

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_ee_stat_rt_id
582: (p_ee_stat_rt_id => p_rec.ee_stat_rt_id,
583: p_effective_date => p_effective_date,

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

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