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.GHR_DUT_UPD dependencies on HR_API

Line 112: When hr_api.check_integrity_violated Then

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));

Line 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

Line 117: When hr_api.unique_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
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 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;

Line 445: If (p_rec.duty_station_code = hr_api.g_varchar2) then

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: --

Line 451: If (p_rec.name = hr_api.g_varchar2) then

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: --

Line 541: p_locality_pay_area_id in number default hr_api.g_number ,

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 ,

Line 542: p_leo_pay_area_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 ,

Line 543: p_name 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 ,

Line 545: p_msa_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 ,

Line 546: p_cmsa_code 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,

Line 547: p_state_or_country_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,
551: p_effective_date in date,

Line 548: p_county_code 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,
552: p_datetrack_update_mode in varchar2

Line 549: p_is_duty_station in varchar2 default hr_api.g_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