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;
125: plan_id = p_rec.plan_id,
126: offline_status = p_rec.offline_status
127: where appraisal_id = p_rec.appraisal_id;
128:
129: hr_utility.set_location(' Leaving:'||l_proc, 10);
130:
131: Exception
132: When hr_api.check_integrity_violated Then
133: -- A check constraint has been violated
181:
182: l_proc varchar2(72) := g_package||'pre_update';
183:
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186:
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: End pre_update;
189:
183:
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186:
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: End pre_update;
189:
190: -- ---------------------------------------------------------------------------+
191: -- |-----------------------------< post_update >------------------------------|
223:
224: l_proc varchar2(72) := g_package||'post_update';
225:
226: Begin
227: hr_utility.set_location('Entering:'||l_proc, 5);
228:
229: -- This is a hook point and the user hook for post_update is called here.
230:
231: begin
362: );
363: end;
364: -- End of API User Hook for post_update
365:
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: End post_update;
368:
369: -- ---------------------------------------------------------------------------+
370: -- |-----------------------------< convert_defs >-----------------------------|
415: l_proc varchar2(72) := g_package||'convert_defs';
416:
417: Begin
418:
419: hr_utility.set_location('Entering:'||l_proc, 5);
420:
421: -- We must now examine each argument value in the
422: -- p_rec plsql record structure
423: -- to see if a system default is being used. If a system default
695: If (p_rec.offline_status = hr_api.g_varchar2) then
696: p_rec.offline_status :=
697: per_apr_shd.g_old_rec.offline_status;
698: End If;
699: hr_utility.set_location(' Leaving:'||l_proc, 10);
700:
701: End convert_defs;
702:
703: -- ---------------------------------------------------------------------------+
712:
713: l_proc varchar2(72) := g_package||'upd';
714:
715: Begin
716: hr_utility.set_location('Entering:'||l_proc, 5);
717:
718: -- Determine if the business process is to be validated.
719:
720: If p_validate then
761: If p_validate then
762: Raise HR_Api.Validate_Enabled;
763: End If;
764:
765: hr_utility.set_location(' Leaving:'||l_proc, 10);
766: Exception
767: When HR_Api.Validate_Enabled Then
768:
769: -- As the Validate_Enabled exception has been raised
847: l_rec per_apr_shd.g_rec_type;
848: l_proc varchar2(72) := g_package||'upd';
849:
850: Begin
851: hr_utility.set_location('Entering:'||l_proc, 5);
852:
853: -- Call conversion function to turn arguments into the
854: -- l_rec structure.
855:
932:
933: upd(l_rec, p_effective_date,p_validate);
934: p_object_version_number := l_rec.object_version_number;
935:
936: hr_utility.set_location(' Leaving:'||l_proc, 10);
937: End upd;
938:
939: end per_apr_upd;