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;
93: propagation_method = p_rec.propagation_method
94: where worksheet_detail_id = p_rec.worksheet_detail_id;
95: --
96: --
97: hr_utility.set_location(' Leaving:'||l_proc, 10);
98: --
99: Exception
100: When hr_api.check_integrity_violated Then
101: -- A check constraint has been violated
149: --
150: l_proc varchar2(72) := g_package||'pre_update';
151: --
152: Begin
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: End pre_update;
157: --
151: --
152: Begin
153: hr_utility.set_location('Entering:'||l_proc, 5);
154: --
155: hr_utility.set_location(' Leaving:'||l_proc, 10);
156: End pre_update;
157: --
158: -- ----------------------------------------------------------------------------
159: -- |-----------------------------< post_update >------------------------------|
192: --
193: l_proc varchar2(72) := g_package||'post_update';
194: --
195: Begin
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: --
199: -- Start of API User Hook for post_update.
200: --
276: --
277: -- End of API User Hook for post_update.
278: --
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 10);
281: End post_update;
282: --
283: -- ----------------------------------------------------------------------------
284: -- |-----------------------------< convert_defs >-----------------------------|
328: l_proc varchar2(72) := g_package||'convert_defs';
329: --
330: Begin
331: --
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: -- We must now examine each argument value in the
335: -- p_rec plsql record structure
336: -- to see if a system default is being used. If a system default
448: p_rec.propagation_method :=
449: pqh_wdt_shd.g_old_rec.propagation_method;
450: End If;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 10);
453: --
454: End convert_defs;
455: --
456: -- ----------------------------------------------------------------------------
464: --
465: l_proc varchar2(72) := g_package||'upd';
466: --
467: Begin
468: hr_utility.set_location('Entering:'||l_proc, 5);
469: --
470: -- We must lock the row which we need to update.
471: --
472: pqh_wdt_shd.lck
540: l_rec pqh_wdt_shd.g_rec_type;
541: l_proc varchar2(72) := g_package||'upd';
542: --
543: Begin
544: hr_utility.set_location('Entering:'||l_proc, 5);
545: --
546: -- Call conversion function to turn arguments into the
547: -- l_rec structure.
548: --
588: upd(
589: p_effective_date,l_rec);
590: p_object_version_number := l_rec.object_version_number;
591: --
592: hr_utility.set_location(' Leaving:'||l_proc, 10);
593: End upd;
594: --
595: end pqh_wdt_upd;