[Home] [Help]
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: hr_trn_ins.g_transaction_id_i := p_transaction_id;
29: --
30: hr_utility.set_location(' Leaving:'||l_proc, 20);
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: hr_trn_ins.g_transaction_id_i := p_transaction_id;
29: --
30: hr_utility.set_location(' Leaving:'||l_proc, 20);
31: End set_base_key_value;
32:
33: --
34: -- ----------------------------------------------------------------------------
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: --
84: --
85: hr_trn_shd.g_api_dml := true; -- Set the api dml status
86: --
150: -- plan_id, rptg_grp_id, effective_date_option added by sanej
151: --
152: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 10);
155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: hr_trn_shd.g_api_dml := false; -- Unset the api dml status
222: from hr_api_transactions
223: where transaction_id = hr_trn_ins.g_transaction_id_i;
224: --
225: Begin
226: hr_utility.set_location('Entering:'||l_proc, 5);
227:
228: If hr_trn_ins.g_transaction_id_i is not null then
229: --
230: -- Verify registered primary key values not already in use
260: If p_rec.transaction_ref_id is null Then
261: p_rec.transaction_ref_id := p_rec.transaction_id;
262: End If;
263:
264: hr_utility.set_location(' Leaving:'||l_proc, 10);
265: End pre_insert;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |-----------------------------< post_insert >------------------------------|
300: --
301: l_proc varchar2(72) := g_package||'post_insert';
302: --
303: Begin
304: hr_utility.set_location('Entering:'||l_proc, 5);
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 10);
307: End post_insert;
308: --
302: --
303: Begin
304: hr_utility.set_location('Entering:'||l_proc, 5);
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 10);
307: End post_insert;
308: --
309: -- ----------------------------------------------------------------------------
310: -- |---------------------------------< ins >----------------------------------|
317: --
318: l_proc varchar2(72) := g_package||'ins';
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);
322: --
323: -- Determine if the business process is to be validated.
324: --
325: If p_validate then
350: If p_validate then
351: Raise HR_Api.Validate_Enabled;
352: End If;
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: Exception
356: When HR_Api.Validate_Enabled Then
357: --
358: -- As the Validate_Enabled exception has been raised
375: l_rec hr_trn_shd.g_rec_type;
376: l_proc varchar2(72) := g_package||'ins';
377: --
378: Begin
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: --
381: -- Call conversion function to turn arguments into the
382: -- p_rec structure.
383: --
433: );
434: --
435: -- p_plan_id, p_rptg_grp_id, p_effective_date_option added by sanej
436:
437: hr_utility.set_location(' Leaving:'||l_proc, 10);
438: End ins;
439: --
440: -- Overloaded ins procedure
441: Procedure ins
475: --
476: l_rec hr_trn_shd.g_rec_type;
477: l_proc varchar2(72) := g_package||'ins';
478: Begin
479: hr_utility.set_location('Entering:'||l_proc, 5);
480: --
481: -- Call conversion function to turn arguments into the
482: -- p_rec structure.
483: --
527: --
528: p_transaction_id := l_rec.transaction_id;
529: --
530: --
531: hr_utility.set_location(' Leaving:'||l_proc, 10);
532: End ins;
533:
534: end hr_trn_ins;