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

Line 58: and nvl(p_dpnt_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_dpnt_eligy_crit_values_id,hr_api.g_number)
59: <> ben_dpnt_edc_shd.g_old_rec.dpnt_eligy_crit_values_id) then
60: --
61: -- raise error as PK has changed
62: --

Line 134: and nvl(p_eligy_criteria_dpnt_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_dpnt_id,hr_api.g_number)
135: <> ben_dpnt_edc_shd.g_old_rec.eligy_criteria_dpnt_id
136: or not l_api_updating) then
137: --
138: open csr_eligy_criteria_dpnt_id;

Line 211: and nvl(p_dpnt_cvg_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_dpnt_cvg_eligy_prfl_id,hr_api.g_number)
212: <> ben_dpnt_edc_shd.g_old_rec.dpnt_cvg_eligy_prfl_id
213: or not l_api_updating) then
214: --
215: open csr_eligy_prfl_id;

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

269: from ben_dpnt_eligy_crit_values_f edc
270: where edc.dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
271: and edc.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id
272: and edc.dpnt_eligy_crit_values_id <> nvl ( p_dpnt_eligy_crit_values_id, -1)
273: and nvl(edc.number_value1,hr_api.g_number) = nvl(p_number_value1,hr_api.g_number)
274: and nvl(edc.number_value2,hr_api.g_number) = nvl(p_number_value2,hr_api.g_number)
275: and nvl(edc.char_value1,hr_api.g_varchar2) = nvl(p_char_value1,hr_api.g_varchar2)
276: and nvl(edc.char_value2,hr_api.g_varchar2) = nvl(p_char_value2,hr_api.g_varchar2)
277: and nvl(edc.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)

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

270: where edc.dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
271: and edc.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id
272: and edc.dpnt_eligy_crit_values_id <> nvl ( p_dpnt_eligy_crit_values_id, -1)
273: and nvl(edc.number_value1,hr_api.g_number) = nvl(p_number_value1,hr_api.g_number)
274: and nvl(edc.number_value2,hr_api.g_number) = nvl(p_number_value2,hr_api.g_number)
275: and nvl(edc.char_value1,hr_api.g_varchar2) = nvl(p_char_value1,hr_api.g_varchar2)
276: and nvl(edc.char_value2,hr_api.g_varchar2) = nvl(p_char_value2,hr_api.g_varchar2)
277: and nvl(edc.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)
278: and nvl(edc.date_value2,hr_api.g_date) = nvl (p_date_value2,hr_api.g_date)

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

271: and edc.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id
272: and edc.dpnt_eligy_crit_values_id <> nvl ( p_dpnt_eligy_crit_values_id, -1)
273: and nvl(edc.number_value1,hr_api.g_number) = nvl(p_number_value1,hr_api.g_number)
274: and nvl(edc.number_value2,hr_api.g_number) = nvl(p_number_value2,hr_api.g_number)
275: and nvl(edc.char_value1,hr_api.g_varchar2) = nvl(p_char_value1,hr_api.g_varchar2)
276: and nvl(edc.char_value2,hr_api.g_varchar2) = nvl(p_char_value2,hr_api.g_varchar2)
277: and nvl(edc.date_value1,hr_api.g_date) = nvl (p_date_value1,hr_api.g_date)
278: and nvl(edc.date_value2,hr_api.g_date) = nvl (p_date_value2,hr_api.g_date)
279: and nvl(edc.number_value3,hr_api.g_number) = nvl(p_number_value3,hr_api.g_number)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

280: and nvl(edc.number_value4,hr_api.g_number) = nvl(p_number_value4,hr_api.g_number)
281: and nvl(edc.char_value3,hr_api.g_varchar2) = nvl(p_char_value3,hr_api.g_varchar2)
282: and nvl(edc.char_value4,hr_api.g_varchar2) = nvl(p_char_value4,hr_api.g_varchar2)
283: and nvl(edc.date_value3,hr_api.g_date) = nvl (p_date_value3,hr_api.g_date)
284: and nvl(edc.date_value4,hr_api.g_date) = nvl (p_date_value4,hr_api.g_date)
285: and edc.effective_start_date <= p_validation_end_date
286: and edc.effective_end_date >= p_validation_start_date
287: and edc.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 618: if hr_api.not_exists_in_hr_lookups

614: then
615: l_lookup_code := p_date_value3;
616: end if;
617: --
618: if hr_api.not_exists_in_hr_lookups
619: (p_lookup_type => l_col2_lookup_type,
620: p_lookup_code => l_lookup_code,
621: p_effective_date => p_effective_date) then
622: --

