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_BLI_BUS dependencies on HR_API

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

47: (p_batch_ler_id => p_batch_ler_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_batch_ler_id,hr_api.g_number)
52: <> ben_bli_shd.g_old_rec.batch_ler_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 128: and nvl(p_ler_id,hr_api.g_number)

124: (p_batch_ler_id => p_batch_ler_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_ler_id,hr_api.g_number)
129: <> nvl(ben_bli_shd.g_old_rec.ler_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if ler_id value exists in ben_ler_f table

Line 129: <> nvl(ben_bli_shd.g_old_rec.ler_id,hr_api.g_number)

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_ler_id,hr_api.g_number)
129: <> nvl(ben_bli_shd.g_old_rec.ler_id,hr_api.g_number)
130: or not l_api_updating) then
131: --
132: -- check if ler_id value exists in ben_ler_f table
133: --

Line 208: and nvl(p_person_id,hr_api.g_number)

204: (p_batch_ler_id => p_batch_ler_id,
205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and nvl(p_person_id,hr_api.g_number)
209: <> nvl(ben_bli_shd.g_old_rec.person_id,hr_api.g_number)
210: or not l_api_updating) then
211: --
212: -- check if person_id value exists in per_all_people_f table

Line 209: <> nvl(ben_bli_shd.g_old_rec.person_id,hr_api.g_number)

205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and nvl(p_person_id,hr_api.g_number)
209: <> nvl(ben_bli_shd.g_old_rec.person_id,hr_api.g_number)
210: or not l_api_updating) then
211: --
212: -- check if person_id value exists in per_all_people_f table
213: --

Line 283: and nvl(p_benefit_action_id,hr_api.g_number)

279: (p_batch_ler_id => p_batch_ler_id,
280: p_object_version_number => p_object_version_number);
281: --
282: if (l_api_updating
283: and nvl(p_benefit_action_id,hr_api.g_number)
284: <> nvl(ben_bli_shd.g_old_rec.benefit_action_id,hr_api.g_number)
285: or not l_api_updating) then
286: --
287: -- check if benefit_action_id value exists in ben_benefit_actions table

Line 284: <> nvl(ben_bli_shd.g_old_rec.benefit_action_id,hr_api.g_number)

280: p_object_version_number => p_object_version_number);
281: --
282: if (l_api_updating
283: and nvl(p_benefit_action_id,hr_api.g_number)
284: <> nvl(ben_bli_shd.g_old_rec.benefit_action_id,hr_api.g_number)
285: or not l_api_updating) then
286: --
287: -- check if benefit_action_id value exists in ben_benefit_actions table
288: --

Line 355: <> nvl(ben_bli_shd.g_old_rec.dltd_flag,hr_api.g_varchar2)

351: p_object_version_number => p_object_version_number);
352: --
353: if (l_api_updating
354: and p_dltd_flag
355: <> nvl(ben_bli_shd.g_old_rec.dltd_flag,hr_api.g_varchar2)
356: or not l_api_updating) then
357: --
358: -- check if value of lookup falls within lookup type.
359: --

Line 361: if hr_api.not_exists_in_hr_lookups

357: --
358: -- check if value of lookup falls within lookup type.
359: --
360: --
361: if hr_api.not_exists_in_hr_lookups
362: (p_lookup_type => 'YES_NO',
363: p_lookup_code => p_dltd_flag,
364: p_effective_date => p_effective_date) then
365: --

Line 425: <> nvl(ben_bli_shd.g_old_rec.tmprl_flag,hr_api.g_varchar2)

421: p_object_version_number => p_object_version_number);
422: --
423: if (l_api_updating
424: and p_tmprl_flag
425: <> nvl(ben_bli_shd.g_old_rec.tmprl_flag,hr_api.g_varchar2)
426: or not l_api_updating) then
427: --
428: -- check if value of lookup falls within lookup type.
429: --

Line 431: if hr_api.not_exists_in_hr_lookups

427: --
428: -- check if value of lookup falls within lookup type.
429: --
430: --
431: if hr_api.not_exists_in_hr_lookups
432: (p_lookup_type => 'YES_NO',
433: p_lookup_code => p_tmprl_flag,
434: p_effective_date => p_effective_date) then
435: --

Line 495: <> nvl(ben_bli_shd.g_old_rec.crtd_flag,hr_api.g_varchar2)

