[Home] [Help]
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_pps_ins.g_parent_spine_id_i := p_parent_spine_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_pps_ins.g_parent_spine_id_i := p_parent_spine_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: per_pps_shd.g_api_dml := true; -- Set the api dml status
86: --
220: );
221: --
222: per_pps_shd.g_api_dml := false; -- Unset the api dml status
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: per_pps_shd.g_api_dml := false; -- Unset the api dml status
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_pps_ins.g_parent_spine_id_i is not null) Then
302: --
303: -- Verify registered primary key values not already in use
331: Fetch C_Sel1 Into p_rec.parent_spine_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 >------------------------------|
374: --
375: l_proc varchar2(72) := g_package||'post_insert';
376: --
377: Begin
378: hr_utility.set_location('Entering:'||l_proc, 5);
379: begin
380: --
381: per_pps_rki.after_insert
382: (p_effective_date => p_effective_date
519: ,p_hook_type => 'AI');
520: --
521: end;
522: --
523: hr_utility.set_location(' Leaving:'||l_proc, 10);
524: End post_insert;
525: --
526: -- ----------------------------------------------------------------------------
527: -- |---------------------------------< ins >----------------------------------|
533: --
534: l_proc varchar2(72) := g_package||'ins';
535: --
536: Begin
537: hr_utility.set_location('Entering:'||l_proc, 5);
538: --
539: -- Call the supporting insert validate operations
540: --
541: per_pps_bus.insert_validate
563: --
564: -- Call to raise any errors on multi-message list
565: hr_multi_message.end_validation_set;
566: --
567: hr_utility.set_location('Leaving:'||l_proc, 20);
568: end ins;
569: --
570: -- ----------------------------------------------------------------------------
571: -- |---------------------------------< ins >----------------------------------|
641: l_rec per_pps_shd.g_rec_type;
642: l_proc varchar2(72) := g_package||'ins';
643: --
644: Begin
645: hr_utility.set_location('Entering:'||l_proc, 5);
646: --
647: -- Call conversion function to turn arguments into the
648: -- p_rec structure.
649: --
728: --
729: p_parent_spine_id := l_rec.parent_spine_id;
730: p_object_version_number := l_rec.object_version_number;
731: --
732: hr_utility.set_location(' Leaving:'||l_proc, 10);
733: End ins;
734: --
735: end per_pps_ins;