DBA Data[Home] [Help]

APPS.BEN_PYD_BUS dependencies on BEN_PYD_SHD

Line 49: l_api_updating := ben_pyd_shd.api_updating

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

Line 56: <> ben_pyd_shd.g_old_rec.ptip_dpnt_cvg_ctfn_id) then

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

Line 60: ben_pyd_shd.constraint_error('BEN_PTIP_CTFN_PK');

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

Line 70: ben_pyd_shd.constraint_error('BEN_PTIP_CTFN_PK');

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

Line 141: l_api_updating := ben_pyd_shd.api_updating

137: Begin
138: --
139: hr_utility.set_location('Entering:'||l_proc, 5);
140: --
141: l_api_updating := ben_pyd_shd.api_updating
142: (p_ptip_dpnt_cvg_ctfn_id => p_ptip_dpnt_cvg_ctfn_id,
143: p_effective_date => p_effective_date,
144: p_object_version_number => p_object_version_number);
145: --

Line 148: <> nvl(ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd,hr_api.g_varchar2)

144: p_object_version_number => p_object_version_number);
145: --
146: if (l_api_updating
147: and p_dpnt_cvg_ctfn_typ_cd
148: <> nvl(ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd,hr_api.g_varchar2)
149: or not l_api_updating) then
150: --
151: -- check if value of lookup falls within lookup type.
152: --

Line 247: l_api_updating := ben_pyd_shd.api_updating

243: Begin
244: --
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: l_api_updating := ben_pyd_shd.api_updating
248: (p_ptip_dpnt_cvg_ctfn_id => p_ptip_dpnt_cvg_ctfn_id,
249: p_effective_date => p_effective_date,
250: p_object_version_number => p_object_version_number);
251: --

Line 254: <> nvl(ben_pyd_shd.g_old_rec.rlshp_typ_cd,hr_api.g_varchar2)

250: p_object_version_number => p_object_version_number);
251: --
252: if (l_api_updating
253: and p_rlshp_typ_cd
254: <> nvl(ben_pyd_shd.g_old_rec.rlshp_typ_cd,hr_api.g_varchar2)
255: or not l_api_updating) then
256: --
257: -- check if value of lookup falls within lookup type.
258: --

Line 351: l_api_updating := ben_pyd_shd.api_updating

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

Line 358: <> ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl

354: p_object_version_number => p_object_version_number);
355: --
356: if (l_api_updating
357: and nvl(p_ctfn_rqd_when_rl,hr_api.g_number)
358: <> ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
359: or not l_api_updating)
360: and p_ctfn_rqd_when_rl is not null then
361: --
362: -- check if value of formula rule is valid.

Line 428: l_api_updating := ben_pyd_shd.api_updating

424: Begin
425: --
426: hr_utility.set_location('Entering:'||l_proc, 5);
427: --
428: l_api_updating := ben_pyd_shd.api_updating
429: (p_ptip_dpnt_cvg_ctfn_id => p_ptip_dpnt_cvg_ctfn_id,
430: p_effective_date => p_effective_date,
431: p_object_version_number => p_object_version_number);
432: --

Line 435: <> nvl(ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag,hr_api.g_varchar2)

431: p_object_version_number => p_object_version_number);
432: --
433: if (l_api_updating
434: and p_lack_ctfn_sspnd_enrt_flag
435: <> nvl(ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag,hr_api.g_varchar2)
436: or not l_api_updating)
437: and p_lack_ctfn_sspnd_enrt_flag is not null then
438: --
439: -- check if value of lookup falls within lookup type.

Line 516: l_api_updating := ben_pyd_shd.api_updating

512: Begin
513: --
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: l_api_updating := ben_pyd_shd.api_updating
517: (p_ptip_dpnt_cvg_ctfn_id => p_ptip_dpnt_cvg_ctfn_id,
518: p_effective_date => p_effective_date,
519: p_object_version_number => p_object_version_number);
520: --

Line 523: <> nvl(ben_pyd_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)

519: p_object_version_number => p_object_version_number);
520: --
521: if (l_api_updating
522: and p_pfd_flag
523: <> nvl(ben_pyd_shd.g_old_rec.pfd_flag,hr_api.g_varchar2)
524: or not l_api_updating)
525: and p_pfd_flag is not null then
526: --
527: -- check if value of lookup falls within lookup type.

Line 779: (p_rec in ben_pyd_shd.g_rec_type,

775: -- ----------------------------------------------------------------------------
776: -- |---------------------------< insert_validate >----------------------------|
777: -- ----------------------------------------------------------------------------
778: Procedure insert_validate
779: (p_rec in ben_pyd_shd.g_rec_type,
780: p_effective_date in date,
781: p_datetrack_mode in varchar2,
782: p_validation_start_date in date,
783: p_validation_end_date in date) is

Line 841: (p_rec in ben_pyd_shd.g_rec_type,

837: -- ----------------------------------------------------------------------------
838: -- |---------------------------< update_validate >----------------------------|
839: -- ----------------------------------------------------------------------------
840: Procedure update_validate
841: (p_rec in ben_pyd_shd.g_rec_type,
842: p_effective_date in date,
843: p_datetrack_mode in varchar2,
844: p_validation_start_date in date,
845: p_validation_end_date in date) is

Line 912: (p_rec in ben_pyd_shd.g_rec_type,

908: -- ----------------------------------------------------------------------------
909: -- |---------------------------< delete_validate >----------------------------|
910: -- ----------------------------------------------------------------------------
911: Procedure delete_validate
912: (p_rec in ben_pyd_shd.g_rec_type,
913: p_effective_date in date,
914: p_datetrack_mode in varchar2,
915: p_validation_start_date in date,
916: p_validation_end_date in date) is