57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
84: --
85: irc_ido_shd.g_api_dml := false; -- Unset the dml status
86: --
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: --
90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
150: --
151: l_proc varchar2(72) := g_package||'pre_update';
152: --
153: Begin
154: hr_utility.set_location('Entering:'||l_proc, 5);
155: --
156: --
157: -- Derive file_format from MIME type
158: --
162: else
163: p_rec.file_format := 'BINARY';
164: end if;
165:
166: hr_utility.set_location(' Leaving:'||l_proc, 10);
167: End pre_update;
168: --
169: -- ----------------------------------------------------------------------------
170: -- |-----------------------------< post_update >------------------------------|
205: --
206: l_proc varchar2(72) := g_package||'post_update';
207: --
208: Begin
209: hr_utility.set_location('Entering:'||l_proc, 5);
210: begin
211: --
212: irc_ido_rku.after_update
213: (p_effective_date => p_effective_date
262: ,p_hook_type => 'AU');
263: --
264: end;
265: --
266: hr_utility.set_location(' Leaving:'||l_proc, 10);
267: End post_update;
268: --
269: -- ----------------------------------------------------------------------------
270: -- |-----------------------------< convert_defs >-----------------------------|
368: --
369: l_proc varchar2(72) := g_package||'upd';
370: --
371: Begin
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: -- We must lock the row which we need to update.
375: --
376: irc_ido_shd.lck
434: l_rec irc_ido_shd.g_rec_type;
435: l_proc varchar2(72) := g_package||'upd';
436: --
437: Begin
438: hr_utility.set_location('Entering:'||l_proc, 5);
439: --
440: -- Call conversion function to turn arguments into the
441: -- l_rec structure.
442: --
465: ,l_rec
466: );
467: p_object_version_number := l_rec.object_version_number;
468: --
469: hr_utility.set_location(' Leaving:'||l_proc, 10);
470: End upd;
471: --
472: end irc_ido_upd;