APPS.PER_DISABILITY_API dependencies on PER_MEDICAL_ASSESSMENT_API

Line 397: -- call per_medical_assessment_api.update_medical_assessment to

393: );
394: end;
395:
396: -- if medical assessment id has been passed in then
397: -- call per_medical_assessment_api.update_medical_assessment to
398: -- set the foreign key of disability_id for the supplied
399: -- medical asessment id, and therby link the disability to the
400: -- assessment.
401: --

Line 411: per_medical_assessment_api.update_medical_assessment

407: select mea.object_version_number into l_object_version_number1
408: from per_medical_assessments mea
409: where mea.medical_assessment_id = p_medical_assessment_id;
410:
411: per_medical_assessment_api.update_medical_assessment
412: (p_validate => p_validate
413: ,p_medical_assessment_id => p_medical_assessment_id
414: ,p_object_version_number => l_object_version_number1
415: ,p_effective_date => l_effective_date

Line 636: per_medical_assessment_api.update_medical_assessment

632: select mea.object_version_number into l_object_version_number1
633: from per_medical_assessments mea
634: where mea.medical_assessment_id = l_mea_id;
635:
636: per_medical_assessment_api.update_medical_assessment
637: (p_validate => p_validate
638: ,p_medical_assessment_id => l_mea_id
639: ,p_object_version_number => l_object_version_number1
640: ,p_effective_date => l_effective_date

Line 669: per_medical_assessment_api.update_medical_assessment

665: where mea.medical_assessment_id = p_medical_assessment_id
666: and mea.consultation_result = 'DI'
667: and (mea.disability_id is null or mea.disability_id = p_disability_id);
668:
669: per_medical_assessment_api.update_medical_assessment
670: (p_validate => p_validate
671: ,p_medical_assessment_id => p_medical_assessment_id
672: ,p_object_version_number => l_object_version_number1
673: ,p_effective_date => l_effective_date

Line 1086: per_medical_assessment_api.update_medical_assessment

1082: loop
1083: fetch csr_mea into l_assessment_id, l_ovn1;
1084: exit when csr_mea%notfound;
1085: --
1086: per_medical_assessment_api.update_medical_assessment
1087: (p_validate => p_validate
1088: ,p_medical_assessment_id => l_assessment_id
1089: ,p_object_version_number => l_ovn1
1090: ,p_effective_date => trunc(p_effective_date)