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_EGL_BUS dependencies on BEN_EGL_SHD

Line 46: l_api_updating := ben_egl_shd.api_updating

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

Line 52: <> ben_egl_shd.g_old_rec.eligy_criteria_id) then

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

Line 56: ben_egl_shd.constraint_error('BEN_eligy_criteria_PK');

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

Line 66: ben_egl_shd.constraint_error('BEN_eligy_criteria_PK');

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

Line 246: l_api_updating := ben_egl_shd.api_updating

242: Begin
243: --
244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --
246: l_api_updating := ben_egl_shd.api_updating
247: (p_eligy_criteria_id => p_eligy_criteria_id,
248: p_object_version_number => p_object_version_number);
249: --
250: if (l_api_updating

Line 252: <> nvl(ben_egl_shd.g_old_rec.criteria_type,hr_api.g_varchar2)

248: p_object_version_number => p_object_version_number);
249: --
250: if (l_api_updating
251: and p_criteria_type
252: <> nvl(ben_egl_shd.g_old_rec.criteria_type,hr_api.g_varchar2)
253: or not l_api_updating)
254: and p_criteria_type is not null then
255: --
256: -- check if value of lookup falls within lookup type.

Line 277: <> nvl(ben_egl_shd.g_old_rec.crit_col1_val_type_cd,hr_api.g_varchar2)

273: end if;
274: --
275: if (l_api_updating
276: and p_crit_col1_val_type_cd
277: <> nvl(ben_egl_shd.g_old_rec.crit_col1_val_type_cd,hr_api.g_varchar2)
278: or not l_api_updating)
279: and p_crit_col1_val_type_cd is not null then
280: --
281: -- check if value of lookup falls within lookup type.

Line 302: <> nvl(ben_egl_shd.g_old_rec.crit_col1_datatype,hr_api.g_varchar2)

298: end if;
299: --
300: if (l_api_updating
301: and p_crit_col1_datatype
302: <> nvl(ben_egl_shd.g_old_rec.crit_col1_datatype,hr_api.g_varchar2)
303: or not l_api_updating)
304: and p_crit_col1_datatype is not null then
305: --
306: -- check if value of lookup falls within lookup type.

Line 327: <> nvl(ben_egl_shd.g_old_rec.crit_col2_val_type_cd,hr_api.g_varchar2)

323: end if;
324: --
325: if (l_api_updating
326: and p_crit_col2_val_type_cd
327: <> nvl(ben_egl_shd.g_old_rec.crit_col2_val_type_cd,hr_api.g_varchar2)
328: or not l_api_updating)
329: and p_crit_col2_val_type_cd is not null then
330: --
331: -- check if value of lookup falls within lookup type.

Line 352: <> nvl(ben_egl_shd.g_old_rec.allow_range_validation_flg,hr_api.g_varchar2)

348: end if;
349: --
350: if (l_api_updating
351: and p_allow_range_validation_flg
352: <> nvl(ben_egl_shd.g_old_rec.allow_range_validation_flg,hr_api.g_varchar2)
353: or not l_api_updating)
354: and p_allow_range_validation_flg is not null then
355: --
356: -- check if value of lookup falls within lookup type.

Line 378: <> nvl(ben_egl_shd.g_old_rec.allow_range_validation_flag2,hr_api.g_varchar2)

374: --
375: -- Added by rbingi for allow_range_validation_flag2 exixts check in Lookup
376: if (l_api_updating
377: and p_allow_range_validation_flag2
378: <> nvl(ben_egl_shd.g_old_rec.allow_range_validation_flag2,hr_api.g_varchar2)
379: or not l_api_updating)
380: and p_allow_range_validation_flag2 is not null then
381: --
382: -- check if value of lookup falls within lookup type.

Line 404: <> nvl(ben_egl_shd.g_old_rec.user_defined_flag,hr_api.g_varchar2)

400: --
401:
402: if (l_api_updating
403: and p_user_defined_flag
404: <> nvl(ben_egl_shd.g_old_rec.user_defined_flag,hr_api.g_varchar2)
405: or not l_api_updating)
406: and p_user_defined_flag is not null then
407: --
408: -- check if value of lookup falls within lookup type.

Line 504: l_api_updating := ben_egl_shd.api_updating