491: p_object_version_number => p_object_version_number);
492: --
493: if (l_api_updating
494: and p_crtd_flag
495: <> nvl(ben_bli_shd.g_old_rec.crtd_flag,hr_api.g_varchar2)
496: or not l_api_updating) then
497: --
498: -- check if value of lookup falls within lookup type.
499: --

Line 501: if hr_api.not_exists_in_hr_lookups

497: --
498: -- check if value of lookup falls within lookup type.
499: --
500: --
501: if hr_api.not_exists_in_hr_lookups
502: (p_lookup_type => 'YES_NO',
503: p_lookup_code => p_crtd_flag,
504: p_effective_date => p_effective_date) then
505: --

Line 565: <> nvl(ben_bli_shd.g_old_rec.clpsd_flag,hr_api.g_varchar2)

561: p_object_version_number => p_object_version_number);
562: --
563: if (l_api_updating
564: and p_clpsd_flag
565: <> nvl(ben_bli_shd.g_old_rec.clpsd_flag,hr_api.g_varchar2)
566: or not l_api_updating) then
567: --
568: -- check if value of lookup falls within lookup type.
569: --

Line 571: if hr_api.not_exists_in_hr_lookups

567: --
568: -- check if value of lookup falls within lookup type.
569: --
570: --
571: if hr_api.not_exists_in_hr_lookups
572: (p_lookup_type => 'YES_NO',
573: p_lookup_code => p_clpsd_flag,
574: p_effective_date => p_effective_date) then
575: --

Line 634: <> nvl(ben_bli_shd.g_old_rec.clsn_flag,hr_api.g_varchar2)

630: p_object_version_number => p_object_version_number);
631: --
632: if (l_api_updating
633: and p_clsn_flag
634: <> nvl(ben_bli_shd.g_old_rec.clsn_flag,hr_api.g_varchar2)
635: or not l_api_updating) then
636: --
637: -- check if value of lookup falls within lookup type.
638: --

Line 640: if hr_api.not_exists_in_hr_lookups

636: --
637: -- check if value of lookup falls within lookup type.
638: --
639: --
640: if hr_api.not_exists_in_hr_lookups
641: (p_lookup_type => 'YES_NO',
642: p_lookup_code => p_clsn_flag,
643: p_effective_date => p_effective_date) then
644: --

Line 703: <> nvl(ben_bli_shd.g_old_rec.no_effect_flag,hr_api.g_varchar2)

699: p_object_version_number => p_object_version_number);
700: --
701: if (l_api_updating
702: and p_no_effect_flag
703: <> nvl(ben_bli_shd.g_old_rec.no_effect_flag,hr_api.g_varchar2)
704: or not l_api_updating) then
705: --
706: -- check if value of lookup falls within lookup type.
707: --

Line 709: if hr_api.not_exists_in_hr_lookups

705: --
706: -- check if value of lookup falls within lookup type.
707: --
708: --
709: if hr_api.not_exists_in_hr_lookups
710: (p_lookup_type => 'YES_NO',
711: p_lookup_code => p_no_effect_flag,
712: p_effective_date => p_effective_date) then
713: --

Line 772: <> nvl(ben_bli_shd.g_old_rec.cvrge_rt_prem_flag,hr_api.g_varchar2)

768: p_object_version_number => p_object_version_number);
769: --
770: if (l_api_updating
771: and p_cvrge_rt_prem_flag
772: <> nvl(ben_bli_shd.g_old_rec.cvrge_rt_prem_flag,hr_api.g_varchar2)
773: or not l_api_updating) then
774: --
775: -- check if value of lookup falls within lookup type.
776: --

Line 778: if hr_api.not_exists_in_hr_lookups

774: --
775: -- check if value of lookup falls within lookup type.
776: --
777: --
778: if hr_api.not_exists_in_hr_lookups
779: (p_lookup_type => 'YES_NO',
780: p_lookup_code => p_cvrge_rt_prem_flag,
781: p_effective_date => p_effective_date) then
782: --

Line 841: <> nvl(ben_bli_shd.g_old_rec.replcd_flag,hr_api.g_varchar2)

837: p_object_version_number => p_object_version_number);
838: --
839: if (l_api_updating
840: and p_replcd_flag
841: <> nvl(ben_bli_shd.g_old_rec.replcd_flag,hr_api.g_varchar2)
842: or not l_api_updating) then
843: --
844: -- check if value of lookup falls within lookup type.
845: --

Line 847: if hr_api.not_exists_in_hr_lookups

