[Home] [Help]
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'GHR_DUTY_STATIONS_F_PK') Then
37: fnd_message.set_name('GHR', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
37: fnd_message.set_name('GHR', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'GHR_DUTY_STATIONS_F_UK') Then
42: fnd_message.set_name('GHR', 'GHR_38819_DUTY_STATION_EXISTS');
43: fnd_message.raise_error;
44: Else
45: fnd_message.set_name('GHR', 'HR_7877_API_INVALID_CONSTRAINT');
76: state_or_country_code,
77: county_code ,
78: is_duty_station ,
79: object_version_number
80: FROM ghr_duty_stations_f
81: WHERE duty_station_id = p_duty_station_id
82: AND p_effective_date BETWEEN effective_start_date
83: AND effective_end_date;
84: --
154: -- Call the corresponding datetrack api
155: --
156: dt_api.find_dt_del_modes
157: (p_effective_date => p_effective_date,
158: p_base_table_name => 'ghr_duty_stations_f',
159: p_base_key_column => 'duty_station_id',
160: p_base_key_value => p_base_key_value,
161: p_zap => p_zap,
162: p_delete => p_delete,
186: -- Call the corresponding datetrack api
187: --
188: dt_api.find_dt_upd_modes
189: (p_effective_date => p_effective_date,
190: p_base_table_name => 'ghr_duty_stations_f',
191: p_base_key_column => 'duty_station_id',
192: p_base_key_value => p_base_key_value,
193: p_correction => p_correction,
194: p_update => p_update,
209: p_validation_end_date in date,
210: p_object_version_number out nocopy number) is
211: --
212: l_proc varchar2(72) := g_package||'upd_effective_end_date';
213: l_object_version_number ghr_duty_stations_f.object_version_number%type;
214: --
215: Begin
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
219: -- version number.
220: --
221: l_object_version_number :=
222: dt_api.get_object_version_number
223: (p_base_table_name => 'ghr_duty_stations_f',
224: p_base_key_column => 'duty_station_id',
225: p_base_key_value => p_base_key_value);
226: --
227: hr_utility.set_location(l_proc, 10);
229: --
230: -- Update the specified datetrack row setting the effective
231: -- end date to the specified new effective end date.
232: --
233: update ghr_duty_stations_f t
234: set t.effective_end_date = p_new_effective_end_date,
235: t.object_version_number = l_object_version_number
236: where t.duty_station_id = p_base_key_value
237: and p_effective_date between t.effective_start_date
280: state_or_country_code,
281: county_code ,
282: is_duty_station ,
283: object_version_number
284: FROM ghr_duty_stations_f
285: WHERE duty_station_id = p_duty_station_id
286: AND p_effective_date between effective_start_date
287: and effective_end_date
288: FOR UPDATE NOWAIT;
339: --
340: dt_api.validate_dt_mode
341: (p_effective_date => p_effective_date,
342: p_datetrack_mode => p_datetrack_mode,
343: p_base_table_name => 'ghr_duty_stations_f',
344: p_base_key_column => 'duty_station_id',
345: p_base_key_value => p_duty_station_id,
346: p_validation_start_date => l_validation_start_date,
347: p_validation_end_date => l_validation_end_date
373: -- The object is locked therefore we need to supply a meaningful
374: -- error message.
375: --
376: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
377: fnd_message.set_token('TABLE_NAME', 'GHR_DUTY_STATIONS_F');
378: fnd_message.raise_error;
379:
380: When l_object_invalid then
381: --
381: --
382: -- The object doesn't exist or is invalid
383: --
384: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
385: fnd_message.set_token('TABLE_NAME', 'GHR_DUTY_STATIONS_F');
386: fnd_message.raise_error;
387: End lck;
388: --
389: -- ----------------------------------------------------------------------------