DBA Data[Home] [Help]

APPS.OTA_LO_UTILITY dependencies on OTA_UTILITY

Line 3575: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');

3571: If ( (l_status = 'N') or (l_status = 'I') ) Then
3572: If ( l_course_end_date < l_sysdate --Class is expired --Bug 3554773 --Bug 5222464
3573: AND p_mode is null ) Then -- Bug 3594377
3574: l_status := 'E';
3575: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');
3576: End If;
3577: End If;
3578:
3579: --check if the enrollment is part of active certs

Line 4115: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');

4111: If ( (l_status = 'N') or (l_status = 'I') ) Then
4112: If ( l_course_end_date < trunc(sysdate) --Class is expired --Bug 3554773
4113: AND p_mode is null ) Then -- Bug 3594377
4114: l_status := 'E';
4115: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');
4116: End If;
4117: End If;
4118:
4119: --Added for bug 12425778

Line 4786: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');

4782: If ( rec.course_end_date < trunc(sysdate) --Class is expired --Bug 3554773
4783: -- AND p_mode is null ) Then -- Bug 3594377
4784: ) then
4785: l_status := 'E';
4786: l_status_name := ota_utility.get_message('OTA','OTA_443001_OFFR_EXPIRED_STATUS');
4787: End If;
4788: End If;
4789:
4790: hr_utility.set_location('Leaving :'||l_proc,10);