58: l_last_updated_by ff_archive_items.last_updated_by%TYPE;
59: l_last_update_login ff_archive_items.last_update_login%TYPE;
60: --
61: Begin
62: hr_utility.set_location('Entering:'||l_proc, 5);
63: --
64: -- Increment the object version
65: --
66: p_rec.object_version_number := p_rec.object_version_number + 1;
86: where archive_item_id = p_rec.archive_item_id;
87: --
88: ff_arc_shd.g_api_dml := false; -- Unset the api dml status
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: --
92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
146: --
147: l_proc varchar2(72) := g_package||'pre_update';
148: --
149: Begin
150: hr_utility.set_location('Entering:'||l_proc, 5);
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: End pre_update;
154: --
148: --
149: Begin
150: hr_utility.set_location('Entering:'||l_proc, 5);
151: --
152: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: End pre_update;
154: --
155: -- ----------------------------------------------------------------------------
156: -- |-----------------------------< post_update >------------------------------|
188: --
189: l_proc varchar2(72) := g_package||'post_update';
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: hr_utility.set_location(' Leaving:'||l_proc, 10);
195: End post_update;
196: --
190: --
191: Begin
192: hr_utility.set_location('Entering:'||l_proc, 5);
193: --
194: hr_utility.set_location(' Leaving:'||l_proc, 10);
195: End post_update;
196: --
197: -- ----------------------------------------------------------------------------
198: -- |-----------------------------< convert_defs >-----------------------------|
243: l_proc varchar2(72) := g_package||'convert_defs';
244: --
245: Begin
246: --
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: -- We must now examine each argument value in the
250: -- p_rec plsql record structure
251: -- to see if a system default is being used. If a system default
268: ff_arc_shd.g_old_rec.value;
269: End If;
270:
271: --
272: hr_utility.set_location(' Leaving:'||l_proc, 10);
273: --
274: End convert_defs;
275: --
276: -- ----------------------------------------------------------------------------
283: --
284: l_proc varchar2(72) := g_package||'upd';
285: --
286: Begin
287: hr_utility.set_location('Entering:'||l_proc, 5);
288: --
289: -- We must lock the row which we need to update.
290: --
291: ff_arc_shd.lck
329: l_rec ff_arc_shd.g_rec_type;
330: l_proc varchar2(72) := g_package||'upd';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc, 5);
334: --
335: -- Call conversion function to turn arguments into the
336: -- l_rec structure.
337: --
352: --
353: upd(l_rec);
354: p_object_version_number := l_rec.object_version_number;
355: --
356: hr_utility.set_location(' Leaving:'||l_proc, 10);
357: End upd;
358: --
359: end ff_arc_upd;