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

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

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

Line 127: and apld_dpnt_cvg_elig_prfl_id <> nvl(p_apld_dpnt_cvg_elig_prfl_id, hr_api.g_number)

123: cursor chk_unique is
124: select null,effective_start_date
125: from ben_apld_dpnt_cvg_elig_prfl_f
126: where dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
127: and apld_dpnt_cvg_elig_prfl_id <> nvl(p_apld_dpnt_cvg_elig_prfl_id, hr_api.g_number)
128: and (ptip_id = p_ptip_id or pgm_id = p_pgm_id or pl_id = p_pl_id)
129: and business_group_id + 0 = p_business_group_id
130: and p_validation_start_date <= effective_end_date
131: and p_validation_end_date >= effective_start_date

Line 145: <> nvl(ben_ade_shd.g_old_rec.dpnt_cvg_eligy_prfl_id ,hr_api.g_number)

141: p_object_version_number => p_object_version_number);
142: --
143: if (l_api_updating
144: and p_dpnt_cvg_eligy_prfl_id
145: <> nvl(ben_ade_shd.g_old_rec.dpnt_cvg_eligy_prfl_id ,hr_api.g_number)
146: or not l_api_updating) then
147: --
148: -- this value must be unique
149: --

Line 223: <> nvl(ben_ade_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)

219: p_object_version_number => p_object_version_number);
220: --
221: if (l_api_updating
222: and p_mndtry_flag
223: <> nvl(ben_ade_shd.g_old_rec.mndtry_flag,hr_api.g_varchar2)
224: or not l_api_updating)
225: and p_mndtry_flag is not null then
226: --
227: -- check if value of lookup falls within lookup type.

Line 229: if hr_api.not_exists_in_hr_lookups

225: and p_mndtry_flag is not null then
226: --
227: -- check if value of lookup falls within lookup type.
228: --
229: if hr_api.not_exists_in_hr_lookups
230: (p_lookup_type => 'YES_NO',
231: p_lookup_code => p_mndtry_flag,
232: p_effective_date => p_effective_date) then
233: --

Line 310: and nvl(p_apld_dpnt_cvg_elig_rl,hr_api.g_number)

306: p_effective_date => p_effective_date,
307: p_object_version_number => p_object_version_number);
308: --
309: if (l_api_updating
310: and nvl(p_apld_dpnt_cvg_elig_rl,hr_api.g_number)
311: <> ben_ade_shd.g_old_rec.apld_dpnt_cvg_elig_rl
312: or not l_api_updating)
313: and p_apld_dpnt_cvg_elig_rl is not null then
314: --

