DBA Data[Home] [Help]

APPS.PER_MEA_UPD dependencies on HR_UTILITY

Line 64: hr_utility.set_location('Entering:'||l_proc, 5);

60: l_last_updated_by per_medical_assessments.last_updated_by%TYPE;
61: l_last_update_login per_medical_assessments.last_update_login%TYPE;
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: --
66: -- Increment the object version
67: p_rec.object_version_number := p_rec.object_version_number + 1;
68: --

Line 160: hr_utility.set_location(' Leaving:'||l_proc, 10);

156: where medical_assessment_id = p_rec.medical_assessment_id;
157: --
158: --
159: --
160: hr_utility.set_location(' Leaving:'||l_proc, 10);
161: --
162: Exception
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated

Line 222: hr_utility.set_location('Entering:'||l_proc, 5);

218: --
219: l_proc varchar2(72) := g_package||'pre_update';
220: --
221: Begin
222: hr_utility.set_location('Entering:'||l_proc, 5);
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 10);
225: End pre_update;
226: --

Line 224: hr_utility.set_location(' Leaving:'||l_proc, 10);

220: --
221: Begin
222: hr_utility.set_location('Entering:'||l_proc, 5);
223: --
224: hr_utility.set_location(' Leaving:'||l_proc, 10);
225: End pre_update;
226: --
227: -- ----------------------------------------------------------------------------
228: -- |-----------------------------< post_update >------------------------------|

Line 267: hr_utility.set_location('Entering:'||l_proc, 5);

263: --
264: l_proc varchar2(72) := g_package||'post_update';
265: --
266: Begin
267: hr_utility.set_location('Entering:'||l_proc, 5);
268: BEGIN
269: --
270: per_mea_rku.after_update
271: (p_effective_date => p_effective_date

Line 431: hr_utility.set_location(' Leaving:'||l_proc, 10);

427: ,p_hook_type => 'AU');
428: --
429: end;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc, 10);
432: End post_update;
433: --
434: -- ----------------------------------------------------------------------------
435: -- |-----------------------------< convert_defs >-----------------------------|

Line 485: hr_utility.set_location(' Entering:'||l_proc, 10);

481: l_proc varchar2(72) := g_package||'convert_defs';
482: --
483: Begin
484: --
485: hr_utility.set_location(' Entering:'||l_proc, 10);
486: --
487: -- We must now examine each argument value in the
488: -- p_rec plsql record structure
489: -- to see if a system default is being used. If a system default

Line 497: hr_utility.set_location(l_proc, 20);

493: p_rec.person_id :=
494: per_mea_shd.g_old_rec.person_id;
495: End If;
496: --
497: hr_utility.set_location(l_proc, 20);
498: --
499: If (p_rec.examiner_name = hr_api.g_varchar2) then
500: p_rec.examiner_name :=
501: per_mea_shd.g_old_rec.examiner_name;

Line 504: hr_utility.set_location(l_proc, 30);

500: p_rec.examiner_name :=
501: per_mea_shd.g_old_rec.examiner_name;
502: End If;
503: --
504: hr_utility.set_location(l_proc, 30);
505: --
506: If (p_rec.organization_id = hr_api.g_number) then
507: p_rec.organization_id :=
508: per_mea_shd.g_old_rec.organization_id;

Line 511: hr_utility.set_location(l_proc, 40);

507: p_rec.organization_id :=
508: per_mea_shd.g_old_rec.organization_id;
509: End If;
510: --
511: hr_utility.set_location(l_proc, 40);
512: --
513: If (p_rec.consultation_date = hr_api.g_date) then
514: p_rec.consultation_date :=
515: per_mea_shd.g_old_rec.consultation_date;

Line 518: hr_utility.set_location(l_proc, 50);

514: p_rec.consultation_date :=
515: per_mea_shd.g_old_rec.consultation_date;
516: End If;
517: --
518: hr_utility.set_location(l_proc, 50);
519: --
520: If (p_rec.consultation_type = hr_api.g_varchar2) then
521: p_rec.consultation_type :=
522: per_mea_shd.g_old_rec.consultation_type;

Line 525: hr_utility.set_location(l_proc, 60);

521: p_rec.consultation_type :=
522: per_mea_shd.g_old_rec.consultation_type;
523: End If;
524: --
525: hr_utility.set_location(l_proc, 60);
526: --
527: If (p_rec.incident_id = hr_api.g_number) then
528: p_rec.incident_id :=
529: per_mea_shd.g_old_rec.incident_id;

Line 532: hr_utility.set_location(l_proc, 70);

528: p_rec.incident_id :=
529: per_mea_shd.g_old_rec.incident_id;
530: End If;
531: --
532: hr_utility.set_location(l_proc, 70);
533: --
534: If (p_rec.consultation_result = hr_api.g_varchar2) then
535: p_rec.consultation_result :=
536: per_mea_shd.g_old_rec.consultation_result;

