[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: ame_apt_ins.g_approver_type_id_i := p_approver_type_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ame_apt_ins.g_approver_type_id_i := p_approver_type_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
108: l_current_user_id integer;
109: l_temp_count integer;
110: --
111: Begin
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: -- Set the effective start and end dates to the corresponding
115: -- validation start and end dates
116: --
121: -- If the datetrack_mode is not INSERT then we must populate the WHO
122: -- columns with the 'old' creation values and 'new' updated values.
123: --
124: If (p_datetrack_mode <> hr_api.g_insert) then
125: hr_utility.set_location(l_proc, 10);
126: --
127: -- Get the object version number for the insert
128: --
129: 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_apt_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 >------------------------------|
333: l_proc varchar2(72) := g_package||'pre_insert';
334: l_exists varchar2(1);
335: --
336: Begin
337: hr_utility.set_location('Entering:'||l_proc, 5);
338: --
339: If (ame_apt_ins.g_approver_type_id_i is not null) Then
340: --
341: -- Verify registered primary key values not already in use
369: Close C_Sel1;
370: End If;
371: --
372: --
373: hr_utility.set_location(' Leaving:'||l_proc, 10);
374: End pre_insert;
375: --
376: -- ----------------------------------------------------------------------------
377: -- |----------------------------< post_insert >-------------------------------|
415: --
416: l_proc varchar2(72) := g_package||'post_insert';
417: --
418: Begin
419: hr_utility.set_location('Entering:'||l_proc, 5);
420: begin
421: --
422: ame_apt_rki.after_insert
423: (p_effective_date => p_effective_date
448: ,p_hook_type => 'AI');
449: --
450: end;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 10);
453: End post_insert;
454: --
455: -- ----------------------------------------------------------------------------
456: -- |-------------------------------< ins_lck >--------------------------------|
500: l_validation_start_date date;
501: l_validation_end_date date;
502: --
503: Begin
504: hr_utility.set_location('Entering:'||l_proc, 5);
505: --
506: -- Validate the datetrack mode mode getting the validation start
507: -- and end dates for the specified datetrack operation.
508: --
511: --
512: p_validation_start_date := sysdate;
513: p_validation_end_date := ame_utility_pkg.endOfTime;
514: --
515: hr_utility.set_location(' Leaving:'||l_proc, 10);
516: --
517: End ins_lck;
518: --
519: -- ----------------------------------------------------------------------------
529: l_validation_start_date date;
530: l_validation_end_date date;
531: --
532: Begin
533: hr_utility.set_location('Entering:'||l_proc, 5);
534: --
535: -- Call the lock operation
536: --
537: ame_apt_ins.ins_lck
587: --
588: -- Call to raise any errors on multi-message list
589: hr_multi_message.end_validation_set;
590: --
591: hr_utility.set_location('Leaving:'||l_proc,10);
592: end ins;
593: --
594: -- ----------------------------------------------------------------------------
595: -- |---------------------------------< ins >----------------------------------|
617: l_rec ame_apt_shd.g_rec_type;
618: l_proc varchar2(72) := g_package||'ins';
619: --
620: Begin
621: hr_utility.set_location('Entering:'||l_proc, 5);
622: --
623: -- Call conversion function to turn arguments into the
624: -- p_rec structure.
625: --
659: p_end_date := l_rec.end_date;
660: p_object_version_number := l_rec.object_version_number;
661: --
662: --
663: hr_utility.set_location(' Leaving:'||l_proc, 10);
664: End ins;
665: --
666: end ame_apt_ins;