[Home] [Help]
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: --
78: );
79: --
80: --
81: --
82: hr_utility.set_location(' Leaving:'||l_proc, 10);
83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: --
146: --
147: Cursor C_Sel1 is select hr_template_items_b_s.nextval from sys.dual;
148: --
149: Begin
150: hr_utility.set_location('Entering:'||l_proc, 5);
151: --
152: --
153: -- Select the next sequence number
154: --
155: Open C_Sel1;
156: Fetch C_Sel1 Into p_rec.template_item_id;
157: Close C_Sel1;
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: End pre_insert;
161: --
162: -- ----------------------------------------------------------------------------
163: -- |-----------------------------< post_insert >------------------------------|
197: --
198: l_proc varchar2(72) := g_package||'post_insert';
199: --
200: Begin
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: begin
203: --
204: hr_tim_bus.chk_no_flex_segment_comb
205: (p_form_template_id => p_rec.form_template_id
227: ,p_hook_type => 'AI');
228: --
229: end;
230: --
231: hr_utility.set_location(' Leaving:'||l_proc, 10);
232: End post_insert;
233: --
234: -- ----------------------------------------------------------------------------
235: -- |---------------------------------< ins >----------------------------------|
240: --
241: l_proc varchar2(72) := g_package||'ins';
242: --
243: Begin
244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --
246: -- Call the supporting insert validate operations
247: --
248: hr_tim_bus.insert_validate
262: hr_tim_ins.post_insert
263: (p_rec
264: );
265: --
266: hr_utility.set_location('Leaving:'||l_proc, 20);
267: end ins;
268: --
269: -- ----------------------------------------------------------------------------
270: -- |---------------------------------< ins >----------------------------------|
279: l_rec hr_tim_shd.g_rec_type;
280: l_proc varchar2(72) := g_package||'ins';
281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 5);
284: --
285: -- Call conversion function to turn arguments into the
286: -- p_rec structure.
287: --
305: --
306: p_template_item_id := l_rec.template_item_id;
307: p_object_version_number := l_rec.object_version_number;
308: --
309: hr_utility.set_location(' Leaving:'||l_proc, 10);
310: End ins;
311: --
312: end hr_tim_ins;