22: --
23: l_proc varchar2(72) := g_package||'set_base_key_value';
24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ame_atu_ins.g_attribute_id_i := p_attribute_id;
29: ame_atu_ins.g_application_id_i := p_application_id;
30: --
27: --
28: ame_atu_ins.g_attribute_id_i := p_attribute_id;
29: ame_atu_ins.g_application_id_i := p_application_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --
34: --
35: -- ----------------------------------------------------------------------------
114: l_current_user_id integer;
115: l_temp_count integer;
116: --
117: Begin
118: hr_utility.set_location('Entering:'||l_proc, 5);
119: --
120: -- Set the effective start and end dates to the corresponding
121: -- validation start and end dates
122: --
127: -- If the datetrack_mode is not INSERT then we must populate the WHO
128: -- columns with the 'old' creation values and 'new' updated values.
129: --
130: If (p_datetrack_mode <> hr_api.g_insert) then
131: hr_utility.set_location(l_proc, 10);
132: --
133: -- Get the object version number for the insert
134: --
135: p_rec.object_version_number :=
228: ,l_last_update_login
229: );
230: --
231: --
232: hr_utility.set_location(' Leaving:'||l_proc, 15);
233: --
234: Exception
235: When hr_api.check_integrity_violated Then
236: -- A check constraint has been violated
260: --
261: l_proc varchar2(72) := g_package||'insert_dml';
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: ame_atu_ins.dt_insert_dml
267: (p_rec => p_rec
268: ,p_effective_date => p_effective_date
270: ,p_validation_start_date => p_validation_start_date
271: ,p_validation_end_date => p_validation_end_date
272: );
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 10);
275: End insert_dml;
276: --
277: -- ----------------------------------------------------------------------------
278: -- |------------------------------< pre_insert >------------------------------|
334: l_proc varchar2(72) := g_package||'pre_insert';
335: l_exists varchar2(1);
336: --
337: Begin
338: hr_utility.set_location('Entering:'||l_proc, 5);
339: --
340: If (ame_atu_ins.g_attribute_id_i is not null or
341: ame_atu_ins.g_application_id_i is not null) Then
342: --
365: ame_atu_ins.g_application_id_i := null;
366: End If;
367: --
368: --
369: hr_utility.set_location(' Leaving:'||l_proc, 10);
370: End pre_insert;
371: --
372: -- ----------------------------------------------------------------------------
373: -- |----------------------------< post_insert >-------------------------------|
411: --
412: l_proc varchar2(72) := g_package||'post_insert';
413: --
414: Begin
415: hr_utility.set_location('Entering:'||l_proc, 5);
416: begin
417: --
418: ame_atu_rki.after_insert
419: (p_effective_date
455: ,p_hook_type => 'AI');
456: --
457: end;
458: --
459: hr_utility.set_location(' Leaving:'||l_proc, 10);
460: End post_insert;
461: --
462: -- ----------------------------------------------------------------------------
463: -- |-------------------------------< ins_lck >--------------------------------|
508: l_validation_start_date date;
509: l_validation_end_date date;
510: --
511: Begin
512: hr_utility.set_location('Entering:'||l_proc, 5);
513: --
514: -- Validate the datetrack mode mode getting the validation start
515: -- and end dates for the specified datetrack operation.
516: --
537: fnd_message.set_name('PER', 'AME_400478_CANNOT_LOCK_PARENT');
538: fnd_message.raise_error;
539: end;
540: --
541: hr_utility.set_location(' Leaving:'||l_proc, 20);
542: --
543: End ins_lck;
544: --
545: -- ----------------------------------------------------------------------------
555: l_validation_start_date date;
556: l_validation_end_date date;
557: --
558: Begin
559: hr_utility.set_location('Entering:'||l_proc, 5);
560: --
561: -- Call the lock operation
562: --
563: hr_utility.set_location('Entering:'||l_proc, 15);
559: hr_utility.set_location('Entering:'||l_proc, 5);
560: --
561: -- Call the lock operation
562: --
563: hr_utility.set_location('Entering:'||l_proc, 15);
564: ame_atu_ins.ins_lck
565: (p_effective_date => p_effective_date
566: ,p_datetrack_mode => l_datetrack_mode
567: ,p_rec => p_rec
570: );
571: --
572: -- Call the supporting insert validate operations
573: --
574: hr_utility.set_location('Entering:'||l_proc, 25);
575: ame_atu_bus.insert_validate
576: (p_rec => p_rec
577: ,p_effective_date => p_effective_date
578: ,p_datetrack_mode => l_datetrack_mode
584: hr_multi_message.end_validation_set;
585: --
586: -- Call the supporting pre-insert operation
587: --
588: hr_utility.set_location('Entering:'||l_proc, 35);
589: ame_atu_ins.pre_insert
590: (p_rec => p_rec
591: ,p_effective_date => p_effective_date
592: ,p_datetrack_mode => l_datetrack_mode
595: );
596: --
597: -- Insert the row
598: --
599: hr_utility.set_location('Entering:'||l_proc, 45);
600: ame_atu_ins.insert_dml
601: (p_rec => p_rec
602: ,p_effective_date => p_effective_date
603: ,p_datetrack_mode => l_datetrack_mode
606: );
607: --
608: -- Call the supporting post-insert operation
609: --
610: hr_utility.set_location('Entering:'||l_proc, 55);
611: ame_atu_ins.post_insert
612: (p_rec => p_rec
613: ,p_effective_date => p_effective_date
614: ,p_datetrack_mode => l_datetrack_mode
618: --
619: -- Call to raise any errors on multi-message list
620: hr_multi_message.end_validation_set;
621: --
622: hr_utility.set_location('Leaving:'||l_proc,10);
623: end ins;
624: --
625: -- ----------------------------------------------------------------------------
626: -- |---------------------------------< ins >----------------------------------|
643: l_rec ame_atu_shd.g_rec_type;
644: l_proc varchar2(72) := g_package||'ins';
645: --
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: --
649: -- Call conversion function to turn arguments into the
650: -- p_rec structure.
651: --
679: p_end_date := l_rec.end_date;
680: p_object_version_number := l_rec.object_version_number;
681: --
682: --
683: hr_utility.set_location(' Leaving:'||l_proc, 10);
684: End ins;
685: --
686: end ame_atu_ins;