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

Line 71: and nvl(p_elig_per_opt_id,hr_api.g_number)

67: p_elig_per_opt_id => p_elig_per_opt_id,
68: p_object_version_number => p_object_version_number);
69: --
70: if (l_api_updating
71: and nvl(p_elig_per_opt_id,hr_api.g_number)
72: <> ben_epo_shd.g_old_rec.elig_per_opt_id) then
73: --
74: -- raise error as PK has changed
75: --

Line 96: <> nvl(ben_epo_shd.g_old_rec.elig_per_opt_id,hr_api.g_number)

92: hr_utility.set_location('In:'||l_proc, 7);
93:
94: if (l_api_updating
95: and p_elig_per_opt_id
96: <> nvl(ben_epo_shd.g_old_rec.elig_per_opt_id,hr_api.g_number)
97: or not l_api_updating) then
98: --
99: open c1;
100: --

Line 194: <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,hr_api.g_varchar2)

190: p_object_version_number => p_object_version_number);
191: --
192: if (l_api_updating
193: and p_comp_ref_uom
194: <> nvl(ben_epo_shd.g_old_rec.comp_ref_uom,hr_api.g_varchar2)
195: or not l_api_updating) and p_comp_ref_uom IS NOT NULL then
196: --
197: -- check if comp_ref_uom value exists in hr_lookups table
198: --

Line 216: <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,hr_api.g_varchar2)

212: end if;
213: --
214: if (l_api_updating
215: and p_rt_comp_ref_uom
216: <> nvl(ben_epo_shd.g_old_rec.rt_comp_ref_uom,hr_api.g_varchar2)
217: or not l_api_updating) and p_rt_comp_ref_uom IS NOT NULL then
218: --
219: -- check if rt_comp_ref_uom value exists in hr_lookups table
220: --

Line 284: and nvl(p_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)

280: p_effective_date => p_effective_date,
281: p_object_version_number => p_object_version_number);
282: --
283: if (l_api_updating
284: and nvl(p_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
285: <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
286: or not l_api_updating) and p_hrs_wkd_bndry_perd_cd IS NOT NULL then
287: --
288: -- check if value of lookup falls within lookup type.

Line 285: <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)

281: p_object_version_number => p_object_version_number);
282: --
283: if (l_api_updating
284: and nvl(p_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
285: <> nvl(ben_epo_shd.g_old_rec.hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
286: or not l_api_updating) and p_hrs_wkd_bndry_perd_cd IS NOT NULL then
287: --
288: -- check if value of lookup falls within lookup type.
289: --

Line 290: if hr_api.not_exists_in_hr_lookups

286: or not l_api_updating) and p_hrs_wkd_bndry_perd_cd IS NOT NULL then
287: --
288: -- check if value of lookup falls within lookup type.
289: --
290: if hr_api.not_exists_in_hr_lookups
291: (p_lookup_type => 'BEN_BNDRY_PERD',
292: p_lookup_code => p_hrs_wkd_bndry_perd_cd,
293: p_effective_date => p_effective_date) then
294: --

Line 307: and nvl(p_rt_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)

303: --
304: end if;
305: --
306: if (l_api_updating
307: and nvl(p_rt_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
308: <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
309: or not l_api_updating) and p_rt_hrs_wkd_bndry_perd_cd IS NOT NULL then
310: --
311: -- check if value of lookup falls within lookup type.

Line 308: <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)

304: end if;
305: --
306: if (l_api_updating
307: and nvl(p_rt_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
308: <> nvl(ben_epo_shd.g_old_rec.rt_hrs_wkd_bndry_perd_cd,hr_api.g_varchar2)
309: or not l_api_updating) and p_rt_hrs_wkd_bndry_perd_cd IS NOT NULL then
310: --
311: -- check if value of lookup falls within lookup type.
312: --

Line 313: if hr_api.not_exists_in_hr_lookups

309: or not l_api_updating) and p_rt_hrs_wkd_bndry_perd_cd IS NOT NULL then
310: --
311: -- check if value of lookup falls within lookup type.
312: --
313: if hr_api.not_exists_in_hr_lookups
314: (p_lookup_type => 'BEN_BNDRY_PERD',
315: p_lookup_code => p_rt_hrs_wkd_bndry_perd_cd,
316: p_effective_date => p_effective_date) then
317: --

Line 445: <> nvl(ben_epo_shd.g_old_rec.age_uom,hr_api.g_varchar2)

441: p_object_version_number => p_object_version_number);
442: --
443: if (l_api_updating
444: and p_age_uom
445: <> nvl(ben_epo_shd.g_old_rec.age_uom,hr_api.g_varchar2)
446: or not l_api_updating) and p_age_uom IS NOT NULL then
447: --
448: -- check if value of lookup falls within lookup type.
449: --

