[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: pqp_val_ins.g_vehicle_allocation_id_i := p_vehicle_allocation_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pqp_val_ins.g_vehicle_allocation_id_i := p_vehicle_allocation_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
101: l_last_updated_by pqp_vehicle_allocations_f.last_updated_by%TYPE;
102: l_last_update_login pqp_vehicle_allocations_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Get the object version number for the insert
108: --
109: p_rec.object_version_number :=
122: -- If the datetrack_mode is not INSERT then we must populate the WHO
123: -- columns with the 'old' creation values and 'new' updated values.
124: --
125: If (p_datetrack_mode <> hr_api.g_insert) then
126: hr_utility.set_location(l_proc, 10);
127: --
128: -- Select the 'old' created values
129: --
130: Open C_Sel1;
296: ,l_last_update_login
297: );
298: --
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 15);
301: --
302: Exception
303: When hr_api.check_integrity_violated Then
304: -- A check constraint has been violated
328: --
329: l_proc varchar2(72) := g_package||'insert_dml';
330: --
331: Begin
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: pqp_val_ins.dt_insert_dml
335: (p_rec => p_rec
336: ,p_effective_date => p_effective_date
338: ,p_validation_start_date => p_validation_start_date
339: ,p_validation_end_date => p_validation_end_date
340: );
341: --
342: hr_utility.set_location(' Leaving:'||l_proc, 10);
343: End insert_dml;
344: --
345: -- ----------------------------------------------------------------------------
346: -- |------------------------------< pre_insert >------------------------------|
400: l_proc varchar2(72) := g_package||'pre_insert';
401: l_exists varchar2(1);
402: --
403: Begin
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: --
406: If (pqp_val_ins.g_vehicle_allocation_id_i is not null) Then
407: --
408: -- Verify registered primary key values not already in use
437: Close C_Sel1;
438: End If;
439: --
440: --
441: hr_utility.set_location(' Leaving:'||l_proc, 10);
442: End pre_insert;
443: --
444: -- ----------------------------------------------------------------------------
445: -- |----------------------------< post_insert >-------------------------------|
483: --
484: l_proc varchar2(72) := g_package||'post_insert';
485: --
486: Begin
487: hr_utility.set_location('Entering:'||l_proc, 5);
488: begin
489: --
490: pqp_val_rki.after_insert
491: (p_effective_date
633: ,p_hook_type => 'AI');
634: --
635: end;
636: --
637: hr_utility.set_location(' Leaving:'||l_proc, 10);
638: End post_insert;
639: --
640: -- ----------------------------------------------------------------------------
641: -- |-------------------------------< ins_lck >--------------------------------|
685: l_validation_start_date date;
686: l_validation_end_date date;
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: -- Validate the datetrack mode mode getting the validation start
692: -- and end dates for the specified datetrack operation.
693: --
712: --
713: p_validation_start_date := l_validation_start_date;
714: p_validation_end_date := l_validation_end_date;
715: --
716: hr_utility.set_location(' Leaving:'||l_proc, 10);
717: --
718: End ins_lck;
719: --
720: -- ----------------------------------------------------------------------------
730: l_validation_start_date date;
731: l_validation_end_date date;
732: --
733: Begin
734: hr_utility.set_location('Entering:'||l_proc, 5);
735: --
736: -- Call the lock operation
737: --
738: pqp_val_ins.ins_lck
788: --
789: -- Call to raise any errors on multi-message list
790: hr_multi_message.end_validation_set;
791: --
792: hr_utility.set_location('Leaving:'||l_proc,10);
793: end ins;
794: --
795: -- ----------------------------------------------------------------------------
796: -- |---------------------------------< ins >----------------------------------|
866: l_rec pqp_val_shd.g_rec_type;
867: l_proc varchar2(72) := g_package||'ins';
868: --
869: Begin
870: hr_utility.set_location('Entering:'||l_proc, 5);
871: --
872: -- Call conversion function to turn arguments into the
873: -- p_rec structure.
874: --
956: p_effective_end_date := l_rec.effective_end_date;
957: p_object_version_number := l_rec.object_version_number;
958: --
959: --
960: hr_utility.set_location(' Leaving:'||l_proc, 10);
961: End ins;
962: --
963: end pqp_val_ins;