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: p_rec.object_version_number := p_rec.object_version_number + 1;
75: where occupation_id = p_rec.occupation_id;
76: --
77: pay_pwo_shd.g_api_dml := false; -- Unset the api dml status
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 10);
80: --
81: Exception
82: When hr_api.check_integrity_violated Then
83: -- A check constraint has been violated
135: --
136: l_proc varchar2(72) := g_package||'pre_update';
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_update;
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_update;
143: --
144: -- ----------------------------------------------------------------------------
145: -- |-----------------------------< post_update >------------------------------|
177: --
178: l_proc varchar2(72) := g_package||'post_update';
179: --
180: Begin
181: hr_utility.set_location('Entering:'||l_proc, 5);
182: --
183: --
184: -- Start of API User Hook for post_update.
185: --
212: --
213: -- End of API User Hook for post_update.
214: --
215: --
216: hr_utility.set_location(' Leaving:'||l_proc, 10);
217: End post_update;
218: --
219: -- ----------------------------------------------------------------------------
220: -- |-----------------------------< convert_defs >-----------------------------|
264: l_proc varchar2(72) := g_package||'convert_defs';
265: --
266: Begin
267: --
268: hr_utility.set_location('Entering:'||l_proc, 5);
269: --
270: -- We must now examine each argument value in the
271: -- p_rec plsql record structure
272: -- to see if a system default is being used. If a system default
289: pay_pwo_shd.g_old_rec.comments;
290: End If;
291:
292: --
293: hr_utility.set_location(' Leaving:'||l_proc, 10);
294: --
295: End convert_defs;
296: --
297: -- ----------------------------------------------------------------------------
304: --
305: l_proc varchar2(72) := g_package||'upd';
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: --
310: -- We must lock the row which we need to update.
311: --
312: pay_pwo_shd.lck
351: l_rec pay_pwo_shd.g_rec_type;
352: l_proc varchar2(72) := g_package||'upd';
353: --
354: Begin
355: hr_utility.set_location('Entering:'||l_proc, 5);
356: --
357: -- Call conversion function to turn arguments into the
358: -- l_rec structure.
359: --
374: --
375: upd(l_rec);
376: p_object_version_number := l_rec.object_version_number;
377: --
378: hr_utility.set_location(' Leaving:'||l_proc, 10);
379: End upd;
380: --
381: end pay_pwo_upd;