[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,
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,
875: OTA_OFFERINGS O,
876: OTA_OFFERINGS_TL OT,
877: OTA_CATEGORY_USAGES C,
878: OTA_CATEGORY_USAGES_TL CT,
879: OTA_ACTIVITY_VERSIONS_TL OAV,
880: OTA_EVALUATIONS EVAL
881: WHERE a.activity_version_id = e.activity_version_id
882: AND OAV.ACTIVITY_VERSION_ID = a.ACTIVITY_VERSION_ID
883: AND E.EVENT_ID=D.EVENT_ID
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,
1048: OTA_OFFERINGS O,
1049: OTA_OFFERINGS_TL OT,
1050: OTA_CATEGORY_USAGES C,
1051: OTA_CATEGORY_USAGES_TL CT,
1052: OTA_ACTIVITY_VERSIONS_TL OAV,
1053: OTA_EVALUATIONS EVAL
1054: WHERE a.activity_version_id = e.activity_version_id
1055: AND OAV.ACTIVITY_VERSION_ID = a.ACTIVITY_VERSION_ID
1056: AND E.EVENT_ID=D.EVENT_ID
1137: END get_training_details_internal;
1138:
1139:
1140:
1141: PROCEDURE get_training_details_internal(p_course_id IN ota_activity_versions.activity_id%TYPE
1142: ,p_activity_tbl OUT NOCOPY activity_tabletype)
1143: IS
1144: CURSOR get_activity_rec IS
1145: SELECT
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,
1284: OTA_OFFERINGS O,
1285: OTA_OFFERINGS_TL OT,
1286: OTA_CATEGORY_USAGES C,
1287: OTA_CATEGORY_USAGES_TL CT,
1288: OTA_ACTIVITY_VERSIONS_TL OAV,
1289: OTA_EVALUATIONS EVAL
1290: WHERE a.activity_version_id = e.activity_version_id
1291: AND OAV.ACTIVITY_VERSION_ID = a.ACTIVITY_VERSION_ID
1292: AND E.EVENT_ID=D.EVENT_ID
1408: p_certifications OUT NOCOPY certification_tabletype,
1409: p_ispartofcertification OUT NOCOPY BOOLEAN)
1410: IS
1411: l_person_id ota_delegate_bookings.delegate_person_id%TYPE := NULL;
1412: l_activity_version_id ota_activity_versions.activity_id%TYPE := NULL;
1413: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;
1414: l_event_id ota_events.event_id%TYPE := NULL;
1415: l_activity_rec activity_rectype;
1416: l_event_rec event_rectype;