APPS.BEN_CRD_BUS dependencies on BEN_CRD_SHD

Line 46: l_api_updating := ben_crd_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_crd_shd.api_updating
47: (p_crt_ordr_cvrd_per_id => p_crt_ordr_cvrd_per_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> ben_crd_shd.g_old_rec.crt_ordr_cvrd_per_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_crt_ordr_cvrd_per_id,hr_api.g_number)
52: <> ben_crd_shd.g_old_rec.crt_ordr_cvrd_per_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_crd_shd.constraint_error('BEN_CRT_ORDR_CVRD_PER_PK');

Line 56: ben_crd_shd.constraint_error('BEN_CRT_ORDR_CVRD_PER_PK');

52: <> ben_crd_shd.g_old_rec.crt_ordr_cvrd_per_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_crd_shd.constraint_error('BEN_CRT_ORDR_CVRD_PER_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: ben_crd_shd.constraint_error('BEN_CRT_ORDR_CVRD_PER_PK');

62: if p_crt_ordr_cvrd_per_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_crd_shd.constraint_error('BEN_CRT_ORDR_CVRD_PER_PK');
67: --
68: end if;
69: --
70: end if;

Line 123: l_api_updating := ben_crd_shd.api_updating

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

Line 129: <> nvl(ben_crd_shd.g_old_rec.person_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_person_id,hr_api.g_number)
129: <> nvl(ben_crd_shd.g_old_rec.person_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if person_id value exists in per_all_people_f table
133: --

Line 144: ben_crd_shd.constraint_error('BEN_CRT_ORDR_CVRD_PER_DT1');

140: --
141: -- raise error as FK does not relate to PK in per_all_people_f
142: -- table.
143: --
144: ben_crd_shd.constraint_error('BEN_CRT_ORDR_CVRD_PER_DT1');
145: --
146: end if;
147: --
148: close c1;

Line 198: l_api_updating := ben_crd_shd.api_updating

194: Begin
195: --
196: hr_utility.set_location('Entering:'||l_proc,5);
197: --
198: l_api_updating := ben_crd_shd.api_updating
199: (p_crt_ordr_cvrd_per_id => p_crt_ordr_cvrd_per_id,
200: p_object_version_number => p_object_version_number);
201: --
202: if (l_api_updating

Line 204: <> nvl(ben_crd_shd.g_old_rec.crt_ordr_id,hr_api.g_number)

200: p_object_version_number => p_object_version_number);
201: --
202: if (l_api_updating
203: and nvl(p_crt_ordr_id,hr_api.g_number)
204: <> nvl(ben_crd_shd.g_old_rec.crt_ordr_id,hr_api.g_number)
205: or not l_api_updating) and
206: p_crt_ordr_id is not null then
207: --
208: -- check if crt_ordr_id value exists in ben_crt_ordr table

Line 220: ben_crd_shd.constraint_error('BEN_CRT_ORDR_CVRD_PER_FK1');

216: --
217: -- raise error as FK does not relate to PK in ben_crt_ordr
218: -- table.
219: --
220: ben_crd_shd.constraint_error('BEN_CRT_ORDR_CVRD_PER_FK1');
221: --
222: end if;
223: --
224: close c1;

Line 235: Procedure insert_validate(p_rec in ben_crd_shd.g_rec_type) is

231: --
232: -- ----------------------------------------------------------------------------
233: -- |---------------------------< insert_validate >----------------------------|
234: -- ----------------------------------------------------------------------------
235: Procedure insert_validate(p_rec in ben_crd_shd.g_rec_type) is
236: --
237: l_proc varchar2(72) := g_package||'insert_validate';
238: --
239: Begin

Line 262: Procedure update_validate(p_rec in ben_crd_shd.g_rec_type) is

258: --
259: -- ----------------------------------------------------------------------------
260: -- |---------------------------< update_validate >----------------------------|
261: -- ----------------------------------------------------------------------------
262: Procedure update_validate(p_rec in ben_crd_shd.g_rec_type) is
263: --
264: l_proc varchar2(72) := g_package||'update_validate';
265: --
266: Begin

Line 289: Procedure delete_validate(p_rec in ben_crd_shd.g_rec_type) is

285: --
286: -- ----------------------------------------------------------------------------
287: -- |---------------------------< delete_validate >----------------------------|
288: -- ----------------------------------------------------------------------------
289: Procedure delete_validate(p_rec in ben_crd_shd.g_rec_type) is
290: --
291: l_proc varchar2(72) := g_package||'delete_validate';
292: --
293: Begin