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_sub_shd.g_api_dml := true; -- Set the api dml status
62: --
171: );
172: --
173: per_sub_shd.g_api_dml := false; -- Unset the api dml status
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: Exception
177: When hr_api.check_integrity_violated Then
178: -- A check constraint has been violated
179: per_sub_shd.g_api_dml := false; -- Unset the api dml status
237: --
238: Cursor C_Sel1 is select per_subjects_taken_s.nextval from sys.dual;
239: --
240: Begin
241: hr_utility.set_location('Entering:'||l_proc, 5);
242: --
243: --
244: -- Select the next sequence number
245: --
246: Open C_Sel1;
247: Fetch C_Sel1 Into p_rec.subjects_taken_id;
248: Close C_Sel1;
249: --
250: hr_utility.set_location(' Leaving:'||l_proc, 10);
251: End pre_insert;
252: --
253: -- ----------------------------------------------------------------------------
254: -- |-----------------------------< post_insert >------------------------------|
287: --
288: l_proc varchar2(72) := g_package||'post_insert';
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: -- Start of Row Handler User Hook for post_insert.
294: --
295: Begin
357: end;
358: --
359: -- End of Row Handler User Hook for post_insert.
360: --
361: hr_utility.set_location(' Leaving:'||l_proc, 10);
362: End post_insert;
363: --
364: -- ----------------------------------------------------------------------------
365: -- |---------------------------------< ins >----------------------------------|
373: --
374: l_proc varchar2(72) := g_package||'ins';
375: --
376: Begin
377: hr_utility.set_location('Entering:'||l_proc, 5);
378: --
379: -- Determine if the business process is to be validated.
380: --
381: If p_validate then
406: If p_validate then
407: Raise HR_Api.Validate_Enabled;
408: End If;
409: --
410: hr_utility.set_location(' Leaving:'||l_proc, 10);
411: Exception
412: When HR_Api.Validate_Enabled Then
413: --
414: -- As the Validate_Enabled exception has been raised
480: l_rec per_sub_shd.g_rec_type;
481: l_proc varchar2(72) := g_package||'ins';
482: --
483: Begin
484: hr_utility.set_location('Entering:'||l_proc, 5);
485: --
486: -- Call conversion function to turn arguments into the
487: -- p_rec structure.
488: --
552: --
553: p_subjects_taken_id := l_rec.subjects_taken_id;
554: p_object_version_number := l_rec.object_version_number;
555: --
556: hr_utility.set_location(' Leaving:'||l_proc, 10);
557: End ins;
558: --
559: end per_sub_ins;