APPS.BEN_PRB_BUS dependencies on BEN_PRB_SHD

Line 48: l_api_updating := ben_prb_shd.api_updating

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

Line 55: <> ben_prb_shd.g_old_rec.pl_regy_bod_id) then

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

Line 59: ben_prb_shd.constraint_error('BEN_PL_REGY_BOD_PK');

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

Line 69: ben_prb_shd.constraint_error('BEN_PL_REGY_BOD_PK');

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

Line 123: l_api_updating := ben_prb_shd.api_updating

119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_prb_shd.api_updating
124: (p_pl_regy_bod_id => p_pl_regy_bod_id,
125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --

Line 130: <> nvl(ben_prb_shd.g_old_rec.rptg_grp_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_rptg_grp_id,hr_api.g_number)
130: <> nvl(ben_prb_shd.g_old_rec.rptg_grp_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_rptg_grp_id is not null then
133: --
134: -- check if rptg_grp_id value exists in ben_rptg_grp table

Line 146: ben_prb_shd.constraint_error('BEN_PL_REGY_BOD_FK1');

142: --
143: -- raise error as FK does not relate to PK in ben_rptg_grp
144: -- table.
145: --
146: ben_prb_shd.constraint_error('BEN_PL_REGY_BOD_FK1');
147: --
148: end if;
149: --
150: close c1;

Line 273: l_api_updating := ben_prb_shd.api_updating

269: Begin
270: --
271: hr_utility.set_location('Entering:'||l_proc,5);
272: --
273: l_api_updating := ben_prb_shd.api_updating
274: (p_pl_regy_bod_id => p_pl_regy_bod_id,
275: p_effective_date => p_effective_date,
276: p_object_version_number => p_object_version_number);
277: --

Line 280: <> nvl(ben_prb_shd.g_old_rec.organization_id,hr_api.g_number)

276: p_object_version_number => p_object_version_number);
277: --
278: if (l_api_updating
279: and nvl(p_organization_id,hr_api.g_number)
280: <> nvl(ben_prb_shd.g_old_rec.organization_id,hr_api.g_number)
281: or not l_api_updating) and
282: p_organization_id is not null then
283: --
284: -- check if organization_id value exists in hr_all_organization_units table

Line 297: ben_prb_shd.constraint_error('BEN_PL_REGY_BOD_FK1');

293: --
294: -- raise error as FK does not relate to PK in ben_rptg_grp
295: -- table.
296: --
297: ben_prb_shd.constraint_error('BEN_PL_REGY_BOD_FK1');
298: --
299: end if;
300: --
301: close c1;

Line 348: l_api_updating := ben_prb_shd.api_updating

344: Begin
345: --
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: l_api_updating := ben_prb_shd.api_updating
349: (p_pl_regy_bod_id => p_pl_regy_bod_id,
350: p_effective_date => p_effective_date,
351: p_object_version_number => p_object_version_number);
352: --

Line 355: <> nvl(ben_prb_shd.g_old_rec.quald_flag,hr_api.g_varchar2)

351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and p_quald_flag
355: <> nvl(ben_prb_shd.g_old_rec.quald_flag,hr_api.g_varchar2)
356: or not l_api_updating)
357: and p_quald_flag is not null then
358: --
359: -- check if value of lookup falls within lookup type.

Line 428: -- ben_prb_shd.constraint_error('BEN_PL_REGY_PRP_DT1');

424: --
425: -- raise error as child rows exists.
426: --
427: return true;
428: -- ben_prb_shd.constraint_error('BEN_PL_REGY_PRP_DT1');
429: --
430: else
431: --
432: close c1;

Line 656: (p_rec in ben_prb_shd.g_rec_type,

652: -- ----------------------------------------------------------------------------
653: -- |---------------------------< insert_validate >----------------------------|
654: -- ----------------------------------------------------------------------------
655: Procedure insert_validate
656: (p_rec in ben_prb_shd.g_rec_type,
657: p_effective_date in date,
658: p_datetrack_mode in varchar2,
659: p_validation_start_date in date,
660: p_validation_end_date in date) is

Line 712: (p_rec in ben_prb_shd.g_rec_type,

708: -- ----------------------------------------------------------------------------
709: -- |---------------------------< update_validate >----------------------------|
710: -- ----------------------------------------------------------------------------
711: Procedure update_validate
712: (p_rec in ben_prb_shd.g_rec_type,
713: p_effective_date in date,
714: p_datetrack_mode in varchar2,
715: p_validation_start_date in date,
716: p_validation_end_date in date) is

Line 777: (p_rec in ben_prb_shd.g_rec_type,

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