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_MTR_BUS dependencies on BEN_MTR_SHD

Line 48: l_api_updating := ben_mtr_shd.api_updating

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

Line 55: <> ben_mtr_shd.g_old_rec.mtchg_rt_id) then

51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_mtchg_rt_id,hr_api.g_number)
55: <> ben_mtr_shd.g_old_rec.mtchg_rt_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_mtr_shd.constraint_error('BEN_MTCHG_RT_PK');

Line 59: ben_mtr_shd.constraint_error('BEN_MTCHG_RT_PK');

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

Line 69: ben_mtr_shd.constraint_error('BEN_MTCHG_RT_PK');

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

Line 123: l_api_updating := ben_mtr_shd.api_updating

119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_mtr_shd.api_updating
124: (p_mtchg_rt_id => p_mtchg_rt_id,
125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --

Line 130: <> nvl(ben_mtr_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (p_comp_lvl_fctr_id is not null) and (l_api_updating
129: and nvl(p_comp_lvl_fctr_id,hr_api.g_number)
130: <> nvl(ben_mtr_shd.g_old_rec.comp_lvl_fctr_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if comp_lvl_fctr_id value exists in ben_comp_lvl_fctr table
134: --

Line 145: ben_mtr_shd.constraint_error('BEN_MTCHG_RT_DT2');

141: --
142: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr
143: -- table.
144: --
145: ben_mtr_shd.constraint_error('BEN_MTCHG_RT_DT2');
146: --
147: end if;
148: --
149: close c1;

Line 195: l_api_updating := ben_mtr_shd.api_updating

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

Line 202: <> nvl(ben_mtr_shd.g_old_rec.no_mx_pct_of_py_num_flag,hr_api.g_varchar2)

198: p_object_version_number => p_object_version_number);
199: --
200: if (l_api_updating
201: and p_no_mx_pct_of_py_num_flag
202: <> nvl(ben_mtr_shd.g_old_rec.no_mx_pct_of_py_num_flag,hr_api.g_varchar2)
203: or not l_api_updating) then
204: --
205: -- check if value of lookup falls within lookup type.
206: --

Line 264: l_api_updating := ben_mtr_shd.api_updating

260: Begin
261: --
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: l_api_updating := ben_mtr_shd.api_updating
265: (p_mtchg_rt_id => p_mtchg_rt_id,
266: p_effective_date => p_effective_date,
267: p_object_version_number => p_object_version_number);
268: --

Line 271: <> nvl(ben_mtr_shd.g_old_rec.no_mx_mtch_amt_flag,hr_api.g_varchar2)

267: p_object_version_number => p_object_version_number);
268: --
269: if (l_api_updating
270: and p_no_mx_mtch_amt_flag
271: <> nvl(ben_mtr_shd.g_old_rec.no_mx_mtch_amt_flag,hr_api.g_varchar2)
272: or not l_api_updating) then
273: --
274: -- check if value of lookup falls within lookup type.
275: --

Line 350: l_api_updating := ben_mtr_shd.api_updating

346: Begin
347: --
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: --
350: l_api_updating := ben_mtr_shd.api_updating
351: (p_mtchg_rt_id => p_mtchg_rt_id,
352: p_effective_date => p_effective_date,
353: p_object_version_number => p_object_version_number);
354: --

Line 357: <> ben_mtr_shd.g_old_rec.mtchg_rt_calc_rl

353: p_object_version_number => p_object_version_number);
354: --
355: if (l_api_updating
356: and nvl(p_mtchg_rt_calc_rl,hr_api.g_number)
357: <> ben_mtr_shd.g_old_rec.mtchg_rt_calc_rl
358: or not l_api_updating)
359: and p_mtchg_rt_calc_rl is not null then
360: --
361: -- check if value of formula rule is valid.

Line 428: l_api_updating := ben_mtr_shd.api_updating

424: Begin
425: --
426: hr_utility.set_location('Entering:'||l_proc, 5);
427: --
428: l_api_updating := ben_mtr_shd.api_updating
429: (p_mtchg_rt_id => p_mtchg_rt_id,
430: p_effective_date => p_effective_date,
431: p_object_version_number => p_object_version_number);
432: --

Line 435: <> nvl(ben_mtr_shd.g_old_rec.no_mx_amt_of_py_num_flag,hr_api.g_varchar2)

431: p_object_version_number => p_object_version_number);
432: --
433: if (l_api_updating
434: and p_no_mx_amt_of_py_num_flag
435: <> nvl(ben_mtr_shd.g_old_rec.no_mx_amt_of_py_num_flag,hr_api.g_varchar2)
436: or not l_api_updating) then
437: --
438: -- check if value of lookup falls within lookup type.
439: --

