108: End If;
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 15);
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
115: ghr_dut_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
115: ghr_dut_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
120: ghr_dut_shd.constraint_error
113: -- A check constraint has been violated
114: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
115: ghr_dut_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
120: ghr_dut_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
120: ghr_dut_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
124: Raise;
125: End dt_update_dml;
441: -- p_rec plsql record structure
442: -- to see if a system default is being used. If a system default
443: -- is being used then we must set to the 'current' argument value.
444: --
445: If (p_rec.duty_station_code = hr_api.g_varchar2) then
446: p_rec.duty_station_code :=
447: ghr_dut_shd.g_old_rec.duty_station_code;
448: End If;
449: --
447: ghr_dut_shd.g_old_rec.duty_station_code;
448: End If;
449: --
450: --
451: If (p_rec.name = hr_api.g_varchar2) then
452: p_rec.name :=
453: ghr_dut_shd.g_old_rec.name;
454: End If;
455: --
537: (
538: p_duty_station_id in number,
539: p_effective_start_date out nocopy date,
540: p_effective_end_date out nocopy date,
541: p_locality_pay_area_id in number default hr_api.g_number ,
542: p_leo_pay_area_code in varchar2 default hr_api.g_varchar2 ,
543: p_name in varchar2 default hr_api.g_varchar2 ,
544: p_duty_station_code in varchar2 ,
545: p_msa_code in varchar2 default hr_api.g_varchar2 ,
538: p_duty_station_id in number,
539: p_effective_start_date out nocopy date,
540: p_effective_end_date out nocopy date,
541: p_locality_pay_area_id in number default hr_api.g_number ,
542: p_leo_pay_area_code in varchar2 default hr_api.g_varchar2 ,
543: p_name in varchar2 default hr_api.g_varchar2 ,
544: p_duty_station_code in varchar2 ,
545: p_msa_code in varchar2 default hr_api.g_varchar2 ,
546: p_cmsa_code in varchar2 default hr_api.g_varchar2 ,
539: p_effective_start_date out nocopy date,
540: p_effective_end_date out nocopy date,
541: p_locality_pay_area_id in number default hr_api.g_number ,
542: p_leo_pay_area_code in varchar2 default hr_api.g_varchar2 ,
543: p_name in varchar2 default hr_api.g_varchar2 ,
544: p_duty_station_code in varchar2 ,
545: p_msa_code in varchar2 default hr_api.g_varchar2 ,
546: p_cmsa_code in varchar2 default hr_api.g_varchar2 ,
547: p_state_or_country_code in varchar2 default hr_api.g_varchar2 ,
541: p_locality_pay_area_id in number default hr_api.g_number ,
542: p_leo_pay_area_code in varchar2 default hr_api.g_varchar2 ,
543: p_name in varchar2 default hr_api.g_varchar2 ,
544: p_duty_station_code in varchar2 ,
545: p_msa_code in varchar2 default hr_api.g_varchar2 ,
546: p_cmsa_code in varchar2 default hr_api.g_varchar2 ,
547: p_state_or_country_code in varchar2 default hr_api.g_varchar2 ,
548: p_county_code in varchar2 default hr_api.g_varchar2 ,
549: p_is_duty_station in varchar2 default hr_api.g_varchar2 ,
542: p_leo_pay_area_code in varchar2 default hr_api.g_varchar2 ,
543: p_name in varchar2 default hr_api.g_varchar2 ,
544: p_duty_station_code in varchar2 ,
545: p_msa_code in varchar2 default hr_api.g_varchar2 ,
546: p_cmsa_code in varchar2 default hr_api.g_varchar2 ,
547: p_state_or_country_code in varchar2 default hr_api.g_varchar2 ,
548: p_county_code in varchar2 default hr_api.g_varchar2 ,
549: p_is_duty_station in varchar2 default hr_api.g_varchar2 ,
550: p_object_version_number in out nocopy number,
543: p_name in varchar2 default hr_api.g_varchar2 ,
544: p_duty_station_code in varchar2 ,
545: p_msa_code in varchar2 default hr_api.g_varchar2 ,
546: p_cmsa_code in varchar2 default hr_api.g_varchar2 ,
547: p_state_or_country_code in varchar2 default hr_api.g_varchar2 ,
548: p_county_code in varchar2 default hr_api.g_varchar2 ,
549: p_is_duty_station in varchar2 default hr_api.g_varchar2 ,
550: p_object_version_number in out nocopy number,
551: p_effective_date in date,
544: p_duty_station_code in varchar2 ,
545: p_msa_code in varchar2 default hr_api.g_varchar2 ,
546: p_cmsa_code in varchar2 default hr_api.g_varchar2 ,
547: p_state_or_country_code in varchar2 default hr_api.g_varchar2 ,
548: p_county_code in varchar2 default hr_api.g_varchar2 ,
549: p_is_duty_station in varchar2 default hr_api.g_varchar2 ,
550: p_object_version_number in out nocopy number,
551: p_effective_date in date,
552: p_datetrack_update_mode in varchar2
545: p_msa_code in varchar2 default hr_api.g_varchar2 ,
546: p_cmsa_code in varchar2 default hr_api.g_varchar2 ,
547: p_state_or_country_code in varchar2 default hr_api.g_varchar2 ,
548: p_county_code in varchar2 default hr_api.g_varchar2 ,
549: p_is_duty_station in varchar2 default hr_api.g_varchar2 ,
550: p_object_version_number in out nocopy number,
551: p_effective_date in date,
552: p_datetrack_update_mode in varchar2
553: ) is