DBA Data[Home] [Help]

APPS.BEN_PCS_BUS dependencies on BEN_PCS_SHD

Line 48: l_api_updating := ben_pcs_shd.api_updating

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

Line 55: <> ben_pcs_shd.g_old_rec.prtt_enrt_ctfn_prvdd_id) then

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

Line 59: ben_pcs_shd.constraint_error('BEN_PRTT_ENRT_CTFN_PRVDD_PK');

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

Line 69: ben_pcs_shd.constraint_error('BEN_PRTT_ENRT_CTFN_PRVDD_PK');

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

Line 161: l_api_updating := ben_pcs_shd.api_updating

157: Begin
158: --
159: hr_utility.set_location('Entering:'||l_proc, 5);
160: --
161: l_api_updating := ben_pcs_shd.api_updating
162: (p_prtt_enrt_ctfn_prvdd_id => p_prtt_enrt_ctfn_prvdd_id,
163: p_effective_date => p_effective_date,
164: p_object_version_number => p_object_version_number);
165: --

Line 168: <> nvl(ben_pcs_shd.g_old_rec.enrt_r_bnft_ctfn_cd,hr_api.g_varchar2)

164: p_object_version_number => p_object_version_number);
165: --
166: if (l_api_updating
167: and p_enrt_r_bnft_ctfn_cd
168: <> nvl(ben_pcs_shd.g_old_rec.enrt_r_bnft_ctfn_cd,hr_api.g_varchar2)
169: or not l_api_updating)
170: and p_enrt_r_bnft_ctfn_cd is not null then
171: --
172: -- check if value of lookup falls within lookup type.

Line 233: l_api_updating := ben_pcs_shd.api_updating

229: Begin
230: --
231: hr_utility.set_location('Entering:'||l_proc, 5);
232: --
233: l_api_updating := ben_pcs_shd.api_updating
234: (p_prtt_enrt_ctfn_prvdd_id => p_prtt_enrt_ctfn_prvdd_id,
235: p_effective_date => p_effective_date,
236: p_object_version_number => p_object_version_number);
237: --

Line 240: <> nvl(ben_pcs_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)

236: p_object_version_number => p_object_version_number);
237: --
238: if (l_api_updating
239: and p_enrt_ctfn_typ_cd
240: <> nvl(ben_pcs_shd.g_old_rec.enrt_ctfn_typ_cd,hr_api.g_varchar2)
241: or not l_api_updating)
242: and p_enrt_ctfn_typ_cd is not null then
243: --
244: -- check if value of lookup falls within lookup type.

Line 326: l_api_updating := ben_pcs_shd.api_updating

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

Line 394: l_api_updating := ben_pcs_shd.api_updating

390: Begin
391: --
392: hr_utility.set_location('Entering:'||l_proc, 5);
393: --
394: l_api_updating := ben_pcs_shd.api_updating
395: (p_prtt_enrt_ctfn_prvdd_id => p_prtt_enrt_ctfn_prvdd_id,
396: p_effective_date => p_effective_date,
397: p_object_version_number => p_object_version_number);
398: --

Line 401: <> nvl(ben_pcs_shd.g_old_rec.enrt_ctfn_rqd_flag,hr_api.g_varchar2)

397: p_object_version_number => p_object_version_number);
398: --
399: if (l_api_updating
400: and p_enrt_ctfn_rqd_flag
401: <> nvl(ben_pcs_shd.g_old_rec.enrt_ctfn_rqd_flag,hr_api.g_varchar2)
402: or not l_api_updating) then
403: --
404: -- check if value of lookup falls within lookup type.
405: --

Line 646: (p_rec in ben_pcs_shd.g_rec_type,

642: -- ----------------------------------------------------------------------------
643: -- |---------------------------< insert_validate >----------------------------|
644: -- ----------------------------------------------------------------------------
645: Procedure insert_validate
646: (p_rec in ben_pcs_shd.g_rec_type,
647: p_effective_date in date,
648: p_datetrack_mode in varchar2,
649: p_validation_start_date in date,
650: p_validation_end_date in date) is

Line 706: (p_rec in ben_pcs_shd.g_rec_type,

702: -- ----------------------------------------------------------------------------
703: -- |---------------------------< update_validate >----------------------------|
704: -- ----------------------------------------------------------------------------
705: Procedure update_validate
706: (p_rec in ben_pcs_shd.g_rec_type,
707: p_effective_date in date,
708: p_datetrack_mode in varchar2,
709: p_validation_start_date in date,
710: p_validation_end_date in date) is

Line 776: (p_rec in ben_pcs_shd.g_rec_type,

772: -- ----------------------------------------------------------------------------
773: -- |---------------------------< delete_validate >----------------------------|
774: -- ----------------------------------------------------------------------------
775: Procedure delete_validate
776: (p_rec in ben_pcs_shd.g_rec_type,
777: p_effective_date in date,
778: p_datetrack_mode in varchar2,
779: p_validation_start_date in date,
780: p_validation_end_date in date) is