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 HR_API

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

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
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: --

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1450: --
1451: -- Call all supporting business operations
1452: --
1453: --
1454: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1455: --
1456: chk_eligy_criteria_dpnt_id(p_eligy_criteria_dpnt_id => p_rec.eligy_criteria_dpnt_id,
1457: p_object_version_number => p_rec.object_version_number);
1458: --

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

1604: --
1605: -- Call all supporting business operations
1606: --
1607: --
1608: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1609: --
1610: chk_eligy_criteria_dpnt_id( p_eligy_criteria_dpnt_id => p_rec.eligy_criteria_dpnt_id,
1611: p_object_version_number => p_rec.object_version_number);
1612: --

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

1820: hr_utility.set_location('Entering:'|| l_proc, 10);
1821: --
1822: -- Ensure that all the mandatory parameter are not null
1823: --
1824: hr_api.mandatory_arg_error(p_api_name => l_proc,
1825: p_argument => 'eligy_criteria_dpnt_id',
1826: p_argument_value => p_eligy_criteria_dpnt_id);
1827: --
1828: open csr_leg_code;