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_bmn_shd.g_api_dml := true; -- Set the api dml status
62: --
112: );
113: --
114: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 10);
117: Exception
118: When hr_api.check_integrity_violated Then
119: -- A check constraint has been violated
120: ben_bmn_shd.g_api_dml := false; -- Unset the api dml status
178: --
179: Cursor C_Sel1 is select ben_reporting_s.nextval from sys.dual;
180: --
181: Begin
182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: --
185: -- Select the next sequence number
186: --
187: Open C_Sel1;
188: Fetch C_Sel1 Into p_rec.reporting_id;
189: Close C_Sel1;
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
192: End pre_insert;
193: --
194: -- ----------------------------------------------------------------------------
195: -- |-----------------------------< post_insert >------------------------------|
227: --
228: l_proc varchar2(72) := g_package||'post_insert';
229: --
230: Begin
231: hr_utility.set_location('Entering:'||l_proc, 5);
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 10);
234: End post_insert;
235: --
229: --
230: Begin
231: hr_utility.set_location('Entering:'||l_proc, 5);
232: --
233: hr_utility.set_location(' Leaving:'||l_proc, 10);
234: End post_insert;
235: --
236: -- ----------------------------------------------------------------------------
237: -- |---------------------------------< ins >----------------------------------|
243: --
244: l_proc varchar2(72) := g_package||'ins';
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);
248: --
249: -- Call the supporting insert validate operations
250: --
251: ben_bmn_bus.insert_validate(p_rec);
295: l_rec ben_bmn_shd.g_rec_type;
296: l_proc varchar2(72) := g_package||'ins';
297: --
298: Begin
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: -- Call conversion function to turn arguments into the
302: -- p_rec structure.
303: --
338: --
339: p_reporting_id := l_rec.reporting_id;
340: p_object_version_number := l_rec.object_version_number;
341: --
342: hr_utility.set_location(' Leaving:'||l_proc, 10);
343: End ins;
344: --
345: end ben_bmn_ins;