[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: pay_rfi_ins.g_report_format_item_id_i := p_report_format_item_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_rfi_ins.g_report_format_item_id_i := p_report_format_item_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_items_f.last_updated_by%TYPE;
102: l_last_update_login pay_report_format_items_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 :=
192: ,l_last_update_login
193: );
194: --
195: pay_rfi_shd.g_api_dml := false; -- Unset the api dml status
196: hr_utility.set_location(' Leaving:'||l_proc, 15);
197: --
198: Exception
199: When hr_api.check_integrity_violated Then
200: -- A check constraint has been violated
224: --
225: l_proc varchar2(72) := g_package||'insert_dml';
226: --
227: Begin
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: --
230: pay_rfi_ins.dt_insert_dml
231: (p_rec => p_rec
232: ,p_effective_date => p_effective_date
234: ,p_validation_start_date => p_validation_start_date
235: ,p_validation_end_date => p_validation_end_date
236: );
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 10);
239: End insert_dml;
240: --
241: -- ----------------------------------------------------------------------------
242: -- |------------------------------< pre_insert >------------------------------|
296: l_proc varchar2(72) := g_package||'pre_insert';
297: l_exists varchar2(1);
298: --
299: Begin
300: hr_utility.set_location('Entering:'||l_proc, 5);
301: --
302: If (pay_rfi_ins.g_report_format_item_id_i is not null) Then
303: --
304: -- Verify registered primary key values not already in use
335: --
336: pay_rfi_bus.chk_report_format_item_id
337: ( p_report_format_item_id => p_rec.report_format_item_id );
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 10);
340: End pre_insert;
341: --
342: -- ----------------------------------------------------------------------------
343: -- |----------------------------< post_insert >-------------------------------|
381: --
382: l_proc varchar2(72) := g_package||'post_insert';
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: hr_utility.set_location(' Leaving:'||l_proc, 10);
388: End post_insert;
389: --
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: hr_utility.set_location(' Leaving:'||l_proc, 10);
388: End post_insert;
389: --
390: -- ----------------------------------------------------------------------------
391: -- |-------------------------------< ins_lck >--------------------------------|
435: l_validation_start_date date;
436: l_validation_end_date date;
437: --
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 5);
440: --
441: -- Validate the datetrack mode mode getting the validation start
442: -- and end dates for the specified datetrack operation.
443: --
459: --
460: p_validation_start_date := l_validation_start_date;
461: p_validation_end_date := l_validation_end_date;
462: --
463: hr_utility.set_location(' Leaving:'||l_proc, 10);
464: --
465: End ins_lck;
466: --
467: -- ----------------------------------------------------------------------------
477: l_validation_start_date date;
478: l_validation_end_date date;
479: --
480: Begin
481: hr_utility.set_location('Entering:'||l_proc, 5);
482: --
483: -- Call the lock operation
484: --
485: pay_rfi_ins.ins_lck
535: --
536: -- Call to raise any errors on multi-message list
537: hr_multi_message.end_validation_set;
538: --
539: hr_utility.set_location('Leaving:'||l_proc,10);
540: end ins;
541: --
542: -- ----------------------------------------------------------------------------
543: -- |---------------------------------< ins >----------------------------------|
561: l_proc varchar2(72) := g_package||'ins';
562: l_report_format_mapping_id pay_report_format_mappings_f.report_format_mapping_id%type;
563: --
564: Begin
565: hr_utility.set_location('Entering:'||l_proc, 5);
566: --
567: -- Call conversion function to turn arguments into the
568: -- p_rec structure.
569: --
605: p_effective_end_date := l_rec.effective_end_date;
606: p_object_version_number := l_rec.object_version_number;
607: --
608: --
609: hr_utility.set_location(' Leaving:'||l_proc, 10);
610: End ins;
611: --
612: end pay_rfi_ins;