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_bri_shd.g_api_dml := true; -- Set the api dml status
62: --
114: );
115: --
116: ben_bri_shd.g_api_dml := false; -- Unset the api dml status
117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: Exception
120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
122: ben_bri_shd.g_api_dml := false; -- Unset the api dml status
180: --
181: Cursor C_Sel1 is select ben_batch_rate_info_s.nextval from sys.dual;
182: --
183: Begin
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: --
187: -- Select the next sequence number
188: --
189: Open C_Sel1;
190: Fetch C_Sel1 Into p_rec.batch_rt_id;
191: Close C_Sel1;
192: --
193: hr_utility.set_location(' Leaving:'||l_proc, 10);
194: End pre_insert;
195: --
196: -- ----------------------------------------------------------------------------
197: -- |-----------------------------< post_insert >------------------------------|
230: --
231: l_proc varchar2(72) := g_package||'post_insert';
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: --
237: -- Start of API User Hook for post_insert.
238: --
276: --
277: -- End of API User Hook for post_insert.
278: --
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 10);
281: End post_insert;
282: --
283: -- ----------------------------------------------------------------------------
284: -- |---------------------------------< ins >----------------------------------|
291: --
292: l_proc varchar2(72) := g_package||'ins';
293: --
294: Begin
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: -- Call the supporting insert validate operations
298: --
299: ben_bri_bus.insert_validate(p_rec,p_effective_date);
346: l_rec ben_bri_shd.g_rec_type;
347: l_proc varchar2(72) := g_package||'ins';
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: -- Call conversion function to turn arguments into the
353: -- p_rec structure.
354: --
390: --
391: p_batch_rt_id := l_rec.batch_rt_id;
392: p_object_version_number := l_rec.object_version_number;
393: --
394: hr_utility.set_location(' Leaving:'||l_proc, 10);
395: End ins;
396: --
397: end ben_bri_ins;