[Home] [Help]
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_apu_ins.g_approver_type_id_i := p_approver_type_id;
29: ame_apu_ins.g_action_type_id_i := p_action_type_id;
30: --
27: --
28: ame_apu_ins.g_approver_type_id_i := p_approver_type_id;
29: ame_apu_ins.g_action_type_id_i := p_action_type_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --
34: --
35: -- ----------------------------------------------------------------------------
113: l_current_user_id integer;
114: l_temp_count integer;
115: --
116: Begin
117: hr_utility.set_location('Entering:'||l_proc, 5);
118: --
119: -- Set the effective start and end dates to the corresponding
120: -- validation start and end dates
121: --
126: -- If the datetrack_mode is not INSERT then we must populate the WHO
127: -- columns with the 'old' creation values and 'new' updated values.
128: --
129: If (p_datetrack_mode <> hr_api.g_insert) then
130: hr_utility.set_location(l_proc, 10);
131: --
132: -- Get the object version number for the insert
133: --
134: p_rec.object_version_number :=
215: ,l_last_update_login
216: );
217: --
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 15);
220: --
221: Exception
222: When hr_api.check_integrity_violated Then
223: -- A check constraint has been violated
247: --
248: l_proc varchar2(72) := g_package||'insert_dml';
249: --
250: Begin
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: ame_apu_ins.dt_insert_dml
254: (p_rec => p_rec
255: ,p_effective_date => p_effective_date
257: ,p_validation_start_date => p_validation_start_date
258: ,p_validation_end_date => p_validation_end_date
259: );
260: --
261: hr_utility.set_location(' Leaving:'||l_proc, 10);
262: End insert_dml;
263: --
264: -- ----------------------------------------------------------------------------
265: -- |------------------------------< pre_insert >------------------------------|
321: l_proc varchar2(72) := g_package||'pre_insert';
322: l_exists varchar2(1);
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: If (ame_apu_ins.g_approver_type_id_i is not null or
328: ame_apu_ins.g_action_type_id_i is not null) Then
329: --
365: End If;
366: */
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_apu_rki.after_insert
419: (p_effective_date
443: ,p_hook_type => 'AI');
444: --
445: end;
446: --
447: hr_utility.set_location(' Leaving:'||l_proc, 10);
448: End post_insert;
449: --
450: -- ----------------------------------------------------------------------------
451: -- |-------------------------------< ins_lck >--------------------------------|
503: l_validation_end_date date;
504: l_action_type_id number;
505: --
506: Begin
507: hr_utility.set_location('Entering:'||l_proc, 5);
508: --
509: -- Lock parent
510: open c_sel1;
511: fetch c_sel1 into l_action_type_id;
521: -- MURTHY_CHANGES
522: p_validation_start_date := sysdate;
523: p_validation_end_date := ame_utility_pkg.endOfTime;
524: --
525: hr_utility.set_location(' Leaving:'||l_proc, 10);
526: --
527: End ins_lck;
528: --
529: -- ----------------------------------------------------------------------------
539: l_validation_start_date date;
540: l_validation_end_date date;
541: --
542: Begin
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: -- Call the lock operation
546: --
547: ame_apu_ins.ins_lck
597: --
598: -- Call to raise any errors on multi-message list
599: hr_multi_message.end_validation_set;
600: --
601: hr_utility.set_location('Leaving:'||l_proc,10);
602: end ins;
603: --
604: -- ----------------------------------------------------------------------------
605: -- |---------------------------------< ins >----------------------------------|
616: l_rec ame_apu_shd.g_rec_type;
617: l_proc varchar2(72) := g_package||'ins';
618: --
619: Begin
620: hr_utility.set_location('Entering:'||l_proc, 5);
621: --
622: -- Call conversion function to turn arguments into the
623: -- p_rec structure.
624: --
650: p_end_date := l_rec.end_date;
651: p_object_version_number := l_rec.object_version_number;
652: --
653: --
654: hr_utility.set_location(' Leaving:'||l_proc, 10);
655: End ins;
656: --
657: end ame_apu_ins;