[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_prt_ins.g_run_type_id_i := p_run_type_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_prt_ins.g_run_type_id_i := p_run_type_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: -- ----------------------------------------------------------------------------
32: -- |----------------------------
99: l_last_updated_by pay_run_types_f.last_updated_by%TYPE;
100: l_last_update_login pay_run_types_f.last_update_login%TYPE;
101: --
102: Begin
103: hr_utility.set_location('Entering:'||l_proc, 5);
104: --
105: -- Get the object version number for the insert
106: --
107: p_rec.object_version_number :=
120: -- If the datetrack_mode is not INSERT then we must populate the WHO
121: -- columns with the 'old' creation values and 'new' updated values.
122: --
123: If (p_datetrack_mode <> hr_api.g_insert) then
124: hr_utility.set_location(l_proc, 10);
125: --
126: -- Select the 'old' created values
127: --
128: Open C_Sel1;
245: ,l_last_updated_by
246: ,l_last_update_login
247: );
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 15);
250: --
251: Exception
252: When hr_api.check_integrity_violated Then
253: -- A check constraint has been violated
330: --
331: l_proc varchar2(72) := g_package||'insert_dml';
332: --
333: Begin
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: pay_prt_ins.dt_insert_dml
337: (p_rec => p_rec
338: ,p_effective_date => p_effective_date
340: ,p_validation_start_date => p_validation_start_date
341: ,p_validation_end_date => p_validation_end_date
342: );
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 10);
345: End insert_dml;
346: --
347: -- ----------------------------------------------------------------------------
348: -- |------------------------------< pre_insert >------------------------------|
401: --
402: l_proc varchar2(72) := g_package||'pre_insert';
403: l_exists varchar2(1);
404: Begin
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: If (pay_prt_ins.g_run_type_id_i is not null) Then
408: --
409: -- Verify registered primary key values not already in use
437: Close C_Sel1;
438: --
439: end if;
440: --
441: hr_utility.set_location(' Leaving:'||l_proc, 10);
442: End pre_insert;
443: --
444: -- ----------------------------------------------------------------------------
445: -- |----------------------------< post_insert >-------------------------------|
483: --
484: l_proc varchar2(72) := g_package||'post_insert';
485: --
486: Begin
487: hr_utility.set_location('Entering:'||l_proc, 5);
488: begin
489: --
490: -- RET added call to create_app_ownerships
491: --
593: ,p_hook_type => 'AI');
594: --
595: end;
596: --
597: hr_utility.set_location(' Leaving:'||l_proc, 10);
598: End post_insert;
599: --
600: -- ----------------------------------------------------------------------------
601: -- |-------------------------------< ins_lck >--------------------------------|
645: l_validation_start_date date;
646: l_validation_end_date date;
647: --
648: Begin
649: hr_utility.set_location('Entering:'||l_proc, 5);
650: --
651: -- Validate the datetrack mode mode getting the validation start
652: -- and end dates for the specified datetrack operation.
653: --
666: --
667: p_validation_start_date := l_validation_start_date;
668: p_validation_end_date := l_validation_end_date;
669: --
670: hr_utility.set_location(' Leaving:'||l_proc, 10);
671: --
672: End ins_lck;
673: --
674: -- ----------------------------------------------------------------------------
684: l_validation_start_date date;
685: l_validation_end_date date;
686: --
687: Begin
688: hr_utility.set_location('Entering:'||l_proc, 5);
689: --
690: -- Call the lock operation
691: --
692: pay_prt_ins.ins_lck
736: ,p_validation_start_date => l_validation_start_date
737: ,p_validation_end_date => l_validation_end_date
738: );
739: --
740: hr_utility.set_location('Leaving:'||l_proc,10);
741: end ins;
742: --
743: -- ----------------------------------------------------------------------------
744: -- |---------------------------------< ins >----------------------------------|
791: l_rec pay_prt_shd.g_rec_type;
792: l_proc varchar2(72) := g_package||'ins';
793: --
794: Begin
795: hr_utility.set_location('Entering:'||l_proc, 5);
796: --
797: -- Call conversion function to turn arguments into the
798: -- p_rec structure.
799: --
858: p_effective_end_date := l_rec.effective_end_date;
859: p_object_version_number := l_rec.object_version_number;
860: --
861: --
862: hr_utility.set_location(' Leaving:'||l_proc, 10);
863: End ins;
864: --
865: end pay_prt_ins;