[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: irc_irf_ins.g_referral_info_id_i := p_referral_info_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: irc_irf_ins.g_referral_info_id_i := p_referral_info_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
99: l_current_user_id integer;
100: l_temp_count integer;
101: --
102: Begin
103: hr_utility.set_location('Entering:'||l_proc, 5);
104: --
105: -- Set the effective start and end dates to the corresponding
106: -- validation start and end dates
107: --
112: -- If the datetrack_mode is not INSERT then we must populate the WHO
113: -- columns with the 'old' creation values and 'new' updated values.
114: --
115: If (p_datetrack_mode <> hr_api.g_insert) then
116: hr_utility.set_location(l_proc, 10);
117: --
118: -- Get the object version number for the insert
119: --
120: p_rec.object_version_number :=
245: ,p_rec.object_version_number
246: );
247: --
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 15);
250: --
251: Exception
252: When hr_api.check_integrity_violated Then
253: -- A check constraint has been violated
277: --
278: l_proc varchar2(72) := g_package||'insert_dml';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: irc_irf_ins.dt_insert_dml
284: (p_rec => p_rec
285: ,p_effective_date => p_effective_date
287: ,p_validation_start_date => p_validation_start_date
288: ,p_validation_end_date => p_validation_end_date
289: );
290: --
291: hr_utility.set_location(' Leaving:'||l_proc, 10);
292: End insert_dml;
293: --
294: -- ----------------------------------------------------------------------------
295: -- |------------------------------< pre_insert >------------------------------|
351: l_proc varchar2(72) := g_package||'pre_insert';
352: l_exists varchar2(1);
353: --
354: Begin
355: hr_utility.set_location('Entering:'||l_proc, 5);
356: --
357: --
358: -- Verify registered primary key values not already in use
359: --
388: Close C_Sel1;
389: End If;
390: --
391: --
392: hr_utility.set_location(' Leaving:'||l_proc, 10);
393: End pre_insert;
394: --
395: -- ----------------------------------------------------------------------------
396: -- |----------------------------< post_insert >-------------------------------|
434: --
435: l_proc varchar2(72) := g_package||'post_insert';
436: --
437: Begin
438: hr_utility.set_location('Entering:'||l_proc, 5);
439: begin
440: --
441: irc_irf_rki.after_insert
442: (p_effective_date => p_effective_date
498: ,p_hook_type => 'AI');
499: --
500: end;
501: --
502: hr_utility.set_location(' Leaving:'||l_proc, 10);
503: End post_insert;
504: --
505: -- ----------------------------------------------------------------------------
506: -- |-------------------------------< ins_lck >--------------------------------|
550: l_validation_start_date date;
551: l_validation_end_date date;
552: --
553: Begin
554: hr_utility.set_location('Entering:'||l_proc, 5);
555: --
556: -- Validate the datetrack mode mode getting the validation start
557: -- and end dates for the specified datetrack operation.
558: --
563: -- p_validation_end_date := l_validation_end_date;
564: p_validation_start_date := sysdate;
565: p_validation_end_date := hr_general.end_of_time;
566: --
567: hr_utility.set_location(' Leaving:'||l_proc, 10);
568: --
569: End ins_lck;
570: --
571: -- ----------------------------------------------------------------------------
581: l_validation_start_date date;
582: l_validation_end_date date;
583: --
584: Begin
585: hr_utility.set_location('Entering:'||l_proc, 5);
586: --
587: -- Call the lock operation
588: --
589: irc_irf_ins.ins_lck
639: --
640: -- Call to raise any errors on multi-message list
641: hr_multi_message.end_validation_set;
642: --
643: hr_utility.set_location('Leaving:'||l_proc,10);
644: end ins;
645: --
646: -- ----------------------------------------------------------------------------
647: -- |---------------------------------< ins >----------------------------------|
697: l_rec irc_irf_shd.g_rec_type;
698: l_proc varchar2(72) := g_package||'ins';
699: --
700: Begin
701: hr_utility.set_location('Entering:'||l_proc, 5);
702: --
703: -- Call conversion function to turn arguments into the
704: -- p_rec structure.
705: --
767: p_end_date := l_rec.end_date;
768: p_object_version_number := l_rec.object_version_number;
769: --
770: --
771: hr_utility.set_location(' Leaving:'||l_proc, 10);
772: End ins;
773: --
774: end irc_irf_ins;