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_XCV_BUS dependencies on BEN_XCV_SHD

Line 261: l_api_updating := ben_xcv_shd.api_updating

257: Begin
258: --
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: l_api_updating := ben_xcv_shd.api_updating
262: (p_ext_crit_val_id => p_ext_crit_val_id,
263: p_object_version_number => p_object_version_number);
264: --
265: if (l_api_updating

Line 267: <> ben_xcv_shd.g_old_rec.ext_crit_val_id) then

263: p_object_version_number => p_object_version_number);
264: --
265: if (l_api_updating
266: and nvl(p_ext_crit_val_id,hr_api.g_number)
267: <> ben_xcv_shd.g_old_rec.ext_crit_val_id) then
268: --
269: -- raise error as PK has changed
270: --
271: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_PK');

Line 271: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_PK');

267: <> ben_xcv_shd.g_old_rec.ext_crit_val_id) then
268: --
269: -- raise error as PK has changed
270: --
271: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_PK');
272: --
273: elsif not l_api_updating then
274: --
275: -- check if PK is null

Line 281: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_PK');

277: if p_ext_crit_val_id is not null then
278: --
279: -- raise error as PK is not null
280: --
281: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_PK');
282: --
283: end if;
284: --
285: end if;

Line 333: l_api_updating := ben_xcv_shd.api_updating

329: Begin
330: --
331: hr_utility.set_location('Entering:'||l_proc,5);
332: --
333: l_api_updating := ben_xcv_shd.api_updating
334: (p_ext_crit_val_id => p_ext_crit_val_id,
335: p_object_version_number => p_object_version_number);
336: --
337: if (l_api_updating

Line 339: <> nvl(ben_xcv_shd.g_old_rec.ext_crit_typ_id,hr_api.g_number)

335: p_object_version_number => p_object_version_number);
336: --
337: if (l_api_updating
338: and nvl(p_ext_crit_typ_id,hr_api.g_number)
339: <> nvl(ben_xcv_shd.g_old_rec.ext_crit_typ_id,hr_api.g_number)
340: or not l_api_updating) then
341: --
342: -- check if ext_crit_typ_id value exists in ben_ext_crit_typ table
343: --

Line 354: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_FK1');

350: --
351: -- raise error as FK does not relate to PK in ben_ext_crit_typ
352: -- table.
353: --
354: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_FK1');
355: --
356: end if;
357: --
358: close c1;

Line 395: l_api_updating := ben_xcv_shd.api_updating

391: Begin
392: --
393: hr_utility.set_location('Entering:'||l_proc,5);
394: --
395: l_api_updating := ben_xcv_shd.api_updating
396: (p_ext_crit_val_id => p_ext_crit_val_id,
397: p_object_version_number => p_object_version_number);
398: --
399: if (l_api_updating

Line 401: <> nvl(ben_xcv_shd.g_old_rec.ext_crit_bg_id,hr_api.g_number)

397: p_object_version_number => p_object_version_number);
398: --
399: if (l_api_updating
400: and nvl(p_ext_crit_bg_id,hr_api.g_number)
401: <> nvl(ben_xcv_shd.g_old_rec.ext_crit_bg_id,hr_api.g_number)
402: or not l_api_updating) then
403: --
404: -- check if ext_crit_typ_id value exists in ben_ext_crit_typ table
405: --

Line 417: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_FK3');

413: --
414: -- raise error as FK does not relate to PK in ben_ext_crit_typ
415: -- table.
416: --
417: ben_xcv_shd.constraint_error('BEN_EXT_CRIT_VAL_FK3');
418: --
419: end if;
420: --
421: close c1;

Line 573: l_api_updating := ben_xcv_shd.api_updating

569: Begin
570: --
571: hr_utility.set_location('Entering:'||l_proc,5);
572: --
573: l_api_updating := ben_xcv_shd.api_updating
574: (p_ext_crit_val_id => p_ext_crit_val_id,
575: p_object_version_number => p_object_version_number);
576: --
577: if (l_api_updating

Line 579: <> nvl(ben_xcv_shd.g_old_rec.val_1,hr_api.g_varchar2)

575: p_object_version_number => p_object_version_number);
576: --
577: if (l_api_updating
578: and nvl(p_val_1,hr_api.g_varchar2)
579: <> nvl(ben_xcv_shd.g_old_rec.val_1,hr_api.g_varchar2)
580: or not l_api_updating) then
581: --
582: -- val_1 is mandatory
583: --

Line 928: l_api_updating := ben_xcv_shd.api_updating

