[Home] [Help]
79: l_last_updated_by pay_ie_social_benefits_f.last_updated_by%TYPE;
80: l_last_update_login pay_ie_social_benefits_f.last_update_login%TYPE;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: --
85: -- Get the object version number for the insert
86: --
87: p_rec.object_version_number :=
100: -- If the datetrack_mode is not INSERT then we must populate the WHO
101: -- columns with the 'old' creation values and 'new' updated values.
102: --
103: If (p_datetrack_mode <> hr_api.g_insert) then
104: hr_utility.set_location(l_proc, 10);
105: --
106: -- Select the 'old' created values
107: --
108: Open C_Sel1;
180: ,l_last_update_login
181: );
182: --
183: --
184: hr_utility.set_location(' Leaving:'||l_proc, 15);
185: --
186: Exception
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
212: --
213: l_proc varchar2(72) := g_package||'insert_dml';
214: --
215: Begin
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
218: pay_isb_ins.dt_insert_dml
219: (p_rec => p_rec
220: ,p_effective_date => p_effective_date
222: ,p_validation_start_date => p_validation_start_date
223: ,p_validation_end_date => p_validation_end_date
224: );
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: End insert_dml;
228: --
229: -- ----------------------------------------------------------------------------
230: -- |------------------------------< pre_insert >------------------------------|
277: --
278: Cursor C_Sel1 is select pay_ie_social_benefits_s.nextval from sys.dual;
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: --
284: -- Select the next sequence number
285: --
287: Fetch C_Sel1 Into p_rec.social_benefit_id;
288: Close C_Sel1;
289: --
290: --
291: hr_utility.set_location(' Leaving:'||l_proc, 10);
292: End pre_insert;
293: --
294: -- ----------------------------------------------------------------------------
295: -- |----------------------------< post_insert >-------------------------------|
333: --
334: l_proc varchar2(72) := g_package||'post_insert';
335: --
336: Begin
337: hr_utility.set_location('Entering:'||l_proc, 5);
338: begin
339: --
340: pay_isb_rki.after_insert
341: (p_effective_date
389: ,p_hook_type => 'AI');
390: --
391: end;
392: --
393: hr_utility.set_location(' Leaving:'||l_proc, 10);
394: End post_insert;
395: --
396: -- ----------------------------------------------------------------------------
397: -- |-------------------------------< ins_lck >--------------------------------|
441: l_validation_start_date date;
442: l_validation_end_date date;
443: --
444: Begin
445: hr_utility.set_location('Entering:'||l_proc, 5);
446: --
447: -- Validate the datetrack mode mode getting the validation start
448: -- and end dates for the specified datetrack operation.
449: --
465: --
466: p_validation_start_date := l_validation_start_date;
467: p_validation_end_date := l_validation_end_date;
468: --
469: hr_utility.set_location(' Leaving:'||l_proc, 10);
470: --
471: End ins_lck;
472: --
473: -- ----------------------------------------------------------------------------
483: l_validation_start_date date;
484: l_validation_end_date date;
485: --
486: Begin
487: hr_utility.set_location('Entering:'||l_proc, 5);
488: --
489: -- Call the lock operation
490: --
491: pay_isb_ins.ins_lck
535: ,p_validation_start_date => l_validation_start_date
536: ,p_validation_end_date => l_validation_end_date
537: );
538: --
539: hr_utility.set_location('Leaving:'||l_proc,10);
540: end ins;
541: --
542: -- ----------------------------------------------------------------------------
543: -- |---------------------------------< ins >----------------------------------|
566: l_rec pay_isb_shd.g_rec_type;
567: l_proc varchar2(72) := g_package||'ins';
568: --
569: Begin
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: -- Call conversion function to turn arguments into the
573: -- p_rec structure.
574: --
608: p_effective_start_date := l_rec.effective_start_date;
609: p_effective_end_date := l_rec.effective_end_date;
610: p_object_version_number := l_rec.object_version_number;
611: --
612: hr_utility.set_location(' Leaving:'||l_proc, 10);
613: End ins;
614: --
615: end pay_isb_ins;