[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_aca_ins.g_application_id_i := p_application_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ame_aca_ins.g_application_id_i := p_application_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
109: l_current_user_id integer;
110: l_temp_count integer;
111: --
112: Begin
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: --
115: -- Set the effective start and end dates to the corresponding
116: -- validation start and end dates
117: --
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 :=
218: ,l_last_update_login
219: );
220: --
221: --
222: hr_utility.set_location(' Leaving:'||l_proc, 15);
223: --
224: Exception
225: When hr_api.check_integrity_violated Then
226: -- A check constraint has been violated
250: --
251: l_proc varchar2(72) := g_package||'insert_dml';
252: --
253: Begin
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: ame_aca_ins.dt_insert_dml
257: (p_rec => p_rec
258: ,p_effective_date => p_effective_date
260: ,p_validation_start_date => p_validation_start_date
261: ,p_validation_end_date => p_validation_end_date
262: );
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 10);
265: End insert_dml;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |------------------------------< pre_insert >------------------------------|
324: l_proc varchar2(72) := g_package||'pre_insert';
325: l_exists varchar2(1);
326: --
327: Begin
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: --
330: If (ame_aca_ins.g_application_id_i is not null) Then
331: --
332: -- Verify registered primary key values not already in use
361: Close C_Sel1;
362: End If;
363: --
364: --
365: hr_utility.set_location(' Leaving:'||l_proc, 10);
366: End pre_insert;
367: --
368: -- ----------------------------------------------------------------------------
369: -- |----------------------------< post_insert >-------------------------------|
407: --
408: l_proc varchar2(72) := g_package||'post_insert';
409: --
410: Begin
411: hr_utility.set_location('Entering:'||l_proc, 5);
412: begin
413: --
414: ame_aca_rki.after_insert
415: (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_aca_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 >----------------------------------|
612: l_rec ame_aca_shd.g_rec_type;
613: l_proc varchar2(72) := g_package||'ins';
614: --
615: Begin
616: hr_utility.set_location('Entering:'||l_proc, 5);
617: --
618: -- Call conversion function to turn arguments into the
619: -- p_rec structure.
620: --
647: p_end_date := l_rec.end_date;
648: p_object_version_number := l_rec.object_version_number;
649: --
650: --
651: hr_utility.set_location(' Leaving:'||l_proc, 10);
652: End ins;
653: --
654: end ame_aca_ins;