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_PDP_BUS dependencies on BEN_PDP_SHD

Line 48: l_api_updating := ben_pdp_shd.api_updating

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

Line 55: <> ben_pdp_shd.g_old_rec.elig_cvrd_dpnt_id) then

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

Line 59: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_PK');

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

Line 69: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_PK');

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

Line 111: l_api_updating := ben_pdp_shd.api_updating

107: Begin
108: --
109: hr_utility.set_location('Entering:'||l_proc, 5);
110: --
111: l_api_updating := ben_pdp_shd.api_updating
112: (p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,
113: p_effective_date => p_effective_date,
114: p_object_version_number => p_object_version_number);
115: --

Line 118: <> nvl(ben_pdp_shd.g_old_rec.ovrdn_flag,hr_api.g_varchar2)

114: p_object_version_number => p_object_version_number);
115: --
116: if (l_api_updating
117: and p_ovrdn_flag
118: <> nvl(ben_pdp_shd.g_old_rec.ovrdn_flag,hr_api.g_varchar2)
119: or not l_api_updating) then
120: --
121: -- check if value of lookup falls within lookup type.
122: --

Line 175: l_api_updating := ben_pdp_shd.api_updating

171: Begin
172: --
173: hr_utility.set_location('Entering:'||l_proc, 5);
174: --
175: l_api_updating := ben_pdp_shd.api_updating
176: (p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,
177: p_effective_date => p_effective_date,
178: p_object_version_number => p_object_version_number);
179: --

Line 182: <> nvl(ben_pdp_shd.g_old_rec.cvg_pndg_flag,hr_api.g_varchar2)

178: p_object_version_number => p_object_version_number);
179: --
180: if (l_api_updating
181: and p_cvg_pndg_flag
182: <> nvl(ben_pdp_shd.g_old_rec.cvg_pndg_flag,hr_api.g_varchar2)
183: or not l_api_updating) then
184: --
185: -- check if value of lookup falls within lookup type.
186: --

Line 329: l_api_updating := ben_pdp_shd.api_updating

325: Begin
326: --
327: hr_utility.set_location('Entering:'||l_proc,5);
328: --
329: l_api_updating := ben_pdp_shd.api_updating
330: (p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,
331: p_effective_date => p_effective_date,
332: p_object_version_number => p_object_version_number);
333: --

Line 336: <> nvl(ben_pdp_shd.g_old_rec.dpnt_person_id, hr_api.g_number)

332: p_object_version_number => p_object_version_number);
333: --
334: if (l_api_updating
335: and nvl(p_dpnt_person_id,hr_api.g_number)
336: <> nvl(ben_pdp_shd.g_old_rec.dpnt_person_id, hr_api.g_number)
337: or not l_api_updating) then
338: --
339: -- check if dpnt_person_id value exists in per_all_people_f table
340: --

Line 351: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK1');

347: --
348: -- raise error as FK does not relate to PK in per_all_people
349: -- table.
350: --
351: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK1');
352: --
353: end if;
354: --
355: close c1;

Line 433: l_api_updating := ben_pdp_shd.api_updating

429: Begin
430: --
431: hr_utility.set_location('Entering:'||l_proc,5);
432: --
433: l_api_updating := ben_pdp_shd.api_updating
434: (p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,
435: p_effective_date => p_effective_date,
436: p_object_version_number => p_object_version_number);
437: --

Line 441: <> nvl(ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id, hr_api.g_number)

437: --
438: if p_prtt_enrt_rslt_id is not null
439: and (l_api_updating
440: and nvl(p_prtt_enrt_rslt_id, hr_api.g_number)
441: <> nvl(ben_pdp_shd.g_old_rec.prtt_enrt_rslt_id, hr_api.g_number)
442: or not l_api_updating) then
443: --
444: -- check if prtt_enrt_rslt_id value exists in ben_prtt_enrt_rslt_f table
445: --

Line 456: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK2');

452: --
453: -- raise error as FK does not relate to PK in ben_prtt_enrt_rslt_f
454: -- table.
455: --
456: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK2');
457: --
458: end if;
459: --
460: close c1;

Line 660: l_api_updating := ben_pdp_shd.api_updating

656: --
657: hr_utility.set_location('Entering:'||l_proc,5);
658: --
659:
660: l_api_updating := ben_pdp_shd.api_updating
661: (p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,
662: p_effective_date => p_effective_date,
663: p_object_version_number => p_object_version_number);
664:

Line 672: ben_pdp_shd.g_old_rec.cvg_strt_dt = null)

668: if p_prtt_enrt_rslt_id is not null and
669: p_cvg_strt_dt is not null and
670: p_cvg_thru_dt = hr_api.g_eot and
671: (not l_api_updating or
672: ben_pdp_shd.g_old_rec.cvg_strt_dt = null)
673: then
674: --
675: hr_utility.set_location('open info1_c :'||l_proc,10);
676: --

Line 692: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK2');

688: --
689: -- raise error as FK does not relate to PK in ben_prtt_enrt_rslt_f
690: -- table.
691: --
692: ben_pdp_shd.constraint_error('BEN_ELIG_CVRD_DPNT_FK2');
693: --
694: else
695: --
696: --

Line 1590: (p_rec in ben_pdp_shd.g_rec_type,

1586: -- ----------------------------------------------------------------------------
1587: -- |---------------------------< insert_validate >----------------------------|
1588: -- ----------------------------------------------------------------------------
1589: Procedure insert_validate
1590: (p_rec in ben_pdp_shd.g_rec_type,
1591: p_effective_date in date,
1592: p_datetrack_mode in varchar2,
1593: p_validation_start_date in date,
1594: p_validation_end_date in date) is

Line 1680: (p_rec in ben_pdp_shd.g_rec_type,

1676: -- ----------------------------------------------------------------------------
1677: -- |---------------------------< update_validate >----------------------------|
1678: -- ----------------------------------------------------------------------------
1679: Procedure update_validate
1680: (p_rec in ben_pdp_shd.g_rec_type,
1681: p_effective_date in date,
1682: p_datetrack_mode in varchar2,
1683: p_validation_start_date in date,
1684: p_validation_end_date in date) is

Line 1782: (p_rec in ben_pdp_shd.g_rec_type,

1778: -- |---------------------------< delete_validate >----------------------------|
1779: -- ----------------------------------------------------------------------------
1780: --
1781: Procedure delete_validate
1782: (p_rec in ben_pdp_shd.g_rec_type,
1783: p_effective_date in date,
1784: p_datetrack_mode in varchar2,
1785: p_validation_start_date in date,
1786: p_validation_end_date in date) is