[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_gpi_ins.g_approval_group_item_id_i := p_approval_group_item_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: ame_gpi_ins.g_approval_group_item_id_i := p_approval_group_item_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_gpi_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_gpi_ins.g_approval_group_item_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_gpi_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 >--------------------------------|
510: and p_effective_date
511: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
512: for update nowait;
513: Begin
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: -- Validate the datetrack mode mode getting the validation start
517: -- and end dates for the specified datetrack operation.
518: --
530: );
531: open C_Sel1;
532: close C_Sel1;
533: --
534: hr_utility.set_location(' Leaving:'||l_proc, 10);
535: --
536: End ins_lck;
537: --
538: -- ----------------------------------------------------------------------------
548: l_validation_start_date date;
549: l_validation_end_date date;
550: --
551: Begin
552: hr_utility.set_location('Entering:'||l_proc, 5);
553: --
554: -- Call the lock operation
555: --
556: ame_gpi_ins.ins_lck
606: --
607: -- Call to raise any errors on multi-message list
608: hr_multi_message.end_validation_set;
609: --
610: hr_utility.set_location('Leaving:'||l_proc,10);
611: end ins;
612: --
613: -- ----------------------------------------------------------------------------
614: -- |---------------------------------< ins >----------------------------------|
629: l_rec ame_gpi_shd.g_rec_type;
630: l_proc varchar2(72) := g_package||'ins';
631: --
632: Begin
633: hr_utility.set_location('Entering:'||l_proc, 5);
634: --
635: -- Call conversion function to turn arguments into the
636: -- p_rec structure.
637: --
664: p_end_date := l_rec.end_date;
665: p_object_version_number := l_rec.object_version_number;
666: --
667: --
668: hr_utility.set_location(' Leaving:'||l_proc, 10);
669: End ins;
670: --
671: end ame_gpi_ins;