59: --
60: Begin
61: l_proc := g_package||'update_dml';
62: --
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: --
65: -- Increment the object version
66: p_rec.object_version_number := p_rec.object_version_number + 1;
67: --
85: where module_id = p_rec.module_id;
86: --
87: pay_amo_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.check_integrity_violated Then
93: -- A check constraint has been violated
149: --
150: Begin
151: l_proc := g_package||'pre_update';
152: --
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: End pre_update;
157: --
151: l_proc := g_package||'pre_update';
152: --
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: End pre_update;
157: --
158: -- ----------------------------------------------------------------------------
159: -- |-----------------------------< post_update >------------------------------|
195: --
196: Begin
197: l_proc := g_package||'post_update';
198: --
199: hr_utility.set_location('Entering:'||l_proc, 5);
200: --
201: hr_utility.set_location(' Leaving:'||l_proc, 10);
202: End post_update;
203: --
197: l_proc := g_package||'post_update';
198: --
199: hr_utility.set_location('Entering:'||l_proc, 5);
200: --
201: hr_utility.set_location(' Leaving:'||l_proc, 10);
202: End post_update;
203: --
204: -- ----------------------------------------------------------------------------
205: -- |-----------------------------< convert_defs >-----------------------------|
305: --
306: Begin
307: l_proc := g_package||'upd';
308: --
309: hr_utility.set_location('Entering:'||l_proc, 5);
310: --
311: -- We must lock the row which we need to update.
312: --
313: pay_amo_shd.lck
368: l_proc varchar2(72);
369: --
370: Begin
371: l_proc := g_package||'upd';
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: -- Call conversion function to turn arguments into the
375: -- l_rec structure.
376: --
397: (l_rec
398: );
399: p_object_version_number := l_rec.object_version_number;
400: --
401: hr_utility.set_location(' Leaving:'||l_proc, 10);
402: End upd;
403: --
404: begin
405: g_package := ' pay_amo_upd.'; -- Global package name