[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: pay_psd_ins.g_sii_details_id_i := p_sii_details_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_psd_ins.g_sii_details_id_i := p_sii_details_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 pay_pl_sii_details_f.last_updated_by%TYPE;
102: l_last_update_login pay_pl_sii_details_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Set the effective start and end dates to the corresponding
108: -- validation start and end dates
109: --
113: -- If the datetrack_mode is not INSERT then we must populate the WHO
114: -- columns with the 'old' creation values and 'new' updated values.
115: --
116: If (p_datetrack_mode <> hr_api.g_insert) then
117: hr_utility.set_location(l_proc, 10);
118: --
119: -- Get the object version number for the insert
120: --
121: p_rec.object_version_number :=
222: ,l_last_update_login
223: );
224: --
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 15);
227: --
228: Exception
229: When hr_api.check_integrity_violated Then
230: -- A check constraint has been violated
254: --
255: l_proc varchar2(72) := g_package||'insert_dml';
256: --
257: Begin
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: pay_psd_ins.dt_insert_dml
261: (p_rec => p_rec
262: ,p_effective_date => p_effective_date
264: ,p_validation_start_date => p_validation_start_date
265: ,p_validation_end_date => p_validation_end_date
266: );
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 10);
269: End insert_dml;
270: --
271: -- ----------------------------------------------------------------------------
272: -- |------------------------------< pre_insert >------------------------------|
326: l_proc varchar2(72) := g_package||'pre_insert';
327: l_exists varchar2(1);
328: --
329: Begin
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: If (pay_psd_ins.g_sii_details_id_i is not null) Then
333: --
334: -- Verify registered primary key values not already in use
363: Close C_Sel1;
364: End If;
365: --
366: --
367: hr_utility.set_location(' Leaving:'||l_proc, 10);
368: End pre_insert;
369: --
370: -- ----------------------------------------------------------------------------
371: -- |----------------------------< post_insert >-------------------------------|
409: --
410: l_proc varchar2(72) := g_package||'post_insert';
411: --
412: Begin
413: hr_utility.set_location('Entering:'||l_proc, 5);
414: begin
415: --
416: pay_psd_rki.after_insert
417: (p_effective_date
483: ,p_hook_type => 'AI');
484: --
485: end;
486: --
487: hr_utility.set_location(' Leaving:'||l_proc, 10);
488: End post_insert;
489: --
490: -- ----------------------------------------------------------------------------
491: -- |-------------------------------< ins_lck >--------------------------------|
535: l_validation_start_date date;
536: l_validation_end_date date;
537: --
538: Begin
539: hr_utility.set_location('Entering:'||l_proc, 5);
540: --
541: -- Validate the datetrack mode mode getting the validation start
542: -- and end dates for the specified datetrack operation.
543: --
589: --
590: p_validation_start_date := l_validation_start_date;
591: p_validation_end_date := l_validation_end_date;
592: --
593: hr_utility.set_location(' Leaving:'||l_proc, 10);
594: --
595: End ins_lck;
596: --
597: -- ----------------------------------------------------------------------------
607: l_validation_start_date date;
608: l_validation_end_date date;
609: --
610: Begin
611: hr_utility.set_location('Entering:'||l_proc, 5);
612: --
613: -- Call the lock operation
614: --
615: pay_psd_ins.ins_lck
665: --
666: -- Call to raise any errors on multi-message list
667: hr_multi_message.end_validation_set;
668: --
669: hr_utility.set_location('Leaving:'||l_proc,10);
670: end ins;
671: --
672: -- ----------------------------------------------------------------------------
673: -- |---------------------------------< ins >----------------------------------|
705: l_rec pay_psd_shd.g_rec_type;
706: l_proc varchar2(72) := g_package||'ins';
707: --
708: Begin
709: hr_utility.set_location('Entering:'||l_proc, 5);
710: --
711: -- Call conversion function to turn arguments into the
712: -- p_rec structure.
713: --
757: p_effective_end_date := l_rec.effective_end_date;
758: p_object_version_number := l_rec.object_version_number;
759: --
760: --
761: hr_utility.set_location(' Leaving:'||l_proc, 10);
762: End ins;
763: --
764: end pay_psd_ins;