[Home] [Help]
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: -- Increment the object version
56: --
57: p_rec.object_version_number := p_rec.object_version_number + 1;
70: object_version_number = p_rec.object_version_number
71: where pa_remark_id = p_rec.pa_remark_id;
72:
73: --
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: --
76: Exception
77: When hr_api.check_integrity_violated Then
78: -- A check constraint has been violated
126: --
127: l_proc varchar2(72) := g_package||'pre_update';
128: --
129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: --
132: hr_utility.set_location(' Leaving:'||l_proc, 10);
133: End pre_update;
134: --
128: --
129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: --
132: hr_utility.set_location(' Leaving:'||l_proc, 10);
133: End pre_update;
134: --
135: -- ----------------------------------------------------------------------------
136: -- |-----------------------------< post_update >------------------------------|
168: --
169: l_proc varchar2(72) := g_package||'post_update';
170: --
171: Begin
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: --
174: -- This is a hook point and the user hook for post_update is called here.
175: --
176: begin
209: );
210: end;
211: -- End of API User Hook for post_update.
212: --
213: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: End post_update;
215: --
216: -- ----------------------------------------------------------------------------
217: -- |-----------------------------< convert_defs >-----------------------------|
262: l_proc varchar2(72) := g_package||'convert_defs';
263: --
264: Begin
265: --
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: --
268: -- We must now examine each argument value in the
269: -- p_rec plsql record structure
270: -- to see if a system default is being used. If a system default
283: ghr_pre_shd.g_old_rec.description;
284: End If;
285:
286: --
287: hr_utility.set_location(' Leaving:'||l_proc, 10);
288: --
289: End convert_defs;
290: --
291: -- ----------------------------------------------------------------------------
299: --
300: l_proc varchar2(72) := g_package||'upd';
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: -- Determine if the business process is to be validated.
306: --
307: If p_validate then
345: If p_validate then
346: Raise HR_Api.Validate_Enabled;
347: End If;
348: --
349: hr_utility.set_location(' Leaving:'||l_proc, 10);
350: Exception
351: When HR_Api.Validate_Enabled Then
352: --
353: -- As the Validate_Enabled exception has been raised
375: l_rec ghr_pre_shd.g_rec_type;
376: l_proc varchar2(72) := g_package||'upd';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: --
381: -- Call conversion function to turn arguments into the
382: -- l_rec structure.
383: --
402: --
403: upd(l_rec, p_validate);
404: p_object_version_number := l_rec.object_version_number;
405: --
406: hr_utility.set_location(' Leaving:'||l_proc, 10);
407: End upd;
408: --
409: end ghr_pre_upd;