[Home] [Help]
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;
105: available_flag = p_rec.available_flag
106: where assessment_type_id = p_rec.assessment_type_id;
107: --
108: --
109: hr_utility.set_location(' Leaving:'||l_proc, 10);
110: --
111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
161: --
162: l_proc varchar2(72) := g_package||'pre_update';
163: --
164: Begin
165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: End pre_update;
169: --
163: --
164: Begin
165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: hr_utility.set_location(' Leaving:'||l_proc, 10);
168: End pre_update;
169: --
170: -- ----------------------------------------------------------------------------
171: -- |-----------------------------< post_update >------------------------------|
203: --
204: l_proc varchar2(72) := g_package||'post_update';
205: --
206: Begin
207: hr_utility.set_location('Entering:'||l_proc, 5);
208: --
209: -- This is a hook point and the user hook for post_update is called here.
210: --
211: begin
309: );
310: end;
311: -- End of API User Hook for post_update
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 10);
314: End post_update;
315: --
316: -- ----------------------------------------------------------------------------
317: -- |-----------------------------< convert_defs >-----------------------------|
363: l_proc varchar2(72) := g_package||'convert_defs';
364: --
365: Begin
366: --
367: hr_utility.set_location('Entering:'||l_proc, 5);
368: --
369: -- We must now examine each argument value in the
370: -- p_rec plsql record structure
371: -- to see if a system default is being used. If a system default
535: p_rec.available_flag :=
536: per_ast_shd.g_old_rec.available_flag;
537: End If;
538: --
539: hr_utility.set_location(' Leaving:'||l_proc, 10);
540: --
541: End convert_defs;
542: --
543: -- ----------------------------------------------------------------------------
552: --
553: l_proc varchar2(72) := g_package||'upd';
554: --
555: Begin
556: hr_utility.set_location('Entering:'||l_proc, 5);
557: --
558: -- Determine if the business process is to be validated.
559: --
560: If p_validate then
599: If p_validate then
600: Raise HR_Api.Validate_Enabled;
601: End If;
602: --
603: hr_utility.set_location(' Leaving:'||l_proc, 10);
604: Exception
605: When HR_Api.Validate_Enabled Then
606: --
607: -- As the Validate_Enabled exception has been raised
664: l_rec per_ast_shd.g_rec_type;
665: l_proc varchar2(72) := g_package||'upd';
666: --
667: Begin
668: hr_utility.set_location('Entering:'||l_proc, 5);
669: --
670: -- Call conversion function to turn arguments into the
671: -- l_rec structure.
672: --
669: --
670: -- Call conversion function to turn arguments into the
671: -- l_rec structure.
672: --
673: hr_utility.set_location('In Upd attrib, ass_class is :'||p_assessment_classification, 10);
674: hr_utility.set_location('In Upd attrib, comments is :'||p_comments, 10);
675: --
676: l_rec :=
677: per_ast_shd.convert_args
670: -- Call conversion function to turn arguments into the
671: -- l_rec structure.
672: --
673: hr_utility.set_location('In Upd attrib, ass_class is :'||p_assessment_classification, 10);
674: hr_utility.set_location('In Upd attrib, comments is :'||p_comments, 10);
675: --
676: l_rec :=
677: per_ast_shd.convert_args
678: (
730: ,p_effective_date
731: );
732: p_object_version_number := l_rec.object_version_number;
733: --
734: hr_utility.set_location(' Leaving:'||l_proc, 10);
735: End upd;
736: --
737: end per_ast_upd;