DBA Data[Home] [Help]

APPS.BEN_ERP_BUS dependencies on BEN_ERP_SHD

Line 48: l_api_updating := ben_erp_shd.api_updating

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

Line 55: <> ben_erp_shd.g_old_rec.enrt_perd_for_pl_id) then

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

Line 59: ben_erp_shd.constraint_error('BEN_ENRT_PERD_FOR_PL_F_PK');

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

Line 69: ben_erp_shd.constraint_error('BEN_ENRT_PERD_FOR_PL_F_PK');

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

Line 118: l_api_updating := ben_erp_shd.api_updating

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

Line 125: <> ben_erp_shd.g_old_rec.rt_end_dt_rl

121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_rt_end_dt_rl,hr_api.g_number)
125: <> ben_erp_shd.g_old_rec.rt_end_dt_rl
126: or not l_api_updating)
127: and p_rt_end_dt_rl is not null then
128: --
129: -- check if value of formula rule is valid.

Line 190: l_api_updating := ben_erp_shd.api_updating

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

Line 197: <> nvl(ben_erp_shd.g_old_rec.rt_end_dt_cd,hr_api.g_varchar2)

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

Line 262: l_api_updating := ben_erp_shd.api_updating

258: Begin
259: --
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: --
262: l_api_updating := ben_erp_shd.api_updating
263: (p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_id,
264: p_effective_date => p_effective_date,
265: p_object_version_number => p_object_version_number);
266: --

Line 269: <> ben_erp_shd.g_old_rec.rt_strt_dt_rl

265: p_object_version_number => p_object_version_number);
266: --
267: if (l_api_updating
268: and nvl(p_rt_strt_dt_rl,hr_api.g_number)
269: <> ben_erp_shd.g_old_rec.rt_strt_dt_rl
270: or not l_api_updating)
271: and p_rt_strt_dt_rl is not null then
272: --
273: -- check if value of formula rule is valid.

Line 334: l_api_updating := ben_erp_shd.api_updating

330: Begin
331: --
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: l_api_updating := ben_erp_shd.api_updating
335: (p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_id,
336: p_effective_date => p_effective_date,
337: p_object_version_number => p_object_version_number);
338: --

Line 341: <> nvl(ben_erp_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)

337: p_object_version_number => p_object_version_number);
338: --
339: if (l_api_updating
340: and p_rt_strt_dt_cd
341: <> nvl(ben_erp_shd.g_old_rec.rt_strt_dt_cd,hr_api.g_varchar2)
342: or not l_api_updating)
343: and p_rt_strt_dt_cd is not null then
344: --
345: -- check if value of lookup falls within lookup type.

Line 406: l_api_updating := ben_erp_shd.api_updating

402: Begin
403: --
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: --
406: l_api_updating := ben_erp_shd.api_updating
407: (p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_id,
408: p_effective_date => p_effective_date,
409: p_object_version_number => p_object_version_number);
410: --

Line 413: <> ben_erp_shd.g_old_rec.enrt_cvg_end_dt_rl

409: p_object_version_number => p_object_version_number);
410: --
411: if (l_api_updating
412: and nvl(p_enrt_cvg_end_dt_rl,hr_api.g_number)
413: <> ben_erp_shd.g_old_rec.enrt_cvg_end_dt_rl
414: or not l_api_updating)
415: and p_enrt_cvg_end_dt_rl is not null then
416: --
417: -- check if value of formula rule is valid.

Line 478: l_api_updating := ben_erp_shd.api_updating

474: Begin
475: --
476: hr_utility.set_location('Entering:'||l_proc, 5);
477: --
478: l_api_updating := ben_erp_shd.api_updating
479: (p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_id,
480: p_effective_date => p_effective_date,
481: p_object_version_number => p_object_version_number);
482: --

Line 485: <> nvl(ben_erp_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)

481: p_object_version_number => p_object_version_number);
482: --
483: if (l_api_updating
484: and p_enrt_cvg_end_dt_cd
485: <> nvl(ben_erp_shd.g_old_rec.enrt_cvg_end_dt_cd,hr_api.g_varchar2)
486: or not l_api_updating)
487: and p_enrt_cvg_end_dt_cd is not null then
488: --
489: -- check if value of lookup falls within lookup type.

Line 550: l_api_updating := ben_erp_shd.api_updating

546: Begin
547: --
548: hr_utility.set_location('Entering:'||l_proc, 5);
549: --
550: l_api_updating := ben_erp_shd.api_updating
551: (p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_id,
552: p_effective_date => p_effective_date,
553: p_object_version_number => p_object_version_number);
554: --

Line 557: <> ben_erp_shd.g_old_rec.enrt_cvg_strt_dt_rl

553: p_object_version_number => p_object_version_number);
554: --
555: if (l_api_updating
556: and nvl(p_enrt_cvg_strt_dt_rl,hr_api.g_number)
557: <> ben_erp_shd.g_old_rec.enrt_cvg_strt_dt_rl
558: or not l_api_updating)
559: and p_enrt_cvg_strt_dt_rl is not null then
560: --
561: -- check if value of formula rule is valid.

Line 622: l_api_updating := ben_erp_shd.api_updating

618: Begin
619: --
620: hr_utility.set_location('Entering:'||l_proc, 5);
621: --
622: l_api_updating := ben_erp_shd.api_updating
623: (p_enrt_perd_for_pl_id => p_enrt_perd_for_pl_id,
624: p_effective_date => p_effective_date,
625: p_object_version_number => p_object_version_number);
626: --

Line 629: <> nvl(ben_erp_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)

625: p_object_version_number => p_object_version_number);
626: --
627: if (l_api_updating
628: and p_enrt_cvg_strt_dt_cd
629: <> nvl(ben_erp_shd.g_old_rec.enrt_cvg_strt_dt_cd,hr_api.g_varchar2)
630: or not l_api_updating)
631: and p_enrt_cvg_strt_dt_cd is not null then
632: --
633: -- check if value of lookup falls within lookup type.

Line 874: (p_rec in ben_erp_shd.g_rec_type,

870: -- ----------------------------------------------------------------------------
871: -- |---------------------------< insert_validate >----------------------------|
872: -- ----------------------------------------------------------------------------
873: Procedure insert_validate
874: (p_rec in ben_erp_shd.g_rec_type,
875: p_effective_date in date,
876: p_datetrack_mode in varchar2,
877: p_validation_start_date in date,
878: p_validation_end_date in date) is

Line 954: (p_rec in ben_erp_shd.g_rec_type,

950: -- ----------------------------------------------------------------------------
951: -- |---------------------------< update_validate >----------------------------|
952: -- ----------------------------------------------------------------------------
953: Procedure update_validate
954: (p_rec in ben_erp_shd.g_rec_type,
955: p_effective_date in date,
956: p_datetrack_mode in varchar2,
957: p_validation_start_date in date,
958: p_validation_end_date in date) is

Line 1043: (p_rec in ben_erp_shd.g_rec_type,

1039: -- ----------------------------------------------------------------------------
1040: -- |---------------------------< delete_validate >----------------------------|
1041: -- ----------------------------------------------------------------------------
1042: Procedure delete_validate
1043: (p_rec in ben_erp_shd.g_rec_type,
1044: p_effective_date in date,
1045: p_datetrack_mode in varchar2,
1046: p_validation_start_date in date,
1047: p_validation_end_date in date) is