Line 450: if hr_api.not_exists_in_hr_lookups

446: or not l_api_updating) and p_age_uom IS NOT NULL then
447: --
448: -- check if value of lookup falls within lookup type.
449: --
450: if hr_api.not_exists_in_hr_lookups
451: (p_lookup_type => 'BEN_TM_UOM',
452: p_lookup_code => p_age_uom,
453: p_effective_date => p_effective_date) then
454: --

Line 468: <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,hr_api.g_varchar2)

464: end if;
465: --
466: if (l_api_updating
467: and p_rt_age_uom
468: <> nvl(ben_epo_shd.g_old_rec.rt_age_uom,hr_api.g_varchar2)
469: or not l_api_updating) and p_rt_age_uom IS NOT NULL then
470: --
471: -- check if value of lookup falls within lookup type.
472: --

Line 473: if hr_api.not_exists_in_hr_lookups

469: or not l_api_updating) and p_rt_age_uom IS NOT NULL then
470: --
471: -- check if value of lookup falls within lookup type.
472: --
473: if hr_api.not_exists_in_hr_lookups
474: (p_lookup_type => 'BEN_TM_UOM',
475: p_lookup_code => p_rt_age_uom,
476: p_effective_date => p_effective_date) then
477: --

Line 537: <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,hr_api.g_varchar2)

533: p_object_version_number => p_object_version_number);
534: --
535: if (l_api_updating
536: and p_once_r_cntug_cd
537: <> nvl(ben_epo_shd.g_old_rec.once_r_cntug_cd,hr_api.g_varchar2)
538: or not l_api_updating) and p_once_r_cntug_cd IS NOT NULL then
539: --
540: -- check if value of lookup falls within lookup type.
541: --

Line 542: if hr_api.not_exists_in_hr_lookups

538: or not l_api_updating) and p_once_r_cntug_cd IS NOT NULL then
539: --
540: -- check if value of lookup falls within lookup type.
541: --
542: if hr_api.not_exists_in_hr_lookups
543: (p_lookup_type => 'BEN_ONCE_R_CNTNG',
544: p_lookup_code => p_once_r_cntug_cd,
545: p_effective_date => p_effective_date) then
546: --

Line 606: <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,hr_api.g_varchar2)

602: p_object_version_number => p_object_version_number);
603: --
604: if (l_api_updating
605: and p_inelg_rsn_cd
606: <> nvl(ben_epo_shd.g_old_rec.inelg_rsn_cd,hr_api.g_varchar2)
607: or not l_api_updating) and p_inelg_rsn_cd IS NOT NULL then
608: --
609: -- check if value of lookup falls within lookup type.
610: --

Line 611: if hr_api.not_exists_in_hr_lookups

607: or not l_api_updating) and p_inelg_rsn_cd IS NOT NULL then
608: --
609: -- check if value of lookup falls within lookup type.
610: --
611: if hr_api.not_exists_in_hr_lookups
612: (p_lookup_type => 'BEN_INELG_RSN',
613: p_lookup_code => p_inelg_rsn_cd,
614: p_effective_date => p_effective_date) then
615: --

Line 694: <> nvl(ben_epo_shd.g_old_rec.los_uom,hr_api.g_varchar2)

690: p_object_version_number => p_object_version_number);
691: --
692: if (l_api_updating
693: and p_los_uom
694: <> nvl(ben_epo_shd.g_old_rec.los_uom,hr_api.g_varchar2)
695: or not l_api_updating) and p_los_uom IS NOT NULL then
696: --
697: -- check if value of lookup falls within lookup type.
698: --

Line 699: if hr_api.not_exists_in_hr_lookups

695: or not l_api_updating) and p_los_uom IS NOT NULL then
696: --
697: -- check if value of lookup falls within lookup type.
698: --
699: if hr_api.not_exists_in_hr_lookups
700: (p_lookup_type => 'BEN_TM_UOM',
701: p_lookup_code => p_los_uom,
702: p_effective_date => p_effective_date) then
703: --

Line 717: <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,hr_api.g_varchar2)

713: end if;
714: --
715: if (l_api_updating
716: and p_rt_los_uom
717: <> nvl(ben_epo_shd.g_old_rec.rt_los_uom,hr_api.g_varchar2)
718: or not l_api_updating) and p_rt_los_uom IS NOT NULL then
719: --
720: -- check if value of lookup falls within lookup type.
721: --

