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

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

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

Line 124: <> nvl(ben_edg_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_enrl_det_dt_cd
124: <> nvl(ben_edg_shd.g_old_rec.enrl_det_dt_cd,hr_api.g_varchar2)
125: or not l_api_updating)
126: and p_enrl_det_dt_cd 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_enrl_det_dt_cd 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 => 'BEN_ENRL_DET_DT',
132: p_lookup_code => p_enrl_det_dt_cd,
133: p_effective_date => p_effective_date) then
134: --

Line 195: <> nvl(ben_edg_shd.g_old_rec.only_pls_subj_cobra_flag,hr_api.g_varchar2)

191: p_object_version_number => p_object_version_number);
192: --
193: if (l_api_updating
194: and p_only_pls_subj_cobra_flag
195: <> nvl(ben_edg_shd.g_old_rec.only_pls_subj_cobra_flag,hr_api.g_varchar2)
196: or not l_api_updating) then
197: --
198: -- check if value of lookup falls within lookup type.
199: --

Line 201: if hr_api.not_exists_in_hr_lookups

197: --
198: -- check if value of lookup falls within lookup type.
199: --
200: --
201: if hr_api.not_exists_in_hr_lookups
202: (p_lookup_type => 'YES_NO',
203: p_lookup_code => p_only_pls_subj_cobra_flag,
204: p_effective_date => p_effective_date) then
205: --

Line 266: <> nvl(ben_edg_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

262: p_object_version_number => p_object_version_number);
263: --
264: if (l_api_updating
265: and p_excld_flag
266: <> nvl(ben_edg_shd.g_old_rec.excld_flag,hr_api.g_varchar2)
267: or not l_api_updating) then
268: --
269: -- check if value of lookup falls within lookup type.
270: --

Line 272: if hr_api.not_exists_in_hr_lookups

268: --
269: -- check if value of lookup falls within lookup type.
270: --
271: --
272: if hr_api.not_exists_in_hr_lookups
273: (p_lookup_type => 'YES_NO',
274: p_lookup_code => p_excld_flag,
275: p_effective_date => p_effective_date) then
276: --

Line 380: (p_eligy_prfl_id in number default hr_api.g_number,

376: --
377: -- {End Of Comments}
378: -- ----------------------------------------------------------------------------
379: Procedure dt_update_validate
380: (p_eligy_prfl_id in number default hr_api.g_number,
381: p_pgm_id in number default hr_api.g_number,
382: p_datetrack_mode in varchar2,
383: p_validation_start_date in date,
384: p_validation_end_date in date) Is

Line 381: p_pgm_id in number default hr_api.g_number,

377: -- {End Of Comments}
378: -- ----------------------------------------------------------------------------
379: Procedure dt_update_validate
380: (p_eligy_prfl_id in number default hr_api.g_number,
381: p_pgm_id in number default hr_api.g_number,
382: p_datetrack_mode in varchar2,
383: p_validation_start_date in date,
384: p_validation_end_date in date) Is
385: --

Line 395: hr_api.mandatory_arg_error

391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: -- Ensure that the p_datetrack_mode argument is not null
394: --
395: hr_api.mandatory_arg_error
396: (p_api_name => l_proc,
397: p_argument => 'datetrack_mode',
398: p_argument_value => p_datetrack_mode);
399: --

Line 407: hr_api.mandatory_arg_error

403: --
404: --
405: -- Ensure the arguments are not null
406: --
407: hr_api.mandatory_arg_error
408: (p_api_name => l_proc,
409: p_argument => 'validation_start_date',
410: p_argument_value => p_validation_start_date);
411: --

Line 412: hr_api.mandatory_arg_error

408: (p_api_name => l_proc,
409: p_argument => 'validation_start_date',
410: p_argument_value => p_validation_start_date);
411: --
412: hr_api.mandatory_arg_error
413: (p_api_name => l_proc,
414: p_argument => 'validation_end_date',
415: p_argument_value => p_validation_end_date);
416: --

Line 417: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

413: (p_api_name => l_proc,
414: p_argument => 'validation_end_date',
415: p_argument_value => p_validation_end_date);
416: --
417: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
418: NOT (dt_api.check_min_max_dates
419: (p_base_table_name => 'ben_eligy_prfl_f',
420: p_base_key_column => 'eligy_prfl_id',
421: p_base_key_value => p_eligy_prfl_id,

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

423: p_to_date => p_validation_end_date))) Then
424: l_table_name := 'ben_eligy_prfl_f';
425: Raise l_integrity_error;
426: End If;
427: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
428: NOT (dt_api.check_min_max_dates
429: (p_base_table_name => 'ben_pgm_f',
430: p_base_key_column => 'pgm_id',
431: p_base_key_value => p_pgm_id,

Line 510: hr_api.mandatory_arg_error

506: hr_utility.set_location('Entering:'||l_proc, 5);
507: --
508: -- Ensure that the p_datetrack_mode argument is not null
509: --
510: hr_api.mandatory_arg_error
511: (p_api_name => l_proc,
512: p_argument => 'datetrack_mode',
513: p_argument_value => p_datetrack_mode);
514: --

Line 524: hr_api.mandatory_arg_error

520: --
521: --
522: -- Ensure the arguments are not null
523: --
524: hr_api.mandatory_arg_error
525: (p_api_name => l_proc,
526: p_argument => 'validation_start_date',
527: p_argument_value => p_validation_start_date);
528: --

Line 529: hr_api.mandatory_arg_error

525: (p_api_name => l_proc,
526: p_argument => 'validation_start_date',
527: p_argument_value => p_validation_start_date);
528: --
529: hr_api.mandatory_arg_error
530: (p_api_name => l_proc,
531: p_argument => 'validation_end_date',
532: p_argument_value => p_validation_end_date);
533: --

Line 534: hr_api.mandatory_arg_error

530: (p_api_name => l_proc,
531: p_argument => 'validation_end_date',
532: p_argument_value => p_validation_end_date);
533: --
534: hr_api.mandatory_arg_error
535: (p_api_name => l_proc,
536: p_argument => 'elig_dpnt_cvrd_othr_pgm_id',
537: p_argument_value => p_elig_dpnt_cvrd_othr_pgm_id);
538: --

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

578: --
579: -- Call all supporting business operations
580: --
581: --
582: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
583: --
584: chk_elig_dpnt_cvrd_othr_pgm_id
585: (p_elig_dpnt_cvrd_othr_pgm_id => p_rec.elig_dpnt_cvrd_othr_pgm_id,
586: p_effective_date => p_effective_date,

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

630: --
631: -- Call all supporting business operations
632: --
633: --
634: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
635: --
636: chk_elig_dpnt_cvrd_othr_pgm_id
637: (p_elig_dpnt_cvrd_othr_pgm_id => p_rec.elig_dpnt_cvrd_othr_pgm_id,
638: p_effective_date => p_effective_date,

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

727: hr_utility.set_location('Entering:'|| l_proc, 10);
728: --
729: -- Ensure that all the mandatory parameter are not null
730: --
731: hr_api.mandatory_arg_error(p_api_name => l_proc,
732: p_argument => 'elig_dpnt_cvrd_othr_pgm_id',
733: p_argument_value => p_elig_dpnt_cvrd_othr_pgm_id);
734: --
735: open csr_leg_code;