54:
55: TYPE cert_component_rectype IS RECORD
56: (
57: cert_mbr_enrollment_id ota_cert_mbr_enrollments.cert_mbr_enrollment_id%TYPE,
58: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
59: member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE,
60: course_name ota_activity_versions_vl.version_name%TYPE,
61: completion_date ota_cert_mbr_enrollments.completion_date%TYPE,
62: member_status_meaning hr_lookups.meaning%TYPE,
56: (
57: cert_mbr_enrollment_id ota_cert_mbr_enrollments.cert_mbr_enrollment_id%TYPE,
58: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
59: member_status_code ota_cert_mbr_enrollments.member_status_code%TYPE,
60: course_name ota_activity_versions_vl.version_name%TYPE,
61: completion_date ota_cert_mbr_enrollments.completion_date%TYPE,
62: member_status_meaning hr_lookups.meaning%TYPE,
63: enrollment_details_icon varchar2(100),
64: version_code ota_activity_versions_vl.version_code%TYPE,
60: course_name ota_activity_versions_vl.version_name%TYPE,
61: completion_date ota_cert_mbr_enrollments.completion_date%TYPE,
62: member_status_meaning hr_lookups.meaning%TYPE,
63: enrollment_details_icon varchar2(100),
64: version_code ota_activity_versions_vl.version_code%TYPE,
65: activity_version_name ota_activity_versions_vl.version_name%TYPE,
66: start_date ota_activity_versions_vl.start_date%TYPE,
67: end_date ota_activity_versions_vl.end_date%TYPE,
68: certification_member_id ota_certification_members.certification_member_id%TYPE,
61: completion_date ota_cert_mbr_enrollments.completion_date%TYPE,
62: member_status_meaning hr_lookups.meaning%TYPE,
63: enrollment_details_icon varchar2(100),
64: version_code ota_activity_versions_vl.version_code%TYPE,
65: activity_version_name ota_activity_versions_vl.version_name%TYPE,
66: start_date ota_activity_versions_vl.start_date%TYPE,
67: end_date ota_activity_versions_vl.end_date%TYPE,
68: certification_member_id ota_certification_members.certification_member_id%TYPE,
69: member_sequence ota_certification_members.member_sequence%TYPE,
62: member_status_meaning hr_lookups.meaning%TYPE,
63: enrollment_details_icon varchar2(100),
64: version_code ota_activity_versions_vl.version_code%TYPE,
65: activity_version_name ota_activity_versions_vl.version_name%TYPE,
66: start_date ota_activity_versions_vl.start_date%TYPE,
67: end_date ota_activity_versions_vl.end_date%TYPE,
68: certification_member_id ota_certification_members.certification_member_id%TYPE,
69: member_sequence ota_certification_members.member_sequence%TYPE,
70: event_id ota_events.event_id%TYPE,
63: enrollment_details_icon varchar2(100),
64: version_code ota_activity_versions_vl.version_code%TYPE,
65: activity_version_name ota_activity_versions_vl.version_name%TYPE,
66: start_date ota_activity_versions_vl.start_date%TYPE,
67: end_date ota_activity_versions_vl.end_date%TYPE,
68: certification_member_id ota_certification_members.certification_member_id%TYPE,
69: member_sequence ota_certification_members.member_sequence%TYPE,
70: event_id ota_events.event_id%TYPE,
71: perf_status ota_booking_status_types_tl.name%TYPE,
220: is_mandatory_enrollment ota_delegate_bookings.is_mandatory_enrollment%TYPE
221: );
222: TYPE activity_rectype IS RECORD
223: (
224: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
225: activity_version_name ota_activity_versions_vl.version_name%TYPE,
226: activity_description ota_activity_versions_vl.description%TYPE,
227: activity_objectives ota_activity_versions_vl.objectives%TYPE,
228: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
221: );
222: TYPE activity_rectype IS RECORD
223: (
224: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
225: activity_version_name ota_activity_versions_vl.version_name%TYPE,
226: activity_description ota_activity_versions_vl.description%TYPE,
227: activity_objectives ota_activity_versions_vl.objectives%TYPE,
228: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
229: activity_keywords ota_activity_versions_vl.keywords%TYPE,
222: TYPE activity_rectype IS RECORD
223: (
224: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
225: activity_version_name ota_activity_versions_vl.version_name%TYPE,
226: activity_description ota_activity_versions_vl.description%TYPE,
227: activity_objectives ota_activity_versions_vl.objectives%TYPE,
228: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
229: activity_keywords ota_activity_versions_vl.keywords%TYPE,
230: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
223: (
224: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
225: activity_version_name ota_activity_versions_vl.version_name%TYPE,
226: activity_description ota_activity_versions_vl.description%TYPE,
227: activity_objectives ota_activity_versions_vl.objectives%TYPE,
228: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
229: activity_keywords ota_activity_versions_vl.keywords%TYPE,
230: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
231: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
224: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
225: activity_version_name ota_activity_versions_vl.version_name%TYPE,
226: activity_description ota_activity_versions_vl.description%TYPE,
227: activity_objectives ota_activity_versions_vl.objectives%TYPE,
228: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
229: activity_keywords ota_activity_versions_vl.keywords%TYPE,
230: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
231: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
232: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
225: activity_version_name ota_activity_versions_vl.version_name%TYPE,
226: activity_description ota_activity_versions_vl.description%TYPE,
227: activity_objectives ota_activity_versions_vl.objectives%TYPE,
228: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
229: activity_keywords ota_activity_versions_vl.keywords%TYPE,
230: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
231: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
232: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
233: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
226: activity_description ota_activity_versions_vl.description%TYPE,
227: activity_objectives ota_activity_versions_vl.objectives%TYPE,
228: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
229: activity_keywords ota_activity_versions_vl.keywords%TYPE,
230: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
231: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
232: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
233: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
234: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
227: activity_objectives ota_activity_versions_vl.objectives%TYPE,
228: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
229: activity_keywords ota_activity_versions_vl.keywords%TYPE,
230: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
231: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
232: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
233: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
234: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
235: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
228: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
229: activity_keywords ota_activity_versions_vl.keywords%TYPE,
230: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
231: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
232: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
233: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
234: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
235: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
236: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
229: activity_keywords ota_activity_versions_vl.keywords%TYPE,
230: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
231: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
232: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
233: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
234: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
235: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
236: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
237: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
230: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
231: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
232: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
233: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
234: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
235: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
236: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
237: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
238: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
231: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
232: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
233: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
234: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
235: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
236: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
237: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
238: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
239: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
232: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
233: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
234: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
235: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
236: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
237: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
238: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
239: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
240: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
233: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
234: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
235: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
236: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
237: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
238: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
239: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
240: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
241: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
234: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
235: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
236: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
237: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
238: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
239: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
240: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
241: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
242: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
235: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
236: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
237: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
238: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
239: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
240: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
241: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
242: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
243: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
236: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
237: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
238: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
239: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
240: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
241: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
242: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
243: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
244: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
237: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
238: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
239: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
240: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
241: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
242: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
243: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
244: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
245: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
238: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
239: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
240: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
241: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
242: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
243: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
244: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
245: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
246: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
239: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
240: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
241: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
242: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
243: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
244: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
245: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
246: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
247: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
240: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
241: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
242: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
243: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
244: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
245: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
246: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
247: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
248: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
241: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
242: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
243: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
244: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
245: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
246: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
247: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
248: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
249: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
242: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
243: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
244: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
245: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
246: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
247: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
248: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
249: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
250: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
243: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
244: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
245: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
246: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
247: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
248: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
249: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
250: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
251: activity_version_code ota_activity_versions_vl.version_code%TYPE,
244: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
245: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
246: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
247: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
248: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
249: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
250: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
251: activity_version_code ota_activity_versions_vl.version_code%TYPE,
252: success_criteria hr_lookups.meaning%TYPE,
245: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
246: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
247: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
248: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
249: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
250: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
251: activity_version_code ota_activity_versions_vl.version_code%TYPE,
252: success_criteria hr_lookups.meaning%TYPE,
253: professional_credits ota_activity_versions_vl.professional_credits%TYPE,
246: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
247: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
248: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
249: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
250: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
251: activity_version_code ota_activity_versions_vl.version_code%TYPE,
252: success_criteria hr_lookups.meaning%TYPE,
253: professional_credits ota_activity_versions_vl.professional_credits%TYPE,
254: professional_credit_meaning hr_lookups.meaning%TYPE,
247: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
248: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
249: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
250: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
251: activity_version_code ota_activity_versions_vl.version_code%TYPE,
252: success_criteria hr_lookups.meaning%TYPE,
253: professional_credits ota_activity_versions_vl.professional_credits%TYPE,
254: professional_credit_meaning hr_lookups.meaning%TYPE,
255: controlling_person_id ota_activity_versions.controlling_person_id%type,
249: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
250: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
251: activity_version_code ota_activity_versions_vl.version_code%TYPE,
252: success_criteria hr_lookups.meaning%TYPE,
253: professional_credits ota_activity_versions_vl.professional_credits%TYPE,
254: professional_credit_meaning hr_lookups.meaning%TYPE,
255: controlling_person_id ota_activity_versions.controlling_person_id%type,
256: events event_tabletype,
257: booking booking_rectype,