Line 722: if hr_api.not_exists_in_hr_lookups

718: or not l_api_updating) and p_rt_los_uom IS NOT NULL then
719: --
720: -- check if value of lookup falls within lookup type.
721: --
722: if hr_api.not_exists_in_hr_lookups
723: (p_lookup_type => 'BEN_TM_UOM',
724: p_lookup_code => p_rt_los_uom,
725: p_effective_date => p_effective_date) then
726: --

Line 786: <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd,hr_api.g_varchar2)

782: p_object_version_number => p_object_version_number);
783: --
784: if (l_api_updating
785: and p_prtn_ovridn_rsn_cd
786: <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_rsn_cd,hr_api.g_varchar2)
787: or not l_api_updating)
788: and p_prtn_ovridn_rsn_cd is not null then
789: --
790: -- check if value of lookup falls within lookup type.

Line 792: if hr_api.not_exists_in_hr_lookups

788: and p_prtn_ovridn_rsn_cd is not null then
789: --
790: -- check if value of lookup falls within lookup type.
791: --
792: if hr_api.not_exists_in_hr_lookups
793: (p_lookup_type => 'BEN_PRTN_OVRRIDN_RSN',
794: p_lookup_code => p_prtn_ovridn_rsn_cd,
795: p_effective_date => p_effective_date) then
796: --

Line 857: <> nvl(ben_epo_shd.g_old_rec.elig_flag,hr_api.g_varchar2)

853: p_object_version_number => p_object_version_number);
854: --
855: if (l_api_updating
856: and p_elig_flag
857: <> nvl(ben_epo_shd.g_old_rec.elig_flag,hr_api.g_varchar2)
858: or not l_api_updating) then
859: --
860: -- check if value of lookup falls within lookup type.
861: --

Line 862: if hr_api.not_exists_in_hr_lookups

858: or not l_api_updating) then
859: --
860: -- check if value of lookup falls within lookup type.
861: --
862: if hr_api.not_exists_in_hr_lookups
863: (p_lookup_type => 'YES_NO',
864: p_lookup_code => p_elig_flag,
865: p_effective_date => p_effective_date) then
866: --

Line 928: <> nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,hr_api.g_varchar2)

924: p_object_version_number => p_object_version_number);
925: --
926: if (l_api_updating
927: and p_no_mx_prtn_ovrid_thru_flag
928: <> nvl(ben_epo_shd.g_old_rec.no_mx_prtn_ovrid_thru_flag,hr_api.g_varchar2)
929: or not l_api_updating) then
930: --
931: -- check if value of lookup falls within lookup type.
932: --

Line 934: if hr_api.not_exists_in_hr_lookups

930: --
931: -- check if value of lookup falls within lookup type.
932: --
933: --
934: if hr_api.not_exists_in_hr_lookups
935: (p_lookup_type => 'YES_NO',
936: p_lookup_code => p_no_mx_prtn_ovrid_thru_flag,
937: p_effective_date => p_effective_date) then
938: --

Line 1023: <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,hr_api.g_varchar2)

1019: --
1020: hr_utility.set_location('RFLF:'||l_proc, 5);
1021: if (l_api_updating
1022: and p_rt_frz_los_flag
1023: <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,hr_api.g_varchar2)
1024: or not l_api_updating) then
1025: --
1026: -- check if value of lookup falls within lookup type.
1027: --

Line 1029: if hr_api.not_exists_in_hr_lookups

1025: --
1026: -- check if value of lookup falls within lookup type.
1027: --
1028: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1029: if hr_api.not_exists_in_hr_lookups
1030: (p_lookup_type => 'YES_NO',
1031: p_lookup_code => p_rt_frz_los_flag,
1032: p_effective_date => p_effective_date) then
1033: --

Line 1048: <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,hr_api.g_varchar2)

1044: --
1045: hr_utility.set_location('RFAF:'||l_proc, 5);
1046: if (l_api_updating
1047: and p_rt_frz_age_flag
1048: <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,hr_api.g_varchar2)
1049: or not l_api_updating) then
1050: --
1051: -- check if value of lookup falls within lookup type.
1052: --

Line 1053: if hr_api.not_exists_in_hr_lookups

