[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_itc_ins.g_item_class_id_i := p_item_class_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ame_itc_ins.g_item_class_id_i := p_item_class_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 :=
206: ,l_last_update_login
207: );
208: --
209: --
210: hr_utility.set_location(' Leaving:'||l_proc, 15);
211: --
212: Exception
213: When hr_api.check_integrity_violated Then
214: -- A check constraint has been violated
238: --
239: l_proc varchar2(72) := g_package||'insert_dml';
240: --
241: Begin
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: ame_itc_ins.dt_insert_dml
245: (p_rec => p_rec
246: ,p_effective_date => p_effective_date
248: ,p_validation_start_date => p_validation_start_date
249: ,p_validation_end_date => p_validation_end_date
250: );
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 10);
253: End insert_dml;
254: --
255: -- ----------------------------------------------------------------------------
256: -- |------------------------------< pre_insert >------------------------------|
315: l_proc varchar2(72) := g_package||'pre_insert';
316: l_exists varchar2(1);
317: --
318: Begin
319: hr_utility.set_location('Entering:'||l_proc, 5);
320: --
321: If (ame_itc_ins.g_item_class_id_i is not null) Then
322: --
323: -- Verify registered primary key values not already in use
351: Close C_Sel1;
352: End If;
353: --
354: --
355: hr_utility.set_location(' Leaving:'||l_proc, 10);
356: End pre_insert;
357: --
358: -- ----------------------------------------------------------------------------
359: -- |----------------------------< post_insert >-------------------------------|
397: --
398: l_proc varchar2(72) := g_package||'post_insert';
399: --
400: Begin
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: begin
403: --
404: ame_itc_rki.after_insert
405: (p_effective_date => p_effective_date
421: ,p_hook_type => 'AI');
422: --
423: end;
424: --
425: hr_utility.set_location(' Leaving:'||l_proc, 10);
426: End post_insert;
427: --
428: -- ----------------------------------------------------------------------------
429: -- |-------------------------------< ins_lck >--------------------------------|
473: l_validation_start_date date;
474: l_validation_end_date date;
475: --
476: Begin
477: hr_utility.set_location('Entering:'||l_proc, 5);
478: --
479: -- Validate the datetrack mode mode getting the validation start
480: -- and end dates for the specified datetrack operation.
481: --
484: --
485: p_validation_start_date := sysdate;
486: p_validation_end_date := ame_utility_pkg.endOfTime;
487: --
488: hr_utility.set_location(' Leaving:'||l_proc, 10);
489: --
490: End ins_lck;
491: --
492: -- ----------------------------------------------------------------------------
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: -- Call the lock operation
509: --
510: ame_itc_ins.ins_lck
560: --
561: -- Call to raise any errors on multi-message list
562: hr_multi_message.end_validation_set;
563: --
564: hr_utility.set_location('Leaving:'||l_proc,10);
565: end ins;
566: --
567: -- ----------------------------------------------------------------------------
568: -- |---------------------------------< ins >----------------------------------|
579: l_rec ame_itc_shd.g_rec_type;
580: l_proc varchar2(72) := g_package||'ins';
581: --
582: Begin
583: hr_utility.set_location('Entering:'||l_proc, 5);
584: --
585: -- Call conversion function to turn arguments into the
586: -- p_rec structure.
587: --
610: p_end_date := l_rec.end_date;
611: p_object_version_number := l_rec.object_version_number;
612: --
613: --
614: hr_utility.set_location(' Leaving:'||l_proc, 10);
615: End ins;
616: --
617: end ame_itc_ins;