[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_cfv_ins.g_application_id_i := p_application_id;
29: ame_cfv_ins.g_variable_name_i := p_variable_name;
30: --
27: --
28: ame_cfv_ins.g_application_id_i := p_application_id;
29: ame_cfv_ins.g_variable_name_i := p_variable_name;
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 :=
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_cfv_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 >------------------------------|
333: l_proc varchar2(72) := g_package||'pre_insert';
334: l_exists varchar2(1);
335: --
336: Begin
337: hr_utility.set_location('Entering:'||l_proc, 5);
338: --
339: If (ame_cfv_ins.g_application_id_i is not null or
340: ame_cfv_ins.g_variable_name_i is not null) Then
341: --
372: fetch csr_description into p_rec.description;
373: close csr_description;
374: --
375: --
376: hr_utility.set_location(' Leaving:'||l_proc, 10);
377: End pre_insert;
378: --
379: -- ----------------------------------------------------------------------------
380: -- |----------------------------< post_insert >-------------------------------|
418: --
419: l_proc varchar2(72) := g_package||'post_insert';
420: --
421: Begin
422: hr_utility.set_location('Entering:'||l_proc, 5);
423: begin
424: --
425: ame_cfv_rki.after_insert
426: (p_effective_date
456: ,p_hook_type => 'AI');
457: --
458: end;
459: --
460: hr_utility.set_location(' Leaving:'||l_proc, 10);
461: End post_insert;
462: --
463: -- ----------------------------------------------------------------------------
464: -- |-------------------------------< ins_lck >--------------------------------|
508: l_validation_start_date date;
509: l_validation_end_date date;
510: --
511: Begin
512: hr_utility.set_location('Entering:'||l_proc, 5);
513: --
514: -- Validate the datetrack mode mode getting the validation start
515: -- and end dates for the specified datetrack operation.
516: --
522: -- MURTHY_CHANGES
523: p_validation_start_date := sysdate;
524: p_validation_end_date := ame_utility_pkg.endOfTime;
525: --
526: hr_utility.set_location(' Leaving:'||l_proc, 10);
527: --
528: End ins_lck;
529: --
530: -- ----------------------------------------------------------------------------
540: l_validation_start_date date;
541: l_validation_end_date date;
542: --
543: Begin
544: hr_utility.set_location('Entering:'||l_proc, 5);
545: --
546: -- Call the lock operation
547: --
548: ame_cfv_ins.ins_lck
598: --
599: -- Call to raise any errors on multi-message list
600: hr_multi_message.end_validation_set;
601: --
602: hr_utility.set_location('Leaving:'||l_proc,10);
603: end ins;
604: --
605: -- ----------------------------------------------------------------------------
606: -- |---------------------------------< ins >----------------------------------|
619: l_rec ame_cfv_shd.g_rec_type;
620: l_proc varchar2(72) := g_package||'ins';
621: --
622: Begin
623: hr_utility.set_location('Entering:'||l_proc, 5);
624: --
625: -- Call conversion function to turn arguments into the
626: -- p_rec structure.
627: --
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_cfv_ins;