[Home] [Help]
22: --
23: l_proc varchar2(72) := g_package||'set_base_key_value';
24: --
25: Begin
26: hr_utility.set_location('Entering:'||l_proc, 10);
27: --
28: ame_gcf_ins.g_application_id_i := p_application_id;
29: ame_gcf_ins.g_approval_group_id_i := p_approval_group_id;
30: --
27: --
28: ame_gcf_ins.g_application_id_i := p_application_id;
29: ame_gcf_ins.g_approval_group_id_i := p_approval_group_id;
30: --
31: hr_utility.set_location(' Leaving:'||l_proc, 20);
32: End set_base_key_value;
33: --
34: --
35: -- ----------------------------------------------------------------------------
114: l_current_user_id integer;
115: l_temp_count integer;
116: --
117: Begin
118: hr_utility.set_location('Entering:'||l_proc, 5);
119: --
120: -- Set the effective start and end dates to the corresponding
121: -- validation start and end dates
122: --
127: -- If the datetrack_mode is not INSERT then we must populate the WHO
128: -- columns with the 'old' creation values and 'new' updated values.
129: --
130: If (p_datetrack_mode <> hr_api.g_insert) then
131: hr_utility.set_location(l_proc, 10);
132: --
133: -- Get the object version number for the insert
134: --
135: p_rec.object_version_number :=
220: ,l_last_update_login
221: );
222: --
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 15);
225: --
226: Exception
227: When hr_api.check_integrity_violated Then
228: -- A check constraint has been violated
252: --
253: l_proc varchar2(72) := g_package||'insert_dml';
254: --
255: Begin
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: ame_gcf_ins.dt_insert_dml
259: (p_rec => p_rec
260: ,p_effective_date => p_effective_date
262: ,p_validation_start_date => p_validation_start_date
263: ,p_validation_end_date => p_validation_end_date
264: );
265: --
266: hr_utility.set_location(' Leaving:'||l_proc, 10);
267: End insert_dml;
268: --
269: -- ---------------------------------------------------------------------------
270: -- |----------------------< generate_order_number >-------------------------------|
323: exception
324: when app_exception.application_exception then
325: if hr_multi_message.exception_add
326: (p_associated_column1 => 'ORDER_NUMBER') then
327: hr_utility.set_location(' Leaving:'|| l_proc, 50);
328: raise;
329: end if;
330: hr_utility.set_location(' Leaving:'|| l_proc, 60);
331: end generate_order_number;
326: (p_associated_column1 => 'ORDER_NUMBER') then
327: hr_utility.set_location(' Leaving:'|| l_proc, 50);
328: raise;
329: end if;
330: hr_utility.set_location(' Leaving:'|| l_proc, 60);
331: end generate_order_number;
332: --
333: -- ----------------------------------------------------------------------------
334: -- |------------------------------< pre_insert >------------------------------|
392: l_proc varchar2(72) := g_package||'pre_insert';
393: l_exists varchar2(1);
394: --
395: Begin
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: If (ame_gcf_ins.g_application_id_i is not null or
399: ame_gcf_ins.g_approval_group_id_i is not null) Then
400: --
440: -- Fetch C_Sel1 Into p_rec.application_id;
441: -- Close C_Sel1;
442: --
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 10);
445: End pre_insert;
446: --
447: -- ----------------------------------------------------------------------------
448: -- |----------------------------< post_insert >-------------------------------|
486: --
487: l_proc varchar2(72) := g_package||'post_insert';
488: --
489: Begin
490: hr_utility.set_location('Entering:'||l_proc, 5);
491: begin
492: --
493: ame_gcf_rki.after_insert
494: (p_effective_date
522: ,p_hook_type => 'AI');
523: --
524: end;
525: --
526: hr_utility.set_location(' Leaving:'||l_proc, 10);
527: End post_insert;
528: --
529: -- ----------------------------------------------------------------------------
530: -- |-------------------------------< ins_lck >--------------------------------|
593: and p_effective_date
594: between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date)
595: for update nowait;
596: Begin
597: hr_utility.set_location('Entering:'||l_proc, 5);
598: --
599: -- Validate the datetrack mode mode getting the validation start
600: -- and end dates for the specified datetrack operation.
601: --
617: open C_Sel1;
618: close C_Sel1;
619: open C_Sel2;
620: close C_Sel2;
621: hr_utility.set_location(' Leaving:'||l_proc, 10);
622: --
623: End ins_lck;
624: --
625: -- ----------------------------------------------------------------------------
635: l_validation_start_date date;
636: l_validation_end_date date;
637: --
638: Begin
639: hr_utility.set_location('Entering:'||l_proc, 5);
640: --
641: -- Call the lock operation
642: --
643: ame_gcf_ins.ins_lck
693: --
694: -- Call to raise any errors on multi-message list
695: hr_multi_message.end_validation_set;
696: --
697: hr_utility.set_location('Leaving:'||l_proc,10);
698: end ins;
699: --
700: -- ----------------------------------------------------------------------------
701: -- |---------------------------------< ins >----------------------------------|
714: l_rec ame_gcf_shd.g_rec_type;
715: l_proc varchar2(72) := g_package||'ins';
716: --
717: Begin
718: hr_utility.set_location('Entering:'||l_proc, 5);
719: --
720: -- Call conversion function to turn arguments into the
721: -- p_rec structure.
722: --
746: p_end_date := l_rec.end_date;
747: p_object_version_number := l_rec.object_version_number;
748: --
749: --
750: hr_utility.set_location(' Leaving:'||l_proc, 10);
751: End ins;
752: --
753: end ame_gcf_ins;