22: --
23: l_proc varchar2(72) := g_package||'set_base_key_value';
24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: pqh_tah_ins.g_approval_history_id_i := p_approval_history_id;
29: pqh_tah_ins.g_transaction_history_id_i := p_transaction_history_id;
30: --
27: --
28: pqh_tah_ins.g_approval_history_id_i := p_approval_history_id;
29: pqh_tah_ins.g_transaction_history_id_i := p_transaction_history_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --
34: --
35: -- ----------------------------------------------------------------------------
81: --
82: l_proc varchar2(72) := g_package||'insert_dml';
83: --
84: Begin
85: hr_utility.set_location('Entering:'||l_proc, 5);
86: --
87: --
88: --
89: --
119: );
120: --
121: --
122: --
123: hr_utility.set_location(' Leaving:'||l_proc, 10);
124: Exception
125: When hr_api.check_integrity_violated Then
126: -- A check constraint has been violated
127: --
194: l_proc varchar2(72) := g_package||'pre_insert';
195: l_exists varchar2(1);
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: If (pqh_tah_ins.g_approval_history_id_i is not null AND
201: pqh_tah_ins.g_transaction_history_id_i is not null) Then
202: --
223: Else
224: NULL;
225: End If;
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
228: End pre_insert;
229: --
230: -- ----------------------------------------------------------------------------
231: -- |-----------------------------< post_insert >------------------------------|
265: --
266: l_proc varchar2(72) := g_package||'post_insert';
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: begin
271: --
272: null;
273: --
280: ,p_hook_type => 'AI');
281: --
282: end;
283: --
284: hr_utility.set_location(' Leaving:'||l_proc, 10);
285: End post_insert;
286: --
287: -- ----------------------------------------------------------------------------
288: -- |---------------------------------< ins >----------------------------------|
293: --
294: l_proc varchar2(72) := g_package||'ins';
295: --
296: Begin
297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: -- Call the supporting insert validate operations
300: --
301: pqh_tah_bus.insert_validate
321: --
322: -- Call to raise any errors on multi-message list
323: hr_multi_message.end_validation_set;
324: --
325: hr_utility.set_location('Leaving:'||l_proc, 20);
326: end ins;
327: --
328: -- ----------------------------------------------------------------------------
329: -- |---------------------------------< ins >----------------------------------|
346: l_rec pqh_tah_shd.g_rec_type;
347: l_proc varchar2(72) := g_package||'ins';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: -- Call conversion function to turn arguments into the
353: -- p_rec structure.
354: --
381: p_approval_history_id := l_rec.approval_history_id;
382: p_transaction_history_id := l_rec.transaction_history_id;
383: --
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 10);
386: End ins;
387: --
388: end pqh_tah_ins;