1049: or not l_api_updating) then
1050: --
1051: -- check if value of lookup falls within lookup type.
1052: --
1053: if hr_api.not_exists_in_hr_lookups
1054: (p_lookup_type => 'YES_NO',
1055: p_lookup_code => p_rt_frz_age_flag,
1056: p_effective_date => p_effective_date) then
1057: --

Line 1072: <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,hr_api.g_varchar2)

1068: --
1069: hr_utility.set_location('RFCLF:'||l_proc, 5);
1070: if (l_api_updating
1071: and p_rt_frz_cmp_lvl_flag
1072: <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,hr_api.g_varchar2)
1073: or not l_api_updating) then
1074: --
1075: -- check if value of lookup falls within lookup type.
1076: --

Line 1077: if hr_api.not_exists_in_hr_lookups

1073: or not l_api_updating) then
1074: --
1075: -- check if value of lookup falls within lookup type.
1076: --
1077: if hr_api.not_exists_in_hr_lookups
1078: (p_lookup_type => 'YES_NO',
1079: p_lookup_code => p_rt_frz_cmp_lvl_flag,
1080: p_effective_date => p_effective_date) then
1081: --

Line 1096: <> nvl(ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag,hr_api.g_varchar2)

1092: --
1093: hr_utility.set_location('RFPFTF:'||l_proc, 5);
1094: if (l_api_updating
1095: and p_rt_frz_pct_fl_tm_flag
1096: <> nvl(ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag,hr_api.g_varchar2)
1097: or not l_api_updating) then
1098: --
1099: -- check if value of lookup falls within lookup type.
1100: --

Line 1101: if hr_api.not_exists_in_hr_lookups

1097: or not l_api_updating) then
1098: --
1099: -- check if value of lookup falls within lookup type.
1100: --
1101: if hr_api.not_exists_in_hr_lookups
1102: (p_lookup_type => 'YES_NO',
1103: p_lookup_code => p_rt_frz_pct_fl_tm_flag,
1104: p_effective_date => p_effective_date) then
1105: --

Line 1120: <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,hr_api.g_varchar2)

1116: --
1117: hr_utility.set_location('RFHWF:'||l_proc, 5);
1118: if (l_api_updating
1119: and p_rt_frz_hrs_wkd_flag
1120: <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,hr_api.g_varchar2)
1121: or not l_api_updating) then
1122: --
1123: -- check if value of lookup falls within lookup type.
1124: --

Line 1125: if hr_api.not_exists_in_hr_lookups

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

Line 1144: <> nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,hr_api.g_varchar2)

1140: --
1141: hr_utility.set_location('RFCAALF:'||l_proc, 5);
1142: if (l_api_updating
1143: and p_rt_frz_comb_age_and_los_flag
1144: <> nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,hr_api.g_varchar2)
1145: or not l_api_updating) then
1146: --
1147: -- check if value of lookup falls within lookup type.
1148: --

Line 1149: if hr_api.not_exists_in_hr_lookups

1145: or not l_api_updating) then
1146: --
1147: -- check if value of lookup falls within lookup type.
1148: --
1149: if hr_api.not_exists_in_hr_lookups
1150: (p_lookup_type => 'YES_NO',
1151: p_lookup_code => p_rt_frz_comb_age_and_los_flag,
1152: p_effective_date => p_effective_date) then
1153: --

Line 1168: <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,hr_api.g_varchar2)

1164: --
1165: hr_utility.set_location('FLF:'||l_proc, 5);
1166: if (l_api_updating
1167: and p_frz_los_flag
1168: <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,hr_api.g_varchar2)
1169: or not l_api_updating) then
1170: --
1171: -- check if value of lookup falls within lookup type.
1172: --

Line 1173: if hr_api.not_exists_in_hr_lookups

1169: or not l_api_updating) then
1170: --
1171: -- check if value of lookup falls within lookup type.
1172: --
1173: if hr_api.not_exists_in_hr_lookups
1174: (p_lookup_type => 'YES_NO',
1175: p_lookup_code => p_frz_los_flag,
1176: p_effective_date => p_effective_date) then
1177: --

Line 1192: <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,hr_api.g_varchar2)

1188: --
1189: hr_utility.set_location('FAF:'||l_proc, 5);
1190: if (l_api_updating
1191: and p_frz_age_flag
1192: <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,hr_api.g_varchar2)
1193: or not l_api_updating) then
1194: --
1195: -- check if value of lookup falls within lookup type.
1196: --

Line 1197: if hr_api.not_exists_in_hr_lookups

