55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
59: hr_utility.set_location('Entering:'||l_proc, 5);
60: --
61: -- Increment the object version
62: --
63: --
91: where assessment_id = p_rec.assessment_id;
92: --
93: per_za_ass_shd.g_api_dml := false; -- Unset the api dml status
94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 10);
96: --
97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
151: --
152: l_proc varchar2(72) := g_package||'pre_update';
153: --
154: Begin
155: hr_utility.set_location('Entering:'||l_proc, 5);
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: End pre_update;
159: --
153: --
154: Begin
155: hr_utility.set_location('Entering:'||l_proc, 5);
156: --
157: hr_utility.set_location(' Leaving:'||l_proc, 10);
158: End pre_update;
159: --
160: -- ----------------------------------------------------------------------------
161: -- |-----------------------------< post_update >------------------------------|
193: --
194: l_proc varchar2(72) := g_package||'post_update';
195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: End post_update;
201: -- ----------------------------------------------------------------------------
195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: End post_update;
201: -- ----------------------------------------------------------------------------
202: -- |---------------------------------< upd >----------------------------------|
203: -- ----------------------------------------------------------------------------
209: --
210: l_proc varchar2(72) := g_package||'upd';
211: --
212: Begin
213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: -- Determine if the business process is to be validated.
216: --
217: If p_validate then
255: If p_validate then
256: Raise HR_Api.Validate_Enabled;
257: End If;
258: --
259: hr_utility.set_location(' Leaving:'||l_proc, 10);
260: Exception
261: When HR_Api.Validate_Enabled Then
262: --
263: -- As the Validate_Enabled exception has been raised
298: l_rec per_za_ass_shd.g_za_rec_type;
299: l_proc varchar2(72) := g_package||'upd';
300: --
301: Begin
302: hr_utility.set_location('Entering:'||l_proc, 5);
303: --
304: -- Call conversion function to turn arguments into the
305: -- l_rec structure.
306: --
335: -- business process.
336: --
337: upd(l_rec, p_validate);
338: --
339: hr_utility.set_location(' Leaving:'||l_proc, 10);
340: End upd;
341: --
342: end per_za_ass_upd;