[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_ppd_ins.g_paye_details_id_i := p_paye_details_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_ppd_ins.g_paye_details_id_i := p_paye_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_paye_details_f.last_updated_by%TYPE;
102: l_last_update_login pay_pl_paye_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 :=
202: ,l_last_update_login
203: );
204: --
205: --
206: hr_utility.set_location(' Leaving:'||l_proc, 15);
207: --
208: Exception
209: When hr_api.check_integrity_violated Then
210: -- A check constraint has been violated
234: --
235: l_proc varchar2(72) := g_package||'insert_dml';
236: --
237: Begin
238: hr_utility.set_location('Entering:'||l_proc, 5);
239: --
240: pay_ppd_ins.dt_insert_dml
241: (p_rec => p_rec
242: ,p_effective_date => p_effective_date
244: ,p_validation_start_date => p_validation_start_date
245: ,p_validation_end_date => p_validation_end_date
246: );
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 10);
249: End insert_dml;
250: --
251: -- ----------------------------------------------------------------------------
252: -- |------------------------------< pre_insert >------------------------------|
306: l_proc varchar2(72) := g_package||'pre_insert';
307: l_exists varchar2(1);
308: --
309: Begin
310: hr_utility.set_location('Entering:'||l_proc, 5);
311: --
312: If (pay_ppd_ins.g_paye_details_id_i is not null) Then
313: --
314: -- Verify registered primary key values not already in use
343: Close C_Sel1;
344: End If;
345: --
346: --
347: hr_utility.set_location(' Leaving:'||l_proc, 10);
348: End pre_insert;
349: --
350: -- ----------------------------------------------------------------------------
351: -- |----------------------------< post_insert >-------------------------------|
389: --
390: l_proc varchar2(72) := g_package||'post_insert';
391: --
392: Begin
393: hr_utility.set_location('Entering:'||l_proc, 5);
394: begin
395: --
396: pay_ppd_rki.after_insert
397: (p_effective_date
443: ,p_hook_type => 'AI');
444: --
445: end;
446: --
447: hr_utility.set_location(' Leaving:'||l_proc, 10);
448: End post_insert;
449: --
450: -- ----------------------------------------------------------------------------
451: -- |-------------------------------< ins_lck >--------------------------------|
495: l_validation_start_date date;
496: l_validation_end_date date;
497: --
498: Begin
499: hr_utility.set_location('Entering:'||l_proc, 5);
500: --
501: -- Validate the datetrack mode mode getting the validation start
502: -- and end dates for the specified datetrack operation.
503: --
551: --
552: p_validation_start_date := l_validation_start_date;
553: p_validation_end_date := l_validation_end_date;
554: --
555: hr_utility.set_location(' Leaving:'||l_proc, 10);
556: --
557: End ins_lck;
558: --
559: -- ----------------------------------------------------------------------------
569: l_validation_start_date date;
570: l_validation_end_date date;
571: --
572: Begin
573: hr_utility.set_location('Entering:'||l_proc, 5);
574: --
575: -- Call the lock operation
576: --
577: pay_ppd_ins.ins_lck
628: --
629: -- Call to raise any errors on multi-message list
630: hr_multi_message.end_validation_set;
631: --
632: hr_utility.set_location('Leaving:'||l_proc,10);
633: end ins;
634: --
635: -- ----------------------------------------------------------------------------
636: -- |---------------------------------< ins >----------------------------------|
658: l_rec pay_ppd_shd.g_rec_type;
659: l_proc varchar2(72) := g_package||'ins';
660: --
661: Begin
662: hr_utility.set_location('Entering:'||l_proc, 5);
663: --
664: -- Call conversion function to turn arguments into the
665: -- p_rec structure.
666: --
701: p_effective_end_date := l_rec.effective_end_date;
702: p_object_version_number := l_rec.object_version_number;
703: --
704: --
705: hr_utility.set_location(' Leaving:'||l_proc, 10);
706: End ins;
707: --
708: end pay_ppd_ins;