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 GHR_DUT_SHD

Line 58: (p_rec in out nocopy ghr_dut_shd.g_rec_type,

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ghr_dut_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is

Line 82: ghr_dut_shd.g_api_dml := true; -- Set the api dml status

78: (p_base_table_name => 'ghr_duty_stations_f',
79: p_base_key_column => 'duty_station_id',
80: p_base_key_value => p_rec.duty_station_id);
81: --
82: ghr_dut_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Update the ghr_duty_stations_f Row
85: --
86: update ghr_duty_stations_f

Line 102: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status

98: where duty_station_id = p_rec.duty_station_id
99: and effective_start_date = p_validation_start_date
100: and effective_end_date = p_validation_end_date;
101: --
102: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
103: --
104: -- Set the effective start and end dates
105: --
106: p_rec.effective_start_date := p_validation_start_date;

Line 114: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status

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));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated

Line 115: ghr_dut_shd.constraint_error

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

Line 119: 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));
122: When Others Then
123: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status

Line 120: 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));
122: When Others Then
123: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status
124: Raise;

Line 123: ghr_dut_shd.g_api_dml := false; -- Unset the api dml status

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;
126: --
127: -- ----------------------------------------------------------------------------

Line 159: (p_rec in out nocopy ghr_dut_shd.g_rec_type,

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure update_dml
159: (p_rec in out nocopy ghr_dut_shd.g_rec_type,
160: p_effective_date in date,
161: p_datetrack_mode in varchar2,
162: p_validation_start_date in date,
163: p_validation_end_date in date) is

Line 223: (p_rec in out nocopy ghr_dut_shd.g_rec_type,

219: --
220: -- {End Of Comments}
221: -- ----------------------------------------------------------------------------
222: Procedure dt_pre_update
223: (p_rec in out nocopy ghr_dut_shd.g_rec_type,
224: p_effective_date in date,
225: p_datetrack_mode in varchar2,
226: p_validation_start_date in date,
227: p_validation_end_date in date) is

Line 239: ghr_dut_shd.upd_effective_end_date

235: hr_utility.set_location(l_proc, 10);
236: --
237: -- Update the current effective end date
238: --
239: ghr_dut_shd.upd_effective_end_date
240: (p_effective_date => p_effective_date,
241: p_base_key_value => p_rec.duty_station_id,
242: p_new_effective_end_date => (p_validation_start_date - 1),
243: p_validation_start_date => p_validation_start_date,

Line 308: (p_rec in out nocopy ghr_dut_shd.g_rec_type,

304: --
305: -- {End Of Comments}
306: -- ----------------------------------------------------------------------------
307: Procedure pre_update
308: (p_rec in out nocopy ghr_dut_shd.g_rec_type,
309: p_effective_date in date,
310: p_datetrack_mode in varchar2,
311: p_validation_start_date in date,
312: p_validation_end_date in date) is

Line 363: (p_rec in ghr_dut_shd.g_rec_type,

359: --
360: -- {End Of Comments}
361: -- ----------------------------------------------------------------------------
362: Procedure post_update
363: (p_rec in ghr_dut_shd.g_rec_type,
364: p_effective_date in date,
365: p_datetrack_mode in varchar2,
366: p_validation_start_date in date,
367: p_validation_end_date in date) is

Line 432: Procedure convert_defs(p_rec in out nocopy ghr_dut_shd.g_rec_type) is

428: -- Internal Row Handler Use Only.
429: --
430: -- {End Of Comments}
431: -- ----------------------------------------------------------------------------
432: Procedure convert_defs(p_rec in out nocopy ghr_dut_shd.g_rec_type) is
433: --
434: l_proc varchar2(72) := g_package||'convert_defs';
435: --
436: Begin

Line 447: ghr_dut_shd.g_old_rec.duty_station_code;

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: --
450: --
451: If (p_rec.name = hr_api.g_varchar2) then

Line 453: ghr_dut_shd.g_old_rec.name;

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: --
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: --

Line 465: p_rec in out nocopy ghr_dut_shd.g_rec_type,

461: -- |---------------------------------< upd >----------------------------------|
462: -- ----------------------------------------------------------------------------
463: Procedure upd
464: (
465: p_rec in out nocopy ghr_dut_shd.g_rec_type,
466: p_effective_date in date,
467: p_datetrack_update_mode in varchar2
468: ) is
469: --

Line 483: ghr_dut_shd.lck

479: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_update_mode);
480: --
481: -- We must lock the row which we need to update.
482: --
483: ghr_dut_shd.lck
484: (p_effective_date => p_effective_date,
485: p_datetrack_mode => p_datetrack_update_mode,
486: p_duty_station_id => p_rec.duty_station_id,
487: p_object_version_number => p_rec.object_version_number,

Line 555: l_rec ghr_dut_shd.g_rec_type;

551: p_effective_date in date,
552: p_datetrack_update_mode in varchar2
553: ) is
554: --
555: l_rec ghr_dut_shd.g_rec_type;
556: l_proc varchar2(72) := g_package||'upd';
557: --
558: Begin
559: hr_utility.set_location('Entering:'||l_proc, 5);

Line 565: ghr_dut_shd.convert_args

561: -- Call conversion function to turn arguments into the
562: -- l_rec structure.
563: --
564: l_rec :=
565: ghr_dut_shd.convert_args
566: (
567: p_duty_station_id => p_duty_station_id
568: ,p_effective_start_date => null
569: ,p_effective_end_date => null