1193: or not l_api_updating) then
1194: --
1195: -- check if value of lookup falls within lookup type.
1196: --
1197: if hr_api.not_exists_in_hr_lookups
1198: (p_lookup_type => 'YES_NO',
1199: p_lookup_code => p_frz_age_flag,
1200: p_effective_date => p_effective_date) then
1201: --

Line 1216: <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,hr_api.g_varchar2)

1212: --
1213: hr_utility.set_location('FCLF:'||l_proc, 5);
1214: if (l_api_updating
1215: and p_frz_cmp_lvl_flag
1216: <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,hr_api.g_varchar2)
1217: or not l_api_updating) then
1218: --
1219: -- check if value of lookup falls within lookup type.
1220: --

Line 1221: if hr_api.not_exists_in_hr_lookups

1217: or not l_api_updating) then
1218: --
1219: -- check if value of lookup falls within lookup type.
1220: --
1221: if hr_api.not_exists_in_hr_lookups
1222: (p_lookup_type => 'YES_NO',
1223: p_lookup_code => p_frz_cmp_lvl_flag,
1224: p_effective_date => p_effective_date) then
1225: --

Line 1240: <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,hr_api.g_varchar2)

1236: --
1237: hr_utility.set_location('FPFTF:'||l_proc, 5);
1238: if (l_api_updating
1239: and p_frz_pct_fl_tm_flag
1240: <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,hr_api.g_varchar2)
1241: or not l_api_updating) then
1242: --
1243: -- check if value of lookup falls within lookup type.
1244: --

Line 1245: if hr_api.not_exists_in_hr_lookups

1241: or not l_api_updating) then
1242: --
1243: -- check if value of lookup falls within lookup type.
1244: --
1245: if hr_api.not_exists_in_hr_lookups
1246: (p_lookup_type => 'YES_NO',
1247: p_lookup_code => p_frz_pct_fl_tm_flag,
1248: p_effective_date => p_effective_date) then
1249: --

Line 1264: <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,hr_api.g_varchar2)

1260: --
1261: hr_utility.set_location('FHWFF:'||l_proc, 5);
1262: if (l_api_updating
1263: and p_frz_hrs_wkd_flag
1264: <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,hr_api.g_varchar2)
1265: or not l_api_updating) then
1266: --
1267: -- check if value of lookup falls within lookup type.
1268: --

Line 1269: if hr_api.not_exists_in_hr_lookups

1265: or not l_api_updating) then
1266: --
1267: -- check if value of lookup falls within lookup type.
1268: --
1269: if hr_api.not_exists_in_hr_lookups
1270: (p_lookup_type => 'YES_NO',
1271: p_lookup_code => p_frz_hrs_wkd_flag,
1272: p_effective_date => p_effective_date) then
1273: --

Line 1333: <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,hr_api.g_varchar2)

1329: p_object_version_number => p_object_version_number);
1330: --
1331: if (l_api_updating
1332: and p_prtn_ovridn_flag
1333: <> nvl(ben_epo_shd.g_old_rec.prtn_ovridn_flag,hr_api.g_varchar2)
1334: or not l_api_updating) then
1335: --
1336: -- check if value of lookup falls within lookup type.
1337: --

Line 1338: if hr_api.not_exists_in_hr_lookups

1334: or not l_api_updating) then
1335: --
1336: -- check if value of lookup falls within lookup type.
1337: --
1338: if hr_api.not_exists_in_hr_lookups
1339: (p_lookup_type => 'YES_NO',
1340: p_lookup_code => p_prtn_ovridn_flag,
1341: p_effective_date => p_effective_date) then
1342: --

