[Home] [Help]
14: RETURN FALSE;
15: END is_required;
16:
17: PROCEDURE get_events(p_event_id IN ota_events_v.event_id%TYPE,
18: p_activity_version_id IN ota_activity_versions_vl.activity_version_id%TYPE,
19: p_events_tbl OUT NOCOPY event_tabletype)
20: IS
21: CURSOR cur_event IS
22: SELECT event_id,
587: from ota_cert_enrollments cre,
588: ota_cert_prd_enrollments cpe,
589: ota_cert_mbr_enrollments cme,
590: ota_certification_members cmb,
591: ota_activity_versions_vl tav,
592: hr_lookups lkp
593: where tav.activity_version_id = cmb.object_id
594: and cmb.object_type = 'H'
595: and cmb.certification_member_id = cme.cert_member_id
865: ,D.DATE_STATUS_CHANGED
866: ,D.SUCCESSFUL_ATTENDANCE_FLAG
867: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
868: ,E.EVENT_ID
869: FROM ota_activity_versions_vl a ,
870: OTA_EVENTS E,
871: OTA_EVENTS_TL ET,
872: OTA_DELEGATE_BOOKINGS D,
873: OTA_BOOKING_STATUS_TYPES S,
1038: ,D.DATE_STATUS_CHANGED
1039: ,D.SUCCESSFUL_ATTENDANCE_FLAG
1040: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
1041: ,E.EVENT_ID
1042: FROM ota_activity_versions_vl a ,
1043: OTA_EVENTS E,
1044: OTA_EVENTS_TL ET,
1045: OTA_DELEGATE_BOOKINGS D,
1046: OTA_BOOKING_STATUS_TYPES S,
1174: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1175: a.professional_credits,
1176: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1177: a.Controlling_Person_Id Controlling_Person_Id
1178: FROM ota_activity_versions_vl a
1179: WHERE a.activity_version_id = p_course_id;
1180: l_activity_rec activity_rectype;
1181: l_activity_tbl activity_tabletype;
1182: BEGIN
1274: ,D.DATE_STATUS_CHANGED
1275: ,D.SUCCESSFUL_ATTENDANCE_FLAG
1276: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
1277: ,E.EVENT_ID
1278: FROM ota_activity_versions_vl a ,
1279: OTA_EVENTS E,
1280: OTA_EVENTS_TL ET,
1281: OTA_DELEGATE_BOOKINGS D,
1282: OTA_BOOKING_STATUS_TYPES S,