[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: pqp_ert_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Insert the row into: pqp_exception_reports_tl
106: END IF;
107: --
108: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 10);
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
173: --
174: l_proc varchar2(72) := g_package||'pre_insert';
175: --
176: Begin
177: hr_utility.set_location('Entering:'||l_proc, 5);
178: --
179: p_rec.exception_report_id := p_exception_report_id;
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 10);
177: hr_utility.set_location('Entering:'||l_proc, 5);
178: --
179: p_rec.exception_report_id := p_exception_report_id;
180: --
181: hr_utility.set_location(' Leaving:'||l_proc, 10);
182: End pre_insert;
183: --
184: -- ----------------------------------------------------------------------------
185: -- |-----------------------------< post_insert >------------------------------|
219: --
220: l_proc varchar2(72) := g_package||'post_insert';
221: --
222: Begin
223: hr_utility.set_location('Entering:'||l_proc, 5);
224: begin
225: --
226: pqp_ert_rki.after_insert (
227: p_exception_report_id
243: ,p_hook_type => 'AI');
244: --
245: end;
246: --
247: hr_utility.set_location(' Leaving:'||l_proc, 10);
248: End post_insert;
249: --
250: -- ----------------------------------------------------------------------------
251: -- |---------------------------------< ins >----------------------------------|
257: --
258: l_proc varchar2(72) := g_package||'ins';
259: --
260: Begin
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: --
263: -- Call the supporting insert validate operations
264: --
265: pqp_ert_bus.insert_validate
282: pqp_ert_ins.post_insert
283: (p_rec
284: );
285: --
286: hr_utility.set_location('Leaving:'||l_proc, 20);
287: end ins;
288: --
289: -- ----------------------------------------------------------------------------
290: -- |---------------------------------< ins >----------------------------------|
299: l_rec pqp_ert_shd.g_rec_type;
300: l_proc varchar2(72) := g_package||'ins';
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: -- Call conversion function to turn arguments into the
306: -- p_rec structure.
307: --
324: -- As the primary key argument(s)
325: -- are specified as an OUT's we must set these values.
326: --
327: --
328: hr_utility.set_location(' Leaving:'||l_proc, 10);
329: End ins;
330: --
331: -- ----------------------------------------------------------------------------
332: -- |------------------------------< ins_tl >----------------------------------|
350: --
351: l_proc varchar2(72) := g_package || 'ins_tl';
352: --
353: Begin
354: hr_utility.set_location('Entering:'||l_proc,10);
355: --
356: -- Insert a row for the base language and every installed language.
357: --
358: for l_lang in csr_ins_langs loop
363: ,p_exception_report_name => p_exception_report_name
364: );
365: end loop;
366: --
367: hr_utility.set_location('Leaving:'||l_proc,20);
368: End ins_tl;
369: --
370: end pqp_ert_ins;