[Home] [Help]
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;
112: where nota_history_id = p_rec.nota_history_id;
113: --
114: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
115: --
116: hr_utility.set_location(' Leaving:'||l_proc, 10);
117: --
118: Exception
119: When hr_api.check_integrity_violated Then
120: -- A check constraint has been violated
172: --
173: l_proc varchar2(72) := g_package||'pre_update';
174: --
175: Begin
176: hr_utility.set_location('Entering:'||l_proc, 5);
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 10);
179: End pre_update;
180: --
174: --
175: Begin
176: hr_utility.set_location('Entering:'||l_proc, 5);
177: --
178: hr_utility.set_location(' Leaving:'||l_proc, 10);
179: End pre_update;
180: --
181: -- ----------------------------------------------------------------------------
182: -- |-----------------------------< post_update >------------------------------|
215: --
216: l_proc varchar2(72) := g_package||'post_update';
217: --
218: Begin
219: hr_utility.set_location('Entering:'||l_proc, 5);
220: --
221: begin
222: --
223: ota_nhs_rku.after_update
397: end;
398:
399:
400:
401: hr_utility.set_location(' Leaving:'||l_proc, 10);
402: End post_update;
403: --
404: -- ----------------------------------------------------------------------------
405: -- |-----------------------------< convert_defs >-----------------------------|
452: l_proc varchar2(72) := g_package||'convert_defs';
453: --
454: Begin
455: --
456: hr_utility.set_location('Entering:'||l_proc, 5);
457: --
458: -- We must now examine each argument value in the
459: -- p_rec plsql record structure
460: -- to see if a system default is being used. If a system default
616: p_rec.organization_id :=
617: ota_nhs_shd.g_old_rec.organization_id;
618: End If;
619: --
620: hr_utility.set_location(' Leaving:'||l_proc, 10);
621: --
622: End convert_defs;
623: --
624: -- ----------------------------------------------------------------------------
631: --
632: l_proc varchar2(72) := g_package||'upd';
633: --
634: Begin
635: hr_utility.set_location('Entering:'||l_proc, 5);
636: --
637: -- We must lock the row which we need to update.
638: --
639: ota_nhs_shd.lck
720: l_rec ota_nhs_shd.g_rec_type;
721: l_proc varchar2(72) := g_package||'upd';
722: --
723: Begin
724: hr_utility.set_location('Entering:'||l_proc, 5);
725:
726: --
727: -- Call conversion function to turn arguments into the
728: -- l_rec structure.
780: upd(p_effective_date ,
781: l_rec);
782: p_object_version_number := l_rec.object_version_number;
783: --
784: hr_utility.set_location(' Leaving:'||l_proc, 10);
785: End upd;
786: --
787: end ota_nhs_upd;