[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.criteria_rate_defn_id := p_criteria_rate_defn_id;
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
149: hr_utility.set_location('Entering:'||l_proc, 5);
150: --
151: p_rec.criteria_rate_defn_id := p_criteria_rate_defn_id;
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 10);
154: End pre_insert;
155: --
156: -- ----------------------------------------------------------------------------
157: -- |-----------------------------< post_insert >------------------------------|
192: --
193: l_proc varchar2(72) := g_package||'post_insert';
194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: begin
198: --
199: pqh_crl_rki.after_insert
200: (p_effective_date => p_effective_date
217: ,p_hook_type => 'AI');
218: --
219: end;
220: --
221: hr_utility.set_location(' Leaving:'||l_proc, 10);
222: End post_insert;
223: --
224: -- ----------------------------------------------------------------------------
225: -- |---------------------------------< ins >----------------------------------|
232: --
233: l_proc varchar2(72) := g_package||'ins';
234: --
235: Begin
236: hr_utility.set_location('Entering:'||l_proc, 5);
237: --
238: -- Call the supporting insert validate operations
239: --
240: pqh_crl_bus.insert_validate
265: --
266: -- Call to raise any errors on multi-message list
267: hr_multi_message.end_validation_set;
268: --
269: hr_utility.set_location('Leaving:'||l_proc, 20);
270: end ins;
271: --
272: -- ----------------------------------------------------------------------------
273: -- |---------------------------------< ins >----------------------------------|
283: l_rec pqh_crl_shd.g_rec_type;
284: l_proc varchar2(72) := g_package||'ins';
285: --
286: Begin
287: hr_utility.set_location('Entering:'||l_proc, 5);
288: --
289: -- Call conversion function to turn arguments into the
290: -- p_rec structure.
291: --
310: -- are specified as an OUT's we must set these values.
311: --
312: --
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 10);
315: End ins;
316: --
317: -- ----------------------------------------------------------------------------
318: -- |------------------------------< ins_tl >----------------------------------|
337: --
338: l_proc varchar2(72) := g_package || 'ins_tl';
339: --
340: Begin
341: hr_utility.set_location('Entering:'||l_proc,10);
342: --
343: -- Insert a row for the base language and every installed language.
344: --
345: for l_lang in csr_ins_langs loop
351: ,p_name => p_name
352: );
353: end loop;
354: --
355: hr_utility.set_location('Leaving:'||l_proc,20);
356: End ins_tl;
357: --
358: end pqh_crl_ins;