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

Line 55: and nvl(p_popl_actn_typ_id,hr_api.g_number)

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

Line 135: and nvl(p_actn_typ_due_dt_rl,hr_api.g_number)

131: p_effective_date => p_effective_date,
132: p_object_version_number => p_object_version_number);
133: --
134: if (l_api_updating
135: and nvl(p_actn_typ_due_dt_rl,hr_api.g_number)
136: <> ben_pat_shd.g_old_rec.actn_typ_due_dt_rl
137: or not l_api_updating)
138: and p_actn_typ_due_dt_rl is not null then
139: --

Line 213: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_cd,hr_api.g_varchar2)

209: p_object_version_number => p_object_version_number);
210: --
211: if (l_api_updating
212: and p_actn_typ_due_dt_cd
213: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_cd,hr_api.g_varchar2)
214: or not l_api_updating)
215: and p_actn_typ_due_dt_cd is not null then
216: --
217: -- check if value of lookup falls within lookup type.

Line 219: if hr_api.not_exists_in_hr_lookups

215: and p_actn_typ_due_dt_cd is not null then
216: --
217: -- check if value of lookup falls within lookup type.
218: --
219: if hr_api.not_exists_in_hr_lookups
220: (p_lookup_type => 'BEN_ACTN_TYP_DUE_DT',
221: p_lookup_code => p_actn_typ_due_dt_cd,
222: p_effective_date => p_effective_date) then
223: --

Line 288: and (nvl(p_actn_typ_due_dt_cd,hr_api.g_varchar2)

284: p_effective_date => p_effective_date,
285: p_object_version_number => p_object_version_number);
286: --
287: if (l_api_updating
288: and (nvl(p_actn_typ_due_dt_cd,hr_api.g_varchar2)
289: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_cd,hr_api.g_varchar2) or
290: nvl(p_actn_typ_due_dt_rl,hr_api.g_number)
291: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_rl,hr_api.g_number))
292: or not l_api_updating) then

Line 289: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_cd,hr_api.g_varchar2) or

285: p_object_version_number => p_object_version_number);
286: --
287: if (l_api_updating
288: and (nvl(p_actn_typ_due_dt_cd,hr_api.g_varchar2)
289: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_cd,hr_api.g_varchar2) or
290: nvl(p_actn_typ_due_dt_rl,hr_api.g_number)
291: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_rl,hr_api.g_number))
292: or not l_api_updating) then
293: --

Line 290: nvl(p_actn_typ_due_dt_rl,hr_api.g_number)

286: --
287: if (l_api_updating
288: and (nvl(p_actn_typ_due_dt_cd,hr_api.g_varchar2)
289: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_cd,hr_api.g_varchar2) or
290: nvl(p_actn_typ_due_dt_rl,hr_api.g_number)
291: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_rl,hr_api.g_number))
292: or not l_api_updating) then
293: --
294: if (p_actn_typ_due_dt_cd = 'RL' and p_actn_typ_due_dt_rl is null) then

Line 291: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_rl,hr_api.g_number))

287: if (l_api_updating
288: and (nvl(p_actn_typ_due_dt_cd,hr_api.g_varchar2)
289: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_cd,hr_api.g_varchar2) or
290: nvl(p_actn_typ_due_dt_rl,hr_api.g_number)
291: <> nvl(ben_pat_shd.g_old_rec.actn_typ_due_dt_rl,hr_api.g_number))
292: or not l_api_updating) then
293: --
294: if (p_actn_typ_due_dt_cd = 'RL' and p_actn_typ_due_dt_rl is null) then
295: --

Line 301: if nvl(p_actn_typ_due_dt_cd,hr_api.g_varchar2) <> 'RL'

297: fnd_message.raise_error;
298: --
299: end if;
300: --
301: if nvl(p_actn_typ_due_dt_cd,hr_api.g_varchar2) <> 'RL'
302: and p_actn_typ_due_dt_rl is not null then
303: --
304: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
305: fnd_message.raise_error;

