57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: --
64: --
65: --
84: where transaction_history_id = p_rec.transaction_history_id;
85: --
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
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 >------------------------------|
190: --
191: l_proc varchar2(72) := g_package||'post_update';
192: --
193: Begin
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: begin
196: --
197: null;
198: --
205: ,p_hook_type => 'AU');
206: --
207: end;
208: --
209: hr_utility.set_location(' Leaving:'||l_proc, 10);
210: End post_update;
211: --
212: -- ----------------------------------------------------------------------------
213: -- |-----------------------------< convert_defs >-----------------------------|
327: --
328: l_proc varchar2(72) := g_package||'upd';
329: --
330: Begin
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: -- We must lock the row which we need to update.
334: --
335: pqh_txh_shd.lck
391: l_rec pqh_txh_shd.g_rec_type;
392: l_proc varchar2(72) := g_package||'upd';
393: --
394: Begin
395: hr_utility.set_location('Entering:'||l_proc, 5);
396: --
397: -- Call conversion function to turn arguments into the
398: -- l_rec structure.
399: --
423: (l_rec
424: );
425: --
426: --
427: hr_utility.set_location(' Leaving:'||l_proc, 10);
428: End upd;
429: --
430: end pqh_txh_upd;