[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
768: FROM ota_events e,
769: ota_events_tl et,
770: hr_all_organization_units o,
771: hr_all_organization_units_tl haotl,
772: ota_activity_versions a,
773: ota_delegate_bookings b,
774: ota_booking_status_types_VL s,
775: ota_cert_enrollments cre,
776: ota_cert_prd_enrollments cpe,
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,
876: OTA_OFFERINGS O,
877: OTA_OFFERINGS_TL OT,
878: OTA_CATEGORY_USAGES C,
879: OTA_CATEGORY_USAGES_TL CT,
880: OTA_ACTIVITY_VERSIONS_TL OAV,
881: OTA_EVALUATIONS EVAL
882: WHERE a.activity_version_id = e.activity_version_id
883: AND OAV.ACTIVITY_VERSION_ID = a.ACTIVITY_VERSION_ID
884: AND E.EVENT_ID=D.EVENT_ID
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,
1051: OTA_OFFERINGS O,
1052: OTA_OFFERINGS_TL OT,
1053: OTA_CATEGORY_USAGES C,
1054: OTA_CATEGORY_USAGES_TL CT,
1055: OTA_ACTIVITY_VERSIONS_TL OAV,
1056: OTA_EVALUATIONS EVAL
1057: WHERE a.activity_version_id = e.activity_version_id
1058: AND OAV.ACTIVITY_VERSION_ID = a.ACTIVITY_VERSION_ID
1059: AND E.EVENT_ID=D.EVENT_ID
1141: END get_training_details_internal;
1142:
1143:
1144:
1145: PROCEDURE get_training_details_internal(p_course_id IN ota_activity_versions.activity_id%TYPE
1146: ,p_activity_tbl OUT NOCOPY activity_tabletype)
1147: IS
1148: CURSOR get_activity_rec IS
1149: SELECT
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,
1289: OTA_OFFERINGS O,
1290: OTA_OFFERINGS_TL OT,
1291: OTA_CATEGORY_USAGES C,
1292: OTA_CATEGORY_USAGES_TL CT,
1293: OTA_ACTIVITY_VERSIONS_TL OAV,
1294: OTA_EVALUATIONS EVAL
1295: WHERE a.activity_version_id = e.activity_version_id
1296: AND OAV.ACTIVITY_VERSION_ID = a.ACTIVITY_VERSION_ID
1297: AND E.EVENT_ID=D.EVENT_ID
1414: p_certifications OUT NOCOPY certification_tabletype,
1415: p_ispartofcertification OUT NOCOPY BOOLEAN)
1416: IS
1417: l_person_id ota_delegate_bookings.delegate_person_id%TYPE := NULL;
1418: l_activity_version_id ota_activity_versions.activity_id%TYPE := NULL;
1419: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;
1420: l_event_id ota_events.event_id%TYPE := NULL;
1421: l_activity_rec activity_rectype;
1422: l_event_rec event_rectype;