Line 345: (p_pgm_id in number default hr_api.g_number,

341: --
342: -- {End Of Comments}
343: -- ----------------------------------------------------------------------------
344: Procedure dt_update_validate
345: (p_pgm_id in number default hr_api.g_number,
346: p_pl_id in number default hr_api.g_number,
347: p_datetrack_mode in varchar2,
348: p_validation_start_date in date,
349: p_validation_end_date in date) Is

Line 346: p_pl_id in number default hr_api.g_number,

342: -- {End Of Comments}
343: -- ----------------------------------------------------------------------------
344: Procedure dt_update_validate
345: (p_pgm_id in number default hr_api.g_number,
346: p_pl_id in number default hr_api.g_number,
347: p_datetrack_mode in varchar2,
348: p_validation_start_date in date,
349: p_validation_end_date in date) Is
350: --

Line 360: hr_api.mandatory_arg_error

356: hr_utility.set_location('Entering:'||l_proc, 5);
357: --
358: -- Ensure that the p_datetrack_mode argument is not null
359: --
360: hr_api.mandatory_arg_error
361: (p_api_name => l_proc,
362: p_argument => 'datetrack_mode',
363: p_argument_value => p_datetrack_mode);
364: --

Line 372: hr_api.mandatory_arg_error

368: --
369: --
370: -- Ensure the arguments are not null
371: --
372: hr_api.mandatory_arg_error
373: (p_api_name => l_proc,
374: p_argument => 'validation_start_date',
375: p_argument_value => p_validation_start_date);
376: --

Line 377: hr_api.mandatory_arg_error

373: (p_api_name => l_proc,
374: p_argument => 'validation_start_date',
375: p_argument_value => p_validation_start_date);
376: --
377: hr_api.mandatory_arg_error
378: (p_api_name => l_proc,
379: p_argument => 'validation_end_date',
380: p_argument_value => p_validation_end_date);
381: --

Line 382: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

378: (p_api_name => l_proc,
379: p_argument => 'validation_end_date',
380: p_argument_value => p_validation_end_date);
381: --
382: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
383: NOT (dt_api.check_min_max_dates
384: (p_base_table_name => 'ben_pgm_f',
385: p_base_key_column => 'pgm_id',
386: p_base_key_value => p_pgm_id,

Line 392: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and

388: p_to_date => p_validation_end_date))) Then
389: l_table_name := 'ben_pgm_f';
390: Raise l_integrity_error;
391: End If;
392: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
393: NOT (dt_api.check_min_max_dates
394: (p_base_table_name => 'ben_pl_f',
395: p_base_key_column => 'pl_id',
396: p_base_key_value => p_pl_id,

Line 476: hr_api.mandatory_arg_error

472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --
474: -- Ensure that the p_datetrack_mode argument is not null
475: --
476: hr_api.mandatory_arg_error
477: (p_api_name => l_proc,
478: p_argument => 'datetrack_mode',
479: p_argument_value => p_datetrack_mode);
480: --

Line 490: hr_api.mandatory_arg_error

486: --
487: --
488: -- Ensure the arguments are not null
489: --
490: hr_api.mandatory_arg_error
491: (p_api_name => l_proc,
492: p_argument => 'validation_start_date',
493: p_argument_value => p_validation_start_date);
494: --

Line 495: hr_api.mandatory_arg_error

491: (p_api_name => l_proc,
492: p_argument => 'validation_start_date',
493: p_argument_value => p_validation_start_date);
494: --
495: hr_api.mandatory_arg_error
496: (p_api_name => l_proc,
497: p_argument => 'validation_end_date',
498: p_argument_value => p_validation_end_date);
499: --

Line 500: hr_api.mandatory_arg_error

496: (p_api_name => l_proc,
497: p_argument => 'validation_end_date',
498: p_argument_value => p_validation_end_date);
499: --
500: hr_api.mandatory_arg_error
501: (p_api_name => l_proc,
502: p_argument => 'popl_actn_typ_id',
503: p_argument_value => p_popl_actn_typ_id);
504: --

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

544: --
545: -- Call all supporting business operations
546: --
547: --
548: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
549: --
550: chk_popl_actn_typ_id
551: (p_popl_actn_typ_id => p_rec.popl_actn_typ_id,
552: p_effective_date => p_effective_date,

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

591: --
592: -- Call all supporting business operations
593: --
594: --
595: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
596: --
597: chk_popl_actn_typ_id
598: (p_popl_actn_typ_id => p_rec.popl_actn_typ_id,
599: p_effective_date => p_effective_date,

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

683: hr_utility.set_location('Entering:'|| l_proc, 10);
684: --
685: -- Ensure that all the mandatory parameter are not null
686: --
687: hr_api.mandatory_arg_error(p_api_name => l_proc,
688: p_argument => 'popl_actn_typ_id',
689: p_argument_value => p_popl_actn_typ_id);
690: --
691: open csr_leg_code;