[Home] [Help]
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_pac_ins.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following global variables are only to be used by
12: -- the set_base_key_value and pre_insert procedures.
13: --
21: --
22: l_proc varchar2(72) := g_package||'set_base_key_value';
23: --
24: Begin
25: hr_utility.set_location('Entering:'||l_proc, 10);
26: --
27: per_pac_ins.g_allocated_checklist_id_i := p_allocated_checklist_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
25: hr_utility.set_location('Entering:'||l_proc, 10);
26: --
27: per_pac_ins.g_allocated_checklist_id_i := p_allocated_checklist_id;
28: --
29: hr_utility.set_location(' Leaving:'||l_proc, 20);
30: End set_base_key_value;
31: --
32: --
33: -- ----------------------------------------------------------------------------
79: --
80: l_proc varchar2(72) := g_package||'insert_dml';
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: p_rec.object_version_number := 1; -- Initialise the object version
85: --
86: --
87: --
193: );
194: --
195: --
196: --
197: hr_utility.set_location(' Leaving:'||l_proc, 10);
198: Exception
199: When hr_api.check_integrity_violated Then
200: -- A check constraint has been violated
201: --
268: l_proc varchar2(72) := g_package||'pre_insert';
269: l_exists varchar2(1);
270: --
271: Begin
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: If (per_pac_ins.g_allocated_checklist_id_i is not null) Then
275: --
276: -- Verify registered primary key values not already in use
304: Fetch C_Sel1 Into p_rec.allocated_checklist_id;
305: Close C_Sel1;
306: End If;
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 10);
309: End pre_insert;
310: --
311: -- ----------------------------------------------------------------------------
312: -- |-----------------------------< post_insert >------------------------------|
347: --
348: l_proc varchar2(72) := g_package||'post_insert';
349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: begin
353: --
354: per_pac_rki.after_insert
355: (p_effective_date => p_effective_date
464: ,p_hook_type => 'AI');
465: --
466: end;
467: --
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: End post_insert;
470: --
471: -- ----------------------------------------------------------------------------
472: -- |---------------------------------< ins >----------------------------------|
478: --
479: l_proc varchar2(72) := g_package||'ins';
480: --
481: Begin
482: hr_utility.set_location('Entering:'||l_proc, 5);
483: --
484: -- Call the supporting insert validate operations
485: --
486: per_pac_bus.insert_validate
508: --
509: -- Call to raise any errors on multi-message list
510: hr_multi_message.end_validation_set;
511: --
512: hr_utility.set_location('Leaving:'||l_proc, 20);
513: end ins;
514: --
515: -- ----------------------------------------------------------------------------
516: -- |---------------------------------< ins >----------------------------------|
572: l_rec per_pac_shd.g_rec_type;
573: l_proc varchar2(72) := g_package||'ins';
574: --
575: Begin
576: hr_utility.set_location('Entering:'||l_proc, 5);
577: --
578: -- Call conversion function to turn arguments into the
579: -- p_rec structure.
580: --
645: --
646: p_allocated_checklist_id := l_rec.allocated_checklist_id;
647: p_object_version_number := l_rec.object_version_number;
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 10);
650: End ins;
651: --
652: end per_pac_ins;