DBA Data[Home] [Help]

APPS.BEN_LPE_BUS dependencies on BEN_LPE_SHD

Line 49: l_api_updating := ben_lpe_shd.api_updating

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

Line 56: <> ben_lpe_shd.g_old_rec.ler_chg_pl_nip_enrt_id) then

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

Line 60: ben_lpe_shd.constraint_error('BEN_LER_CHG_PL_NIP_ENRT_PK');

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

Line 70: ben_lpe_shd.constraint_error('BEN_LER_CHG_PL_NIP_ENRT_PK');

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

Line 135: l_api_updating := ben_lpe_shd.api_updating

131: Begin
132: --
133: hr_utility.set_location('Entering:'||l_proc, 5);
134: --
135: l_api_updating := ben_lpe_shd.api_updating
136: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
137: p_effective_date => p_effective_date,
138: p_object_version_number => p_object_version_number);
139: --

Line 142: <> ben_lpe_shd.g_old_rec.auto_enrt_mthd_rl

138: p_object_version_number => p_object_version_number);
139: --
140: if (l_api_updating
141: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)
142: <> ben_lpe_shd.g_old_rec.auto_enrt_mthd_rl
143: or not l_api_updating)
144: and p_auto_enrt_mthd_rl is not null then
145: --
146: -- check if value of formula rule is valid.

Line 213: l_api_updating := ben_lpe_shd.api_updating

209: Begin
210: --
211: hr_utility.set_location('Entering:'||l_proc, 5);
212: --
213: l_api_updating := ben_lpe_shd.api_updating
214: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
215: p_effective_date => p_effective_date,
216: p_object_version_number => p_object_version_number);
217: --

Line 220: <> nvl(ben_lpe_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)

216: p_object_version_number => p_object_version_number);
217: --
218: if (l_api_updating
219: and p_enrt_mthd_cd
220: <> nvl(ben_lpe_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)
221: or not l_api_updating)
222: and p_enrt_mthd_cd is not null then
223: --
224: -- check if value of lookup falls within lookup type.

Line 284: l_api_updating := ben_lpe_shd.api_updating

280: Begin
281: --
282: hr_utility.set_location('Entering:'||l_proc, 5);
283: --
284: l_api_updating := ben_lpe_shd.api_updating
285: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
286: p_effective_date => p_effective_date,
287: p_object_version_number => p_object_version_number);
288: --

Line 291: <> nvl(ben_lpe_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)

287: p_object_version_number => p_object_version_number);
288: --
289: if (l_api_updating
290: and p_stl_elig_cant_chg_flag
291: <> nvl(ben_lpe_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)
292: or not l_api_updating) then
293: --
294: -- check if value of lookup falls within lookup type.
295: --

Line 355: l_api_updating := ben_lpe_shd.api_updating

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

Line 362: <> nvl(ben_lpe_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

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

Line 444: l_api_updating := ben_lpe_shd.api_updating

440: Begin
441: --
442: hr_utility.set_location('Entering:'||l_proc, 5);
443: --
444: l_api_updating := ben_lpe_shd.api_updating
445: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
446: p_effective_date => p_effective_date,
447: p_object_version_number => p_object_version_number);
448: --

Line 451: <> ben_lpe_shd.g_old_rec.enrt_rl

447: p_object_version_number => p_object_version_number);
448: --
449: if (l_api_updating
450: and nvl(p_enrt_rl,hr_api.g_number)
451: <> ben_lpe_shd.g_old_rec.enrt_rl
452: or not l_api_updating)
453: and p_enrt_rl is not null then
454: --
455: -- check if value of formula rule is valid.

Line 522: l_api_updating := ben_lpe_shd.api_updating

518: Begin
519: --
520: hr_utility.set_location('Entering:'||l_proc, 5);
521: --
522: l_api_updating := ben_lpe_shd.api_updating
523: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
524: p_effective_date => p_effective_date,
525: p_object_version_number => p_object_version_number);
526: --

Line 529: <> nvl(ben_lpe_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

525: p_object_version_number => p_object_version_number);
526: --
527: if (l_api_updating
528: and p_dflt_flag
529: <> nvl(ben_lpe_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
530: or not l_api_updating) then
531: --
532: -- check if value of lookup falls within lookup type.
533: --

Line 611: l_api_updating := ben_lpe_shd.api_updating

607: Begin
608: --
609: hr_utility.set_location('Entering:'||l_proc, 5);
610: --
611: l_api_updating := ben_lpe_shd.api_updating
612: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
613: p_effective_date => p_effective_date,
614: p_object_version_number => p_object_version_number);
615: --

