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: per_za_eqt_shd.g_api_dml := true; -- Set the api dml status
62: --
125: p_rec.nqf_qualification_type);
126: --
127: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: per_za_eqt_shd.g_api_dml := false; -- Unset the api dml status
193: select per_qualification_types_s.nextval
194: from sys.dual;
195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: open c1;
200: --
201: fetch c1 into p_rec.qualification_type_id;
201: fetch c1 into p_rec.qualification_type_id;
202: --
203: close c1;
204: --
205: hr_utility.set_location(' Leaving:'||l_proc, 10);
206: End pre_insert;
207: --
208: -- ----------------------------------------------------------------------------
209: -- |-----------------------------< post_insert >------------------------------|
241: --
242: l_proc varchar2(72) := g_package||'post_insert';
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: hr_utility.set_location(' Leaving:'||l_proc, 10);
248: End post_insert;
249: --
243: --
244: Begin
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: hr_utility.set_location(' Leaving:'||l_proc, 10);
248: End post_insert;
249: --
250: -- ----------------------------------------------------------------------------
251: -- |---------------------------------< ins >----------------------------------|
259: --
260: l_proc varchar2(72) := g_package||'ins';
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: -- Determine if the business process is to be validated.
266: --
267: If p_validate then
292: If p_validate then
293: Raise HR_Api.Validate_Enabled;
294: End If;
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 10);
297: Exception
298: When HR_Api.Validate_Enabled Then
299: --
300: -- As the Validate_Enabled exception has been raised
342: l_rec per_za_eqt_shd.g_rec_type;
343: l_proc varchar2(72) := g_package||'ins';
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- Call conversion function to turn arguments into the
349: -- p_rec structure.
350: --
390: --
391: p_qualification_type_id := l_rec.qualification_type_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 per_za_eqt_ins;