[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: pqh_gin_ins.g_global_index_id_i := p_global_index_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pqh_gin_ins.g_global_index_id_i := p_global_index_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
101: l_last_updated_by pqh_fr_global_indices_f.last_updated_by%TYPE;
102: l_last_update_login pqh_fr_global_indices_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Set the effective start and end dates to the corresponding
108: -- validation start and end dates
109: --
113: -- If the datetrack_mode is not INSERT then we must populate the WHO
114: -- columns with the 'old' creation values and 'new' updated values.
115: --
116: If (p_datetrack_mode <> hr_api.g_insert) then
117: hr_utility.set_location(l_proc, 10);
118: --
119: -- Get the object version number for the insert
120: --
121: p_rec.object_version_number :=
190: ,l_last_update_login
191: );
192: --
193: --
194: hr_utility.set_location(' Leaving:'||l_proc, 15);
195: --
196: Exception
197: When hr_api.check_integrity_violated Then
198: -- A check constraint has been violated
222: --
223: l_proc varchar2(72) := g_package||'insert_dml';
224: --
225: Begin
226: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: pqh_gin_ins.dt_insert_dml
229: (p_rec => p_rec
230: ,p_effective_date => p_effective_date
232: ,p_validation_start_date => p_validation_start_date
233: ,p_validation_end_date => p_validation_end_date
234: );
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: End insert_dml;
238: --
239: -- ----------------------------------------------------------------------------
240: -- |------------------------------< pre_insert >------------------------------|
294: l_proc varchar2(72) := g_package||'pre_insert';
295: l_exists varchar2(1);
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: If (pqh_gin_ins.g_global_index_id_i is not null) Then
301: --
302: -- Verify registered primary key values not already in use
331: Close C_Sel1;
332: End If;
333: --
334: --
335: hr_utility.set_location(' Leaving:'||l_proc, 10);
336: End pre_insert;
337: --
338: -- ----------------------------------------------------------------------------
339: -- |----------------------------< post_insert >-------------------------------|
377: --
378: l_proc varchar2(72) := g_package||'post_insert';
379: --
380: Begin
381: hr_utility.set_location('Entering:'||l_proc, 5);
382: begin
383: --
384: pqh_gin_rki.after_insert
385: (p_effective_date
419: ,p_hook_type => 'AI');
420: --
421: end;
422: --
423: hr_utility.set_location(' Leaving:'||l_proc, 10);
424: End post_insert;
425: --
426: -- ----------------------------------------------------------------------------
427: -- |-------------------------------< ins_lck >--------------------------------|
471: l_validation_start_date date;
472: l_validation_end_date date;
473: --
474: Begin
475: hr_utility.set_location('Entering:'||l_proc, 5);
476: --
477: -- Validate the datetrack mode mode getting the validation start
478: -- and end dates for the specified datetrack operation.
479: --
492: --
493: p_validation_start_date := l_validation_start_date;
494: p_validation_end_date := l_validation_end_date;
495: --
496: hr_utility.set_location(' Leaving:'||l_proc, 10);
497: --
498: End ins_lck;
499: --
500: -- ----------------------------------------------------------------------------
510: l_validation_start_date date;
511: l_validation_end_date date;
512: --
513: Begin
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: -- Call the lock operation
517: --
518: pqh_gin_ins.ins_lck
568: --
569: -- Call to raise any errors on multi-message list
570: hr_multi_message.end_validation_set;
571: --
572: hr_utility.set_location('Leaving:'||l_proc,10);
573: end ins;
574: --
575: -- ----------------------------------------------------------------------------
576: -- |---------------------------------< ins >----------------------------------|
592: l_rec pqh_gin_shd.g_rec_type;
593: l_proc varchar2(72) := g_package||'ins';
594: --
595: Begin
596: hr_utility.set_location('Entering:'||l_proc, 5);
597: --
598: -- Call conversion function to turn arguments into the
599: -- p_rec structure.
600: --
629: p_effective_end_date := l_rec.effective_end_date;
630: p_object_version_number := l_rec.object_version_number;
631: --
632: --
633: hr_utility.set_location(' Leaving:'||l_proc, 10);
634: End ins;
635: --
636: end pqh_gin_ins;