Line 618: <> ben_lpe_shd.g_old_rec.dflt_enrt_rl

614: p_object_version_number => p_object_version_number);
615: --
616: if (l_api_updating
617: and nvl(p_dflt_enrt_rl,hr_api.g_number)
618: <> ben_lpe_shd.g_old_rec.dflt_enrt_rl
619: or not l_api_updating)
620: and p_dflt_enrt_rl is not null then
621: --
622: -- check if value of formula rule is valid.

Line 689: l_api_updating := ben_lpe_shd.api_updating

685: Begin
686: --
687: hr_utility.set_location('Entering:'||l_proc, 5);
688: --
689: l_api_updating := ben_lpe_shd.api_updating
690: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
691: p_effective_date => p_effective_date,
692: p_object_version_number => p_object_version_number);
693: --

Line 696: <> nvl(ben_lpe_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)

692: p_object_version_number => p_object_version_number);
693: --
694: if (l_api_updating
695: and p_dflt_enrt_cd
696: <> nvl(ben_lpe_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)
697: or not l_api_updating)
698: and p_dflt_enrt_cd is not null then
699: --
700: -- check if value of lookup falls within lookup type.

Line 760: l_api_updating := ben_lpe_shd.api_updating

756: Begin
757: --
758: hr_utility.set_location('Entering:'||l_proc, 5);
759: --
760: l_api_updating := ben_lpe_shd.api_updating
761: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
762: p_effective_date => p_effective_date,
763: p_object_version_number => p_object_version_number);
764: --

Line 767: <> nvl(ben_lpe_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)

763: p_object_version_number => p_object_version_number);
764: --
765: if (l_api_updating
766: and p_crnt_enrt_prclds_chg_flag
767: <> nvl(ben_lpe_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)
768: or not l_api_updating) then
769: --
770: -- check if value of lookup falls within lookup type.
771: --

Line 831: l_api_updating := ben_lpe_shd.api_updating

827: Begin
828: --
829: hr_utility.set_location('Entering:'||l_proc, 5);
830: --
831: l_api_updating := ben_lpe_shd.api_updating
832: (p_ler_chg_pl_nip_enrt_id => p_ler_chg_pl_nip_enrt_id,
833: p_effective_date => p_effective_date,
834: p_object_version_number => p_object_version_number);
835: --

Line 839: <> nvl(ben_lpe_shd.g_old_rec.tco_chg_enrt_cd,hr_api.g_varchar2)

835: --
836: if (l_api_updating
837: and p_tco_chg_enrt_cd is not null
838: and p_tco_chg_enrt_cd
839: <> nvl(ben_lpe_shd.g_old_rec.tco_chg_enrt_cd,hr_api.g_varchar2)
840: or not l_api_updating)and p_tco_chg_enrt_cd is not null then
841: --
842: -- check if value of lookup falls within lookup type.
843: --

Line 1081: (p_rec in ben_lpe_shd.g_rec_type,

1077: -- ----------------------------------------------------------------------------
1078: -- |---------------------------< insert_validate >----------------------------|
1079: -- ----------------------------------------------------------------------------
1080: Procedure insert_validate
1081: (p_rec in ben_lpe_shd.g_rec_type,
1082: p_effective_date in date,
1083: p_datetrack_mode in varchar2,
1084: p_validation_start_date in date,
1085: p_validation_end_date in date) is

Line 1172: (p_rec in ben_lpe_shd.g_rec_type,

1168: -- ----------------------------------------------------------------------------
1169: -- |---------------------------< update_validate >----------------------------|
1170: -- ----------------------------------------------------------------------------
1171: Procedure update_validate
1172: (p_rec in ben_lpe_shd.g_rec_type,
1173: p_effective_date in date,
1174: p_datetrack_mode in varchar2,
1175: p_validation_start_date in date,
1176: p_validation_end_date in date) is

Line 1271: (p_rec in ben_lpe_shd.g_rec_type,

1267: -- ----------------------------------------------------------------------------
1268: -- |---------------------------< delete_validate >----------------------------|
1269: -- ----------------------------------------------------------------------------
1270: Procedure delete_validate
1271: (p_rec in ben_lpe_shd.g_rec_type,
1272: p_effective_date in date,
1273: p_datetrack_mode in varchar2,
1274: p_validation_start_date in date,
1275: p_validation_end_date in date) is