924: Begin
925: --
926: hr_utility.set_location('Entering:'||l_proc,5);
927: --
928: l_api_updating := ben_xcv_shd.api_updating
929: (p_ext_crit_val_id => p_ext_crit_val_id,
930: p_object_version_number => p_object_version_number);
931: --
932: if (l_api_updating

Line 934: <> nvl(ben_xcv_shd.g_old_rec.val_2,hr_api.g_varchar2)

930: p_object_version_number => p_object_version_number);
931: --
932: if (l_api_updating
933: and nvl(p_val_2,hr_api.g_varchar2)
934: <> nvl(ben_xcv_shd.g_old_rec.val_2,hr_api.g_varchar2)
935: or not l_api_updating) then
936: --
937: open c1;
938: -- won't fail because already checked in above edit.

Line 1025: l_api_updating := ben_xcv_shd.api_updating

1021: Begin
1022: --
1023: hr_utility.set_location('Entering:'||l_proc,5);
1024: --
1025: l_api_updating := ben_xcv_shd.api_updating
1026: (p_ext_crit_val_id => p_ext_crit_val_id,
1027: p_object_version_number => p_object_version_number);
1028: --
1029: if (l_api_updating

Line 1032: <> nvl(ben_xcv_shd.g_old_rec.val_1,hr_api.g_varchar2) or

1028: --
1029: if (l_api_updating
1030: and
1031: (nvl(p_val_1,hr_api.g_varchar2)
1032: <> nvl(ben_xcv_shd.g_old_rec.val_1,hr_api.g_varchar2) or
1033: nvl(p_val_2,hr_api.g_varchar2)
1034: <> nvl(ben_xcv_shd.g_old_rec.val_2,hr_api.g_varchar2))
1035: or not l_api_updating) then
1036: --

Line 1034: <> nvl(ben_xcv_shd.g_old_rec.val_2,hr_api.g_varchar2))

1030: and
1031: (nvl(p_val_1,hr_api.g_varchar2)
1032: <> nvl(ben_xcv_shd.g_old_rec.val_1,hr_api.g_varchar2) or
1033: nvl(p_val_2,hr_api.g_varchar2)
1034: <> nvl(ben_xcv_shd.g_old_rec.val_2,hr_api.g_varchar2))
1035: or not l_api_updating) then
1036: --
1037: open c1;
1038: fetch c1 into l_crit_typ_cd;

Line 1064: Procedure insert_validate(p_rec in ben_xcv_shd.g_rec_type

1060: End chk_val_dpndcy;
1061: -- ----------------------------------------------------------------------------
1062: -- |---------------------------< insert_validate >----------------------------|
1063: -- ----------------------------------------------------------------------------
1064: Procedure insert_validate(p_rec in ben_xcv_shd.g_rec_type
1065: ,p_effective_date in date) is
1066: --
1067: l_proc varchar2(72) := g_package||'insert_validate';
1068: --

Line 1133: Procedure update_validate(p_rec in ben_xcv_shd.g_rec_type

1129: --
1130: -- ----------------------------------------------------------------------------
1131: -- |---------------------------< update_validate >----------------------------|
1132: -- ----------------------------------------------------------------------------
1133: Procedure update_validate(p_rec in ben_xcv_shd.g_rec_type
1134: ,p_effective_date in date) is
1135: --
1136: l_proc varchar2(72) := g_package||'update_validate';
1137: --

Line 1202: Procedure delete_validate(p_rec in ben_xcv_shd.g_rec_type) is

1198: --
1199: -- ----------------------------------------------------------------------------
1200: -- |---------------------------< delete_validate >----------------------------|
1201: -- ----------------------------------------------------------------------------
1202: Procedure delete_validate(p_rec in ben_xcv_shd.g_rec_type) is
1203: --
1204: l_proc varchar2(72) := g_package||'delete_validate';
1205: --
1206: Begin

Line 1212: ,ben_xcv_shd.g_old_rec.business_group_id

1208: --
1209: -- Call all supporting business operations
1210: --
1211: chk_startup_action(False
1212: ,ben_xcv_shd.g_old_rec.business_group_id
1213: ,ben_xcv_shd.g_old_rec.legislation_code);
1214: --
1215: hr_utility.set_location(' Leaving:'||l_proc, 10);
1216: End delete_validate;

Line 1213: ,ben_xcv_shd.g_old_rec.legislation_code);

1209: -- Call all supporting business operations
1210: --
1211: chk_startup_action(False
1212: ,ben_xcv_shd.g_old_rec.business_group_id
1213: ,ben_xcv_shd.g_old_rec.legislation_code);
1214: --
1215: hr_utility.set_location(' Leaving:'||l_proc, 10);
1216: End delete_validate;
1217: --