[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_iid_ins.g_interview_details_id_i := p_interview_details_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: irc_iid_ins.g_interview_details_id_i := p_interview_details_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 :=
219: ,p_rec.object_version_number
220: );
221: --
222: --
223: hr_utility.set_location(' Leaving:'||l_proc, 15);
224: --
225: Exception
226: When hr_api.check_integrity_violated Then
227: -- A check constraint has been violated
251: --
252: l_proc varchar2(72) := g_package||'insert_dml';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: irc_iid_ins.dt_insert_dml
258: (p_rec => p_rec
259: ,p_effective_date => p_effective_date
261: ,p_validation_start_date => p_validation_start_date
262: ,p_validation_end_date => p_validation_end_date
263: );
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: End insert_dml;
267: --
268: -- ----------------------------------------------------------------------------
269: -- |------------------------------< pre_insert >------------------------------|
325: l_proc varchar2(72) := g_package||'pre_insert';
326: l_exists varchar2(1);
327: --
328: Begin
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: If (irc_iid_ins.g_interview_details_id_i is not null) Then
332: --
333: -- Verify registered primary key values not already in use
362: Close C_Sel1;
363: End If;
364: --
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: End pre_insert;
368: --
369: -- ----------------------------------------------------------------------------
370: -- |----------------------------< post_insert >-------------------------------|
408: --
409: l_proc varchar2(72) := g_package||'post_insert';
410: --
411: Begin
412: hr_utility.set_location('Entering:'||l_proc, 5);
413: begin
414: --
415: irc_iid_rki.after_insert
416: (p_effective_date => p_effective_date
459: ,p_hook_type => 'AI');
460: --
461: end;
462: --
463: hr_utility.set_location(' Leaving:'||l_proc, 10);
464: End post_insert;
465: --
466: -- ----------------------------------------------------------------------------
467: -- |-------------------------------< ins_lck >--------------------------------|
511: l_validation_start_date date;
512: l_validation_end_date date;
513: --
514: Begin
515: hr_utility.set_location('Entering:'||l_proc, 5);
516: --
517: -- Validate the datetrack mode mode getting the validation start
518: -- and end dates for the specified datetrack operation.
519: --
525: -- MURTHY_CHANGES
526: p_validation_start_date := sysdate;
527: p_validation_end_date := hr_general.end_of_time;
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 10);
530: --
531: End ins_lck;
532: --
533: -- ----------------------------------------------------------------------------
543: l_validation_start_date date;
544: l_validation_end_date date;
545: --
546: Begin
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: -- Call the lock operation
550: --
551: irc_iid_ins.ins_lck
601: --
602: -- Call to raise any errors on multi-message list
603: hr_multi_message.end_validation_set;
604: --
605: hr_utility.set_location('Leaving:'||l_proc,10);
606: end ins;
607: --
608: -- ----------------------------------------------------------------------------
609: -- |---------------------------------< ins >----------------------------------|
647: l_rec irc_iid_shd.g_rec_type;
648: l_proc varchar2(72) := g_package||'ins';
649: --
650: Begin
651: hr_utility.set_location('Entering:'||l_proc, 5);
652: --
653: -- Call conversion function to turn arguments into the
654: -- p_rec structure.
655: --
705: p_end_date := l_rec.end_date;
706: p_object_version_number := l_rec.object_version_number;
707: --
708: --
709: hr_utility.set_location(' Leaving:'||l_proc, 10);
710: End ins;
711: --
712: end irc_iid_ins;