56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --
59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: --
64: --
82: );
83: --
84: --
85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: --
150: --
151: Cursor C_Sel1 is select pay_shadow_ele_type_usages_s.nextval from sys.dual;
152: --
153: Begin
154: hr_utility.set_location('Entering:'||l_proc, 5);
155: --
156: --
157: -- Select the next sequence number
158: --
159: Open C_Sel1;
160: Fetch C_Sel1 Into p_rec.element_type_usage_id;
161: Close C_Sel1;
162: --
163: hr_utility.set_location(' Leaving:'||l_proc, 10);
164: End pre_insert;
165: --
166: -- ----------------------------------------------------------------------------
167: -- |-----------------------------< post_insert >------------------------------|
202: --
203: l_proc varchar2(72) := g_package||'post_insert';
204: --
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: hr_utility.set_location(' Leaving:'||l_proc, 10);
209: End post_insert;
210: --
204: --
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: hr_utility.set_location(' Leaving:'||l_proc, 10);
209: End post_insert;
210: --
211: -- ----------------------------------------------------------------------------
212: -- |---------------------------------< ins >----------------------------------|
218: --
219: l_proc varchar2(72) := g_package||'ins';
220: --
221: Begin
222: hr_utility.set_location('Entering:'||l_proc, 5);
223: --
224: -- Call the supporting insert validate operations
225: --
226: pay_seu_bus.insert_validate
242: (p_effective_date
243: ,p_rec
244: );
245: --
246: hr_utility.set_location('Leaving:'||l_proc, 20);
247: end ins;
248: --
249: -- ----------------------------------------------------------------------------
250: -- |---------------------------------< ins >----------------------------------|
262: l_rec pay_seu_shd.g_rec_type;
263: l_proc varchar2(72) := g_package||'ins';
264: --
265: Begin
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: --
268: -- Call conversion function to turn arguments into the
269: -- p_rec structure.
270: --
291: --
292: p_element_type_usage_id := l_rec.element_type_usage_id;
293: p_object_version_number := l_rec.object_version_number;
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 10);
296: End ins;
297: --
298: end pay_seu_ins;