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_DPNT_EGD_BUS dependencies on BEN_DPNT_EGD_SHD

Line 46: l_api_updating := ben_dpnt_egd_shd.api_updating

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

Line 52: <> ben_dpnt_egd_shd.g_old_rec.eligy_criteria_dpnt_id) then

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

Line 56: ben_dpnt_egd_shd.constraint_error('BEN_dpnt_eligy_criteria_PK');

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

Line 66: ben_dpnt_egd_shd.constraint_error('BEN_dpnt_eligy_criteria_PK');

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

Line 247: l_api_updating := ben_dpnt_egd_shd.api_updating

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

Line 253: <> nvl(ben_dpnt_egd_shd.g_old_rec.criteria_type,hr_api.g_varchar2)

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

Line 278: <> nvl(ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd,hr_api.g_varchar2)

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

Line 303: <> nvl(ben_dpnt_egd_shd.g_old_rec.crit_col1_datatype,hr_api.g_varchar2)

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

Line 328: <> nvl(ben_dpnt_egd_shd.g_old_rec.crit_col2_val_type_cd,hr_api.g_varchar2)

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

Line 353: <> nvl(ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg,hr_api.g_varchar2)

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

Line 379: <> nvl(ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2,hr_api.g_varchar2)

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

Line 405: <> nvl(ben_dpnt_egd_shd.g_old_rec.user_defined_flag,hr_api.g_varchar2)

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

Line 505: l_api_updating := ben_dpnt_egd_shd.api_updating

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

Line 511: <> nvl(ben_dpnt_egd_shd.g_old_rec.col1_lookup_type,hr_api.g_varchar2)

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

Line 530: <> nvl(ben_dpnt_egd_shd.g_old_rec.col2_lookup_type,hr_api.g_varchar2)

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

Line 601: l_api_updating := ben_dpnt_egd_shd.api_updating