Line 497: l_api_updating := ben_mtr_shd.api_updating

493: Begin
494: --
495: hr_utility.set_location('Entering:'||l_proc, 5);
496: --
497: l_api_updating := ben_mtr_shd.api_updating
498: (p_mtchg_rt_id => p_mtchg_rt_id,
499: p_effective_date => p_effective_date,
500: p_object_version_number => p_object_version_number);
501: --

Line 504: <> nvl(ben_mtr_shd.g_old_rec.cntnu_mtch_aftr_mx_rl_flag,hr_api.g_varchar2)

500: p_object_version_number => p_object_version_number);
501: --
502: if (l_api_updating
503: and p_cntnu_mtch_aftr_mx_rl_flag
504: <> nvl(ben_mtr_shd.g_old_rec.cntnu_mtch_aftr_mx_rl_flag,hr_api.g_varchar2)
505: or not l_api_updating) then
506: --
507: -- check if value of lookup falls within lookup type.
508: --

Line 572: l_api_updating := ben_mtr_shd.api_updating

568: Begin
569: --
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: l_api_updating := ben_mtr_shd.api_updating
573: (p_mtchg_rt_id => p_mtchg_rt_id,
574: p_effective_date => p_effective_date,
575: p_object_version_number => p_object_version_number);
576: --

Line 640: l_api_updating := ben_mtr_shd.api_updating

636: --
637: hr_utility.set_location('Entering:'||l_proc, 5);
638: --
639:
640: l_api_updating := ben_mtr_shd.api_updating
641: (p_mtchg_rt_id => p_mtchg_rt_id,
642: p_effective_date => p_effective_date,
643: p_object_version_number => p_object_version_number);
644: --

Line 979: (p_rec in ben_mtr_shd.g_rec_type,

975: -- ----------------------------------------------------------------------------
976: -- |---------------------------< insert_validate >----------------------------|
977: -- ----------------------------------------------------------------------------
978: Procedure insert_validate
979: (p_rec in ben_mtr_shd.g_rec_type,
980: p_effective_date in date,
981: p_datetrack_mode in varchar2,
982: p_validation_start_date in date,
983: p_validation_end_date in date) is

Line 1066: (p_rec in ben_mtr_shd.g_rec_type,

1062: -- ----------------------------------------------------------------------------
1063: -- |---------------------------< update_validate >----------------------------|
1064: -- ----------------------------------------------------------------------------
1065: Procedure update_validate
1066: (p_rec in ben_mtr_shd.g_rec_type,
1067: p_effective_date in date,
1068: p_datetrack_mode in varchar2,
1069: p_validation_start_date in date,
1070: p_validation_end_date in date) is

Line 1162: (p_rec in ben_mtr_shd.g_rec_type,

1158: -- ----------------------------------------------------------------------------
1159: -- |---------------------------< delete_validate >----------------------------|
1160: -- ----------------------------------------------------------------------------
1161: Procedure delete_validate
1162: (p_rec in ben_mtr_shd.g_rec_type,
1163: p_effective_date in date,
1164: p_datetrack_mode in varchar2,
1165: p_validation_start_date in date,
1166: p_validation_end_date in date) is