eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_XRD_BUS dependencies on BEN_XRD_SHD

Line 46: l_api_updating := ben_xrd_shd.api_updating

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

Line 52: <> ben_xrd_shd.g_old_rec.ext_rslt_dtl_id) then

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

Line 56: ben_xrd_shd.constraint_error('BEN_EXT_RSLT_DTL_PK');

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

Line 66: ben_xrd_shd.constraint_error('BEN_EXT_RSLT_DTL_PK');

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

Line 123: l_api_updating := ben_xrd_shd.api_updating

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

Line 129: <> nvl(ben_xrd_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_xrd_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_xrd_shd.constraint_error('BEN_EXT_RSLT_DTL_DT1');

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

Line 198: l_api_updating := ben_xrd_shd.api_updating

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

Line 204: <> nvl(ben_xrd_shd.g_old_rec.ext_rcd_id,hr_api.g_number)

200: p_object_version_number => p_object_version_number);
201: --
202: if (l_api_updating
203: and nvl(p_ext_rcd_id,hr_api.g_number)
204: <> nvl(ben_xrd_shd.g_old_rec.ext_rcd_id,hr_api.g_number)
205: or not l_api_updating) then
206: --
207: -- check if ext_rcd_id value exists in ben_ext_rcd table
208: --

Line 219: ben_xrd_shd.constraint_error('BEN_EXT_RSLT_DTL_FK3');

215: --
216: -- raise error as FK does not relate to PK in ben_ext_rcd
217: -- table.
218: --
219: ben_xrd_shd.constraint_error('BEN_EXT_RSLT_DTL_FK3');
220: --
221: end if;
222: --
223: close c1;

Line 252: l_api_updating := ben_xrd_shd.api_updating

248: Begin
249: --
250: hr_utility.set_location('Entering:'||l_proc,5);
251: --
252: l_api_updating := ben_xrd_shd.api_updating
253: (p_ext_rslt_dtl_id => p_ext_rslt_dtl_id,
254: p_object_version_number => p_object_version_number);
255: --
256: if (l_api_updating

Line 258: <> nvl(ben_xrd_shd.g_old_rec.ext_rcd_in_file_id,hr_api.g_number)

254: p_object_version_number => p_object_version_number);
255: --
256: if (l_api_updating
257: and nvl(p_ext_rcd_in_file_id,hr_api.g_number)
258: <> nvl(ben_xrd_shd.g_old_rec.ext_rcd_in_file_id,hr_api.g_number)
259: or not l_api_updating) and p_ext_rcd_in_file_id is not null then
260: --
261: -- check if ext_rcd_id value exists in ben_ext_rcd table
262: --

Line 273: ben_xrd_shd.constraint_error('BEN_EXT_RSLT_DTL_FK3');

269: --
270: -- raise error as FK does not relate to PK in ben_ext_rcd
271: -- table.
272: --
273: ben_xrd_shd.constraint_error('BEN_EXT_RSLT_DTL_FK3');
274: --
275: end if;
276: --
277: close c1;

Line 330: l_api_updating := ben_xrd_shd.api_updating

326: Begin
327: --
328: hr_utility.set_location('Entering:'||l_proc,5);
329: --
330: l_api_updating := ben_xrd_shd.api_updating
331: (p_ext_rslt_dtl_id => p_ext_rslt_dtl_id,
332: p_object_version_number => p_object_version_number);
333: --
334: if (l_api_updating

Line 336: <> nvl(ben_xrd_shd.g_old_rec.ext_rslt_id,hr_api.g_number)

332: p_object_version_number => p_object_version_number);
333: --
334: if (l_api_updating
335: and nvl(p_ext_rslt_id,hr_api.g_number)
336: <> nvl(ben_xrd_shd.g_old_rec.ext_rslt_id,hr_api.g_number)
337: or not l_api_updating) then
338: --
339: -- check if ext_rslt_id value exists in ben_ext_rslt table
340: --

Line 351: ben_xrd_shd.constraint_error('BEN_EXT_RSLT_DTL_FK1');

347: --
348: -- raise error as FK does not relate to PK in ben_ext_rslt
349: -- table.
350: --
351: ben_xrd_shd.constraint_error('BEN_EXT_RSLT_DTL_FK1');
352: --
353: end if;
354: --
355: close c1;

Line 366: Procedure insert_validate(p_rec in ben_xrd_shd.g_rec_type) is

362: --
363: -- ----------------------------------------------------------------------------
364: -- |---------------------------< insert_validate >----------------------------|
365: -- ----------------------------------------------------------------------------
366: Procedure insert_validate(p_rec in ben_xrd_shd.g_rec_type) is
367: --
368: l_proc varchar2(72) := g_package||'insert_validate';
369: --
370: Begin

Line 408: Procedure update_validate(p_rec in ben_xrd_shd.g_rec_type) is

404: --
405: -- ----------------------------------------------------------------------------
406: -- |---------------------------< update_validate >----------------------------|
407: -- ----------------------------------------------------------------------------
408: Procedure update_validate(p_rec in ben_xrd_shd.g_rec_type) is
409: --
410: l_proc varchar2(72) := g_package||'update_validate';
411: --
412: Begin

Line 449: Procedure delete_validate(p_rec in ben_xrd_shd.g_rec_type) is

445: --
446: -- ----------------------------------------------------------------------------
447: -- |---------------------------< delete_validate >----------------------------|
448: -- ----------------------------------------------------------------------------
449: Procedure delete_validate(p_rec in ben_xrd_shd.g_rec_type) is
450: --
451: l_proc varchar2(72) := g_package||'delete_validate';
452: --
453: Begin