[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.user_column_id := p_user_column_id;
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: hr_utility.set_location('Entering:'||l_proc, 5);
150: --
151: p_rec.user_column_id := p_user_column_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: pay_pct_rki.after_insert
199: (p_user_column_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: pay_pct_bus.insert_validate
258: --
259: -- Call to raise any errors on multi-message list
260: hr_multi_message.end_validation_set;
261: --
262: hr_utility.set_location('Leaving:'||l_proc, 20);
263: end ins;
264: --
265: -- ----------------------------------------------------------------------------
266: -- |---------------------------------< ins >----------------------------------|
275: l_rec pay_pct_shd.g_rec_type;
276: l_proc varchar2(72) := g_package||'ins';
277: --
278: Begin
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: -- Call conversion function to turn arguments into the
282: -- p_rec structure.
283: --
301: -- are specified as an OUT's we must set these values.
302: --
303: --
304: --
305: hr_utility.set_location(' Leaving:'||l_proc, 10);
306: End ins;
307: --
308: -- ----------------------------------------------------------------------------
309: -- |------------------------------< ins_tl >----------------------------------|
327: --
328: l_proc varchar2(72) := g_package || 'ins_tl';
329: --
330: Begin
331: hr_utility.set_location('Entering:'||l_proc,10);
332: --
333: -- Insert a row for the base language and every installed language.
334: --
335: for l_lang in csr_ins_langs loop
340: ,p_user_column_name => p_user_column_name
341: );
342: end loop;
343: --
344: hr_utility.set_location('Leaving:'||l_proc,20);
345: End ins_tl;
346: --
347: end pay_pct_ins;