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: ota_ple_shd.g_api_dml := true; -- Set the api dml status
62: --
134: );
135: --
136: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
137: --
138: hr_utility.set_location(' Leaving:'||l_proc, 10);
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: ota_ple_shd.g_api_dml := false; -- Unset the api dml status
200: --
201: Cursor C_Sel1 is select ota_price_list_entries_s.nextval from sys.dual;
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: --
207: -- Select the next sequence number
208: --
209: Open C_Sel1;
210: Fetch C_Sel1 Into p_rec.price_list_entry_id;
211: Close C_Sel1;
212: --
213: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: End pre_insert;
215: --
216: -- ----------------------------------------------------------------------------
217: -- |-----------------------------< post_insert >------------------------------|
249: --
250: l_proc varchar2(72) := g_package||'post_insert';
251: --
252: Begin
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: hr_utility.set_location(' Leaving:'||l_proc, 10);
256: End post_insert;
257: --
251: --
252: Begin
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: hr_utility.set_location(' Leaving:'||l_proc, 10);
256: End post_insert;
257: --
258: -- ----------------------------------------------------------------------------
259: -- |---------------------------------< ins >----------------------------------|
266: --
267: l_proc varchar2(72) := g_package||'ins';
268: --
269: Begin
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: --
272: -- Determine if the business process is to be validated.
273: --
274: If p_validate then
299: If p_validate then
300: Raise HR_Api.Validate_Enabled;
301: End If;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 10);
304: Exception
305: When HR_Api.Validate_Enabled Then
306: --
307: -- As the Validate_Enabled exception has been raised
354: l_rec ota_ple_shd.g_rec_type;
355: l_proc varchar2(72) := g_package||'ins';
356: --
357: Begin
358: hr_utility.set_location('Entering:'||l_proc, 5);
359: --
360: -- Call conversion function to turn arguments into the
361: -- p_rec structure.
362: --
408: --
409: p_price_list_entry_id := l_rec.price_list_entry_id;
410: p_object_version_number := l_rec.object_version_number;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: End ins;
414: --
415: end ota_ple_ins;