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

Line 58: and nvl(p_eligy_crit_values_id,hr_api.g_number)

54: p_object_version_number => p_object_version_number
55: );
56: --
57: if (l_api_updating
58: and nvl(p_eligy_crit_values_id,hr_api.g_number)
59: <> ben_ecv_shd.g_old_rec.eligy_crit_values_id) then
60: --
61: -- raise error as PK has changed
62: --

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

130: p_object_version_number => p_object_version_number
131: );
132: --
133: if (l_api_updating
134: and nvl(p_eligy_criteria_id,hr_api.g_number)
135: <> ben_ecv_shd.g_old_rec.eligy_criteria_id
136: or not l_api_updating) then
137: --
138: open csr_eligy_criteria_id;

Line 211: and nvl(p_eligy_prfl_id,hr_api.g_number)

207: p_object_version_number => p_object_version_number
208: );
209: --
210: if (l_api_updating
211: and nvl(p_eligy_prfl_id,hr_api.g_number)
212: <> ben_ecv_shd.g_old_rec.eligy_prfl_id
213: or not l_api_updating) then
214: --
215: open csr_eligy_prfl_id;

Line 273: and nvl(ecv.number_value1,hr_api.g_number) = nvl(p_number_value1,hr_api.g_number)

269: from ben_eligy_crit_values_f ecv
270: where ecv.eligy_prfl_id = p_eligy_prfl_id
271: and ecv.eligy_criteria_id = p_eligy_criteria_id
272: and ecv.eligy_crit_values_id <> nvl ( p_eligy_crit_values_id, -1)
273: and nvl(ecv.number_value1,hr_api.g_number) = nvl(p_number_value1,hr_api.g_number)
274: and nvl(ecv.number_value2,hr_api.g_number) = nvl(p_number_value2,hr_api.g_number)
275: and nvl(ecv.char_value1,hr_api.g_varchar2) = nvl(p_char_value1,hr_api.g_varchar2)
276: and nvl(ecv.char_value2,hr_api.g_varchar2) = nvl(p_char_value2,hr_api.g_varchar2)
277: and nvl(ecv.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)

Line 274: and nvl(ecv.number_value2,hr_api.g_number) = nvl(p_number_value2,hr_api.g_number)

270: where ecv.eligy_prfl_id = p_eligy_prfl_id
271: and ecv.eligy_criteria_id = p_eligy_criteria_id
272: and ecv.eligy_crit_values_id <> nvl ( p_eligy_crit_values_id, -1)
273: and nvl(ecv.number_value1,hr_api.g_number) = nvl(p_number_value1,hr_api.g_number)
274: and nvl(ecv.number_value2,hr_api.g_number) = nvl(p_number_value2,hr_api.g_number)
275: and nvl(ecv.char_value1,hr_api.g_varchar2) = nvl(p_char_value1,hr_api.g_varchar2)
276: and nvl(ecv.char_value2,hr_api.g_varchar2) = nvl(p_char_value2,hr_api.g_varchar2)
277: and nvl(ecv.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)
278: and nvl(ecv.date_value2,hr_api.g_date) = nvl (p_date_value2,hr_api.g_date)

Line 275: and nvl(ecv.char_value1,hr_api.g_varchar2) = nvl(p_char_value1,hr_api.g_varchar2)

271: and ecv.eligy_criteria_id = p_eligy_criteria_id
272: and ecv.eligy_crit_values_id <> nvl ( p_eligy_crit_values_id, -1)
273: and nvl(ecv.number_value1,hr_api.g_number) = nvl(p_number_value1,hr_api.g_number)
274: and nvl(ecv.number_value2,hr_api.g_number) = nvl(p_number_value2,hr_api.g_number)
275: and nvl(ecv.char_value1,hr_api.g_varchar2) = nvl(p_char_value1,hr_api.g_varchar2)
276: and nvl(ecv.char_value2,hr_api.g_varchar2) = nvl(p_char_value2,hr_api.g_varchar2)
277: and nvl(ecv.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)
278: and nvl(ecv.date_value2,hr_api.g_date) = nvl (p_date_value2,hr_api.g_date)
279: and nvl(ecv.number_value3,hr_api.g_number) = nvl(p_number_value3,hr_api.g_number)

