[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
866: ,D.DATE_STATUS_CHANGED
867: ,D.SUCCESSFUL_ATTENDANCE_FLAG
868: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
869: ,E.EVENT_ID
870: FROM ota_activity_versions_vl a ,
871: OTA_EVENTS E,
872: OTA_EVENTS_TL ET,
873: OTA_DELEGATE_BOOKINGS D,
874: OTA_BOOKING_STATUS_TYPES S,
1041: ,D.DATE_STATUS_CHANGED
1042: ,D.SUCCESSFUL_ATTENDANCE_FLAG
1043: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
1044: ,E.EVENT_ID
1045: FROM ota_activity_versions_vl a ,
1046: OTA_EVENTS E,
1047: OTA_EVENTS_TL ET,
1048: OTA_DELEGATE_BOOKINGS D,
1049: OTA_BOOKING_STATUS_TYPES S,
1178: hr_general_utilities.get_lookup_meaning('ACTIVITY_SUCCESS_CRITERIA', a.success_criteria) Success_Criteria,
1179: a.professional_credits,
1180: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1181: a.Controlling_Person_Id Controlling_Person_Id
1182: FROM ota_activity_versions_vl a
1183: WHERE a.activity_version_id = p_course_id;
1184: l_activity_rec activity_rectype;
1185: l_activity_tbl activity_tabletype;
1186: BEGIN
1279: ,D.DATE_STATUS_CHANGED
1280: ,D.SUCCESSFUL_ATTENDANCE_FLAG
1281: , nvl(D.IS_MANDATORY_ENROLLMENT,'N') is_mandatory_enrollment
1282: ,E.EVENT_ID
1283: FROM ota_activity_versions_vl a ,
1284: OTA_EVENTS E,
1285: OTA_EVENTS_TL ET,
1286: OTA_DELEGATE_BOOKINGS D,
1287: OTA_BOOKING_STATUS_TYPES S,