49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: -- Increment the object version
56: --
57: p_rec.object_version_number := p_rec.object_version_number + 1;
67: object_version_number = p_rec.object_version_number
68: where dflt_budget_set_id = p_rec.dflt_budget_set_id;
69: --
70: --
71: hr_utility.set_location(' Leaving:'||l_proc, 10);
72: --
73: Exception
74: When hr_api.check_integrity_violated Then
75: -- A check constraint has been violated
123: --
124: l_proc varchar2(72) := g_package||'pre_update';
125: --
126: Begin
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: End pre_update;
131: --
125: --
126: Begin
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130: End pre_update;
131: --
132: -- ----------------------------------------------------------------------------
133: -- |-----------------------------< post_update >------------------------------|
165: --
166: l_proc varchar2(72) := g_package||'post_update';
167: --
168: Begin
169: hr_utility.set_location('Entering:'||l_proc, 5);
170: --
171: --
172: -- Start of API User Hook for post_update.
173: --
196: --
197: -- End of API User Hook for post_update.
198: --
199: --
200: hr_utility.set_location(' Leaving:'||l_proc, 10);
201: End post_update;
202: --
203: -- ----------------------------------------------------------------------------
204: -- |-----------------------------< convert_defs >-----------------------------|
248: l_proc varchar2(72) := g_package||'convert_defs';
249: --
250: Begin
251: --
252: hr_utility.set_location('Entering:'||l_proc, 5);
253: --
254: -- We must now examine each argument value in the
255: -- p_rec plsql record structure
256: -- to see if a system default is being used. If a system default
265: pqh_dst_shd.g_old_rec.business_group_id;
266: End If;
267:
268: --
269: hr_utility.set_location(' Leaving:'||l_proc, 10);
270: --
271: End convert_defs;
272: --
273: -- ----------------------------------------------------------------------------
280: --
281: l_proc varchar2(72) := g_package||'upd';
282: --
283: Begin
284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: -- We must lock the row which we need to update.
287: --
288: pqh_dst_shd.lck
327: l_rec pqh_dst_shd.g_rec_type;
328: l_proc varchar2(72) := g_package||'upd';
329: --
330: Begin
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: -- Call conversion function to turn arguments into the
334: -- l_rec structure.
335: --
348: --
349: upd(l_rec);
350: p_object_version_number := l_rec.object_version_number;
351: --
352: hr_utility.set_location(' Leaving:'||l_proc, 10);
353: End upd;
354: --
355: end pqh_dst_upd;