[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_atr_ins.g_attribute_id_i := p_attribute_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ame_atr_ins.g_attribute_id_i := p_attribute_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 :=
222: ,l_last_update_login
223: );
224: --
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 15);
227: --
228: Exception
229: When hr_api.check_integrity_violated Then
230: -- A check constraint has been violated
254: --
255: l_proc varchar2(72) := g_package||'insert_dml';
256: --
257: Begin
258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: ame_atr_ins.dt_insert_dml
261: (p_rec => p_rec
262: ,p_effective_date => p_effective_date
264: ,p_validation_start_date => p_validation_start_date
265: ,p_validation_end_date => p_validation_end_date
266: );
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 10);
269: End insert_dml;
270: --
271: -- ----------------------------------------------------------------------------
272: -- |------------------------------< pre_insert >------------------------------|
328: l_proc varchar2(72) := g_package||'pre_insert';
329: l_exists varchar2(1);
330: --
331: Begin
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: If (ame_atr_ins.g_attribute_id_i is not null) Then
335: --
336: -- Verify registered primary key values not already in use
365: Close C_Sel1;
366: End If;
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_atr_rki.after_insert
419: (p_effective_date
455: ,p_hook_type => 'AI');
456: --
457: end;
458: --
459: hr_utility.set_location(' Leaving:'||l_proc, 10);
460: End post_insert;
461: --
462: -- ----------------------------------------------------------------------------
463: -- |-------------------------------< ins_lck >--------------------------------|
507: l_validation_start_date date;
508: l_validation_end_date date;
509: --
510: Begin
511: hr_utility.set_location('Entering:'||l_proc, 5);
512: --
513: -- Validate the datetrack mode mode getting the validation start
514: -- and end dates for the specified datetrack operation.
515: --
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_atr_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 >----------------------------------|
622: l_rec ame_atr_shd.g_rec_type;
623: l_proc varchar2(72) := g_package||'ins';
624: --
625: Begin
626: hr_utility.set_location('Entering:'||l_proc, 5);
627: --
628: -- Call conversion function to turn arguments into the
629: -- p_rec structure.
630: --
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_atr_ins;