597: Begin
598: hr_utility.set_location('Entering:'||l_proc, 5);
599: --
600: --
601: l_api_updating := ben_dpnt_egd_shd.api_updating
602: (p_eligy_criteria_dpnt_id => p_eligy_criteria_dpnt_id,
603: p_object_version_number => p_object_version_number);
604: --
605: if (l_api_updating

Line 607: <> nvl(ben_dpnt_egd_shd.g_old_rec.access_calc_rule,hr_api.g_number)

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

Line 689: l_api_updating := ben_dpnt_egd_shd.api_updating

685: Begin
686: hr_utility.set_location('Entering:'||l_proc, 5);
687: --
688: --
689: l_api_updating := ben_dpnt_egd_shd.api_updating
690: (p_eligy_criteria_dpnt_id => p_eligy_criteria_dpnt_id,
691: p_object_version_number => p_object_version_number);
692: --
693: if (l_api_updating

Line 695: <> nvl(ben_dpnt_egd_shd.g_old_rec.col1_value_set_id,hr_api.g_number)

691: p_object_version_number => p_object_version_number);
692: --
693: if (l_api_updating
694: and p_col1_value_set_id
695: <> nvl(ben_dpnt_egd_shd.g_old_rec.col1_value_set_id,hr_api.g_number)
696: or not l_api_updating)
697: and p_col1_value_set_id is not null then
698: --
699: open c1(p_col1_value_set_id);

Line 714: <> nvl(ben_dpnt_egd_shd.g_old_rec.col2_value_set_id,hr_api.g_number)

710:
711:
712: if (l_api_updating
713: and p_col2_value_set_id
714: <> nvl(ben_dpnt_egd_shd.g_old_rec.col2_value_set_id,hr_api.g_number)
715: or not l_api_updating)
716: and p_col2_value_set_id is not null then
717: --
718: open c1(p_col2_value_set_id);

Line 1210: l_api_updating := ben_dpnt_egd_shd.api_updating

1206: Begin
1207: hr_utility.set_location('Entering:'||l_proc, 5);
1208: --
1209: --
1210: l_api_updating := ben_dpnt_egd_shd.api_updating
1211: (p_eligy_criteria_dpnt_id => p_eligy_criteria_dpnt_id,
1212: p_object_version_number => p_object_version_number);
1213: --
1214: --

Line 1235: <> nvl(ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd,hr_api.g_number)

1231: else
1232: if (
1233: (l_api_updating
1234: and p_crit_col_val_type_cd
1235: <> nvl(ben_dpnt_egd_shd.g_old_rec.crit_col1_val_type_cd,hr_api.g_number)
1236: )
1237: or not l_api_updating
1238: )
1239: and p_crit_col_val_type_cd is not null then

Line 1361: l_api_updating := ben_dpnt_egd_shd.api_updating

1357: Begin
1358: hr_utility.set_location('Entering:'||l_proc, 5);
1359: --
1360: --
1361: l_api_updating := ben_dpnt_egd_shd.api_updating
1362: (p_eligy_criteria_dpnt_id => p_eligy_criteria_dpnt_id,
1363: p_object_version_number => p_object_version_number);
1364: --
1365:

Line 1376: <> nvl(ben_dpnt_egd_shd.g_old_rec.access_table_name1,hr_api.g_number)

1372: end if;
1373: --
1374: if (l_api_updating
1375: and p_access_table_name1
1376: <> nvl(ben_dpnt_egd_shd.g_old_rec.access_table_name1,hr_api.g_number)
1377: or not l_api_updating)
1378: and p_access_table_name1 is not null then
1379: --
1380: chk_child_records(p_eligy_criteria_dpnt_id => p_eligy_criteria_dpnt_id);

Line 1386: <> nvl(ben_dpnt_egd_shd.g_old_rec.access_column_name1,hr_api.g_number)

1382: end if;
1383: --
1384: if (l_api_updating
1385: and p_access_column_name1
1386: <> nvl(ben_dpnt_egd_shd.g_old_rec.access_column_name1,hr_api.g_number)
1387: or not l_api_updating)
1388: and p_access_column_name1 is not null then
1389: --
1390: chk_child_records(p_eligy_criteria_dpnt_id => p_eligy_criteria_dpnt_id);

Line 1415: l_api_updating := ben_dpnt_egd_shd.api_updating

1411: --
1412: Begin
1413: --
1414: --
1415: l_api_updating := ben_dpnt_egd_shd.api_updating
1416: (p_eligy_criteria_dpnt_id => p_eligy_criteria_dpnt_id,
1417: p_object_version_number => p_object_version_number);
1418: --
1419: if -- Flag 1 is changed

Line 1422: <> nvl(ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg,hr_api.g_varchar2)

1418: --
1419: if -- Flag 1 is changed
1420: (((l_api_updating
1421: and p_allow_range_validation_flg
1422: <> nvl(ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flg,hr_api.g_varchar2)
1423: or not l_api_updating) and p_allow_range_validation_flg is not null)
1424: or -- Flag 2 is changed
1425: ((l_api_updating
1426: and p_allow_range_validation_flg2

Line 1427: <> nvl(ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2,hr_api.g_varchar2)

1423: or not l_api_updating) and p_allow_range_validation_flg is not null)
1424: or -- Flag 2 is changed
1425: ((l_api_updating
1426: and p_allow_range_validation_flg2
1427: <> nvl(ben_dpnt_egd_shd.g_old_rec.allow_range_validation_flag2,hr_api.g_varchar2)
1428: or not l_api_updating) and p_allow_range_validation_flg2 is not null)
1429: ) then
1430: --
1431: chk_child_records(p_eligy_criteria_dpnt_id => p_eligy_criteria_dpnt_id);

Line 1442: Procedure insert_validate(p_rec in ben_dpnt_egd_shd.g_rec_type

1438: --
1439: -- ----------------------------------------------------------------------------
1440: -- |---------------------------< insert_validate >----------------------------|
1441: -- ----------------------------------------------------------------------------
1442: Procedure insert_validate(p_rec in ben_dpnt_egd_shd.g_rec_type
1443: ,p_effective_date in date) is
1444: --
1445: l_proc varchar2(72) := g_package||'insert_validate';
1446: l_set2_empty varchar2(1) := 'Y';

Line 1596: Procedure update_validate(p_rec in ben_dpnt_egd_shd.g_rec_type

1592: --
1593: -- ----------------------------------------------------------------------------
1594: -- |---------------------------< update_validate >----------------------------|
1595: -- ----------------------------------------------------------------------------
1596: Procedure update_validate(p_rec in ben_dpnt_egd_shd.g_rec_type
1597: ,p_effective_date in date) is
1598: --
1599: l_proc varchar2(72) := g_package||'update_validate';
1600: l_set2_empty varchar2(1) := 'Y';

Line 1778: Procedure delete_validate(p_rec in ben_dpnt_egd_shd.g_rec_type

1774: --
1775: -- ----------------------------------------------------------------------------
1776: -- |---------------------------< delete_validate >----------------------------|
1777: -- ----------------------------------------------------------------------------
1778: Procedure delete_validate(p_rec in ben_dpnt_egd_shd.g_rec_type
1779: ,p_effective_date in date) is
1780: --
1781: l_proc varchar2(72) := g_package||'delete_validate';
1782: --