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_pmp_ins.g_plan_id_i := p_plan_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_pmp_ins.g_plan_id_i := p_plan_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: -- Insert the row into: per_perf_mgmt_plans
220: ,p_rec.automatic_approval_flag
221: );
222: --
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 10);
225: Exception
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
228: --
295: l_proc varchar2(72) := g_package||'pre_insert';
296: l_exists varchar2(1);
297: --
298: Begin
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: If (per_pmp_ins.g_plan_id_i is not null) Then
302: --
303: -- Verify registered primary key values not already in use
331: Fetch C_Sel1 Into p_rec.plan_id;
332: Close C_Sel1;
333: End If;
334: --
335: hr_utility.set_location(' Leaving:'||l_proc, 10);
336: End pre_insert;
337: --
338: -- ----------------------------------------------------------------------------
339: -- |-----------------------------< post_insert >------------------------------|
376: --
377: l_proc varchar2(72) := g_package||'post_insert';
378: --
379: Begin
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: begin
382: --
383: per_pmp_rki.after_insert
384: (p_effective_date => p_effective_date
523: ,p_hook_type => 'AI');
524: --
525: end;
526: --
527: hr_utility.set_location(' Leaving:'||l_proc, 10);
528: End post_insert;
529: --
530: -- ----------------------------------------------------------------------------
531: -- |---------------------------------< ins >----------------------------------|
539: --
540: l_proc varchar2(72) := g_package||'ins';
541: --
542: Begin
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: -- Call the supporting insert validate operations
546: --
547: per_pmp_bus.insert_validate
574: --
575: -- Call to raise any errors on multi-message list
576: hr_multi_message.end_validation_set;
577: --
578: hr_utility.set_location('Leaving:'||l_proc, 20);
579: end ins;
580: --
581: -- ----------------------------------------------------------------------------
582: -- |---------------------------------< ins >----------------------------------|
656: l_proc varchar2(72) := g_package||'ins';
657: l_status_code CONSTANT varchar2(5) := 'DRAFT';
658: --
659: Begin
660: hr_utility.set_location('Entering:'||l_proc, 5);
661: --
662: -- Call conversion function to turn arguments into the
663: -- p_rec structure.
664: --
748: p_plan_id := l_rec.plan_id;
749: p_object_version_number := l_rec.object_version_number;
750: p_status_code := l_rec.status_code;
751: --
752: hr_utility.set_location(' Leaving:'||l_proc, 10);
753:
754: End ins;
755: --
756: end per_pmp_ins;