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: hr_cau_shd.g_api_dml := true; -- Set the api dml status
62: --
82: );
83: --
84: hr_cau_shd.g_api_dml := false; -- Unset the api dml status
85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: Exception
88: When hr_api.check_integrity_violated Then
89: -- A check constraint has been violated
90: hr_cau_shd.g_api_dml := false; -- Unset the api dml status
148: --
149: Cursor C_Sel1 is select hr_calendar_usages_s.nextval from sys.dual;
150: --
151: Begin
152: hr_utility.set_location('Entering:'||l_proc, 5);
153: --
154: --
155: -- Select the next sequence number
156: --
157: Open C_Sel1;
158: Fetch C_Sel1 Into p_rec.calendar_usage_id;
159: Close C_Sel1;
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 10);
162: End pre_insert;
163: --
164: -- ----------------------------------------------------------------------------
165: -- |-----------------------------< post_insert >------------------------------|
197: --
198: l_proc varchar2(72) := g_package||'post_insert';
199: --
200: Begin
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: hr_utility.set_location(' Leaving:'||l_proc, 10);
204: End post_insert;
205: --
199: --
200: Begin
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: hr_utility.set_location(' Leaving:'||l_proc, 10);
204: End post_insert;
205: --
206: -- ----------------------------------------------------------------------------
207: -- |---------------------------------< ins >----------------------------------|
214: --
215: l_proc varchar2(72) := g_package||'ins';
216: --
217: Begin
218: hr_utility.set_location('Entering:'||l_proc, 5);
219: --
220: -- Determine if the business process is to be validated.
221: --
222: If p_validate then
247: If p_validate then
248: Raise HR_Api.Validate_Enabled;
249: End If;
250: --
251: hr_utility.set_location(' Leaving:'||l_proc, 10);
252: Exception
253: When HR_Api.Validate_Enabled Then
254: --
255: -- As the Validate_Enabled exception has been raised
276: l_rec hr_cau_shd.g_rec_type;
277: l_proc varchar2(72) := g_package||'ins';
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: -- Call conversion function to turn arguments into the
283: -- p_rec structure.
284: --
304: --
305: p_calendar_usage_id := l_rec.calendar_usage_id;
306: p_object_version_number := l_rec.object_version_number;
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 10);
309: End ins;
310: --
311: end hr_cau_ins;