Line 1388: (p_elig_per_id in number default hr_api.g_number,

1384: --
1385: -- {End Of Comments}
1386: -- ----------------------------------------------------------------------------
1387: Procedure dt_update_validate
1388: (p_elig_per_id in number default hr_api.g_number,
1389: p_opt_id in number default hr_api.g_number,
1390: p_datetrack_mode in varchar2,
1391: p_validation_start_date in date,
1392: p_validation_end_date in date) Is

Line 1389: p_opt_id in number default hr_api.g_number,

1385: -- {End Of Comments}
1386: -- ----------------------------------------------------------------------------
1387: Procedure dt_update_validate
1388: (p_elig_per_id in number default hr_api.g_number,
1389: p_opt_id in number default hr_api.g_number,
1390: p_datetrack_mode in varchar2,
1391: p_validation_start_date in date,
1392: p_validation_end_date in date) Is
1393: --

Line 1403: hr_api.mandatory_arg_error

1399: hr_utility.set_location('Entering:'||l_proc, 5);
1400: --
1401: -- Ensure that the p_datetrack_mode argument is not null
1402: --
1403: hr_api.mandatory_arg_error
1404: (p_api_name => l_proc,
1405: p_argument => 'datetrack_mode',
1406: p_argument_value => p_datetrack_mode);
1407: --

Line 1415: hr_api.mandatory_arg_error

1411: --
1412: --
1413: -- Ensure the arguments are not null
1414: --
1415: hr_api.mandatory_arg_error
1416: (p_api_name => l_proc,
1417: p_argument => 'validation_start_date',
1418: p_argument_value => p_validation_start_date);
1419: --

Line 1420: hr_api.mandatory_arg_error

1416: (p_api_name => l_proc,
1417: p_argument => 'validation_start_date',
1418: p_argument_value => p_validation_start_date);
1419: --
1420: hr_api.mandatory_arg_error
1421: (p_api_name => l_proc,
1422: p_argument => 'validation_end_date',
1423: p_argument_value => p_validation_end_date);
1424: --

Line 1425: If ((nvl(p_elig_per_id, hr_api.g_number) <> hr_api.g_number) and

1421: (p_api_name => l_proc,
1422: p_argument => 'validation_end_date',
1423: p_argument_value => p_validation_end_date);
1424: --
1425: If ((nvl(p_elig_per_id, hr_api.g_number) <> hr_api.g_number) and
1426: NOT (dt_api.check_min_max_dates
1427: (p_base_table_name => 'ben_elig_per_f',
1428: p_base_key_column => 'elig_per_id',
1429: p_base_key_value => p_elig_per_id,

Line 1435: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and

1431: p_to_date => p_validation_end_date))) Then
1432: l_table_name := 'ben_elig_per_f';
1433: Raise l_integrity_error;
1434: End If;
1435: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
1436: NOT (dt_api.check_min_max_dates
1437: (p_base_table_name => 'ben_opt_f',
1438: p_base_key_column => 'opt_id',
1439: p_base_key_value => p_opt_id,

Line 1519: hr_api.mandatory_arg_error

1515: hr_utility.set_location('Entering:'||l_proc, 5);
1516: --
1517: -- Ensure that the p_datetrack_mode argument is not null
1518: --
1519: hr_api.mandatory_arg_error
1520: (p_api_name => l_proc,
1521: p_argument => 'datetrack_mode',
1522: p_argument_value => p_datetrack_mode);
1523: --

Line 1533: hr_api.mandatory_arg_error

1529: --
1530: --
1531: -- Ensure the arguments are not null
1532: --
1533: hr_api.mandatory_arg_error
1534: (p_api_name => l_proc,
1535: p_argument => 'validation_start_date',
1536: p_argument_value => p_validation_start_date);
1537: --

Line 1538: hr_api.mandatory_arg_error

1534: (p_api_name => l_proc,
1535: p_argument => 'validation_start_date',
1536: p_argument_value => p_validation_start_date);
1537: --
1538: hr_api.mandatory_arg_error
1539: (p_api_name => l_proc,
1540: p_argument => 'validation_end_date',
1541: p_argument_value => p_validation_end_date);
1542: --

Line 1543: hr_api.mandatory_arg_error

1539: (p_api_name => l_proc,
1540: p_argument => 'validation_end_date',
1541: p_argument_value => p_validation_end_date);
1542: --
1543: hr_api.mandatory_arg_error
1544: (p_api_name => l_proc,
1545: p_argument => 'elig_per_opt_id',
1546: p_argument_value => p_elig_per_opt_id);
1547: --

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

1587: --
1588: -- Call all supporting business operations
1589: --
1590: --
1591: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1592: --
1593: chk_elig_per_opt_id
1594: (p_elig_per_opt_id => p_rec.elig_per_opt_id,
1595: p_elig_per_id => p_rec.elig_per_id,

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

1708: --
1709: -- Call all supporting business operations
1710: --
1711: --
1712: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1713: --
1714: chk_elig_per_opt_id
1715: (p_elig_per_opt_id => p_rec.elig_per_opt_id,
1716: p_elig_per_id => p_rec.elig_per_id,

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

1873: hr_utility.set_location('Entering:'|| l_proc, 10);
1874: --
1875: -- Ensure that all the mandatory parameter are not null
1876: --
1877: hr_api.mandatory_arg_error(p_api_name => l_proc,
1878: p_argument => 'elig_per_opt_id',
1879: p_argument_value => p_elig_per_opt_id);
1880: --
1881: open csr_leg_code;