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 HR_API

Line 51: and nvl(p_eligy_criteria_id,hr_api.g_number)

47: (p_eligy_criteria_id => p_eligy_criteria_id,
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: --

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 258: if hr_api.not_exists_in_hr_lookups

254: and p_criteria_type is not null then
255: --
256: -- check if value of lookup falls within lookup type.
257: --
258: if hr_api.not_exists_in_hr_lookups
259: (p_lookup_type => 'BEN_CRITERIA_TYPE',
260: p_lookup_code => p_criteria_type,
261: p_effective_date => p_effective_date) then
262: --

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 283: if hr_api.not_exists_in_hr_lookups

279: and p_crit_col1_val_type_cd is not null then
280: --
281: -- check if value of lookup falls within lookup type.
282: --
283: if hr_api.not_exists_in_hr_lookups
284: (p_lookup_type => 'CRIT_COL1_VAL_TYPE_CD',
285: p_lookup_code => p_crit_col1_val_type_cd,
286: p_effective_date => p_effective_date) then
287: --

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 308: if hr_api.not_exists_in_hr_lookups

304: and p_crit_col1_datatype is not null then
305: --
306: -- check if value of lookup falls within lookup type.
307: --
308: if hr_api.not_exists_in_hr_lookups
309: (p_lookup_type => 'CRIT_COL1_DATATYPE',
310: p_lookup_code => p_crit_col1_datatype,
311: p_effective_date => p_effective_date) then
312: --

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 333: if hr_api.not_exists_in_hr_lookups

329: and p_crit_col2_val_type_cd is not null then
330: --
331: -- check if value of lookup falls within lookup type.
332: --
333: if hr_api.not_exists_in_hr_lookups
334: (p_lookup_type => 'CRIT_COL1_VAL_TYPE_CD',
335: p_lookup_code => p_crit_col2_val_type_cd,
336: p_effective_date => p_effective_date) then
337: --

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 358: if hr_api.not_exists_in_hr_lookups

354: and p_allow_range_validation_flg is not null then
355: --
356: -- check if value of lookup falls within lookup type.
357: --
358: if hr_api.not_exists_in_hr_lookups
359: (p_lookup_type => 'YES_NO',
360: p_lookup_code => p_allow_range_validation_flg,
361: p_effective_date => p_effective_date) then
362: --

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 384: if hr_api.not_exists_in_hr_lookups

380: and p_allow_range_validation_flag2 is not null then
381: --
382: -- check if value of lookup falls within lookup type.
383: --
384: if hr_api.not_exists_in_hr_lookups
385: (p_lookup_type => 'YES_NO',
386: p_lookup_code => p_allow_range_validation_flag2,
387: p_effective_date => p_effective_date) then
388: --

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 410: if hr_api.not_exists_in_hr_lookups

406: and p_user_defined_flag is not null then
407: --
408: -- check if value of lookup falls within lookup type.
409: --
410: if hr_api.not_exists_in_hr_lookups
411: (p_lookup_type => 'YES_NO',
412: p_lookup_code => p_user_defined_flag,
413: p_effective_date => p_effective_date) then
414: --

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 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 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 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 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 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 1465: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1461: --
1462: -- Call all supporting business operations
1463: --
1464: --
1465: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1466: --
1467: chk_eligy_criteria_id(p_eligy_criteria_id => p_rec.eligy_criteria_id,
1468: p_object_version_number => p_rec.object_version_number);
1469: --

Line 1625: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1621: --
1622: -- Call all supporting business operations
1623: --
1624: --
1625: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1626: --
1627: chk_eligy_criteria_id( p_eligy_criteria_id => p_rec.eligy_criteria_id,
1628: p_object_version_number => p_rec.object_version_number);
1629: --

Line 1848: hr_api.mandatory_arg_error(p_api_name => l_proc,

1844: hr_utility.set_location('Entering:'|| l_proc, 10);
1845: --
1846: -- Ensure that all the mandatory parameter are not null
1847: --
1848: hr_api.mandatory_arg_error(p_api_name => l_proc,
1849: p_argument => 'eligy_criteria_id',
1850: p_argument_value => p_eligy_criteria_id);
1851: --
1852: open csr_leg_code;