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

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

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

Line 119: Where a.ptd_lmt_id <> nvl(p_ptd_lmt_id,hr_api.g_number)

115: l_dummy char(1);
116: l_api_updating boolean;
117: cursor c1 is select null
118: from ben_ptd_lmt_f a
119: Where a.ptd_lmt_id <> nvl(p_ptd_lmt_id,hr_api.g_number)
120: and a.name = p_name
121: and a.business_group_id + 0 = p_business_group_id
122: and p_effective_date
123: between a.effective_start_date

Line 135: and nvl(p_name,hr_api.g_varchar2)

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_name,hr_api.g_varchar2)
136: <> ben_pln_shd.g_old_rec.name
137: or not l_api_updating) then
138: --
139: open c1;

Line 201: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)

197: p_ptd_lmt_id => p_ptd_lmt_id,
198: p_object_version_number => p_object_version_number);
199: --
200: if (l_api_updating
201: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
202: <> nvl(ben_pdl_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
203: or not l_api_updating) and
204: p_comp_lvl_fctr_id is not null then
205: --

Line 202: <> nvl(ben_pdl_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)

198: p_object_version_number => p_object_version_number);
199: --
200: if (l_api_updating
201: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
202: <> nvl(ben_pdl_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
203: or not l_api_updating) and
204: p_comp_lvl_fctr_id is not null then
205: --
206: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table

Line 280: and nvl(p_balance_type_id,hr_api.g_number)

276: p_effective_date => p_effective_date,
277: p_object_version_number => p_object_version_number);
278: --
279: if (l_api_updating
280: and nvl(p_balance_type_id,hr_api.g_number)
281: <> nvl(ben_pdl_shd.g_old_rec.balance_type_id,hr_api.g_number)
282: or not l_api_updating) and
283: p_balance_type_id is not null then
284: --

Line 281: <> nvl(ben_pdl_shd.g_old_rec.balance_type_id,hr_api.g_number)

277: p_object_version_number => p_object_version_number);
278: --
279: if (l_api_updating
280: and nvl(p_balance_type_id,hr_api.g_number)
281: <> nvl(ben_pdl_shd.g_old_rec.balance_type_id,hr_api.g_number)
282: or not l_api_updating) and
283: p_balance_type_id is not null then
284: --
285: -- check if balance_type_id value exists in pay_balance_types table

Line 355: <> nvl(ben_pdl_shd.g_old_rec.lmt_det_cd,hr_api.g_varchar2)

351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and p_lmt_det_cd
355: <> nvl(ben_pdl_shd.g_old_rec.lmt_det_cd,hr_api.g_varchar2)
356: or not l_api_updating) then
357: --
358: -- check if value of lookup falls within lookup type.
359: --

Line 361: if hr_api.not_exists_in_hr_lookups

357: --
358: -- check if value of lookup falls within lookup type.
359: --
360: --
361: if hr_api.not_exists_in_hr_lookups
362: (p_lookup_type => 'BEN_LMT_DET',
363: p_lookup_code => p_lmt_det_cd,
364: p_effective_date => p_effective_date) then
365: --

Line 442: and nvl(p_ptd_lmt_calc_rl,hr_api.g_number)

438: p_effective_date => p_effective_date,
439: p_object_version_number => p_object_version_number);
440: --
441: if (l_api_updating
442: and nvl(p_ptd_lmt_calc_rl,hr_api.g_number)
443: <> ben_pdl_shd.g_old_rec.ptd_lmt_calc_rl
444: or not l_api_updating)
445: and p_ptd_lmt_calc_rl is not null then
446: --

Line 520: hr_api.mandatory_arg_error

516: hr_utility.set_location('Entering:'||l_proc, 5);
517: --
518: -- Ensure that the p_datetrack_mode argument is not null
519: --
520: hr_api.mandatory_arg_error
521: (p_api_name => l_proc,
522: p_argument => 'datetrack_mode',
523: p_argument_value => p_datetrack_mode);
524: --

Line 532: hr_api.mandatory_arg_error

528: --
529: --
530: -- Ensure the arguments are not null
531: --
532: hr_api.mandatory_arg_error
533: (p_api_name => l_proc,
534: p_argument => 'validation_start_date',
535: p_argument_value => p_validation_start_date);
536: --

Line 537: hr_api.mandatory_arg_error

533: (p_api_name => l_proc,
534: p_argument => 'validation_start_date',
535: p_argument_value => p_validation_start_date);
536: --
537: hr_api.mandatory_arg_error
538: (p_api_name => l_proc,
539: p_argument => 'validation_end_date',
540: p_argument_value => p_validation_end_date);
541: --

Line 616: hr_api.mandatory_arg_error

612: hr_utility.set_location('Entering:'||l_proc, 5);
613: --
614: -- Ensure that the p_datetrack_mode argument is not null
615: --
616: hr_api.mandatory_arg_error
617: (p_api_name => l_proc,
618: p_argument => 'datetrack_mode',
619: p_argument_value => p_datetrack_mode);
620: --

Line 630: hr_api.mandatory_arg_error

626: --
627: --
628: -- Ensure the arguments are not null
629: --
630: hr_api.mandatory_arg_error
631: (p_api_name => l_proc,
632: p_argument => 'validation_start_date',
633: p_argument_value => p_validation_start_date);
634: --

Line 635: hr_api.mandatory_arg_error

631: (p_api_name => l_proc,
632: p_argument => 'validation_start_date',
633: p_argument_value => p_validation_start_date);
634: --
635: hr_api.mandatory_arg_error
636: (p_api_name => l_proc,
637: p_argument => 'validation_end_date',
638: p_argument_value => p_validation_end_date);
639: --

Line 640: hr_api.mandatory_arg_error

636: (p_api_name => l_proc,
637: p_argument => 'validation_end_date',
638: p_argument_value => p_validation_end_date);
639: --
640: hr_api.mandatory_arg_error
641: (p_api_name => l_proc,
642: p_argument => 'ptd_lmt_id',
643: p_argument_value => p_ptd_lmt_id);
644: --

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

691: --
692: -- Call all supporting business operations
693: --
694: --
695: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
696: --
697: chk_ptd_lmt_id
698: (p_ptd_lmt_id => p_rec.ptd_lmt_id,
699: p_effective_date => p_effective_date,

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

749: --
750: -- Call all supporting business operations
751: --
752: --
753: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
754: --
755: chk_ptd_lmt_id
756: (p_ptd_lmt_id => p_rec.ptd_lmt_id,
757: p_effective_date => p_effective_date,

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

851: hr_utility.set_location('Entering:'|| l_proc, 10);
852: --
853: -- Ensure that all the mandatory parameter are not null
854: --
855: hr_api.mandatory_arg_error(p_api_name => l_proc,
856: p_argument => 'ptd_lmt_id',
857: p_argument_value => p_ptd_lmt_id);
858: --
859: open csr_leg_code;