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;
109: where source_id = p_rec.source_id;
110: --
111: pay_pma_shd.g_api_dml := false; -- Unset the api dml status
112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 10);
114: --
115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
169: --
170: l_proc varchar2(72) := g_package||'pre_update';
171: --
172: Begin
173: hr_utility.set_location('Entering:'||l_proc, 5);
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: End pre_update;
177: --
171: --
172: Begin
173: hr_utility.set_location('Entering:'||l_proc, 5);
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: End pre_update;
177: --
178: -- ----------------------------------------------------------------------------
179: -- |-----------------------------< post_update >------------------------------|
211: --
212: l_proc varchar2(72) := g_package||'post_update';
213: --
214: Begin
215: hr_utility.set_location('Entering:'||l_proc, 5);
216: --
217: --
218: -- Start of API User Hook for post_update.
219: --
310: --
311: -- End of API User Hook for post_update.
312: --
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 10);
315: End post_update;
316: --
317: -- ----------------------------------------------------------------------------
318: -- |-----------------------------< convert_defs >-----------------------------|
362: l_proc varchar2(72) := g_package||'convert_defs';
363: --
364: Begin
365: --
366: hr_utility.set_location('Entering:'||l_proc, 5);
367: --
368: -- We must now examine each argument value in the
369: -- p_rec plsql record structure
370: -- to see if a system default is being used. If a system default
515: pay_pma_shd.g_old_rec.attribute30;
516: End If;
517:
518: --
519: hr_utility.set_location(' Leaving:'||l_proc, 10);
520: --
521: End convert_defs;
522: --
523: -- ----------------------------------------------------------------------------
530: --
531: l_proc varchar2(72) := g_package||'upd';
532: --
533: Begin
534: hr_utility.set_location('Entering:'||l_proc, 5);
535: --
536: -- We must lock the row which we need to update.
537: --
538: pay_pma_shd.lck
611: l_rec pay_pma_shd.g_rec_type;
612: l_proc varchar2(72) := g_package||'upd';
613: --
614: Begin
615: hr_utility.set_location('Entering:'||l_proc, 5);
616: --
617: -- Call conversion function to turn arguments into the
618: -- l_rec structure.
619: --
666: --
667: upd(l_rec);
668: p_object_version_number := l_rec.object_version_number;
669: --
670: hr_utility.set_location(' Leaving:'||l_proc, 10);
671: End upd;
672: --
673: end pay_pma_upd;