[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_aty_ins.g_action_type_id_i := p_action_type_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ame_aty_ins.g_action_type_id_i := p_action_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 :=
221: ,l_last_update_login
222: );
223: --
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 15);
226: --
227: Exception
228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
253: --
254: l_proc varchar2(72) := g_package||'insert_dml';
255: --
256: Begin
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: ame_aty_ins.dt_insert_dml
260: (p_rec => p_rec
261: ,p_effective_date => p_effective_date
263: ,p_validation_start_date => p_validation_start_date
264: ,p_validation_end_date => p_validation_end_date
265: );
266: --
267: hr_utility.set_location(' Leaving:'||l_proc, 10);
268: End insert_dml;
269: --
270: -- ----------------------------------------------------------------------------
271: -- |------------------------------< pre_insert >------------------------------|
325: l_proc varchar2(72) := g_package||'pre_insert';
326: l_exists varchar2(1);
327: --
328: Begin
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: --
331: If (ame_aty_ins.g_action_type_id_i is not null) Then
332: --
333: -- Verify registered primary key values not already in use
362: Close C_Sel1;
363: End If;
364: --
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: End pre_insert;
368: --
369: -- ----------------------------------------------------------------------------
370: -- |----------------------------< post_insert >-------------------------------|
408: --
409: l_proc varchar2(72) := g_package||'post_insert';
410: --
411: Begin
412: hr_utility.set_location('Entering:'||l_proc, 5);
413: begin
414: --
415: ame_aty_rki.after_insert
416: (p_effective_date
450: ,p_hook_type => 'AI');
451: --
452: end;
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: End post_insert;
456: --
457: -- ----------------------------------------------------------------------------
458: -- |-------------------------------< ins_lck >--------------------------------|
502: l_validation_start_date date;
503: l_validation_end_date date;
504: --
505: Begin
506: hr_utility.set_location('Entering:'||l_proc, 5);
507: --
508: -- Validate the datetrack mode mode getting the validation start
509: -- and end dates for the specified datetrack operation.
510: --
516: -- MURTHY_CHANGES
517: p_validation_start_date := sysdate;
518: p_validation_end_date := ame_utility_pkg.endOfTime;
519: --
520: hr_utility.set_location(' Leaving:'||l_proc, 10);
521: --
522: End ins_lck;
523: --
524: -- ----------------------------------------------------------------------------
534: l_validation_start_date date;
535: l_validation_end_date date;
536: --
537: Begin
538: hr_utility.set_location('Entering:'||l_proc, 5);
539: --
540: -- Call the lock operation
541: --
542: ame_aty_ins.ins_lck
592: --
593: -- Call to raise any errors on multi-message list
594: hr_multi_message.end_validation_set;
595: --
596: hr_utility.set_location('Leaving:'||l_proc,10);
597: end ins;
598: --
599: -- ----------------------------------------------------------------------------
600: -- |---------------------------------< ins >----------------------------------|
616: l_rec ame_aty_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: --
652: p_end_date := l_rec.end_date;
653: p_object_version_number := l_rec.object_version_number;
654: --
655: --
656: hr_utility.set_location(' Leaving:'||l_proc, 10);
657: End ins;
658: --
659: end ame_aty_ins;