[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_rmr_ins.g_rate_matrix_rate_id_i := p_rate_matrix_rate_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pqh_rmr_ins.g_rate_matrix_rate_id_i := p_rate_matrix_rate_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_rate_matrix_rates_f.last_updated_by%TYPE;
102: l_last_update_login pqh_rate_matrix_rates_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 :=
194: ,l_last_update_login
195: );
196: --
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 15);
199: --
200: Exception
201: When hr_api.check_integrity_violated Then
202: -- A check constraint has been violated
274: --
275: l_proc varchar2(72) := g_package||'insert_dml';
276: --
277: Begin
278: hr_utility.set_location('Entering:'||l_proc, 5);
279: --
280: pqh_rmr_ins.dt_insert_dml
281: (p_rec => p_rec
282: ,p_effective_date => p_effective_date
284: ,p_validation_start_date => p_validation_start_date
285: ,p_validation_end_date => p_validation_end_date
286: );
287: --
288: hr_utility.set_location(' Leaving:'||l_proc, 10);
289: End insert_dml;
290: --
291: -- ----------------------------------------------------------------------------
292: -- |------------------------------< pre_insert >------------------------------|
346: l_proc varchar2(72) := g_package||'pre_insert';
347: l_exists varchar2(1);
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: If (pqh_rmr_ins.g_rate_matrix_rate_id_i is not null) Then
353: --
354: -- Verify registered primary key values not already in use
383: Close C_Sel1;
384: End If;
385: --
386: --
387: hr_utility.set_location(' Leaving:'||l_proc, 10);
388: End pre_insert;
389: --
390: -- ----------------------------------------------------------------------------
391: -- |----------------------------< post_insert >-------------------------------|
429: --
430: l_proc varchar2(72) := g_package||'post_insert';
431: --
432: Begin
433: hr_utility.set_location('Entering:'||l_proc, 5);
434: begin
435: --
436: -- insert ownerships if applicable
437: create_app_ownerships
481: ,p_hook_type => 'AI');
482: --
483: end;
484: --
485: hr_utility.set_location(' Leaving:'||l_proc, 10);
486: End post_insert;
487: --
488: -- ----------------------------------------------------------------------------
489: -- |-------------------------------< ins_lck >--------------------------------|
533: l_validation_start_date date;
534: l_validation_end_date date;
535: --
536: Begin
537: hr_utility.set_location('Entering:'||l_proc, 5);
538: --
539: -- Validate the datetrack mode mode getting the validation start
540: -- and end dates for the specified datetrack operation.
541: --
554: --
555: p_validation_start_date := l_validation_start_date;
556: p_validation_end_date := l_validation_end_date;
557: --
558: hr_utility.set_location(' Leaving:'||l_proc, 10);
559: --
560: End ins_lck;
561: --
562: -- ----------------------------------------------------------------------------
572: l_validation_start_date date;
573: l_validation_end_date date;
574: --
575: Begin
576: hr_utility.set_location('Entering:'||l_proc, 5);
577: --
578: -- Call the lock operation
579: --
580: pqh_rmr_ins.ins_lck
630: --
631: -- Call to raise any errors on multi-message list
632: hr_multi_message.end_validation_set;
633: --
634: hr_utility.set_location('Leaving:'||l_proc,10);
635: end ins;
636: --
637: -- ----------------------------------------------------------------------------
638: -- |---------------------------------< ins >----------------------------------|
656: l_rec pqh_rmr_shd.g_rec_type;
657: l_proc varchar2(72) := g_package||'ins';
658: --
659: Begin
660: hr_utility.set_location('Entering:'||l_proc, 5);
661: --
662: -- Call conversion function to turn arguments into the
663: -- p_rec structure.
664: --
694: p_effective_end_date := l_rec.effective_end_date;
695: p_object_version_number := l_rec.object_version_number;
696: --
697: --
698: hr_utility.set_location(' Leaving:'||l_proc, 10);
699: End ins;
700: --
701: end pqh_rmr_ins;