Line 276: and nvl(ecv.char_value2,hr_api.g_varchar2) = nvl(p_char_value2,hr_api.g_varchar2)

272: and ecv.eligy_crit_values_id <> nvl ( p_eligy_crit_values_id, -1)
273: and nvl(ecv.number_value1,hr_api.g_number) = nvl(p_number_value1,hr_api.g_number)
274: and nvl(ecv.number_value2,hr_api.g_number) = nvl(p_number_value2,hr_api.g_number)
275: and nvl(ecv.char_value1,hr_api.g_varchar2) = nvl(p_char_value1,hr_api.g_varchar2)
276: and nvl(ecv.char_value2,hr_api.g_varchar2) = nvl(p_char_value2,hr_api.g_varchar2)
277: and nvl(ecv.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)
278: and nvl(ecv.date_value2,hr_api.g_date) = nvl (p_date_value2,hr_api.g_date)
279: and nvl(ecv.number_value3,hr_api.g_number) = nvl(p_number_value3,hr_api.g_number)
280: and nvl(ecv.number_value4,hr_api.g_number) = nvl(p_number_value4,hr_api.g_number)

Line 277: and nvl(ecv.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)

273: and nvl(ecv.number_value1,hr_api.g_number) = nvl(p_number_value1,hr_api.g_number)
274: and nvl(ecv.number_value2,hr_api.g_number) = nvl(p_number_value2,hr_api.g_number)
275: and nvl(ecv.char_value1,hr_api.g_varchar2) = nvl(p_char_value1,hr_api.g_varchar2)
276: and nvl(ecv.char_value2,hr_api.g_varchar2) = nvl(p_char_value2,hr_api.g_varchar2)
277: and nvl(ecv.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)
278: and nvl(ecv.date_value2,hr_api.g_date) = nvl (p_date_value2,hr_api.g_date)
279: and nvl(ecv.number_value3,hr_api.g_number) = nvl(p_number_value3,hr_api.g_number)
280: and nvl(ecv.number_value4,hr_api.g_number) = nvl(p_number_value4,hr_api.g_number)
281: and nvl(ecv.char_value3,hr_api.g_varchar2) = nvl(p_char_value3,hr_api.g_varchar2)

Line 278: and nvl(ecv.date_value2,hr_api.g_date) = nvl (p_date_value2,hr_api.g_date)

274: and nvl(ecv.number_value2,hr_api.g_number) = nvl(p_number_value2,hr_api.g_number)
275: and nvl(ecv.char_value1,hr_api.g_varchar2) = nvl(p_char_value1,hr_api.g_varchar2)
276: and nvl(ecv.char_value2,hr_api.g_varchar2) = nvl(p_char_value2,hr_api.g_varchar2)
277: and nvl(ecv.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)
278: and nvl(ecv.date_value2,hr_api.g_date) = nvl (p_date_value2,hr_api.g_date)
279: and nvl(ecv.number_value3,hr_api.g_number) = nvl(p_number_value3,hr_api.g_number)
280: and nvl(ecv.number_value4,hr_api.g_number) = nvl(p_number_value4,hr_api.g_number)
281: and nvl(ecv.char_value3,hr_api.g_varchar2) = nvl(p_char_value3,hr_api.g_varchar2)
282: and nvl(ecv.char_value4,hr_api.g_varchar2) = nvl(p_char_value4,hr_api.g_varchar2)

Line 279: and nvl(ecv.number_value3,hr_api.g_number) = nvl(p_number_value3,hr_api.g_number)

