[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_iad_ins.g_assignment_details_id_i := p_assignment_details_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: irc_iad_ins.g_assignment_details_id_i := p_assignment_details_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
110: l_last_updated_by irc_assignment_details_f.last_updated_by%TYPE;
111: l_last_update_login irc_assignment_details_f.last_update_login%TYPE;
112: --
113: Begin
114: hr_utility.set_location('Entering:'||l_proc, 5);
115: --
116: -- Set the effective start and end dates to the corresponding
117: -- validation start and end dates
118: --
122: -- If the datetrack_mode is not INSERT then we must populate the WHO
123: -- columns with the 'old' creation values and 'new' updated values.
124: --
125: If (p_datetrack_mode <> hr_api.g_insert) then
126: hr_utility.set_location(l_proc, 10);
127: --
128: -- Get the object version number for the insert
129: --
130: p_rec.object_version_number :=
208: ,l_last_update_login
209: );
210: --
211: --
212: hr_utility.set_location(' Leaving:'||l_proc, 15);
213: --
214: Exception
215: When hr_api.check_integrity_violated Then
216: -- A check constraint has been violated
240: --
241: l_proc varchar2(72) := g_package||'insert_dml';
242: --
243: Begin
244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --
246: irc_iad_ins.dt_insert_dml
247: (p_rec => p_rec
248: ,p_effective_date => p_effective_date
250: ,p_validation_start_date => p_validation_start_date
251: ,p_validation_end_date => p_validation_end_date
252: );
253: --
254: hr_utility.set_location(' Leaving:'||l_proc, 10);
255: End insert_dml;
256: --
257: -- ----------------------------------------------------------------------------
258: -- |------------------------------< pre_insert >------------------------------|
312: l_proc varchar2(72) := g_package||'pre_insert';
313: l_exists varchar2(1);
314: --
315: Begin
316: hr_utility.set_location('Entering:'||l_proc, 5);
317: --
318: If (irc_iad_ins.g_assignment_details_id_i is not null) Then
319: --
320: -- Verify registered primary key values not already in use
349: Close C_Sel1;
350: End If;
351: --
352: --
353: hr_utility.set_location(' Leaving:'||l_proc, 10);
354: End pre_insert;
355: --
356: -- ----------------------------------------------------------------------------
357: -- |----------------------------< post_insert >-------------------------------|
395: --
396: l_proc varchar2(72) := g_package||'post_insert';
397: --
398: Begin
399: hr_utility.set_location('Entering:'||l_proc, 5);
400: begin
401: --
402: irc_iad_rki.after_insert
403: (p_effective_date
437: ,p_hook_type => 'AI');
438: --
439: end;
440: --
441: hr_utility.set_location(' Leaving:'||l_proc, 10);
442: End post_insert;
443: --
444: -- ----------------------------------------------------------------------------
445: -- |-------------------------------< ins_lck >--------------------------------|
489: l_validation_start_date date;
490: l_validation_end_date date;
491: --
492: Begin
493: hr_utility.set_location('Entering:'||l_proc, 5);
494: --
495: -- Validate the datetrack mode mode getting the validation start
496: -- and end dates for the specified datetrack operation.
497: --
513: --
514: p_validation_start_date := l_validation_start_date;
515: p_validation_end_date := l_validation_end_date;
516: --
517: hr_utility.set_location(' Leaving:'||l_proc, 10);
518: --
519: End ins_lck;
520: --
521: -- ----------------------------------------------------------------------------
531: l_validation_start_date date;
532: l_validation_end_date date;
533: --
534: Begin
535: hr_utility.set_location('Entering:'||l_proc, 5);
536: --
537: -- Call the lock operation
538: --
539: irc_iad_ins.ins_lck
589: --
590: -- Call to raise any errors on multi-message list
591: hr_multi_message.end_validation_set;
592: --
593: hr_utility.set_location('Leaving:'||l_proc,10);
594: end ins;
595: --
596: -- ----------------------------------------------------------------------------
597: -- |---------------------------------< ins >----------------------------------|
613: l_rec irc_iad_shd.g_rec_type;
614: l_proc varchar2(72) := g_package||'ins';
615: --
616: Begin
617: hr_utility.set_location('Entering:'||l_proc, 5);
618: --
619: -- Call conversion function to turn arguments into the
620: -- p_rec structure.
621: --
651: p_effective_end_date := l_rec.effective_end_date;
652: p_object_version_number := l_rec.object_version_number;
653: --
654: --
655: hr_utility.set_location(' Leaving:'||l_proc, 10);
656: End ins;
657: --
658: end irc_iad_ins;