DBA Data[Home] [Help]

APPS.BEN_WCT_BUS dependencies on BEN_WCT_SHD

Line 49: l_api_updating := ben_wct_shd.api_updating

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

Line 56: <> ben_wct_shd.g_old_rec.wv_prtn_rsn_ctfn_ptip_id) then

52: p_object_version_number => p_object_version_number);
53: --
54: if (l_api_updating
55: and nvl(p_wv_prtn_rsn_ctfn_ptip_id,hr_api.g_number)
56: <> ben_wct_shd.g_old_rec.wv_prtn_rsn_ctfn_ptip_id) then
57: --
58: -- raise error as PK has changed
59: --
60: ben_wct_shd.constraint_error('BEN_WV_PRTN_RSN_CTFN_PTIP_PK');

Line 60: ben_wct_shd.constraint_error('BEN_WV_PRTN_RSN_CTFN_PTIP_PK');

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

Line 70: ben_wct_shd.constraint_error('BEN_WV_PRTN_RSN_CTFN_PTIP_PK');

66: if p_wv_prtn_rsn_ctfn_ptip_id is not null then
67: --
68: -- raise error as PK is not null
69: --
70: ben_wct_shd.constraint_error('BEN_WV_PRTN_RSN_CTFN_PTIP_PK');
71: --
72: end if;
73: --
74: end if;

Line 119: l_api_updating := ben_wct_shd.api_updating

115: Begin
116: --
117: hr_utility.set_location('Entering:'||l_proc, 5);
118: --
119: l_api_updating := ben_wct_shd.api_updating
120: (p_wv_prtn_rsn_ctfn_ptip_id => p_wv_prtn_rsn_ctfn_ptip_id,
121: p_effective_date => p_effective_date,
122: p_object_version_number => p_object_version_number);
123: --

Line 126: <> nvl(ben_wct_shd.g_old_rec.wv_prtn_ctfn_typ_cd,hr_api.g_varchar2)

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

Line 189: l_api_updating := ben_wct_shd.api_updating

185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := ben_wct_shd.api_updating
190: (p_wv_prtn_rsn_ctfn_ptip_id => p_wv_prtn_rsn_ctfn_ptip_id,
191: p_effective_date => p_effective_date,
192: p_object_version_number => p_object_version_number);
193: --

Line 196: <> nvl(ben_wct_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)

192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and p_pfd_flag
196: <> nvl(ben_wct_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
197: or not l_api_updating)
198: and p_pfd_flag is not null then
199: --
200: -- check if value of lookup falls within lookup type.

Line 275: l_api_updating := ben_wct_shd.api_updating

271: Begin
272: --
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: --
275: l_api_updating := ben_wct_shd.api_updating
276: (p_wv_prtn_rsn_ctfn_ptip_id => p_wv_prtn_rsn_ctfn_ptip_id,
277: p_effective_date => p_effective_date,
278: p_object_version_number => p_object_version_number);
279: --

Line 282: <> ben_wct_shd.g_old_rec.ctfn_rqd_when_rl

278: p_object_version_number => p_object_version_number);
279: --
280: if (l_api_updating
281: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
282: <> ben_wct_shd.g_old_rec.ctfn_rqd_when_rl
283: or not l_api_updating)
284: and p_ctfn_rqd_when_rl is not null then
285: --
286: -- check if value of formula rule is valid.

Line 354: l_api_updating := ben_wct_shd.api_updating

350: Begin
351: --
352: hr_utility.set_location('Entering:'||l_proc, 5);
353: --
354: l_api_updating := ben_wct_shd.api_updating
355: (p_wv_prtn_rsn_ctfn_ptip_id => p_wv_prtn_rsn_ctfn_ptip_id,
356: p_effective_date => p_effective_date,
357: p_object_version_number => p_object_version_number);
358: --

Line 361: <> nvl(ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag,hr_api.g_varchar2)

357: p_object_version_number => p_object_version_number);
358: --
359: if (l_api_updating
360: and p_lack_ctfn_sspnd_wvr_flag
361: <> nvl(ben_wct_shd.g_old_rec.lack_ctfn_sspnd_wvr_flag,hr_api.g_varchar2)
362: or not l_api_updating)
363: and p_lack_ctfn_sspnd_wvr_flag is not null then
364: --
365: -- check if value of lookup falls within lookup type.

Line 424: l_api_updating := ben_wct_shd.api_updating

420: Begin
421: --
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: --
424: l_api_updating := ben_wct_shd.api_updating
425: (p_wv_prtn_rsn_ctfn_ptip_id => p_wv_prtn_rsn_ctfn_ptip_id,
426: p_effective_date => p_effective_date,
427: p_object_version_number => p_object_version_number);
428: --

Line 431: <> nvl(ben_wct_shd.g_old_rec.wv_prtn_ctfn_cd,hr_api.g_varchar2)

427: p_object_version_number => p_object_version_number);
428: --
429: if (l_api_updating
430: and p_wv_prtn_ctfn_cd
431: <> nvl(ben_wct_shd.g_old_rec.wv_prtn_ctfn_cd,hr_api.g_varchar2)
432: or not l_api_updating)
433: and p_wv_prtn_ctfn_cd is not null then
434: --
435: -- check if value of lookup falls within lookup type.

Line 674: (p_rec in ben_wct_shd.g_rec_type,

670: -- ----------------------------------------------------------------------------
671: -- |---------------------------< insert_validate >----------------------------|
672: -- ----------------------------------------------------------------------------
673: Procedure insert_validate
674: (p_rec in ben_wct_shd.g_rec_type,
675: p_effective_date in date,
676: p_datetrack_mode in varchar2,
677: p_validation_start_date in date,
678: p_validation_end_date in date) is

Line 733: (p_rec in ben_wct_shd.g_rec_type,

729: -- ----------------------------------------------------------------------------
730: -- |---------------------------< update_validate >----------------------------|
731: -- ----------------------------------------------------------------------------
732: Procedure update_validate
733: (p_rec in ben_wct_shd.g_rec_type,
734: p_effective_date in date,
735: p_datetrack_mode in varchar2,
736: p_validation_start_date in date,
737: p_validation_end_date in date) is

Line 801: (p_rec in ben_wct_shd.g_rec_type,

797: -- ----------------------------------------------------------------------------
798: -- |---------------------------< delete_validate >----------------------------|
799: -- ----------------------------------------------------------------------------
800: Procedure delete_validate
801: (p_rec in ben_wct_shd.g_rec_type,
802: p_effective_date in date,
803: p_datetrack_mode in varchar2,
804: p_validation_start_date in date,
805: p_validation_end_date in date) is