275: and nvl(ecv.char_value1,hr_api.g_varchar2) = nvl(p_char_value1,hr_api.g_varchar2)
276: and nvl(ecv.char_value2,hr_api.g_varchar2) = nvl(p_char_value2,hr_api.g_varchar2)
277: and nvl(ecv.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)
278: and nvl(ecv.date_value2,hr_api.g_date) = nvl (p_date_value2,hr_api.g_date)
279: and nvl(ecv.number_value3,hr_api.g_number) = nvl(p_number_value3,hr_api.g_number)
280: and nvl(ecv.number_value4,hr_api.g_number) = nvl(p_number_value4,hr_api.g_number)
281: and nvl(ecv.char_value3,hr_api.g_varchar2) = nvl(p_char_value3,hr_api.g_varchar2)
282: and nvl(ecv.char_value4,hr_api.g_varchar2) = nvl(p_char_value4,hr_api.g_varchar2)
283: and nvl(ecv.date_value3,hr_api.g_date) = nvl (p_date_value3,hr_api.g_date)

Line 280: and nvl(ecv.number_value4,hr_api.g_number) = nvl(p_number_value4,hr_api.g_number)

276: and nvl(ecv.char_value2,hr_api.g_varchar2) = nvl(p_char_value2,hr_api.g_varchar2)
277: and nvl(ecv.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)
278: and nvl(ecv.date_value2,hr_api.g_date) = nvl (p_date_value2,hr_api.g_date)
279: and nvl(ecv.number_value3,hr_api.g_number) = nvl(p_number_value3,hr_api.g_number)
280: and nvl(ecv.number_value4,hr_api.g_number) = nvl(p_number_value4,hr_api.g_number)
281: and nvl(ecv.char_value3,hr_api.g_varchar2) = nvl(p_char_value3,hr_api.g_varchar2)
282: and nvl(ecv.char_value4,hr_api.g_varchar2) = nvl(p_char_value4,hr_api.g_varchar2)
283: and nvl(ecv.date_value3,hr_api.g_date) = nvl (p_date_value3,hr_api.g_date)
284: and nvl(ecv.date_value4,hr_api.g_date) = nvl (p_date_value4,hr_api.g_date)

Line 281: and nvl(ecv.char_value3,hr_api.g_varchar2) = nvl(p_char_value3,hr_api.g_varchar2)

277: and nvl(ecv.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)
278: and nvl(ecv.date_value2,hr_api.g_date) = nvl (p_date_value2,hr_api.g_date)
279: and nvl(ecv.number_value3,hr_api.g_number) = nvl(p_number_value3,hr_api.g_number)
280: and nvl(ecv.number_value4,hr_api.g_number) = nvl(p_number_value4,hr_api.g_number)
281: and nvl(ecv.char_value3,hr_api.g_varchar2) = nvl(p_char_value3,hr_api.g_varchar2)
282: and nvl(ecv.char_value4,hr_api.g_varchar2) = nvl(p_char_value4,hr_api.g_varchar2)
283: and nvl(ecv.date_value3,hr_api.g_date) = nvl (p_date_value3,hr_api.g_date)
284: and nvl(ecv.date_value4,hr_api.g_date) = nvl (p_date_value4,hr_api.g_date)
285: and ecv.effective_start_date <= p_validation_end_date

Line 282: and nvl(ecv.char_value4,hr_api.g_varchar2) = nvl(p_char_value4,hr_api.g_varchar2)

278: and nvl(ecv.date_value2,hr_api.g_date) = nvl (p_date_value2,hr_api.g_date)
279: and nvl(ecv.number_value3,hr_api.g_number) = nvl(p_number_value3,hr_api.g_number)
280: and nvl(ecv.number_value4,hr_api.g_number) = nvl(p_number_value4,hr_api.g_number)
281: and nvl(ecv.char_value3,hr_api.g_varchar2) = nvl(p_char_value3,hr_api.g_varchar2)
282: and nvl(ecv.char_value4,hr_api.g_varchar2) = nvl(p_char_value4,hr_api.g_varchar2)
283: and nvl(ecv.date_value3,hr_api.g_date) = nvl (p_date_value3,hr_api.g_date)
284: and nvl(ecv.date_value4,hr_api.g_date) = nvl (p_date_value4,hr_api.g_date)
285: and ecv.effective_start_date <= p_validation_end_date
286: and ecv.effective_end_date >= p_validation_start_date