500: begin
501: hr_utility.set_location('Entering:'||l_proc, 5);
502: --
503: --
504: l_api_updating := ben_egl_shd.api_updating
505: (p_eligy_criteria_id => p_eligy_criteria_id,
506: p_object_version_number => p_object_version_number);
507: --
508: if (l_api_updating

Line 510: <> nvl(ben_egl_shd.g_old_rec.col1_lookup_type,hr_api.g_varchar2)

506: p_object_version_number => p_object_version_number);
507: --
508: if (l_api_updating
509: and p_col1_lookup_type
510: <> nvl(ben_egl_shd.g_old_rec.col1_lookup_type,hr_api.g_varchar2)
511: or not l_api_updating)
512: and p_col1_lookup_type is not null then
513: --
514: open c1(p_col1_lookup_type, p_business_group_id);

Line 529: <> nvl(ben_egl_shd.g_old_rec.col2_lookup_type,hr_api.g_varchar2)

525: --
526:
527: if (l_api_updating
528: and p_col2_lookup_type
529: <> nvl(ben_egl_shd.g_old_rec.col2_lookup_type,hr_api.g_varchar2)
530: or not l_api_updating)
531: and p_col2_lookup_type is not null then
532: --
533: open c1(p_col2_lookup_type, p_business_group_id);

Line 599: l_api_updating := ben_egl_shd.api_updating

595: Begin
596: hr_utility.set_location('Entering:'||l_proc, 5);
597: --
598: --
599: l_api_updating := ben_egl_shd.api_updating
600: (p_eligy_criteria_id => p_eligy_criteria_id,
601: p_object_version_number => p_object_version_number);
602: --
603: if (l_api_updating

Line 605: <> nvl(ben_egl_shd.g_old_rec.access_calc_rule,hr_api.g_number)

601: p_object_version_number => p_object_version_number);
602: --
603: if (l_api_updating
604: and p_access_calc_rule
605: <> nvl(ben_egl_shd.g_old_rec.access_calc_rule,hr_api.g_number)
606: or not l_api_updating)
607: and p_access_calc_rule is not null
608: then
609: --

Line 693: l_api_updating := ben_egl_shd.api_updating

689: Begin
690: hr_utility.set_location('Entering:'||l_proc, 5);
691: --
692: --
693: l_api_updating := ben_egl_shd.api_updating
694: (p_eligy_criteria_id => p_eligy_criteria_id,
695: p_object_version_number => p_object_version_number);
696: --
697: if (l_api_updating

Line 699: <> nvl(ben_egl_shd.g_old_rec.col1_value_set_id,hr_api.g_number)

695: p_object_version_number => p_object_version_number);
696: --
697: if (l_api_updating
698: and p_col1_value_set_id
699: <> nvl(ben_egl_shd.g_old_rec.col1_value_set_id,hr_api.g_number)
700: or not l_api_updating)
701: and p_col1_value_set_id is not null then
702: --
703: open c1(p_col1_value_set_id);

Line 718: <> nvl(ben_egl_shd.g_old_rec.col2_value_set_id,hr_api.g_number)

714:
715:
716: if (l_api_updating
717: and p_col2_value_set_id
718: <> nvl(ben_egl_shd.g_old_rec.col2_value_set_id,hr_api.g_number)
719: or not l_api_updating)
720: and p_col2_value_set_id is not null then
721: --
722: open c1(p_col2_value_set_id);

Line 1216: l_api_updating := ben_egl_shd.api_updating

1212: Begin
1213: hr_utility.set_location('Entering:'||l_proc, 5);
1214: --
1215: --
1216: l_api_updating := ben_egl_shd.api_updating
1217: (p_eligy_criteria_id => p_eligy_criteria_id,
1218: p_object_version_number => p_object_version_number);
1219: --
1220: --

Line 1241: <> nvl(ben_egl_shd.g_old_rec.crit_col1_val_type_cd,hr_api.g_number)

1237: else
1238: if (
1239: (l_api_updating
1240: and p_crit_col_val_type_cd
1241: <> nvl(ben_egl_shd.g_old_rec.crit_col1_val_type_cd,hr_api.g_number)
1242: )
1243: or not l_api_updating
1244: )
1245: and p_crit_col_val_type_cd is not null then

Line 1370: l_api_updating := ben_egl_shd.api_updating

1366: Begin
1367: hr_utility.set_location('Entering:'||l_proc, 5);
1368: --
1369: --
1370: l_api_updating := ben_egl_shd.api_updating
1371: (p_eligy_criteria_id => p_eligy_criteria_id,
1372: p_object_version_number => p_object_version_number);
1373: --
1374:

Line 1377: <> nvl(ben_egl_shd.g_old_rec.access_calc_rule,hr_api.g_number)

