20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_ckl_ins.g_checklist_id_i := p_checklist_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_ckl_ins.g_checklist_id_i := p_checklist_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --
81: Begin
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
190: );
191: --
192: --
193: --
194: hr_utility.set_location(' Leaving:'||l_proc, 10);
195: Exception
196: When hr_api.check_integrity_violated Then
197: -- A check constraint has been violated
198: --
265: l_proc varchar2(72) := g_package||'pre_insert';
266: l_exists varchar2(1);
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: If (per_ckl_ins.g_checklist_id_i is not null) Then
272: --
273: -- Verify registered primary key values not already in use
301: Fetch C_Sel1 Into p_rec.checklist_id;
302: Close C_Sel1;
303: End If;
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 10);
306: End pre_insert;
307: --
308: -- ----------------------------------------------------------------------------
309: -- |-----------------------------< post_insert >------------------------------|
344: --
345: l_proc varchar2(72) := g_package||'post_insert';
346: --
347: Begin
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: begin
350: --
351: per_ckl_rki.after_insert
352: (p_effective_date => p_effective_date
459: ,p_hook_type => 'AI');
460: --
461: end;
462: --
463: hr_utility.set_location(' Leaving:'||l_proc, 10);
464: End post_insert;
465: --
466: -- ----------------------------------------------------------------------------
467: -- |---------------------------------< ins >----------------------------------|
473: --
474: l_proc varchar2(72) := g_package||'ins';
475: --
476: Begin
477: hr_utility.set_location('Entering:'||l_proc, 5);
478: --
479: -- Call the supporting insert validate operations
480: --
481: per_ckl_bus.insert_validate
503: --
504: -- Call to raise any errors on multi-message list
505: hr_multi_message.end_validation_set;
506: --
507: hr_utility.set_location('Leaving:'||l_proc, 20);
508: end ins;
509: --
510: -- ----------------------------------------------------------------------------
511: -- |---------------------------------< ins >----------------------------------|
566: l_rec per_ckl_shd.g_rec_type;
567: l_proc varchar2(72) := g_package||'ins';
568: --
569: Begin
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: -- Call conversion function to turn arguments into the
573: -- p_rec structure.
574: --
638: --
639: p_checklist_id := l_rec.checklist_id;
640: p_object_version_number := l_rec.object_version_number;
641: --
642: hr_utility.set_location(' Leaving:'||l_proc, 10);
643: End ins;
644: --
645: end per_ckl_ins;