Line 283: and nvl(ecv.date_value3,hr_api.g_date) = nvl (p_date_value3,hr_api.g_date)

279: and nvl(ecv.number_value3,hr_api.g_number) = nvl(p_number_value3,hr_api.g_number)
280: and nvl(ecv.number_value4,hr_api.g_number) = nvl(p_number_value4,hr_api.g_number)
281: and nvl(ecv.char_value3,hr_api.g_varchar2) = nvl(p_char_value3,hr_api.g_varchar2)
282: and nvl(ecv.char_value4,hr_api.g_varchar2) = nvl(p_char_value4,hr_api.g_varchar2)
283: and nvl(ecv.date_value3,hr_api.g_date) = nvl (p_date_value3,hr_api.g_date)
284: and nvl(ecv.date_value4,hr_api.g_date) = nvl (p_date_value4,hr_api.g_date)
285: and ecv.effective_start_date <= p_validation_end_date
286: and ecv.effective_end_date >= p_validation_start_date
287: and ecv.business_group_id = p_business_group_id;

Line 284: and nvl(ecv.date_value4,hr_api.g_date) = nvl (p_date_value4,hr_api.g_date)

280: and nvl(ecv.number_value4,hr_api.g_number) = nvl(p_number_value4,hr_api.g_number)
281: and nvl(ecv.char_value3,hr_api.g_varchar2) = nvl(p_char_value3,hr_api.g_varchar2)
282: and nvl(ecv.char_value4,hr_api.g_varchar2) = nvl(p_char_value4,hr_api.g_varchar2)
283: and nvl(ecv.date_value3,hr_api.g_date) = nvl (p_date_value3,hr_api.g_date)
284: and nvl(ecv.date_value4,hr_api.g_date) = nvl (p_date_value4,hr_api.g_date)
285: and ecv.effective_start_date <= p_validation_end_date
286: and ecv.effective_end_date >= p_validation_start_date
287: and ecv.business_group_id = p_business_group_id;
288: --

Line 551: if hr_api.not_exists_in_hr_lookups

547: then
548: l_lookup_code := p_date_value1;
549: end if;
550: --
551: if hr_api.not_exists_in_hr_lookups
552: (p_lookup_type => l_col1_lookup_type,
553: p_lookup_code => l_lookup_code,
554: p_effective_date => p_effective_date) then
555: --

Line 722: if hr_api.not_exists_in_hr_lookups

718: then
719: l_lookup_code := p_date_value3;
720: end if;
721: --
722: if hr_api.not_exists_in_hr_lookups
723: (p_lookup_type => l_col2_lookup_type,
724: p_lookup_code => l_lookup_code,
725: p_effective_date => p_effective_date) then
726: --

