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;
83: object_version_number = p_rec.object_version_number
84: where budget_detail_id = p_rec.budget_detail_id;
85: --
86: --
87: hr_utility.set_location(' Leaving:'||l_proc, 10);
88: --
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
139: --
140: l_proc varchar2(72) := g_package||'pre_update';
141: --
142: Begin
143: hr_utility.set_location('Entering:'||l_proc, 5);
144: --
145: hr_utility.set_location(' Leaving:'||l_proc, 10);
146: End pre_update;
147: --
141: --
142: Begin
143: hr_utility.set_location('Entering:'||l_proc, 5);
144: --
145: hr_utility.set_location(' Leaving:'||l_proc, 10);
146: End pre_update;
147: --
148: -- ----------------------------------------------------------------------------
149: -- |-----------------------------< post_update >------------------------------|
181: --
182: l_proc varchar2(72) := g_package||'post_update';
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: --
188: -- Start of API User Hook for post_update.
189: --
244: --
245: -- End of API User Hook for post_update.
246: --
247: --
248: hr_utility.set_location(' Leaving:'||l_proc, 10);
249: End post_update;
250: --
251: -- ----------------------------------------------------------------------------
252: -- |-----------------------------< convert_defs >-----------------------------|
296: l_proc varchar2(72) := g_package||'convert_defs';
297: --
298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc, 5);
301: --
302: -- We must now examine each argument value in the
303: -- p_rec plsql record structure
304: -- to see if a system default is being used. If a system default
377: pqh_bdt_shd.g_old_rec.gl_status;
378: End If;
379:
380: --
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: --
383: End convert_defs;
384: --
385: -- ----------------------------------------------------------------------------
392: --
393: l_proc varchar2(72) := g_package||'upd';
394: --
395: Begin
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: -- We must lock the row which we need to update.
399: --
400: pqh_bdt_shd.lck
455: l_rec pqh_bdt_shd.g_rec_type;
456: l_proc varchar2(72) := g_package||'upd';
457: --
458: Begin
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: --
461: -- Call conversion function to turn arguments into the
462: -- l_rec structure.
463: --
492: --
493: upd(l_rec);
494: p_object_version_number := l_rec.object_version_number;
495: --
496: hr_utility.set_location(' Leaving:'||l_proc, 10);
497: End upd;
498: --
499: end pqh_bdt_upd;