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: --
75: where job_basket_item_id = p_rec.job_basket_item_id;
76: --
77: irc_jbi_shd.g_api_dml := false; -- Unset the api dml status
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
141: --
142: l_proc varchar2(72) := g_package||'pre_update';
143: --
144: Begin
145: hr_utility.set_location('Entering:'||l_proc, 5);
146: --
147: hr_utility.set_location(' Leaving:'||l_proc, 10);
148: End pre_update;
149: --
143: --
144: Begin
145: hr_utility.set_location('Entering:'||l_proc, 5);
146: --
147: hr_utility.set_location(' Leaving:'||l_proc, 10);
148: End pre_update;
149: --
150: -- ----------------------------------------------------------------------------
151: -- |-----------------------------< post_update >------------------------------|
186: --
187: l_proc varchar2(72) := g_package||'post_update';
188: --
189: Begin
190: hr_utility.set_location('Entering:'||l_proc, 5);
191: begin
192: --
193: irc_jbi_rku.after_update(p_effective_date => p_effective_date
194: ,p_person_id=>p_rec.person_id
213: ,p_hook_type => 'AU');
214: --
215: end;
216: --
217: hr_utility.set_location(' Leaving:'||l_proc, 10);
218: End post_update;
219: --
220: -- ----------------------------------------------------------------------------
221: -- |-----------------------------< convert_defs >-----------------------------|
266: --
267: l_proc varchar2(72) := g_package||'convert_defs';
268: Begin
269: --
270: hr_utility.set_location('Entering:' ||l_proc,10);
271: -- We must now examine each argument value in the
272: -- p_rec plsql record structure
273: -- to see if a system default is being used. If a system default
274: -- is being used then we must set to the 'current' argument value.
272: -- p_rec plsql record structure
273: -- to see if a system default is being used. If a system default
274: -- is being used then we must set to the 'current' argument value.
275: --
276: hr_utility.set_location('Leaving:' ||l_proc,20);
277: End convert_defs;
278: --
279: -- ----------------------------------------------------------------------------
280: -- |---------------------------------< upd >----------------------------------|
286: --
287: l_proc varchar2(72) := g_package||'upd';
288: --
289: Begin
290: hr_utility.set_location('Entering:'||l_proc, 5);
291: --
292: -- We must lock the row which we need to update.
293: --
294: irc_jbi_shd.lck
338: l_rec irc_jbi_shd.g_rec_type;
339: l_proc varchar2(72) := g_package||'upd';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);
343: --
344: -- Call conversion function to turn arguments into the
345: -- l_rec structure.
346: --
361: ,l_rec
362: );
363: p_object_version_number := l_rec.object_version_number;
364: --
365: hr_utility.set_location(' Leaving:'||l_proc, 10);
366: End upd;
367: --
368: end irc_jbi_upd;