[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: --
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: --
149: --
150: l_proc varchar2(72) := g_package||'pre_insert';
151: --
152: Begin
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: p_rec.element_type_id := p_element_type_id;
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: p_rec.element_type_id := p_element_type_id;
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: End pre_insert;
159: --
160: -- ----------------------------------------------------------------------------
161: -- |-----------------------------< post_insert >------------------------------|
195: --
196: l_proc varchar2(72) := g_package||'post_insert';
197: --
198: Begin
199: hr_utility.set_location('Entering:'||l_proc, 5);
200: begin
201: --
202: pay_ett_rki.after_insert
203: (p_element_type_id
223: ,p_hook_type => 'AI');
224: --
225: end;
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
228: End post_insert;
229: --
230: -- ----------------------------------------------------------------------------
231: -- |---------------------------------< ins >----------------------------------|
237: --
238: l_proc varchar2(72) := g_package||'ins';
239: --
240: Begin
241: hr_utility.set_location('Entering:'||l_proc, 5);
242: --
243: -- Call the supporting insert validate operations
244: --
245: pay_ett_bus.insert_validate
269: --
270: -- Call to raise any errors on multi-message list
271: hr_multi_message.end_validation_set;
272: --
273: hr_utility.set_location('Leaving:'||l_proc, 20);
274: end ins;
275: --
276: -- ----------------------------------------------------------------------------
277: -- |---------------------------------< ins >----------------------------------|
288: l_rec pay_ett_shd.g_rec_type;
289: l_proc varchar2(72) := g_package||'ins';
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: -- Call conversion function to turn arguments into the
295: -- p_rec structure.
296: --
316: -- are specified as an OUT's we must set these values.
317: --
318: --
319: --
320: hr_utility.set_location(' Leaving:'||l_proc, 10);
321: End ins;
322: --
323: -- ----------------------------------------------------------------------------
324: -- |------------------------------< ins_tl >----------------------------------|
344: --
345: l_proc varchar2(72) := g_package || 'ins_tl';
346: --
347: Begin
348: hr_utility.set_location('Entering:'||l_proc,10);
349: --
350: -- Insert a row for the base language and every installed language.
351: --
352: for l_lang in csr_ins_langs loop
359: ,p_description => p_description
360: );
361: end loop;
362: --
363: hr_utility.set_location('Leaving:'||l_proc,20);
364: End ins_tl;
365: --
366: end pay_ett_ins;