[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_opm_ins.g_org_payment_method_id_i := p_org_payment_method_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_opm_ins.g_org_payment_method_id_i := p_org_payment_method_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: -- ----------------------------------------------------------------------------
32: -- |----------------------------< dt_insert_dml >-----------------------------|
100: l_last_updated_by pay_org_payment_methods_f.last_updated_by%TYPE;
101: l_last_update_login pay_org_payment_methods_f.last_update_login%TYPE;
102: --
103: Begin
104: hr_utility.set_location('Entering:'||l_proc, 5);
105: --
106: -- Get the object version number for the insert
107: --
108: p_rec.object_version_number :=
121: -- If the datetrack_mode is not INSERT then we must populate the WHO
122: -- columns with the 'old' creation values and 'new' updated values.
123: --
124: If (p_datetrack_mode <> hr_api.g_insert) then
125: hr_utility.set_location(l_proc, 10);
126: --
127: -- Select the 'old' created values
128: --
129: Open C_Sel1;
283: ,p_rec.exclude_manual_payment
284: );
285: --
286: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
287: hr_utility.set_location(' Leaving:'||l_proc, 15);
288: --
289: Exception
290: When hr_api.check_integrity_violated Then
291: -- A check constraint has been violated
315: --
316: l_proc varchar2(72) := g_package||'insert_dml';
317: --
318: Begin
319: hr_utility.set_location('Entering:'||l_proc, 5);
320: --
321: pay_opm_ins.dt_insert_dml
322: (p_rec => p_rec
323: ,p_effective_date => p_effective_date
325: ,p_validation_start_date => p_validation_start_date
326: ,p_validation_end_date => p_validation_end_date
327: );
328: --
329: hr_utility.set_location(' Leaving:'||l_proc, 10);
330: End insert_dml;
331: --
332: -- ----------------------------------------------------------------------------
333: -- |------------------------------< pre_insert >------------------------------|
387: l_proc varchar2(72) := g_package||'pre_insert';
388: l_exists varchar2(1);
389:
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: If (pay_opm_ins.g_org_payment_method_id_i is not null ) Then
394: --
395: -- Verify registered primary key values not already in use
432: ,p_source_table_name => 'PAY_ORG_PAYMENT_METHODS_F'
433: ,p_comment_text => p_rec.comments
434: );
435: End If;
436: hr_utility.set_location(' Leaving:'||l_proc, 10);
437: End pre_insert;
438: --
439: -- ----------------------------------------------------------------------------
440: -- |----------------------------< post_insert >-------------------------------|
478: --
479: l_proc varchar2(72) := g_package||'post_insert';
480: --
481: Begin
482: hr_utility.set_location('Entering:'||l_proc, 5);
483: begin
484: --
485: pay_opm_rki.after_insert
486: (p_effective_date
618: ,p_hook_type => 'AI');
619: --
620: end;
621: --
622: hr_utility.set_location(' Leaving:'||l_proc, 10);
623: End post_insert;
624: --
625: -- ----------------------------------------------------------------------------
626: -- |-------------------------------< ins_lck >--------------------------------|
670: l_validation_start_date date;
671: l_validation_end_date date;
672: --
673: Begin
674: hr_utility.set_location('Entering:'||l_proc, 5);
675: --
676: -- Validate the datetrack mode mode getting the validation start
677: -- and end dates for the specified datetrack operation.
678: --
691: --
692: p_validation_start_date := l_validation_start_date;
693: p_validation_end_date := l_validation_end_date;
694: --
695: hr_utility.set_location(' Leaving:'||l_proc, 10);
696: --
697: End ins_lck;
698: --
699: -- ----------------------------------------------------------------------------
709: l_validation_start_date date;
710: l_validation_end_date date;
711: --
712: Begin
713: hr_utility.set_location('Entering:'||l_proc, 5);
714: --
715: -- Call the lock operation
716: --
717: pay_opm_ins.ins_lck
761: ,p_validation_start_date => l_validation_start_date
762: ,p_validation_end_date => l_validation_end_date
763: );
764: --
765: hr_utility.set_location('Leaving:'||l_proc,10);
766: end ins;
767: --
768: -- ----------------------------------------------------------------------------
769: -- |---------------------------------< ins >----------------------------------|
834: l_rec pay_opm_shd.g_rec_type;
835: l_proc varchar2(72) := g_package||'ins';
836: --
837: Begin
838: hr_utility.set_location('Entering:'||l_proc, 5);
839: --
840: -- Call conversion function to turn arguments into the
841: -- p_rec structure.
842: --
919: p_effective_end_date := l_rec.effective_end_date;
920: p_object_version_number := l_rec.object_version_number;
921: p_comment_id := l_rec.comment_id;
922: --
923: hr_utility.set_location(' Leaving:'||l_proc, 10);
924: End ins;
925: --
926: end pay_opm_ins;