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

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

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

Line 124: <> nvl(ben_etw_shd.g_old_rec.wvd_flag,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_wvd_flag
124: <> nvl(ben_etw_shd.g_old_rec.wvd_flag,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_wvd_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.

Line 130: if hr_api.not_exists_in_hr_lookups

126: and p_wvd_flag is not null then
127: --
128: -- check if value of lookup falls within lookup type.
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'YES_NO',
132: p_lookup_code => p_wvd_flag,
133: p_effective_date => p_effective_date) then
134: --

Line 193: <> nvl(ben_etw_shd.g_old_rec.wv_prtn_rsn_cd,hr_api.g_varchar2)

189: p_object_version_number => p_object_version_number);
190: --
191: if (l_api_updating
192: and p_wv_prtn_rsn_cd
193: <> nvl(ben_etw_shd.g_old_rec.wv_prtn_rsn_cd,hr_api.g_varchar2)
194: or not l_api_updating)
195: and p_wv_prtn_rsn_cd is not null then
196: --
197: -- check if value of lookup falls within lookup type.

Line 199: if hr_api.not_exists_in_hr_lookups

195: and p_wv_prtn_rsn_cd is not null then
196: --
197: -- check if value of lookup falls within lookup type.
198: --
199: if hr_api.not_exists_in_hr_lookups
200: (p_lookup_type => 'BEN_WV_PRTN_RSN',
201: p_lookup_code => p_wv_prtn_rsn_cd,
202: p_effective_date => p_effective_date) then
203: --

Line 262: <> nvl(ben_etw_shd.g_old_rec.wv_cftn_typ_cd,hr_api.g_varchar2)

258: p_object_version_number => p_object_version_number);
259: --
260: if (l_api_updating
261: and p_wv_cftn_typ_cd
262: <> nvl(ben_etw_shd.g_old_rec.wv_cftn_typ_cd,hr_api.g_varchar2)
263: or not l_api_updating)
264: and p_wv_cftn_typ_cd is not null then
265: --
266: -- check if value of lookup falls within lookup type.

Line 268: if hr_api.not_exists_in_hr_lookups

264: and p_wv_cftn_typ_cd is not null then
265: --
266: -- check if value of lookup falls within lookup type.
267: --
268: if hr_api.not_exists_in_hr_lookups
269: (p_lookup_type => 'BEN_WV_PRTN_CTFN_TYP',
270: p_lookup_code => p_wv_cftn_typ_cd,
271: p_effective_date => p_effective_date) then
272: --

Line 316: (p_elig_per_id in number default hr_api.g_number,

312: --
313: -- {End Of Comments}
314: -- ----------------------------------------------------------------------------
315: Procedure dt_update_validate
316: (p_elig_per_id in number default hr_api.g_number,
317: p_pl_typ_id in number default hr_api.g_number,
318: p_datetrack_mode in varchar2,
319: p_validation_start_date in date,
320: p_validation_end_date in date) Is

Line 317: p_pl_typ_id in number default hr_api.g_number,

313: -- {End Of Comments}
314: -- ----------------------------------------------------------------------------
315: Procedure dt_update_validate
316: (p_elig_per_id in number default hr_api.g_number,
317: p_pl_typ_id in number default hr_api.g_number,
318: p_datetrack_mode in varchar2,
319: p_validation_start_date in date,
320: p_validation_end_date in date) Is
321: --

Line 331: hr_api.mandatory_arg_error

327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: -- Ensure that the p_datetrack_mode argument is not null
330: --
331: hr_api.mandatory_arg_error
332: (p_api_name => l_proc,
333: p_argument => 'datetrack_mode',
334: p_argument_value => p_datetrack_mode);
335: --

Line 343: hr_api.mandatory_arg_error

339: --
340: --
341: -- Ensure the arguments are not null
342: --
343: hr_api.mandatory_arg_error
344: (p_api_name => l_proc,
345: p_argument => 'validation_start_date',
346: p_argument_value => p_validation_start_date);
347: --

Line 348: hr_api.mandatory_arg_error

344: (p_api_name => l_proc,
345: p_argument => 'validation_start_date',
346: p_argument_value => p_validation_start_date);
347: --
348: hr_api.mandatory_arg_error
349: (p_api_name => l_proc,
350: p_argument => 'validation_end_date',
351: p_argument_value => p_validation_end_date);
352: --

Line 353: If ((nvl(p_elig_per_id, hr_api.g_number) <> hr_api.g_number) and

349: (p_api_name => l_proc,
350: p_argument => 'validation_end_date',
351: p_argument_value => p_validation_end_date);
352: --
353: If ((nvl(p_elig_per_id, hr_api.g_number) <> hr_api.g_number) and
354: NOT (dt_api.check_min_max_dates
355: (p_base_table_name => 'ben_elig_per_f',
356: p_base_key_column => 'elig_per_id',
357: p_base_key_value => p_elig_per_id,

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

359: p_to_date => p_validation_end_date))) Then
360: l_table_name := 'ben_elig_per_f';
361: Raise l_integrity_error;
362: End If;
363: If ((nvl(p_pl_typ_id, hr_api.g_number) <> hr_api.g_number) and
364: NOT (dt_api.check_min_max_dates
365: (p_base_table_name => 'ben_pl_typ_f',
366: p_base_key_column => 'pl_typ_id',
367: p_base_key_value => p_pl_typ_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 => 'elig_per_wv_pl_typ_id',
474: p_argument_value => p_elig_per_wv_pl_typ_id);
475: --

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

515: --
516: -- Call all supporting business operations
517: --
518: --
519: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
520: --
521: chk_elig_per_wv_pl_typ_id
522: (p_elig_per_wv_pl_typ_id => p_rec.elig_per_wv_pl_typ_id,
523: 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_elig_per_wv_pl_typ_id
568: (p_elig_per_wv_pl_typ_id => p_rec.elig_per_wv_pl_typ_id,
569: p_effective_date => p_effective_date,

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

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