[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_axu_ins.g_action_type_id_i := p_action_type_id;
29: ame_axu_ins.g_rule_type_i := p_rule_type;
30: --
27: --
28: ame_axu_ins.g_action_type_id_i := p_action_type_id;
29: ame_axu_ins.g_rule_type_i := p_rule_type;
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 :=
217: ,l_last_update_login
218: );
219: --
220: --
221: hr_utility.set_location(' Leaving:'||l_proc, 15);
222: --
223: Exception
224: When hr_api.check_integrity_violated Then
225: -- A check constraint has been violated
249: --
250: l_proc varchar2(72) := g_package||'insert_dml';
251: --
252: Begin
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: ame_axu_ins.dt_insert_dml
256: (p_rec => p_rec
257: ,p_effective_date => p_effective_date
259: ,p_validation_start_date => p_validation_start_date
260: ,p_validation_end_date => p_validation_end_date
261: );
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 10);
264: End insert_dml;
265: --
266: -- ----------------------------------------------------------------------------
267: -- |------------------------------< pre_insert >------------------------------|
323: l_proc varchar2(72) := g_package||'pre_insert';
324: l_exists varchar2(1);
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: If (ame_axu_ins.g_action_type_id_i is not null or
330: ame_axu_ins.g_rule_type_i is not null) Then
331: --
367: End If;
368: */
369: --
370: --
371: hr_utility.set_location(' Leaving:'||l_proc, 10);
372: End pre_insert;
373: --
374: -- ----------------------------------------------------------------------------
375: -- |----------------------------< post_insert >-------------------------------|
413: --
414: l_proc varchar2(72) := g_package||'post_insert';
415: --
416: Begin
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: begin
419: --
420: ame_axu_rki.after_insert
421: (p_effective_date
447: ,p_hook_type => 'AI');
448: --
449: end;
450: --
451: hr_utility.set_location(' Leaving:'||l_proc, 10);
452: End post_insert;
453: --
454: -- ----------------------------------------------------------------------------
455: -- |-------------------------------< ins_lck >--------------------------------|
499: l_validation_start_date date;
500: l_validation_end_date date;
501: --
502: Begin
503: hr_utility.set_location('Entering:'||l_proc, 5);
504: --
505: -- Validate the datetrack mode mode getting the validation start
506: -- and end dates for the specified datetrack operation.
507: --
513: -- MURTHY_CHANGES
514: p_validation_start_date := sysdate;
515: p_validation_end_date := ame_utility_pkg.endOfTime;
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: ame_axu_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 >----------------------------------|
609: l_rec ame_axu_shd.g_rec_type;
610: l_proc varchar2(72) := g_package||'ins';
611: --
612: Begin
613: hr_utility.set_location('Entering:'||l_proc, 5);
614: --
615: -- Call conversion function to turn arguments into the
616: -- p_rec structure.
617: --
644: p_end_date := l_rec.end_date;
645: p_object_version_number := l_rec.object_version_number;
646: --
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 10);
649: End ins;
650: --
651: end ame_axu_ins;