[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: --
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: --
145: --
146: l_proc varchar2(72) := g_package||'pre_insert';
147: --
148: Begin
149: hr_utility.set_location('Entering:'||l_proc, 5);
150: --
151: p_rec.position_id := p_position_id;
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: hr_utility.set_location('Entering:'||l_proc, 5);
150: --
151: p_rec.position_id := p_position_id;
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
154: End pre_insert;
155: --
156: -- ----------------------------------------------------------------------------
157: -- |-----------------------------< post_insert >------------------------------|
191: --
192: l_proc varchar2(72) := g_package||'post_insert';
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: begin
197: --
198: hr_pft_rki.after_insert
199: (p_position_id
215: ,p_hook_type => 'AI');
216: --
217: end;
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 10);
220: End post_insert;
221: --
222: -- ----------------------------------------------------------------------------
223: -- |---------------------------------< ins >----------------------------------|
229: --
230: l_proc varchar2(72) := g_package||'ins';
231: --
232: Begin
233: hr_utility.set_location('Entering:'||l_proc, 5);
234: --
235: -- Call the supporting insert validate operations
236: --
237: hr_pft_bus.insert_validate
260: --
261: -- Call to raise any errors on multi-message list
262: hr_multi_message.end_validation_set;
263: --
264: hr_utility.set_location('Leaving:'||l_proc, 20);
265: end ins;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |---------------------------------< ins >----------------------------------|
277: l_rec hr_pft_shd.g_rec_type;
278: l_proc varchar2(72) := g_package||'ins';
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282: --
283: -- Call conversion function to turn arguments into the
284: -- p_rec structure.
285: --
303: -- are specified as an OUT's we must set these values.
304: --
305: --
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 10);
308: End ins;
309: --
310: -- ----------------------------------------------------------------------------
311: -- |------------------------------< ins_tl >----------------------------------|
329: --
330: l_proc varchar2(72) := g_package || 'ins_tl';
331: --
332: Begin
333: hr_utility.set_location('Entering:'||l_proc,10);
334: --
335: -- Insert a row for the base language and every installed language.
336: --
337: for l_lang in csr_ins_langs loop
346: hr_pft_upd.upd_key_flex_meanings( p_position_id
347: , p_position_definition_id
348: );
349: --
350: hr_utility.set_location('Leaving:'||l_proc,20);
351: End ins_tl;
352: --
353: end hr_pft_ins;