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

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

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

Line 137: and svc_area_rt_id <> nvl(p_svc_area_rt_id,hr_api.g_number)

133: select null
134: from ben_svc_area_rt_f
135: where svc_area_id = p_svc_area_id
136: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
137: and svc_area_rt_id <> nvl(p_svc_area_rt_id,hr_api.g_number)
138: and business_group_id + 0 = p_business_group_id
139: and p_validation_start_date <= effective_end_date
140: and p_validation_end_date >= effective_start_date;
141: --

Line 153: and nvl(p_svc_area_id,hr_api.g_number)

149: p_effective_date => p_effective_date,
150: p_object_version_number => p_object_version_number);
151: --
152: if (l_api_updating
153: and nvl(p_svc_area_id,hr_api.g_number)
154: <> nvl(ben_sar_shd.g_old_rec.svc_area_id,hr_api.g_number)
155: or not l_api_updating) then
156: --
157: -- check if p_svc_area_id value exists in ben_svc_area_f table

Line 154: <> nvl(ben_sar_shd.g_old_rec.svc_area_id,hr_api.g_number)

150: p_object_version_number => p_object_version_number);
151: --
152: if (l_api_updating
153: and nvl(p_svc_area_id,hr_api.g_number)
154: <> nvl(ben_sar_shd.g_old_rec.svc_area_id,hr_api.g_number)
155: or not l_api_updating) then
156: --
157: -- check if p_svc_area_id value exists in ben_svc_area_f table
158: --

Line 303: <> nvl(ben_sar_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

299: p_object_version_number => p_object_version_number);
300: --
301: if (l_api_updating
302: and p_excld_flag
303: <> nvl(ben_sar_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
304: or not l_api_updating) then
305: --
306: -- check if value of lookup falls within lookup type.
307: --

Line 309: if hr_api.not_exists_in_hr_lookups

305: --
306: -- check if value of lookup falls within lookup type.
307: --
308: --
309: if hr_api.not_exists_in_hr_lookups
310: (p_lookup_type => 'YES_NO',
311: p_lookup_code => p_excld_flag,
312: p_effective_date => p_effective_date) then
313: --

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

353: --
354: -- {End Of Comments}
355: -- ----------------------------------------------------------------------------
356: Procedure dt_update_validate
357: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
358: p_svc_area_id in number default hr_api.g_number,
359: p_datetrack_mode in varchar2,
360: p_validation_start_date in date,
361: p_validation_end_date in date) Is

Line 358: p_svc_area_id in number default hr_api.g_number,

354: -- {End Of Comments}
355: -- ----------------------------------------------------------------------------
356: Procedure dt_update_validate
357: (p_vrbl_rt_prfl_id in number default hr_api.g_number,
358: p_svc_area_id in number default hr_api.g_number,
359: p_datetrack_mode in varchar2,
360: p_validation_start_date in date,
361: p_validation_end_date in date) Is
362: --

Line 372: hr_api.mandatory_arg_error

368: hr_utility.set_location('Entering:'||l_proc, 5);
369: --
370: -- Ensure that the p_datetrack_mode argument is not null
371: --
372: hr_api.mandatory_arg_error
373: (p_api_name => l_proc,
374: p_argument => 'datetrack_mode',
375: p_argument_value => p_datetrack_mode);
376: --

Line 384: hr_api.mandatory_arg_error

380: --
381: --
382: -- Ensure the arguments are not null
383: --
384: hr_api.mandatory_arg_error
385: (p_api_name => l_proc,
386: p_argument => 'validation_start_date',
387: p_argument_value => p_validation_start_date);
388: --

Line 389: hr_api.mandatory_arg_error

385: (p_api_name => l_proc,
386: p_argument => 'validation_start_date',
387: p_argument_value => p_validation_start_date);
388: --
389: hr_api.mandatory_arg_error
390: (p_api_name => l_proc,
391: p_argument => 'validation_end_date',
392: p_argument_value => p_validation_end_date);
393: --

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

390: (p_api_name => l_proc,
391: p_argument => 'validation_end_date',
392: p_argument_value => p_validation_end_date);
393: --
394: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
395: NOT (dt_api.check_min_max_dates
396: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
397: p_base_key_column => 'vrbl_rt_prfl_id',
398: p_base_key_value => p_vrbl_rt_prfl_id,

Line 404: If ((nvl(p_svc_area_id, hr_api.g_number) <> hr_api.g_number) and

400: p_to_date => p_validation_end_date))) Then
401: l_table_name := 'ben_vrbl_rt_prfl_f';
402: Raise l_integrity_error;
403: End If;
404: If ((nvl(p_svc_area_id, hr_api.g_number) <> hr_api.g_number) and
405: NOT (dt_api.check_min_max_dates
406: (p_base_table_name => 'ben_svc_area_f',
407: p_base_key_column => 'svc_area_id',
408: p_base_key_value => p_svc_area_id,

Line 488: hr_api.mandatory_arg_error

484: hr_utility.set_location('Entering:'||l_proc, 5);
485: --
486: -- Ensure that the p_datetrack_mode argument is not null
487: --
488: hr_api.mandatory_arg_error
489: (p_api_name => l_proc,
490: p_argument => 'datetrack_mode',
491: p_argument_value => p_datetrack_mode);
492: --

Line 502: hr_api.mandatory_arg_error

498: --
499: --
500: -- Ensure the arguments are not null
501: --
502: hr_api.mandatory_arg_error
503: (p_api_name => l_proc,
504: p_argument => 'validation_start_date',
505: p_argument_value => p_validation_start_date);
506: --

Line 507: hr_api.mandatory_arg_error

503: (p_api_name => l_proc,
504: p_argument => 'validation_start_date',
505: p_argument_value => p_validation_start_date);
506: --
507: hr_api.mandatory_arg_error
508: (p_api_name => l_proc,
509: p_argument => 'validation_end_date',
510: p_argument_value => p_validation_end_date);
511: --

Line 512: hr_api.mandatory_arg_error

508: (p_api_name => l_proc,
509: p_argument => 'validation_end_date',
510: p_argument_value => p_validation_end_date);
511: --
512: hr_api.mandatory_arg_error
513: (p_api_name => l_proc,
514: p_argument => 'svc_area_rt_id',
515: p_argument_value => p_svc_area_rt_id);
516: --

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

556: --
557: -- Call all supporting business operations
558: --
559: --
560: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
561: --
562: chk_svc_area_rt_id
563: (p_svc_area_rt_id => p_rec.svc_area_rt_id,
564: p_effective_date => p_effective_date,

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

607: --
608: -- Call all supporting business operations
609: --
610: --
611: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
612: --
613: chk_svc_area_rt_id
614: (p_svc_area_rt_id => p_rec.svc_area_rt_id,
615: p_effective_date => p_effective_date,

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

703: hr_utility.set_location('Entering:'|| l_proc, 10);
704: --
705: -- Ensure that all the mandatory parameter are not null
706: --
707: hr_api.mandatory_arg_error(p_api_name => l_proc,
708: p_argument => 'svc_area_rt_id',
709: p_argument_value => p_svc_area_rt_id);
710: --
711: open csr_leg_code;