843: --
844: -- check if value of lookup falls within lookup type.
845: --
846: --
847: if hr_api.not_exists_in_hr_lookups
848: (p_lookup_type => 'YES_NO',
849: p_lookup_code => p_replcd_flag,
850: p_effective_date => p_effective_date) then
851: --

Line 911: <> nvl(ben_bli_shd.g_old_rec.open_and_clsd_flag,hr_api.g_varchar2)

907: p_object_version_number => p_object_version_number);
908: --
909: if (l_api_updating
910: and p_open_and_clsd_flag
911: <> nvl(ben_bli_shd.g_old_rec.open_and_clsd_flag,hr_api.g_varchar2)
912: or not l_api_updating) then
913: --
914: -- check if value of lookup falls within lookup type.
915: --

Line 917: if hr_api.not_exists_in_hr_lookups

913: --
914: -- check if value of lookup falls within lookup type.
915: --
916: --
917: if hr_api.not_exists_in_hr_lookups
918: (p_lookup_type => 'YES_NO',
919: p_lookup_code => p_open_and_clsd_flag,
920: p_effective_date => p_effective_date) then
921: --

Line 980: <> nvl(ben_bli_shd.g_old_rec.clsd_flag,hr_api.g_varchar2)

976: p_object_version_number => p_object_version_number);
977: --
978: if (l_api_updating
979: and p_clsd_flag
980: <> nvl(ben_bli_shd.g_old_rec.clsd_flag,hr_api.g_varchar2)
981: or not l_api_updating) then
982: --
983: -- check if value of lookup falls within lookup type.
984: --

Line 986: if hr_api.not_exists_in_hr_lookups

982: --
983: -- check if value of lookup falls within lookup type.
984: --
985: --
986: if hr_api.not_exists_in_hr_lookups
987: (p_lookup_type => 'YES_NO',
988: p_lookup_code => p_clsd_flag,
989: p_effective_date => p_effective_date) then
990: --

Line 1049: <> nvl(ben_bli_shd.g_old_rec.not_crtd_flag,hr_api.g_varchar2)

1045: p_object_version_number => p_object_version_number);
1046: --
1047: if (l_api_updating
1048: and p_not_crtd_flag
1049: <> nvl(ben_bli_shd.g_old_rec.not_crtd_flag,hr_api.g_varchar2)
1050: or not l_api_updating) then
1051: --
1052: -- check if value of lookup falls within lookup type.
1053: --

Line 1055: if hr_api.not_exists_in_hr_lookups

1051: --
1052: -- check if value of lookup falls within lookup type.
1053: --
1054: --
1055: if hr_api.not_exists_in_hr_lookups
1056: (p_lookup_type => 'YES_NO',
1057: p_lookup_code => p_not_crtd_flag,
1058: p_effective_date => p_effective_date) then
1059: --

Line 1118: <> nvl(ben_bli_shd.g_old_rec.stl_actv_flag,hr_api.g_varchar2)

1114: p_object_version_number => p_object_version_number);
1115: --
1116: if (l_api_updating
1117: and p_stl_actv_flag
1118: <> nvl(ben_bli_shd.g_old_rec.stl_actv_flag,hr_api.g_varchar2)
1119: or not l_api_updating) then
1120: --
1121: -- check if value of lookup falls within lookup type.
1122: --

Line 1124: if hr_api.not_exists_in_hr_lookups

1120: --
1121: -- check if value of lookup falls within lookup type.
1122: --
1123: --
1124: if hr_api.not_exists_in_hr_lookups
1125: (p_lookup_type => 'YES_NO',
1126: p_lookup_code => p_stl_actv_flag,
1127: p_effective_date => p_effective_date) then
1128: --

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

1153: --
1154: -- Call all supporting business operations
1155: --
1156: --
1157: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1158: --
1159: chk_batch_ler_id
1160: (p_batch_ler_id => p_rec.batch_ler_id,
1161: p_object_version_number => p_rec.object_version_number);

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

1265: --
1266: -- Call all supporting business operations
1267: --
1268: --
1269: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1270: --
1271: chk_batch_ler_id
1272: (p_batch_ler_id => p_rec.batch_ler_id,
1273: p_object_version_number => p_rec.object_version_number);

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

1406: hr_utility.set_location('Entering:'|| l_proc, 10);
1407: --
1408: -- Ensure that all the mandatory parameter are not null
1409: --
1410: hr_api.mandatory_arg_error(p_api_name => l_proc,
1411: p_argument => 'batch_ler_id',
1412: p_argument_value => p_batch_ler_id);
1413: --
1414: open csr_leg_code;