Line 694: (p_eligy_criteria_dpnt_id In number default hr_api.g_number,

690: --
691: -- {End Of Comments}
692: -- ----------------------------------------------------------------------------
693: procedure dt_update_validate
694: (p_eligy_criteria_dpnt_id In number default hr_api.g_number,
695: p_dpnt_cvg_eligy_prfl_id In number default hr_api.g_number,
696: p_datetrack_mode In Varchar2,
697: p_validation_start_date In Date,
698: p_validation_end_date In Date

Line 695: p_dpnt_cvg_eligy_prfl_id In number default hr_api.g_number,

691: -- {End Of Comments}
692: -- ----------------------------------------------------------------------------
693: procedure dt_update_validate
694: (p_eligy_criteria_dpnt_id In number default hr_api.g_number,
695: p_dpnt_cvg_eligy_prfl_id In number default hr_api.g_number,
696: p_datetrack_mode In Varchar2,
697: p_validation_start_date In Date,
698: p_validation_end_date In Date
699: ) Is

Line 710: hr_api.mandatory_arg_error

706: hr_utility.set_location('Entering:'||l_proc, 5);
707: --
708: -- Ensure that the p_datetrack_mode argument is not null
709: --
710: hr_api.mandatory_arg_error
711: (p_api_name => l_proc,
712: p_argument => 'datetrack_mode',
713: p_argument_value => p_datetrack_mode);
714: --

Line 722: hr_api.mandatory_arg_error

718: --
719: --
720: -- Ensure the arguments are not null
721: --
722: hr_api.mandatory_arg_error
723: (p_api_name => l_proc,
724: p_argument => 'validation_start_date',
725: p_argument_value => p_validation_start_date);
726: --

Line 727: hr_api.mandatory_arg_error

723: (p_api_name => l_proc,
724: p_argument => 'validation_start_date',
725: p_argument_value => p_validation_start_date);
726: --
727: hr_api.mandatory_arg_error
728: (p_api_name => l_proc,
729: p_argument => 'validation_end_date',
730: p_argument_value => p_validation_end_date);
731: --

Line 732: /* If ((nvl(p_eligy_criteria_dpnt_id, hr_api.g_number) <> hr_api.g_number) and

728: (p_api_name => l_proc,
729: p_argument => 'validation_end_date',
730: p_argument_value => p_validation_end_date);
731: --
732: /* If ((nvl(p_eligy_criteria_dpnt_id, hr_api.g_number) <> hr_api.g_number) and
733: NOT (dt_api.check_min_max_dates
734: (p_base_table_name => 'ben_eligy_criteria',
735: p_base_key_column => 'eligy_criteria_dpnt_id',
736: p_base_key_value => p_eligy_criteria_dpnt_id,

Line 743: If ((nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

739: l_table_name := 'ben_eligy_criteria';
740: Raise l_integrity_error;
741: End If;*/
742: --
743: If ((nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
744: NOT (dt_api.check_min_max_dates
745: (p_base_table_name => 'ben_dpnt_cvg_eligy_prfl_f',
746: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
747: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,

Line 824: hr_api.mandatory_arg_error

820: hr_utility.set_location('Entering:'||l_proc, 5);
821: --
822: -- Ensure that the p_datetrack_mode argument is not null
823: --
824: hr_api.mandatory_arg_error
825: (p_api_name => l_proc,
826: p_argument => 'datetrack_mode',
827: p_argument_value => p_datetrack_mode);
828: --

Line 838: hr_api.mandatory_arg_error

834: --
835: --
836: -- Ensure the arguments are not null
837: --
838: hr_api.mandatory_arg_error
839: (p_api_name => l_proc,
840: p_argument => 'validation_start_date',
841: p_argument_value => p_validation_start_date);
842: --

Line 843: hr_api.mandatory_arg_error

839: (p_api_name => l_proc,
840: p_argument => 'validation_start_date',
841: p_argument_value => p_validation_start_date);
842: --
843: hr_api.mandatory_arg_error
844: (p_api_name => l_proc,
845: p_argument => 'validation_end_date',
846: p_argument_value => p_validation_end_date);
847: --

Line 848: hr_api.mandatory_arg_error

844: (p_api_name => l_proc,
845: p_argument => 'validation_end_date',
846: p_argument_value => p_validation_end_date);
847: --
848: hr_api.mandatory_arg_error
849: (p_api_name => l_proc,
850: p_argument => 'dpnt_eligy_crit_values_id',
851: p_argument_value => p_dpnt_eligy_crit_values_id);
852: --

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

872: -- Call all supporting business operations
873: --
874: --
875: if p_rec.business_group_id is not null then
876: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
877: end if;
878: --
879: chk_dpnt_eligy_crit_values_id( p_dpnt_eligy_crit_values_id => p_rec.dpnt_eligy_crit_values_id,
880: p_effective_date => p_effective_date,

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

958: --
959: if p_rec.business_group_id is not null
960: then
961: --
962: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
963: --
964: end if;
965: --
966: chk_dpnt_eligy_crit_values_id( p_dpnt_eligy_crit_values_id => p_rec.dpnt_eligy_crit_values_id,

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

1091: hr_utility.set_location('Entering:'|| l_proc, 10);
1092: --
1093: -- Ensure that all the mandatory parameter are not null
1094: --
1095: hr_api.mandatory_arg_error(p_api_name => l_proc,
1096: p_argument => 'dpnt_eligy_crit_values_id',
1097: p_argument_value => p_dpnt_eligy_crit_values_id);
1098: --
1099: open csr_leg_code;