[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_pji_ins.g_previous_job_extra_info_id_i := p_previous_job_extra_info_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: per_pji_ins.g_previous_job_extra_info_id_i := p_previous_job_extra_info_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: -- Insert the row into: per_prev_job_extra_info
86: --
220: ,p_rec.pji_information30
221: ,p_rec.object_version_number
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_pji_ins.g_previous_job_extra_info_id_i is not null) Then
302: --
303: -- Verify registered primary key values not already in use
331: Fetch C_Sel1 Into p_rec.previous_job_extra_info_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 >------------------------------|
373: --
374: l_proc varchar2(72) := g_package||'post_insert';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: begin
379: --
380: per_pji_rki.after_insert
381: (p_previous_job_extra_info_id
521: ,p_hook_type => 'AI');
522: --
523: end;
524: --
525: hr_utility.set_location(' Leaving:'||l_proc, 10);
526: End post_insert;
527: --
528: -- ----------------------------------------------------------------------------
529: -- |---------------------------------< ins >----------------------------------|
534: --
535: l_proc varchar2(72) := g_package||'ins';
536: --
537: Begin
538: hr_utility.set_location('Entering:'||l_proc, 5);
539: --
540: -- Call the supporting insert validate operations
541: --
542: per_pji_bus.insert_validate
556: per_pji_ins.post_insert
557: (p_rec
558: );
559: --
560: hr_utility.set_location('Leaving:'||l_proc, 20);
561: end ins;
562: --
563: -- ----------------------------------------------------------------------------
564: -- |---------------------------------< ins >----------------------------------|
635: l_rec per_pji_shd.g_rec_type;
636: l_proc varchar2(72) := g_package||'ins';
637: --
638: Begin
639: hr_utility.set_location('Entering:'||l_proc, 5);
640: --
641: -- Call conversion function to turn arguments into the
642: -- p_rec structure.
643: --
723: --
724: p_previous_job_extra_info_id := l_rec.previous_job_extra_info_id;
725: p_object_version_number := l_rec.object_version_number;
726: --
727: hr_utility.set_location(' Leaving:'||l_proc, 10);
728: End ins;
729: --
730: end per_pji_ins;