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

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

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

Line 138: and pstl_zip_rt_id <> nvl(p_pstl_zip_rt_id,hr_api.g_number)

134: select null
135: from ben_pstl_zip_rt_f
136: where pstl_zip_rng_id = p_pstl_zip_rng_id
137: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
138: and pstl_zip_rt_id <> nvl(p_pstl_zip_rt_id,hr_api.g_number)
139: and business_group_id + 0 = p_business_group_id
140: and p_validation_start_date <= effective_end_date
141: and p_validation_end_date >= effective_start_date;
142: --

Line 154: and nvl(p_pstl_zip_rng_id,hr_api.g_number)

150: p_effective_date => p_effective_date,
151: p_object_version_number => p_object_version_number);
152: --
153: if (l_api_updating
154: and nvl(p_pstl_zip_rng_id,hr_api.g_number)
155: <> nvl(ben_pzr_shd.g_old_rec.pstl_zip_rng_id,hr_api.g_number)
156: or not l_api_updating) then
157: --
158: -- check if pstl_zip_rng_id value exists in ben_pstl_zip_rng_f table

Line 155: <> nvl(ben_pzr_shd.g_old_rec.pstl_zip_rng_id,hr_api.g_number)

151: p_object_version_number => p_object_version_number);
152: --
153: if (l_api_updating
154: and nvl(p_pstl_zip_rng_id,hr_api.g_number)
155: <> nvl(ben_pzr_shd.g_old_rec.pstl_zip_rng_id,hr_api.g_number)
156: or not l_api_updating) then
157: --
158: -- check if pstl_zip_rng_id value exists in ben_pstl_zip_rng_f table
159: --

Line 304: <> nvl(ben_pzr_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 310: if hr_api.not_exists_in_hr_lookups

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

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

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

Line 359: p_pstl_zip_rng_id in number default hr_api.g_number,

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

Line 373: hr_api.mandatory_arg_error

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

Line 385: hr_api.mandatory_arg_error

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

Line 390: hr_api.mandatory_arg_error

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

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

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

Line 405: If ((nvl(p_pstl_zip_rng_id, hr_api.g_number) <> hr_api.g_number) and

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

Line 489: hr_api.mandatory_arg_error

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

Line 503: hr_api.mandatory_arg_error

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

Line 508: hr_api.mandatory_arg_error

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

Line 513: hr_api.mandatory_arg_error

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

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

557: --
558: -- Call all supporting business operations
559: --
560: --
561: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
562: --
563: chk_pstl_zip_rt_id
564: (p_pstl_zip_rt_id => p_rec.pstl_zip_rt_id,
565: p_effective_date => p_effective_date,

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

608: --
609: -- Call all supporting business operations
610: --
611: --
612: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
613: --
614: chk_pstl_zip_rt_id
615: (p_pstl_zip_rt_id => p_rec.pstl_zip_rt_id,
616: p_effective_date => p_effective_date,

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

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