Line 372: (p_apld_dpnt_cvg_elig_rl in number default hr_api.g_number,

368: --
369: -- {End Of Comments}
370: -- ----------------------------------------------------------------------------
371: Procedure dt_update_validate
372: (p_apld_dpnt_cvg_elig_rl in number default hr_api.g_number,
373: p_pgm_id in number default hr_api.g_number,
374: p_ptip_id in number default hr_api.g_number,
375: p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,
376: p_pl_id in number default hr_api.g_number,

Line 373: p_pgm_id in number default hr_api.g_number,

369: -- {End Of Comments}
370: -- ----------------------------------------------------------------------------
371: Procedure dt_update_validate
372: (p_apld_dpnt_cvg_elig_rl in number default hr_api.g_number,
373: p_pgm_id in number default hr_api.g_number,
374: p_ptip_id in number default hr_api.g_number,
375: p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,
376: p_pl_id in number default hr_api.g_number,
377: p_datetrack_mode in varchar2,

Line 374: p_ptip_id in number default hr_api.g_number,

370: -- ----------------------------------------------------------------------------
371: Procedure dt_update_validate
372: (p_apld_dpnt_cvg_elig_rl in number default hr_api.g_number,
373: p_pgm_id in number default hr_api.g_number,
374: p_ptip_id in number default hr_api.g_number,
375: p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,
376: p_pl_id in number default hr_api.g_number,
377: p_datetrack_mode in varchar2,
378: p_validation_start_date in date,

Line 375: p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,

371: Procedure dt_update_validate
372: (p_apld_dpnt_cvg_elig_rl in number default hr_api.g_number,
373: p_pgm_id in number default hr_api.g_number,
374: p_ptip_id in number default hr_api.g_number,
375: p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,
376: p_pl_id in number default hr_api.g_number,
377: p_datetrack_mode in varchar2,
378: p_validation_start_date in date,
379: p_validation_end_date in date) Is

Line 376: p_pl_id in number default hr_api.g_number,

372: (p_apld_dpnt_cvg_elig_rl in number default hr_api.g_number,
373: p_pgm_id in number default hr_api.g_number,
374: p_ptip_id in number default hr_api.g_number,
375: p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,
376: p_pl_id in number default hr_api.g_number,
377: p_datetrack_mode in varchar2,
378: p_validation_start_date in date,
379: p_validation_end_date in date) Is
380: --

Line 390: hr_api.mandatory_arg_error

386: hr_utility.set_location('Entering:'||l_proc, 5);
387: --
388: -- Ensure that the p_datetrack_mode argument is not null
389: --
390: hr_api.mandatory_arg_error
391: (p_api_name => l_proc,
392: p_argument => 'datetrack_mode',
393: p_argument_value => p_datetrack_mode);
394: --

Line 402: hr_api.mandatory_arg_error

398: --
399: --
400: -- Ensure the arguments are not null
401: --
402: hr_api.mandatory_arg_error
403: (p_api_name => l_proc,
404: p_argument => 'validation_start_date',
405: p_argument_value => p_validation_start_date);
406: --

Line 407: hr_api.mandatory_arg_error

403: (p_api_name => l_proc,
404: p_argument => 'validation_start_date',
405: p_argument_value => p_validation_start_date);
406: --
407: hr_api.mandatory_arg_error
408: (p_api_name => l_proc,
409: p_argument => 'validation_end_date',
410: p_argument_value => p_validation_end_date);
411: --

Line 412: If ((nvl(p_apld_dpnt_cvg_elig_rl, hr_api.g_number) <> hr_api.g_number) and

408: (p_api_name => l_proc,
409: p_argument => 'validation_end_date',
410: p_argument_value => p_validation_end_date);
411: --
412: If ((nvl(p_apld_dpnt_cvg_elig_rl, hr_api.g_number) <> hr_api.g_number) and
413: NOT (dt_api.check_min_max_dates
414: (p_base_table_name => 'ff_formulas_f',
415: p_base_key_column => 'formula_id',
416: p_base_key_value => p_apld_dpnt_cvg_elig_rl,

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

418: p_to_date => p_validation_end_date))) Then
419: l_table_name := 'ff_formulas_f';
420: Raise l_integrity_error;
421: End If;
422: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
423: NOT (dt_api.check_min_max_dates
424: (p_base_table_name => 'ben_pgm_f',
425: p_base_key_column => 'pgm_id',
426: p_base_key_value => p_pgm_id,

Line 432: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and

428: p_to_date => p_validation_end_date))) Then
429: l_table_name := 'ben_pgm_f';
430: Raise l_integrity_error;
431: End If;
432: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
433: NOT (dt_api.check_min_max_dates
434: (p_base_table_name => 'ben_ptip_f',
435: p_base_key_column => 'ptip_id',
436: p_base_key_value => p_ptip_id,

Line 442: If ((nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

438: p_to_date => p_validation_end_date))) Then
439: l_table_name := 'ben_ptip_f';
440: Raise l_integrity_error;
441: End If;
442: If ((nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
443: NOT (dt_api.check_min_max_dates
444: (p_base_table_name => 'ben_dpnt_cvg_eligy_prfl_f',
445: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
446: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,

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

448: p_to_date => p_validation_end_date))) Then
449: l_table_name := 'ben_dpnt_cvg_eligy_prfl_f';
450: Raise l_integrity_error;
451: End If;
452: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
453: NOT (dt_api.check_min_max_dates
454: (p_base_table_name => 'ben_pl_f',
455: p_base_key_column => 'pl_id',
456: p_base_key_value => p_pl_id,

Line 534: hr_api.mandatory_arg_error

530: hr_utility.set_location('Entering:'||l_proc, 5);
531: --
532: -- Ensure that the p_datetrack_mode argument is not null
533: --
534: hr_api.mandatory_arg_error
535: (p_api_name => l_proc,
536: p_argument => 'datetrack_mode',
537: p_argument_value => p_datetrack_mode);
538: --

Line 548: hr_api.mandatory_arg_error

544: --
545: --
546: -- Ensure the arguments are not null
547: --
548: hr_api.mandatory_arg_error
549: (p_api_name => l_proc,
550: p_argument => 'validation_start_date',
551: p_argument_value => p_validation_start_date);
552: --

Line 553: hr_api.mandatory_arg_error

549: (p_api_name => l_proc,
550: p_argument => 'validation_start_date',
551: p_argument_value => p_validation_start_date);
552: --
553: hr_api.mandatory_arg_error
554: (p_api_name => l_proc,
555: p_argument => 'validation_end_date',
556: p_argument_value => p_validation_end_date);
557: --

Line 558: hr_api.mandatory_arg_error

554: (p_api_name => l_proc,
555: p_argument => 'validation_end_date',
556: p_argument_value => p_validation_end_date);
557: --
558: hr_api.mandatory_arg_error
559: (p_api_name => l_proc,
560: p_argument => 'apld_dpnt_cvg_elig_prfl_id',
561: p_argument_value => p_apld_dpnt_cvg_elig_prfl_id);
562: --

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

600: --
601: -- Call all supporting business operations
602: --
603: --
604: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
605: --
606: chk_apld_dpnt_cvg_elig_prfl_id
607: (p_apld_dpnt_cvg_elig_prfl_id => p_rec.apld_dpnt_cvg_elig_prfl_id,
608: p_effective_date => p_effective_date,

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

653: --
654: -- Call all supporting business operations
655: --
656: --
657: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
658: --
659: chk_apld_dpnt_cvg_elig_prfl_id
660: (p_apld_dpnt_cvg_elig_prfl_id => p_rec.apld_dpnt_cvg_elig_prfl_id,
661: p_effective_date => p_effective_date,

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

754: hr_utility.set_location('Entering:'|| l_proc, 10);
755: --
756: -- Ensure that all the mandatory parameter are not null
757: --
758: hr_api.mandatory_arg_error(p_api_name => l_proc,
759: p_argument => 'apld_dpnt_cvg_elig_prfl_id',
760: p_argument_value => p_apld_dpnt_cvg_elig_prfl_id);
761: --
762: open csr_leg_code;