Line 903: (p_eligy_criteria_id In number default hr_api.g_number,

899: --
900: -- {End Of Comments}
901: -- ----------------------------------------------------------------------------
902: procedure dt_update_validate
903: (p_eligy_criteria_id In number default hr_api.g_number,
904: p_eligy_prfl_id In number default hr_api.g_number,
905: p_datetrack_mode In Varchar2,
906: p_validation_start_date In Date,
907: p_validation_end_date In Date

Line 904: p_eligy_prfl_id In number default hr_api.g_number,

900: -- {End Of Comments}
901: -- ----------------------------------------------------------------------------
902: procedure dt_update_validate
903: (p_eligy_criteria_id In number default hr_api.g_number,
904: p_eligy_prfl_id In number default hr_api.g_number,
905: p_datetrack_mode In Varchar2,
906: p_validation_start_date In Date,
907: p_validation_end_date In Date
908: ) Is

Line 919: hr_api.mandatory_arg_error

915: hr_utility.set_location('Entering:'||l_proc, 5);
916: --
917: -- Ensure that the p_datetrack_mode argument is not null
918: --
919: hr_api.mandatory_arg_error
920: (p_api_name => l_proc,
921: p_argument => 'datetrack_mode',
922: p_argument_value => p_datetrack_mode);
923: --

Line 931: hr_api.mandatory_arg_error

927: --
928: --
929: -- Ensure the arguments are not null
930: --
931: hr_api.mandatory_arg_error
932: (p_api_name => l_proc,
933: p_argument => 'validation_start_date',
934: p_argument_value => p_validation_start_date);
935: --

Line 936: hr_api.mandatory_arg_error

932: (p_api_name => l_proc,
933: p_argument => 'validation_start_date',
934: p_argument_value => p_validation_start_date);
935: --
936: hr_api.mandatory_arg_error
937: (p_api_name => l_proc,
938: p_argument => 'validation_end_date',
939: p_argument_value => p_validation_end_date);
940: --

Line 941: /* If ((nvl(p_eligy_criteria_id, hr_api.g_number) <> hr_api.g_number) and

937: (p_api_name => l_proc,
938: p_argument => 'validation_end_date',
939: p_argument_value => p_validation_end_date);
940: --
941: /* If ((nvl(p_eligy_criteria_id, hr_api.g_number) <> hr_api.g_number) and
942: NOT (dt_api.check_min_max_dates
943: (p_base_table_name => 'ben_eligy_criteria',
944: p_base_key_column => 'eligy_criteria_id',
945: p_base_key_value => p_eligy_criteria_id,

Line 952: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

948: l_table_name := 'ben_eligy_criteria';
949: Raise l_integrity_error;
950: End If;*/
951: --
952: If ((nvl(p_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
953: NOT (dt_api.check_min_max_dates
954: (p_base_table_name => 'ben_eligy_prfl_f',
955: p_base_key_column => 'eligy_prfl_id',
956: p_base_key_value => p_eligy_prfl_id,

Line 1033: hr_api.mandatory_arg_error

1029: hr_utility.set_location('Entering:'||l_proc, 5);
1030: --
1031: -- Ensure that the p_datetrack_mode argument is not null
1032: --
1033: hr_api.mandatory_arg_error
1034: (p_api_name => l_proc,
1035: p_argument => 'datetrack_mode',
1036: p_argument_value => p_datetrack_mode);
1037: --

Line 1047: hr_api.mandatory_arg_error

1043: --
1044: --
1045: -- Ensure the arguments are not null
1046: --
1047: hr_api.mandatory_arg_error
1048: (p_api_name => l_proc,
1049: p_argument => 'validation_start_date',
1050: p_argument_value => p_validation_start_date);
1051: --

Line 1052: hr_api.mandatory_arg_error

1048: (p_api_name => l_proc,
1049: p_argument => 'validation_start_date',
1050: p_argument_value => p_validation_start_date);
1051: --
1052: hr_api.mandatory_arg_error
1053: (p_api_name => l_proc,
1054: p_argument => 'validation_end_date',
1055: p_argument_value => p_validation_end_date);
1056: --

Line 1057: hr_api.mandatory_arg_error

1053: (p_api_name => l_proc,
1054: p_argument => 'validation_end_date',
1055: p_argument_value => p_validation_end_date);
1056: --
1057: hr_api.mandatory_arg_error
1058: (p_api_name => l_proc,
1059: p_argument => 'eligy_crit_values_id',
1060: p_argument_value => p_eligy_crit_values_id);
1061: --

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

1081: -- Call all supporting business operations
1082: --
1083: --
1084: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
1085: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1086: end if;
1087: --
1088: chk_eligy_crit_values_id( p_eligy_crit_values_id => p_rec.eligy_crit_values_id,
1089: p_effective_date => p_effective_date,

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

1167: --
1168: if p_rec.business_group_id is not null and p_rec.legislation_code is null
1169: then
1170: --
1171: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1172: --
1173: end if;
1174: --
1175: chk_eligy_crit_values_id( p_eligy_crit_values_id => p_rec.eligy_crit_values_id,

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

1299: hr_utility.set_location('Entering:'|| l_proc, 10);
1300: --
1301: -- Ensure that all the mandatory parameter are not null
1302: --
1303: hr_api.mandatory_arg_error(p_api_name => l_proc,
1304: p_argument => 'eligy_crit_values_id',
1305: p_argument_value => p_eligy_crit_values_id);
1306: --
1307: open csr_leg_code;