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

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

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

Line 128: and dpnt_othr_ptip_rt_id <> nvl(p_dpnt_othr_ptip_rt_id,hr_api.g_number)

124: select null
125: from ben_dpnt_othr_ptip_rt_f
126: where ptip_id = p_ptip_id
127: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
128: and dpnt_othr_ptip_rt_id <> nvl(p_dpnt_othr_ptip_rt_id,hr_api.g_number)
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;
132: --

Line 143: and p_ptip_id <> nvl(ben_dot_shd.g_old_rec.ptip_id,hr_api.g_number)

139: p_effective_date => p_effective_date,
140: p_object_version_number => p_object_version_number);
141: --
142: if (l_api_updating
143: and p_ptip_id <> nvl(ben_dot_shd.g_old_rec.ptip_id,hr_api.g_number)
144: or not l_api_updating) then
145:
146: open c_dup;
147: fetch c_dup into l_exists;

Line 213: <> nvl(ben_dot_shd.g_old_rec.excld_flag,hr_api.g_varchar2)

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

Line 219: if hr_api.not_exists_in_hr_lookups

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

Line 339: p_vrbl_rt_prfl_id in number default hr_api.g_number,

335: -- {End Of Comments}
336: -- ----------------------------------------------------------------------------
337: Procedure dt_update_validate
338: (
339: p_vrbl_rt_prfl_id in number default hr_api.g_number,
340: p_ptip_id in number default hr_api.g_number,
341: p_datetrack_mode in varchar2,
342: p_validation_start_date in date,
343: p_validation_end_date in date) Is

Line 340: p_ptip_id in number default hr_api.g_number,

336: -- ----------------------------------------------------------------------------
337: Procedure dt_update_validate
338: (
339: p_vrbl_rt_prfl_id in number default hr_api.g_number,
340: p_ptip_id in number default hr_api.g_number,
341: p_datetrack_mode in varchar2,
342: p_validation_start_date in date,
343: p_validation_end_date in date) Is
344: --

Line 354: hr_api.mandatory_arg_error

350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: -- Ensure that the p_datetrack_mode argument is not null
353: --
354: hr_api.mandatory_arg_error
355: (p_api_name => l_proc,
356: p_argument => 'datetrack_mode',
357: p_argument_value => p_datetrack_mode);
358: --

Line 366: hr_api.mandatory_arg_error

362: --
363: --
364: -- Ensure the arguments are not null
365: --
366: hr_api.mandatory_arg_error
367: (p_api_name => l_proc,
368: p_argument => 'validation_start_date',
369: p_argument_value => p_validation_start_date);
370: --

Line 371: hr_api.mandatory_arg_error

367: (p_api_name => l_proc,
368: p_argument => 'validation_start_date',
369: p_argument_value => p_validation_start_date);
370: --
371: hr_api.mandatory_arg_error
372: (p_api_name => l_proc,
373: p_argument => 'validation_end_date',
374: p_argument_value => p_validation_end_date);
375: --

Line 376: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and

372: (p_api_name => l_proc,
373: p_argument => 'validation_end_date',
374: p_argument_value => p_validation_end_date);
375: --
376: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
377: NOT (dt_api.check_min_max_dates
378: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
379: p_base_key_column => 'vrbl_rt_prfl_id',
380: p_base_key_value => p_vrbl_rt_prfl_id,

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

382: p_to_date => p_validation_end_date))) Then
383: l_table_name := 'ben_vrbl_rt_prfl_f';
384: Raise l_integrity_error;
385: End If;
386: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
387: NOT (dt_api.check_min_max_dates
388: (p_base_table_name => 'ben_ptip_f',
389: p_base_key_column => 'ptip_id',
390: p_base_key_value => p_ptip_id,

Line 468: hr_api.mandatory_arg_error

464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: -- Ensure that the p_datetrack_mode argument is not null
467: --
468: hr_api.mandatory_arg_error
469: (p_api_name => l_proc,
470: p_argument => 'datetrack_mode',
471: p_argument_value => p_datetrack_mode);
472: --

Line 482: hr_api.mandatory_arg_error

478: --
479: --
480: -- Ensure the arguments are not null
481: --
482: hr_api.mandatory_arg_error
483: (p_api_name => l_proc,
484: p_argument => 'validation_start_date',
485: p_argument_value => p_validation_start_date);
486: --

Line 487: hr_api.mandatory_arg_error

483: (p_api_name => l_proc,
484: p_argument => 'validation_start_date',
485: p_argument_value => p_validation_start_date);
486: --
487: hr_api.mandatory_arg_error
488: (p_api_name => l_proc,
489: p_argument => 'validation_end_date',
490: p_argument_value => p_validation_end_date);
491: --

Line 492: hr_api.mandatory_arg_error

488: (p_api_name => l_proc,
489: p_argument => 'validation_end_date',
490: p_argument_value => p_validation_end_date);
491: --
492: hr_api.mandatory_arg_error
493: (p_api_name => l_proc,
494: p_argument => 'dpnt_othr_ptip_rt_id',
495: p_argument_value => p_dpnt_othr_ptip_rt_id);
496: --

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

564: ,p_validation_end_date => p_validation_end_date
565: ,p_business_group_id => p_rec.business_group_id);
566:
567: --
568: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
569: --
570: hr_utility.set_location(' Leaving:'||l_proc, 10);
571: End insert_validate;
572: --

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

617: ,p_validation_end_date => p_validation_end_date
618: ,p_business_group_id => p_rec.business_group_id);
619:
620: --
621: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
622: --
623: -- Call the datetrack update integrity operation
624: --
625: dt_update_validate

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

686: hr_utility.set_location('Entering:'|| l_proc, 10);
687: --
688: -- Ensure that all the mandatory parameter are not null
689: --
690: hr_api.mandatory_arg_error(p_api_name => l_proc,
691: p_argument => 'dpnt_othr_ptip_rt_id',
692: p_argument_value => p_dpnt_othr_ptip_rt_id);
693: --
694: open csr_leg_code;