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_PGC_BUS dependencies on BEN_PGC_SHD

Line 48: l_api_updating := ben_pgc_shd.api_updating

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

Line 55: <> ben_pgc_shd.g_old_rec.pgm_dpnt_cvg_ctfn_id) then

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

Line 59: ben_pgc_shd.constraint_error('BEN_PGM_CTFN_PK');

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

Line 69: ben_pgc_shd.constraint_error('BEN_PGM_CTFN_PK');

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

Line 137: l_api_updating := ben_pgc_shd.api_updating

133: Begin
134: --
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: --
137: l_api_updating := ben_pgc_shd.api_updating
138: (p_pgm_dpnt_cvg_ctfn_id => p_pgm_dpnt_cvg_ctfn_id,
139: p_effective_date => p_effective_date,
140: p_object_version_number => p_object_version_number);
141: --

Line 144: <> nvl(ben_pgc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd,hr_api.g_varchar2)

140: p_object_version_number => p_object_version_number);
141: --
142: if (l_api_updating
143: and p_dpnt_cvg_ctfn_typ_cd
144: <> nvl(ben_pgc_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd,hr_api.g_varchar2)
145: or not l_api_updating) then
146: --
147: -- check if value of lookup falls within lookup type.
148: --

Line 241: l_api_updating := ben_pgc_shd.api_updating

237: Begin
238: --
239: hr_utility.set_location('Entering:'||l_proc, 5);
240: --
241: l_api_updating := ben_pgc_shd.api_updating
242: (p_pgm_dpnt_cvg_ctfn_id => p_pgm_dpnt_cvg_ctfn_id,
243: p_effective_date => p_effective_date,
244: p_object_version_number => p_object_version_number);
245: --

Line 248: <> nvl(ben_pgc_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)

244: p_object_version_number => p_object_version_number);
245: --
246: if (l_api_updating
247: and p_pfd_flag
248: <> nvl(ben_pgc_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
249: or not l_api_updating)
250: and p_pfd_flag is not null then
251: --
252: -- check if value of lookup falls within lookup type.

Line 326: l_api_updating := ben_pgc_shd.api_updating

322: Begin
323: --
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: l_api_updating := ben_pgc_shd.api_updating
327: (p_pgm_dpnt_cvg_ctfn_id => p_pgm_dpnt_cvg_ctfn_id,
328: p_effective_date => p_effective_date,
329: p_object_version_number => p_object_version_number);
330: --

Line 333: <> nvl(ben_pgc_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)

329: p_object_version_number => p_object_version_number);
330: --
331: if (l_api_updating
332: and p_rqd_flag
333: <> nvl(ben_pgc_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
334: or not l_api_updating)
335: and p_rqd_flag is not null then
336: --
337: -- check if value of lookup falls within lookup type.

Line 412: l_api_updating := ben_pgc_shd.api_updating

408: Begin
409: --
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: --
412: l_api_updating := ben_pgc_shd.api_updating
413: (p_pgm_dpnt_cvg_ctfn_id => p_pgm_dpnt_cvg_ctfn_id,
414: p_effective_date => p_effective_date,
415: p_object_version_number => p_object_version_number);
416: --

Line 419: <> ben_pgc_shd.g_old_rec.ctfn_rqd_when_rl

415: p_object_version_number => p_object_version_number);
416: --
417: if (l_api_updating
418: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
419: <> ben_pgc_shd.g_old_rec.ctfn_rqd_when_rl
420: or not l_api_updating)
421: and p_ctfn_rqd_when_rl is not null then
422: --
423: -- check if value of formula rule is valid.

Line 490: l_api_updating := ben_pgc_shd.api_updating

486: Begin
487: --
488: hr_utility.set_location('Entering:'||l_proc, 5);
489: --
490: l_api_updating := ben_pgc_shd.api_updating
491: (p_pgm_dpnt_cvg_ctfn_id => p_pgm_dpnt_cvg_ctfn_id,
492: p_effective_date => p_effective_date,
493: p_object_version_number => p_object_version_number);
494: --

Line 497: <> nvl(ben_pgc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag,hr_api.g_varchar2)

493: p_object_version_number => p_object_version_number);
494: --
495: if (l_api_updating
496: and p_lack_ctfn_sspnd_enrt_flag
497: <> nvl(ben_pgc_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag,hr_api.g_varchar2)
498: or not l_api_updating)
499: and p_lack_ctfn_sspnd_enrt_flag is not null then
500: --
501: -- check if value of lookup falls within lookup type.

Line 736: (p_rec in ben_pgc_shd.g_rec_type,

732: -- ----------------------------------------------------------------------------
733: -- |---------------------------< insert_validate >----------------------------|
734: -- ----------------------------------------------------------------------------
735: Procedure insert_validate
736: (p_rec in ben_pgc_shd.g_rec_type,
737: p_effective_date in date,
738: p_datetrack_mode in varchar2,
739: p_validation_start_date in date,
740: p_validation_end_date in date) is

Line 804: (p_rec in ben_pgc_shd.g_rec_type,

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

Line 881: (p_rec in ben_pgc_shd.g_rec_type,

877: -- ----------------------------------------------------------------------------
878: -- |---------------------------< delete_validate >----------------------------|
879: -- ----------------------------------------------------------------------------
880: Procedure delete_validate
881: (p_rec in ben_pgc_shd.g_rec_type,
882: p_effective_date in date,
883: p_datetrack_mode in varchar2,
884: p_validation_start_date in date,
885: p_validation_end_date in date) is