[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_tab_pages_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_tab_page_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_ttp_rki.after_insert
205: (p_template_tab_page_id
221: ,p_hook_type => 'AI');
222: --
223: end;
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 10);
226: End post_insert;
227: --
228: -- ----------------------------------------------------------------------------
229: -- |---------------------------------< ins >----------------------------------|
234: --
235: l_proc varchar2(72) := g_package||'ins';
236: --
237: Begin
238: hr_utility.set_location('Entering:'||l_proc, 5);
239: --
240: -- Call the supporting insert validate operations
241: --
242: hr_ttp_bus.insert_validate
256: hr_ttp_ins.post_insert
257: (p_rec
258: );
259: --
260: hr_utility.set_location('Leaving:'||l_proc, 20);
261: end ins;
262: --
263: -- ----------------------------------------------------------------------------
264: -- |---------------------------------< ins >----------------------------------|
273: l_rec hr_ttp_shd.g_rec_type;
274: l_proc varchar2(72) := g_package||'ins';
275: --
276: Begin
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: -- Call conversion function to turn arguments into the
280: -- p_rec structure.
281: --
299: --
300: p_template_tab_page_id := l_rec.template_tab_page_id;
301: p_object_version_number := l_rec.object_version_number;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 10);
304: End ins;
305: --
306: end hr_ttp_ins;