Line 539: hr_utility.set_location(l_proc, 80);

535: p_rec.consultation_result :=
536: per_mea_shd.g_old_rec.consultation_result;
537: End If;
538: --
539: hr_utility.set_location(l_proc, 80);
540: --
541: If (p_rec.disability_id = hr_api.g_number) then
542: p_rec.disability_id :=
543: per_mea_shd.g_old_rec.disability_id;

Line 546: hr_utility.set_location(l_proc, 90);

542: p_rec.disability_id :=
543: per_mea_shd.g_old_rec.disability_id;
544: End If;
545: --
546: hr_utility.set_location(l_proc, 90);
547: --
548: If (p_rec.next_consultation_date = hr_api.g_date) then
549: p_rec.next_consultation_date :=
550: per_mea_shd.g_old_rec.next_consultation_date;

Line 552: hr_utility.set_location(l_proc, 100);

548: If (p_rec.next_consultation_date = hr_api.g_date) then
549: p_rec.next_consultation_date :=
550: per_mea_shd.g_old_rec.next_consultation_date;
551: End If; --
552: hr_utility.set_location(l_proc, 100);
553: --
554: If (p_rec.description = hr_api.g_varchar2) then
555: p_rec.description :=
556: per_mea_shd.g_old_rec.description;

Line 558: hr_utility.set_location(l_proc, 110);

554: If (p_rec.description = hr_api.g_varchar2) then
555: p_rec.description :=
556: per_mea_shd.g_old_rec.description;
557: End If; --
558: hr_utility.set_location(l_proc, 110);
559: --
560: If (p_rec.attribute_category = hr_api.g_varchar2) then
561: p_rec.attribute_category :=
562: per_mea_shd.g_old_rec.attribute_category;

Line 823: hr_utility.set_location('Entering:'||l_proc, 5);

819: l_proc varchar2(72) := g_package||'upd';
820: --
821: Begin
822: --
823: hr_utility.set_location('Entering:'||l_proc, 5);
824: --
825: -- We must lock the row which we need to update.
826: --
827: per_mea_shd.lck

Line 832: hr_utility.set_location(l_proc, 10);

828: (p_rec.medical_assessment_id
829: ,p_rec.object_version_number
830: );
831: --
832: hr_utility.set_location(l_proc, 10);
833: --
834: --
835: -- 1. During an update system defaults are used to determine if
836: -- arguments have been defaulted or not. We must therefore

Line 843: hr_utility.set_location(l_proc, 20);

839: -- 2. Call the supporting update validate operations.
840: --
841: convert_defs(p_rec);
842: --
843: hr_utility.set_location(l_proc, 20);
844: --
845: per_mea_bus.update_validate
846: (p_effective_date
847: ,p_rec

Line 850: hr_utility.set_location(l_proc, 30);

846: (p_effective_date
847: ,p_rec
848: );
849: --
850: hr_utility.set_location(l_proc, 30);
851: --
852: -- Call the supporting pre-update operation
853: --
854: per_mea_upd.pre_update(p_rec);

Line 856: hr_utility.set_location(l_proc, 40);

852: -- Call the supporting pre-update operation
853: --
854: per_mea_upd.pre_update(p_rec);
855: --
856: hr_utility.set_location(l_proc, 40);
857: --
858: -- Update the row.
859: --
860: per_mea_upd.update_dml(p_rec);

Line 862: hr_utility.set_location(l_proc, 50);

858: -- Update the row.
859: --
860: per_mea_upd.update_dml(p_rec);
861: --
862: hr_utility.set_location(l_proc, 50);
863: --
864: -- Call the supporting post-update operation
865: --
866: per_mea_upd.post_update

Line 871: hr_utility.set_location('Leaving:'||l_proc, 60);

867: (p_effective_date
868: ,p_rec
869: );
870: --
871: hr_utility.set_location('Leaving:'||l_proc, 60);
872: --
873: End upd;
874: --
875: -- ----------------------------------------------------------------------------

Line 959: hr_utility.set_location('Entering:'||l_proc, 5);

955: l_rec per_mea_shd.g_rec_type;
956: l_proc varchar2(72) := g_package||'upd';
957: --
958: Begin
959: hr_utility.set_location('Entering:'||l_proc, 5);
960: --
961: -- Call conversion function to turn arguments into the
962: -- l_rec structure.
963: --

Line 1052: hr_utility.set_location(' Leaving:'||l_proc, 10);

1048: ,l_rec
1049: );
1050: p_object_version_number := l_rec.object_version_number;
1051: --
1052: hr_utility.set_location(' Leaving:'||l_proc, 10);
1053: End upd;
1054: --
1055: end per_mea_upd;