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_WCN_BUS dependencies on BEN_WCN_SHD

Line 48: l_api_updating := ben_wcn_shd.api_updating

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

Line 55: <> ben_wcn_shd.g_old_rec.wv_prtn_rsn_ctfn_pl_id) then

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

Line 59: ben_wcn_shd.constraint_error('BEN_WV_PRTN_RSN_CTFN_PL_F_PK');

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

Line 69: ben_wcn_shd.constraint_error('BEN_WV_PRTN_RSN_CTFN_PL_F_PK');

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

Line 117: l_api_updating := ben_wcn_shd.api_updating

113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_wcn_shd.api_updating
118: (p_wv_prtn_rsn_ctfn_pl_id => p_wv_prtn_rsn_ctfn_pl_id,
119: p_effective_date => p_effective_date,
120: p_object_version_number => p_object_version_number);
121: --

Line 124: <> nvl(ben_wcn_shd.g_old_rec.wv_prtn_ctfn_typ_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_wv_prtn_ctfn_typ_cd
124: <> nvl(ben_wcn_shd.g_old_rec.wv_prtn_ctfn_typ_cd,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 203: l_api_updating := ben_wcn_shd.api_updating

199: Begin
200: --
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: l_api_updating := ben_wcn_shd.api_updating
204: (p_wv_prtn_rsn_ctfn_pl_id => p_wv_prtn_rsn_ctfn_pl_id,
205: p_effective_date => p_effective_date,
206: p_object_version_number => p_object_version_number);
207: --

Line 210: <> ben_wcn_shd.g_old_rec.ctfn_rqd_when_rl

206: p_object_version_number => p_object_version_number);
207: --
208: if (l_api_updating
209: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
210: <> ben_wcn_shd.g_old_rec.ctfn_rqd_when_rl
211: or not l_api_updating)
212: and p_ctfn_rqd_when_rl is not null then
213: --
214: -- check if value of formula rule is valid.

Line 281: l_api_updating := ben_wcn_shd.api_updating

277: Begin
278: --
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: l_api_updating := ben_wcn_shd.api_updating
282: (p_wv_prtn_rsn_ctfn_pl_id => p_wv_prtn_rsn_ctfn_pl_id,
283: p_effective_date => p_effective_date,
284: p_object_version_number => p_object_version_number);
285: --

Line 288: <> nvl(ben_wcn_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

284: p_object_version_number => p_object_version_number);
285: --
286: if (l_api_updating
287: and p_rqd_flag
288: <> nvl(ben_wcn_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
289: or not l_api_updating) then
290: --
291: -- check if value of lookup falls within lookup type.
292: --

Line 350: l_api_updating := ben_wcn_shd.api_updating

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

Line 357: <> nvl(ben_wcn_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag,hr_api.g_varchar2)

353: p_object_version_number => p_object_version_number);
354: --
355: if (l_api_updating
356: and p_lack_ctfn_sspnd_wvr_flag
357: <> nvl(ben_wcn_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag,hr_api.g_varchar2)
358: or not l_api_updating) then
359: --
360: -- check if value of lookup falls within lookup type.
361: --

Line 419: l_api_updating := ben_wcn_shd.api_updating

415: Begin
416: --
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: --
419: l_api_updating := ben_wcn_shd.api_updating
420: (p_wv_prtn_rsn_ctfn_pl_id => p_wv_prtn_rsn_ctfn_pl_id,
421: p_effective_date => p_effective_date,
422: p_object_version_number => p_object_version_number);
423: --

Line 426: <> nvl(ben_wcn_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)

422: p_object_version_number => p_object_version_number);
423: --
424: if (l_api_updating
425: and p_pfd_flag
426: <> nvl(ben_wcn_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
427: or not l_api_updating) then
428: --
429: -- check if value of lookup falls within lookup type.
430: --

Line 658: (p_rec in ben_wcn_shd.g_rec_type,

654: -- ----------------------------------------------------------------------------
655: -- |---------------------------< insert_validate >----------------------------|
656: -- ----------------------------------------------------------------------------
657: Procedure insert_validate
658: (p_rec in ben_wcn_shd.g_rec_type,
659: p_effective_date in date,
660: p_datetrack_mode in varchar2,
661: p_validation_start_date in date,
662: p_validation_end_date in date) is

Line 717: (p_rec in ben_wcn_shd.g_rec_type,

713: -- ----------------------------------------------------------------------------
714: -- |---------------------------< update_validate >----------------------------|
715: -- ----------------------------------------------------------------------------
716: Procedure update_validate
717: (p_rec in ben_wcn_shd.g_rec_type,
718: p_effective_date in date,
719: p_datetrack_mode in varchar2,
720: p_validation_start_date in date,
721: p_validation_end_date in date) is

Line 784: (p_rec in ben_wcn_shd.g_rec_type,

780: -- ----------------------------------------------------------------------------
781: -- |---------------------------< delete_validate >----------------------------|
782: -- ----------------------------------------------------------------------------
783: Procedure delete_validate
784: (p_rec in ben_wcn_shd.g_rec_type,
785: p_effective_date in date,
786: p_datetrack_mode in varchar2,
787: p_validation_start_date in date,
788: p_validation_end_date in date) is