[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_pbc_ins.g_balance_category_id_i := p_balance_category_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_pbc_ins.g_balance_category_id_i := p_balance_category_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_balance_categories_f.last_updated_by%TYPE;
102: l_last_update_login pay_balance_categories_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Get the object version number for the insert
108: --
109: p_rec.object_version_number :=
122: -- If the datetrack_mode is not INSERT then we must populate the WHO
123: -- columns with the 'old' creation values and 'new' updated values.
124: --
125: If (p_datetrack_mode <> hr_api.g_insert) then
126: hr_utility.set_location(l_proc, 10);
127: --
128: -- Select the 'old' created values
129: --
130: Open C_Sel1;
248: ,l_last_update_login
249: );
250: --
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 15);
253: --
254: Exception
255: When hr_api.check_integrity_violated Then
256: -- A check constraint has been violated
328: --
329: l_proc varchar2(72) := g_package||'insert_dml';
330: --
331: Begin
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: pay_pbc_ins.dt_insert_dml
335: (p_rec => p_rec
336: ,p_effective_date => p_effective_date
338: ,p_validation_start_date => p_validation_start_date
339: ,p_validation_end_date => p_validation_end_date
340: );
341: --
342: hr_utility.set_location(' Leaving:'||l_proc, 10);
343: End insert_dml;
344: --
345: -- ----------------------------------------------------------------------------
346: -- |------------------------------< pre_insert >------------------------------|
400: l_proc varchar2(72) := g_package||'pre_insert';
401: l_exists varchar2(1);
402: --
403: Begin
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: --
406: If (pay_pbc_ins.g_balance_category_id_i is not null) Then
407: --
408: -- Verify registered primary key values not already in use
437: Close C_Sel1;
438: End If;
439: --
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: -- insert ownerships if applicable
491: create_app_ownerships
591: ,p_hook_type => 'AI');
592: --
593: end;
594: --
595: hr_utility.set_location(' Leaving:'||l_proc, 10);
596: End post_insert;
597: --
598: -- ----------------------------------------------------------------------------
599: -- |-------------------------------< ins_lck >--------------------------------|
643: l_validation_start_date date;
644: l_validation_end_date date;
645: --
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);
648: --
649: -- Validate the datetrack mode mode getting the validation start
650: -- and end dates for the specified datetrack operation.
651: --
664: --
665: p_validation_start_date := l_validation_start_date;
666: p_validation_end_date := l_validation_end_date;
667: --
668: hr_utility.set_location(' Leaving:'||l_proc, 10);
669: --
670: End ins_lck;
671: --
672: -- ----------------------------------------------------------------------------
682: l_validation_start_date date;
683: l_validation_end_date date;
684: --
685: Begin
686: hr_utility.set_location('Entering:'||l_proc, 5);
687: --
688: -- Call the lock operation
689: --
690: pay_pbc_ins.ins_lck
740: --
741: -- Call to raise any errors on multi-message list
742: hr_multi_message.end_validation_set;
743: --
744: hr_utility.set_location('Leaving:'||l_proc,10);
745: end ins;
746: --
747: -- ----------------------------------------------------------------------------
748: -- |---------------------------------< ins >----------------------------------|
794: l_rec pay_pbc_shd.g_rec_type;
795: l_proc varchar2(72) := g_package||'ins';
796: --
797: Begin
798: hr_utility.set_location('Entering:'||l_proc, 5);
799: --
800: -- Call conversion function to turn arguments into the
801: -- p_rec structure.
802: --
860: p_effective_end_date := l_rec.effective_end_date;
861: p_object_version_number := l_rec.object_version_number;
862: --
863: --
864: hr_utility.set_location(' Leaving:'||l_proc, 10);
865: End ins;
866: --
867: end pay_pbc_ins;