54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: --
62: -- Insert the row into: per_bf_payment_details
146: p_rec.bpd_attribute30
147: );
148: --
149: --
150: hr_utility.set_location(' Leaving:'||l_proc, 10);
151: Exception
152: When hr_api.check_integrity_violated Then
153: -- A check constraint has been violated
154: per_bpd_shd.constraint_error
208: --
209: Cursor C_Sel1 is select per_bf_payment_details_s.nextval from sys.dual;
210: --
211: Begin
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: Open C_Sel1;
215: Fetch C_Sel1 Into p_rec.payment_detail_id;
216: Close C_Sel1;
214: Open C_Sel1;
215: Fetch C_Sel1 Into p_rec.payment_detail_id;
216: Close C_Sel1;
217: --
218: hr_utility.set_location(' Leaving:'||l_proc, 10);
219: End pre_insert;
220: --
221: -- ----------------------------------------------------------------------------
222: -- |-----------------------------< post_insert >------------------------------|
255: --
256: l_proc varchar2(72) := g_package||'post_insert';
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: begin
261: --
262: per_bpd_rki.after_insert
263: (p_effective_date => p_effective_date,
312: ,p_hook_type => 'AI');
313: --
314: end;
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 10);
317: End post_insert;
318: --
319: -- ----------------------------------------------------------------------------
320: -- |---------------------------------< ins >----------------------------------|
327: --
328: l_proc varchar2(72) := g_package||'ins';
329: --
330: Begin
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: -- Call the supporting insert validate operations
334: --
335: per_bpd_bus.insert_validate(p_effective_date,
348: --
349: post_insert(p_effective_date,
350: p_rec);
351: --
352: hr_utility.set_location('Leaving:'||l_proc, 20);
353: end ins;
354: --
355: -- ----------------------------------------------------------------------------
356: -- |---------------------------------< ins >----------------------------------|
403: l_rec per_bpd_shd.g_rec_type;
404: l_proc varchar2(72) := g_package||'ins';
405: --
406: Begin
407: hr_utility.set_location('Entering:'||l_proc, 5);
408: --
409: -- Call conversion function to turn arguments into the
410: -- p_rec structure.
411: --
466: --
467: p_payment_detail_id := l_rec.payment_detail_id;
468: p_object_version_number := l_rec.object_version_number;
469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 10);
471: End ins;
472: --
473: end per_bpd_ins;