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: ben_agf_shd.g_api_dml := true; -- Set the api dml status
62: --
160: );
161: --
162: ben_agf_shd.g_api_dml := false; -- Unset the api dml status
163: --
164: hr_utility.set_location(' Leaving:'||l_proc, 10);
165: Exception
166: When hr_api.check_integrity_violated Then
167: -- A check constraint has been violated
168: ben_agf_shd.g_api_dml := false; -- Unset the api dml status
226: --
227: Cursor C_Sel1 is select ben_age_fctr_s.nextval from sys.dual;
228: --
229: Begin
230: hr_utility.set_location('Entering:'||l_proc, 5);
231: --
232: --
233: -- Select the next sequence number
234: --
235: Open C_Sel1;
236: Fetch C_Sel1 Into p_rec.age_fctr_id;
237: Close C_Sel1;
238: --
239: hr_utility.set_location(' Leaving:'||l_proc, 10);
240: End pre_insert;
241: --
242: -- ----------------------------------------------------------------------------
243: -- |-----------------------------< post_insert >------------------------------|
276: --
277: l_proc varchar2(72) := g_package||'post_insert';
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: --
283: -- Start of API User Hook for post_insert.
284: --
347: --
348: -- End of API User Hook for post_insert.
349: --
350: --
351: hr_utility.set_location(' Leaving:'||l_proc, 10);
352: End post_insert;
353: --
354: -- ----------------------------------------------------------------------------
355: -- |---------------------------------< ins >----------------------------------|
362: --
363: l_proc varchar2(72) := g_package||'ins';
364: --
365: Begin
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: -- Call the supporting insert validate operations
369: --
370: ben_agf_bus.insert_validate(p_rec
441: l_rec ben_agf_shd.g_rec_type;
442: l_proc varchar2(72) := g_package||'ins';
443: --
444: Begin
445: hr_utility.set_location('Entering:'||l_proc, 5);
446: --
447: -- Call conversion function to turn arguments into the
448: -- p_rec structure.
449: --
509: --
510: p_age_fctr_id := l_rec.age_fctr_id;
511: p_object_version_number := l_rec.object_version_number;
512: --
513: hr_utility.set_location(' Leaving:'||l_proc, 10);
514: End ins;
515: --
516: end ben_agf_ins;