57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: -- Increment the object version
64: --
65: p_rec.object_version_number := p_rec.object_version_number + 1;
129: attribute20 = p_rec.attribute20
130: where collective_agreement_id = p_rec.collective_agreement_id;
131: --
132: --
133: hr_utility.set_location(' Leaving:'||l_proc, 10);
134: --
135: Exception
136: When hr_api.check_integrity_violated Then
137: -- A check constraint has been violated
185: --
186: l_proc varchar2(72) := g_package||'pre_update';
187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
192: End pre_update;
193: --
187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 10);
192: End pre_update;
193: --
194: -- ----------------------------------------------------------------------------
195: -- |-----------------------------< post_update >------------------------------|
227: --
228: l_proc varchar2(72) := g_package||'post_update';
229: --
230: Begin
231: hr_utility.set_location('Entering:'||l_proc, 5);
232: --
233: --
234: --
235: -- Start of API User Hook for post_update.
367: -- End of API User Hook for post_update.
368: --
369: --
370:
371: hr_utility.set_location(' Leaving:'||l_proc, 10);
372: End post_update;
373: --
374: -- ----------------------------------------------------------------------------
375: -- |-----------------------------< convert_defs >-----------------------------|
419: l_proc varchar2(72) := g_package||'convert_defs';
420: --
421: Begin
422: --
423: hr_utility.set_location('Entering:'||l_proc, 5);
424: --
425: -- We must now examine each argument value in the
426: -- p_rec plsql record structure
427: -- to see if a system default is being used. If a system default
653: p_rec.attribute20 :=
654: per_cag_shd.g_old_rec.attribute20;
655: End If;
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 10);
658: --
659: End convert_defs;
660: --
661: -- ----------------------------------------------------------------------------
668: --
669: l_proc varchar2(72) := g_package||'upd';
670: --
671: Begin
672: hr_utility.set_location('Entering:'||l_proc, 5);
673: --
674: -- We must lock the row which we need to update.
675: --
676: per_cag_shd.lck
769: l_rec per_cag_shd.g_rec_type;
770: l_proc varchar2(72) := g_package||'upd';
771: --
772: Begin
773: hr_utility.set_location('Entering:'||l_proc, 5);
774: --
775: -- Call conversion function to turn arguments into the
776: -- l_rec structure.
777: --
845: --
846: upd(l_rec);
847: p_object_version_number := l_rec.object_version_number;
848: --
849: hr_utility.set_location(' Leaving:'||l_proc, 10);
850: End upd;
851: --
852: end per_cag_upd;