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

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

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

Line 124: <> nvl(ben_dpc_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 130: if hr_api.not_exists_in_hr_lookups

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

Line 195: <> nvl(ben_dpc_shd.g_old_rec.cvg_det_dt_cd,hr_api.g_varchar2)

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

Line 201: if hr_api.not_exists_in_hr_lookups

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

Line 382: (p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,

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

Line 383: p_pl_id in number default hr_api.g_number,

379: -- {End Of Comments}
380: -- ----------------------------------------------------------------------------
381: Procedure dt_update_validate
382: (p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,
383: p_pl_id in number default hr_api.g_number,
384: p_datetrack_mode in varchar2,
385: p_validation_start_date in date,
386: p_validation_end_date in date) Is
387: --

Line 397: hr_api.mandatory_arg_error

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

Line 409: hr_api.mandatory_arg_error

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

Line 414: hr_api.mandatory_arg_error

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

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

415: (p_api_name => l_proc,
416: p_argument => 'validation_end_date',
417: p_argument_value => p_validation_end_date);
418: --
419: If ((nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
420: NOT (dt_api.check_min_max_dates
421: (p_base_table_name => 'ben_dpnt_cvg_eligy_prfl_f',
422: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
423: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,

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

425: p_to_date => p_validation_end_date))) Then
426: l_table_name := 'ben_dpnt_cvg_eligy_prfl_f';
427: Raise l_integrity_error;
428: End If;
429: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
430: NOT (dt_api.check_min_max_dates
431: (p_base_table_name => 'ben_pl_f',
432: p_base_key_column => 'pl_id',
433: p_base_key_value => p_pl_id,

Line 511: hr_api.mandatory_arg_error

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

Line 525: hr_api.mandatory_arg_error

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

Line 530: hr_api.mandatory_arg_error

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

Line 535: hr_api.mandatory_arg_error

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

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

579: --
580: -- Call all supporting business operations
581: --
582: --
583: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
584: --
585: chk_duplicate_rows
586: (p_dpnt_cvrd_anthr_pl_cvg_id => p_rec.dpnt_cvrd_anthr_pl_cvg_id,
587: p_pl_id => p_rec.pl_id,

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

636: --
637: -- Call all supporting business operations
638: --
639: --
640: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
641: --
642: chk_duplicate_rows
643: (p_dpnt_cvrd_anthr_pl_cvg_id => p_rec.dpnt_cvrd_anthr_pl_cvg_id,
644: p_pl_id => p_rec.pl_id,

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

738: hr_utility.set_location('Entering:'|| l_proc, 10);
739: --
740: -- Ensure that all the mandatory parameter are not null
741: --
742: hr_api.mandatory_arg_error(p_api_name => l_proc,
743: p_argument => 'dpnt_cvrd_anthr_pl_cvg_id',
744: p_argument_value => p_dpnt_cvrd_anthr_pl_cvg_id);
745: --
746: open csr_leg_code;