[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.balance_type_id := p_balance_type_id;
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: hr_utility.set_location('Entering:'||l_proc, 5);
152: --
153: p_rec.balance_type_id := p_balance_type_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: hr_utility.set_location('Entering:'||l_proc||p_rec.balance_type_id||' : '||p_rec.balance_name||' : '||p_rec.reporting_name, 6);
201: pay_btt_rki.after_insert
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: begin
199: --
200: hr_utility.set_location('Entering:'||l_proc||p_rec.balance_type_id||' : '||p_rec.balance_name||' : '||p_rec.reporting_name, 6);
201: pay_btt_rki.after_insert
202: (p_balance_type_id => p_rec.balance_type_id
203: ,p_balance_name => p_rec.balance_name
204: ,p_reporting_name => p_rec.reporting_name
205: ,p_language => p_rec.language
206: ,p_source_lang => p_rec.source_lang
207: );
208: --
209: hr_utility.set_location(' Leaving:'||l_proc, 10);
210: exception
211: --
212: when hr_api.cannot_find_prog_unit then
213: --
216: ,p_hook_type => 'AI');
217: --
218: end;
219: --
220: hr_utility.set_location(' Leaving:'||l_proc, 15);
221: End post_insert;
222: --
223: -- ----------------------------------------------------------------------------
224: -- |---------------------------------< ins >----------------------------------|
230: --
231: l_proc varchar2(72) := g_package||'ins';
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: -- Call the supporting insert validate operations
237: --
238: pay_btt_bus.insert_validate
261: --
262: -- Call to raise any errors on multi-message list
263: hr_multi_message.end_validation_set;
264: --
265: hr_utility.set_location('Leaving:'||l_proc, 20);
266: end ins;
267: --
268: -- ----------------------------------------------------------------------------
269: -- |---------------------------------< ins >----------------------------------|
279: l_rec pay_btt_shd.g_rec_type;
280: l_proc varchar2(72) := g_package||'ins';
281: --
282: Begin
283: hr_utility.set_location('Entering:'||l_proc, 5);
284: --
285: -- Call conversion function to turn arguments into the
286: -- p_rec structure.
287: --
306: -- are specified as an OUT's we must set these values.
307: --
308: --
309: --
310: hr_utility.set_location(' Leaving:'||l_proc, 10);
311: End ins;
312: --
313: -- ----------------------------------------------------------------------------
314: -- |------------------------------< ins_tl >----------------------------------|
333: --
334: l_proc varchar2(72) := g_package || 'ins_tl';
335: --
336: Begin
337: hr_utility.set_location('Entering:'||l_proc,10);
338: --
339: -- Insert a row for the base language and every installed language.
340: --
341: for l_lang in csr_ins_langs loop
347: ,p_reporting_name => p_reporting_name
348: );
349: end loop;
350: --
351: hr_utility.set_location('Leaving:'||l_proc,20);
352: End ins_tl;
353: --
354: end pay_btt_ins;