1373: --
1374:
1375: if (l_api_updating
1376: and p_access_calc_rule
1377: <> nvl(ben_egl_shd.g_old_rec.access_calc_rule,hr_api.g_number)
1378: or not l_api_updating)
1379: and p_access_calc_rule is not null then
1380: --
1381: chk_child_records(p_eligy_criteria_id => p_eligy_criteria_id);

Line 1387: <> nvl(ben_egl_shd.g_old_rec.access_table_name1,hr_api.g_number)

1383: end if;
1384: --
1385: if (l_api_updating
1386: and p_access_table_name1
1387: <> nvl(ben_egl_shd.g_old_rec.access_table_name1,hr_api.g_number)
1388: or not l_api_updating)
1389: and p_access_table_name1 is not null then
1390: --
1391: chk_child_records(p_eligy_criteria_id => p_eligy_criteria_id);

Line 1397: <> nvl(ben_egl_shd.g_old_rec.access_column_name1,hr_api.g_number)

1393: end if;
1394: --
1395: if (l_api_updating
1396: and p_access_column_name1
1397: <> nvl(ben_egl_shd.g_old_rec.access_column_name1,hr_api.g_number)
1398: or not l_api_updating)
1399: and p_access_column_name1 is not null then
1400: --
1401: chk_child_records(p_eligy_criteria_id => p_eligy_criteria_id);

Line 1426: l_api_updating := ben_egl_shd.api_updating

1422: --
1423: Begin
1424: --
1425: --
1426: l_api_updating := ben_egl_shd.api_updating
1427: (p_eligy_criteria_id => p_eligy_criteria_id,
1428: p_object_version_number => p_object_version_number);
1429: --
1430: if -- Flag 1 is changed

Line 1433: <> nvl(ben_egl_shd.g_old_rec.allow_range_validation_flg,hr_api.g_varchar2)

1429: --
1430: if -- Flag 1 is changed
1431: (((l_api_updating
1432: and p_allow_range_validation_flg
1433: <> nvl(ben_egl_shd.g_old_rec.allow_range_validation_flg,hr_api.g_varchar2)
1434: or not l_api_updating) and p_allow_range_validation_flg is not null)
1435: or -- Flag 2 is changed
1436: ((l_api_updating
1437: and p_allow_range_validation_flg2

Line 1438: <> nvl(ben_egl_shd.g_old_rec.allow_range_validation_flag2,hr_api.g_varchar2)

1434: or not l_api_updating) and p_allow_range_validation_flg is not null)
1435: or -- Flag 2 is changed
1436: ((l_api_updating
1437: and p_allow_range_validation_flg2
1438: <> nvl(ben_egl_shd.g_old_rec.allow_range_validation_flag2,hr_api.g_varchar2)
1439: or not l_api_updating) and p_allow_range_validation_flg2 is not null)
1440: ) then
1441: --
1442: chk_child_records(p_eligy_criteria_id => p_eligy_criteria_id);

Line 1453: Procedure insert_validate(p_rec in ben_egl_shd.g_rec_type

1449: --
1450: -- ----------------------------------------------------------------------------
1451: -- |---------------------------< insert_validate >----------------------------|
1452: -- ----------------------------------------------------------------------------
1453: Procedure insert_validate(p_rec in ben_egl_shd.g_rec_type
1454: ,p_effective_date in date) is
1455: --
1456: l_proc varchar2(72) := g_package||'insert_validate';
1457: l_set2_empty varchar2(1) := 'Y';

Line 1613: Procedure update_validate(p_rec in ben_egl_shd.g_rec_type

1609: --
1610: -- ----------------------------------------------------------------------------
1611: -- |---------------------------< update_validate >----------------------------|
1612: -- ----------------------------------------------------------------------------
1613: Procedure update_validate(p_rec in ben_egl_shd.g_rec_type
1614: ,p_effective_date in date) is
1615: --
1616: l_proc varchar2(72) := g_package||'update_validate';
1617: l_set2_empty varchar2(1) := 'Y';

Line 1804: Procedure delete_validate(p_rec in ben_egl_shd.g_rec_type

1800: --
1801: -- ----------------------------------------------------------------------------
1802: -- |---------------------------< delete_validate >----------------------------|
1803: -- ----------------------------------------------------------------------------
1804: Procedure delete_validate(p_rec in ben_egl_shd.g_rec_type
1805: ,p_effective_date in date) is
1806: --
1807: l_proc varchar2(72) := g_package||'delete_validate';
1808: --