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: pay_rfm_ins.g_report_format_mapping_id_i := p_report_format_mapping_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_rfm_ins.g_report_format_mapping_id_i := p_report_format_mapping_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 pay_report_format_mappings_f.last_updated_by%TYPE;
102: l_last_update_login pay_report_format_mappings_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 :=
210: ,l_last_update_login
211: );
212: --
213: pay_rfm_shd.g_api_dml := false; -- Unset the api dml status
214: hr_utility.set_location(' Leaving:'||l_proc, 15);
215: --
216: Exception
217: When hr_api.check_integrity_violated Then
218: -- A check constraint has been violated
290: --
291: l_proc varchar2(72) := g_package||'insert_dml';
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: pay_rfm_ins.dt_insert_dml
297: (p_rec => p_rec
298: ,p_effective_date => p_effective_date
300: ,p_validation_start_date => p_validation_start_date
301: ,p_validation_end_date => p_validation_end_date
302: );
303: --
304: hr_utility.set_location(' Leaving:'||l_proc, 10);
305: End insert_dml;
306: --
307: -- ----------------------------------------------------------------------------
308: -- |------------------------------< pre_insert >------------------------------|
362: l_proc varchar2(72) := g_package||'pre_insert';
363: l_exists varchar2(1);
364: --
365: Begin
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: If (pay_rfm_ins.g_report_format_mapping_id_i is not null) Then
369: --
370: -- Verify registered primary key values not already in use
401: --
402: pay_rfm_bus.chk_report_format_mapping_id
403: ( p_report_format_mapping_id => p_rec.report_format_mapping_id );
404: --
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: End pre_insert;
407: --
408: -- ----------------------------------------------------------------------------
409: -- |----------------------------< post_insert >-------------------------------|
447: --
448: l_proc varchar2(72) := g_package||'post_insert';
449: --
450: Begin
451: hr_utility.set_location('Entering:'||l_proc, 5);
452: --
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: End post_insert;
450: Begin
451: hr_utility.set_location('Entering:'||l_proc, 5);
452: --
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: End post_insert;
456: --
457: -- ----------------------------------------------------------------------------
458: -- |-------------------------------< ins_lck >--------------------------------|
502: l_validation_start_date date;
503: l_validation_end_date date;
504: --
505: Begin
506: hr_utility.set_location('Entering:'||l_proc, 5);
507: --
508: -- Validate the datetrack mode mode getting the validation start
509: -- and end dates for the specified datetrack operation.
510: --
523: --
524: p_validation_start_date := l_validation_start_date;
525: p_validation_end_date := l_validation_end_date;
526: --
527: hr_utility.set_location(' Leaving:'||l_proc, 10);
528: --
529: End ins_lck;
530: --
531: -- ----------------------------------------------------------------------------
541: l_validation_start_date date;
542: l_validation_end_date date;
543: --
544: Begin
545: hr_utility.set_location('Entering:'||l_proc, 5);
546: --
547: -- Call the lock operation
548: --
549: pay_rfm_ins.ins_lck
599: --
600: -- Call to raise any errors on multi-message list
601: hr_multi_message.end_validation_set;
602: --
603: hr_utility.set_location('Leaving:'||l_proc,10);
604: end ins;
605: --
606: -- ----------------------------------------------------------------------------
607: -- |---------------------------------< ins >----------------------------------|
633: l_rec pay_rfm_shd.g_rec_type;
634: l_proc varchar2(72) := g_package||'ins';
635: --
636: Begin
637: hr_utility.set_location('Entering:'||l_proc, 5);
638: --
639: -- Call conversion function to turn arguments into the
640: -- p_rec structure.
641: --
679: p_effective_end_date := l_rec.effective_end_date;
680: p_object_version_number := l_rec.object_version_number;
681: --
682: --
683: hr_utility.set_location(' Leaving:'||l_proc, 10);
684: End ins;
685: --
686: end pay_rfm_ins;