53: l_proc varchar2(72) := g_package||'delete_dml';
54: l_resDefId ota_resource_definitions.resource_definition_id%type;
55: --
56: Begin
57: hr_utility.set_location('Entering:'||l_proc, 5);
58: --
59: ota_tsr_shd.g_api_dml := true; -- Set the api dml status
60:
61: -- Bug. no. 3242410
85: End;
86: --
87: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: --
91: Exception
92: When hr_api.child_integrity_violated then
93: -- Child integrity has been violated
135: --
136: l_proc varchar2(72) := g_package||'pre_delete';
137: --
138: Begin
139: hr_utility.set_location('Entering:'||l_proc, 5);
140: --
141: hr_utility.set_location(' Leaving:'||l_proc, 10);
142: End pre_delete;
143: --
137: --
138: Begin
139: hr_utility.set_location('Entering:'||l_proc, 5);
140: --
141: hr_utility.set_location(' Leaving:'||l_proc, 10);
142: End pre_delete;
143: --
144: -- ----------------------------------------------------------------------------
145: -- |-----------------------------< post_delete >------------------------------|
177: --
178: l_proc varchar2(72) := g_package||'post_delete';
179: --
180: Begin
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: --
183: hr_utility.set_location(' Leaving:'||l_proc, 10);
184: End post_delete;
185: --
179: --
180: Begin
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: --
183: hr_utility.set_location(' Leaving:'||l_proc, 10);
184: End post_delete;
185: --
186: -- ----------------------------------------------------------------------------
187: -- |---------------------------------< del >----------------------------------|
194: --
195: l_proc varchar2(72) := g_package||'del';
196: --
197: Begin
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: -- Determine if the business process is to be validated.
201: --
202: If p_validate then
235: If p_validate then
236: Raise HR_Api.Validate_Enabled;
237: End If;
238: --
239: hr_utility.set_location(' Leaving:'||l_proc, 10);
240: Exception
241: When HR_Api.Validate_Enabled Then
242: --
243: -- As the Validate_Enabled exception has been raised
259: l_rec ota_tsr_shd.g_rec_type;
260: l_proc varchar2(72) := g_package||'del';
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: -- As the delete procedure accepts a plsql record structure we do need to
266: -- convert the arguments into the record structure.
267: -- We don't need to call the supplied conversion argument routine as we
275: -- business process
276: --
277: del(l_rec, p_validate);
278: --
279: hr_utility.set_location(' Leaving:'||l_proc, 10);
280: End del;
281: --
282: end ota_tsr_del;