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 BEN_PDL_SHD

Line 48: l_api_updating := ben_pdl_shd.api_updating

44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_pdl_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ptd_lmt_id => p_ptd_lmt_id,
51: p_object_version_number => p_object_version_number);
52: --

Line 55: <> ben_pdl_shd.g_old_rec.ptd_lmt_id) then

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: --
59: ben_pdl_shd.constraint_error('BEN_PTD_LMT_F_PK');

Line 59: ben_pdl_shd.constraint_error('BEN_PTD_LMT_F_PK');

55: <> ben_pdl_shd.g_old_rec.ptd_lmt_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_pdl_shd.constraint_error('BEN_PTD_LMT_F_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_pdl_shd.constraint_error('BEN_PTD_LMT_F_PK');

65: if p_ptd_lmt_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_pdl_shd.constraint_error('BEN_PTD_LMT_F_PK');
70: --
71: end if;
72: --
73: end if;

Line 129: l_api_updating := ben_pdl_shd.api_updating

125: --
126: Begin
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: l_api_updating := ben_pdl_shd.api_updating
130: (p_ptd_lmt_id => p_ptd_lmt_id,
131: p_effective_date => p_effective_date,
132: p_object_version_number => p_object_version_number);
133: --

Line 195: l_api_updating := ben_pdl_shd.api_updating

191: Begin
192: --
193: hr_utility.set_location('Entering:'||l_proc,5);
194: --
195: l_api_updating := ben_pdl_shd.api_updating
196: (p_effective_date => p_effective_date,
197: p_ptd_lmt_id => p_ptd_lmt_id,
198: p_object_version_number => p_object_version_number);
199: --

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 218: ben_pdl_shd.constraint_error('BEN_PTD_LMT_F_FK2');

214: --
215: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr
216: -- table.
217: --
218: ben_pdl_shd.constraint_error('BEN_PTD_LMT_F_FK2');
219: --
220: end if;
221: --
222: close c1;

Line 274: l_api_updating := ben_pdl_shd.api_updating

270: Begin
271: --
272: hr_utility.set_location('Entering:'||l_proc,5);
273: --
274: l_api_updating := ben_pdl_shd.api_updating
275: (p_ptd_lmt_id => p_ptd_lmt_id,
276: p_effective_date => p_effective_date,
277: p_object_version_number => p_object_version_number);
278: --

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 348: l_api_updating := ben_pdl_shd.api_updating

344: Begin
345: --
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: l_api_updating := ben_pdl_shd.api_updating
349: (p_ptd_lmt_id => p_ptd_lmt_id,
350: p_effective_date => p_effective_date,
351: p_object_version_number => p_object_version_number);
352: --

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 436: l_api_updating := ben_pdl_shd.api_updating

432: Begin
433: --
434: hr_utility.set_location('Entering:'||l_proc, 5);
435: --
436: l_api_updating := ben_pdl_shd.api_updating
437: (p_ptd_lmt_id => p_ptd_lmt_id,
438: p_effective_date => p_effective_date,
439: p_object_version_number => p_object_version_number);
440: --

Line 443: <> ben_pdl_shd.g_old_rec.ptd_lmt_calc_rl

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: --
447: -- check if value of formula rule is valid.

Line 681: (p_rec in ben_pdl_shd.g_rec_type,

677: -- ----------------------------------------------------------------------------
678: -- |---------------------------< insert_validate >----------------------------|
679: -- ----------------------------------------------------------------------------
680: Procedure insert_validate
681: (p_rec in ben_pdl_shd.g_rec_type,
682: p_effective_date in date,
683: p_datetrack_mode in varchar2,
684: p_validation_start_date in date,
685: p_validation_end_date in date) is

Line 739: (p_rec in ben_pdl_shd.g_rec_type,

735: -- ----------------------------------------------------------------------------
736: -- |---------------------------< update_validate >----------------------------|
737: -- ----------------------------------------------------------------------------
738: Procedure update_validate
739: (p_rec in ben_pdl_shd.g_rec_type,
740: p_effective_date in date,
741: p_datetrack_mode in varchar2,
742: p_validation_start_date in date,
743: p_validation_end_date in date) is

Line 805: (p_rec in ben_pdl_shd.g_rec_type,

801: -- ----------------------------------------------------------------------------
802: -- |---------------------------< delete_validate >----------------------------|
803: -- ----------------------------------------------------------------------------
804: Procedure delete_validate
805: (p_rec in ben_pdl_shd.g_rec_type,
806: p_effective_date in date,
807: p_datetrack_mode in varchar2,
808: p_validation_start_date in date,
809: p_validation_end_date in date) is