51: --
52: l_proc varchar2(72) := g_package||'insert_dml';
53: --
54: Begin
55: hr_utility.set_location('Entering:'||l_proc, 5);
56: p_rec.object_version_number := 1; -- Initialise the object version
57: --
58: --
59: -- Insert the row into: pay_shadow_formulas
81: p_rec.object_version_number
82: );
83: --
84: --
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pay_sf_shd.constraint_error
143: --
144: Cursor C_Sel1 is select pay_shadow_formulas_s.nextval from sys.dual;
145: --
146: Begin
147: hr_utility.set_location('Entering:'||l_proc, 5);
148: --
149: --
150: -- Select the next sequence number
151: --
152: Open C_Sel1;
153: Fetch C_Sel1 Into p_rec.formula_id;
154: Close C_Sel1;
155: --
156: hr_utility.set_location(' Leaving:'||l_proc, 10);
157: End pre_insert;
158: --
159: -- ----------------------------------------------------------------------------
160: -- |-----------------------------< post_insert >------------------------------|
192: --
193: l_proc varchar2(72) := g_package||'post_insert';
194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 10);
199: End post_insert;
200: --
194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: hr_utility.set_location(' Leaving:'||l_proc, 10);
199: End post_insert;
200: --
201: -- ----------------------------------------------------------------------------
202: -- |---------------------------------< ins >----------------------------------|
208: --
209: l_proc varchar2(72) := g_package||'ins';
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: -- Call the supporting insert validate operations
215: --
216: pay_sf_bus.insert_validate(p_effective_date, p_rec);
248: l_rec pay_sf_shd.g_rec_type;
249: l_proc varchar2(72) := g_package||'ins';
250: --
251: Begin
252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: -- Call conversion function to turn arguments into the
255: -- p_rec structure.
256: --
278: --
279: p_formula_id := l_rec.formula_id;
280: p_object_version_number := l_rec.object_version_number;
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 10);
283: End ins;
284: --
285: end pay_sf_ins;