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_RGR_BUS dependencies on BEN_RGR_SHD

Line 48: l_api_updating := ben_rgr_shd.api_updating

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

Line 55: <> ben_rgr_shd.g_old_rec.popl_rptg_grp_id) then

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

Line 59: ben_rgr_shd.constraint_error('BEN_POPL_RPTG_GRP_PK');

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

Line 69: ben_rgr_shd.constraint_error('BEN_POPL_RPTG_GRP_PK');

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

Line 193: l_api_updating := ben_rgr_shd.api_updating

189: Begin
190: --
191: hr_utility.set_location('Entering:'||l_proc,5);
192: --
193: l_api_updating := ben_rgr_shd.api_updating
194: (p_popl_rptg_grp_id => p_popl_rptg_grp_id,
195: p_effective_date => p_effective_date,
196: p_object_version_number => p_object_version_number);
197: --

Line 200: <> nvl(ben_rgr_shd.g_old_rec.rptg_grp_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_rptg_grp_id,hr_api.g_number)
200: <> nvl(ben_rgr_shd.g_old_rec.rptg_grp_id,hr_api.g_number)
201: or not l_api_updating)
202: -- and p_rptg_grp_id is not null /* Moved the check condition below bug 2690186 */
203: then
204: --

Line 224: ben_rgr_shd.constraint_error('BEN_POPL_RPTG_GRP_FK1');

220: --
221: -- raise error as FK does not relate to PK in ben_rptg_grp
222: -- table.
223: --
224: ben_rgr_shd.constraint_error('BEN_POPL_RPTG_GRP_FK1');
225: --
226: end if;
227: --
228: close c1;

Line 315: l_api_updating := ben_rgr_shd.api_updating

311: Begin
312: --
313: hr_utility.set_location('Entering:'||l_proc, 5);
314: --
315: l_api_updating := ben_rgr_shd.api_updating
316: (p_effective_date => p_effective_date,
317: p_popl_rptg_grp_id => p_popl_rptg_grp_id,
318: p_object_version_number => p_object_version_number);
319: --

Line 321: and p_pl_id <> ben_rgr_shd.g_old_rec.pl_id) or

317: p_popl_rptg_grp_id => p_popl_rptg_grp_id,
318: p_object_version_number => p_object_version_number);
319: --
320: if (l_api_updating
321: and p_pl_id <> ben_rgr_shd.g_old_rec.pl_id) or
322: not l_api_updating then
323: --
324: hr_utility.set_location('Entering:'||l_proc, 10);
325: --

Line 336: -- ben_rgr_shd.constraint_error('BEN_REGN_UK1');

332: close crs_pl_id;
333: --
334: -- raise error as UK1 is violated
335: --
336: -- ben_rgr_shd.constraint_error('BEN_REGN_UK1');
337: fnd_message.set_name('BEN','BEN_91313_DUP_RPTG_GRP_PL_ID');
338: fnd_message.raise_error;
339: --
340: end if;

Line 436: l_api_updating := ben_rgr_shd.api_updating

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

Line 442: and p_pgm_id <> ben_rgr_shd.g_old_rec.pgm_id) or

438: p_popl_rptg_grp_id => p_popl_rptg_grp_id,
439: p_object_version_number => p_object_version_number);
440: --
441: if (l_api_updating
442: and p_pgm_id <> ben_rgr_shd.g_old_rec.pgm_id) or
443: not l_api_updating then
444: --
445: hr_utility.set_location('Entering:'||l_proc, 10);
446: --

Line 456: -- ben_rgr_shd.constraint_error('BEN_REGN_UK1');

452: close csr_pgm_id;
453: --
454: -- raise error as UK1 is violated
455: --
456: -- ben_rgr_shd.constraint_error('BEN_REGN_UK1');
457: fnd_message.set_name('BEN','BEN_91314_DUP_RPTG_GRP_PGM_ID');
458: fnd_message.raise_error;
459: --
460: end if;

Line 746: (p_rec in ben_rgr_shd.g_rec_type,

742: -- ----------------------------------------------------------------------------
743: -- |---------------------------< insert_validate >----------------------------|
744: -- ----------------------------------------------------------------------------
745: Procedure insert_validate
746: (p_rec in ben_rgr_shd.g_rec_type,
747: p_effective_date in date,
748: p_datetrack_mode in varchar2,
749: p_validation_start_date in date,
750: p_validation_end_date in date) is

Line 813: (p_rec in ben_rgr_shd.g_rec_type,

809: -- ----------------------------------------------------------------------------
810: -- |---------------------------< update_validate >----------------------------|
811: -- ----------------------------------------------------------------------------
812: Procedure update_validate
813: (p_rec in ben_rgr_shd.g_rec_type,
814: p_effective_date in date,
815: p_datetrack_mode in varchar2,
816: p_validation_start_date in date,
817: p_validation_end_date in date) is

Line 891: (p_rec in ben_rgr_shd.g_rec_type,

887: -- ----------------------------------------------------------------------------
888: -- |---------------------------< delete_validate >----------------------------|
889: -- ----------------------------------------------------------------------------
890: Procedure delete_validate
891: (p_rec in ben_rgr_shd.g_rec_type,
892: p_effective_date in date,
893: p_datetrack_mode in varchar2,
894: p_validation_start_date in date,
895: p_validation_end_date in date) is