[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: --
80: );
81: --
82: --
83: --
84: hr_utility.set_location(' Leaving:'||l_proc, 10);
85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
147: --
148: l_proc varchar2(72) := g_package||'pre_insert';
149: --
150: Begin
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: --
153: p_rec.user_table_id := p_user_table_id;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: --
153: p_rec.user_table_id := p_user_table_id;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: End pre_insert;
157: --
158: -- ----------------------------------------------------------------------------
159: -- |-----------------------------< post_insert >------------------------------|
193: --
194: l_proc varchar2(72) := g_package||'post_insert';
195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: begin
199: --
200: pay_ptt_rki.after_insert
201: (p_user_table_id
219: ,p_hook_type => 'AI');
220: --
221: end;
222: --
223: hr_utility.set_location(' Leaving:'||l_proc, 10);
224: End post_insert;
225: --
226: -- ----------------------------------------------------------------------------
227: -- |---------------------------------< ins >----------------------------------|
233: --
234: l_proc varchar2(72) := g_package||'ins';
235: --
236: Begin
237: hr_utility.set_location('Entering:'||l_proc, 5);
238: --
239: -- Call the supporting insert validate operations
240: --
241: pay_ptt_bus.insert_validate
262: --
263: -- Call to raise any errors on multi-message list
264: hr_multi_message.end_validation_set;
265: --
266: hr_utility.set_location('Leaving:'||l_proc, 20);
267: end ins;
268: --
269: -- ----------------------------------------------------------------------------
270: -- |---------------------------------< ins >----------------------------------|
280: l_rec pay_ptt_shd.g_rec_type;
281: l_proc varchar2(72) := g_package||'ins';
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: -- Call conversion function to turn arguments into the
287: -- p_rec structure.
288: --
307: -- are specified as an OUT's we must set these values.
308: --
309: --
310: --
311: hr_utility.set_location(' Leaving:'||l_proc, 10);
312: End ins;
313: --
314: -- ----------------------------------------------------------------------------
315: -- |------------------------------< ins_tl >----------------------------------|
334: --
335: l_proc varchar2(72) := g_package || 'ins_tl';
336: --
337: Begin
338: hr_utility.set_location('Entering:'||l_proc,10);
339: --
340: -- Insert a row for the base language and every installed language.
341: --
342: for l_lang in csr_ins_langs loop
348: ,p_user_row_title => p_user_row_title
349: );
350: end loop;
351: --
352: hr_utility.set_location('Leaving:'||l_proc,20);
353: End ins_tl;
354: --
355: end pay_ptt_ins;