eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TRAINING_RECORD dependencies on OTA_ACTIVITY_VERSIONS

Line 58: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,

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,

Line 60: course_name ota_activity_versions_vl.version_name%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,

Line 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,

Line 65: activity_version_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,
69: member_sequence ota_certification_members.member_sequence%TYPE,

Line 66: start_date ota_activity_versions_vl.start_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,
70: event_id ota_events.event_id%TYPE,

Line 67: end_date ota_activity_versions_vl.end_date%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,

Line 223: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,

219: is_mandatory_enrollment ota_delegate_bookings.is_mandatory_enrollment%TYPE
220: );
221: TYPE activity_rectype IS RECORD
222: (
223: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
224: activity_version_name ota_activity_versions_vl.version_name%TYPE,
225: activity_description ota_activity_versions_vl.description%TYPE,
226: activity_objectives ota_activity_versions_vl.objectives%TYPE,
227: activity_audience ota_activity_versions_vl.intended_audience%TYPE,

Line 224: activity_version_name ota_activity_versions_vl.version_name%TYPE,

220: );
221: TYPE activity_rectype IS RECORD
222: (
223: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
224: activity_version_name ota_activity_versions_vl.version_name%TYPE,
225: activity_description ota_activity_versions_vl.description%TYPE,
226: activity_objectives ota_activity_versions_vl.objectives%TYPE,
227: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
228: activity_keywords ota_activity_versions_vl.keywords%TYPE,

Line 225: activity_description ota_activity_versions_vl.description%TYPE,

221: TYPE activity_rectype IS RECORD
222: (
223: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
224: activity_version_name ota_activity_versions_vl.version_name%TYPE,
225: activity_description ota_activity_versions_vl.description%TYPE,
226: activity_objectives ota_activity_versions_vl.objectives%TYPE,
227: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
228: activity_keywords ota_activity_versions_vl.keywords%TYPE,
229: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,

Line 226: activity_objectives ota_activity_versions_vl.objectives%TYPE,

222: (
223: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
224: activity_version_name ota_activity_versions_vl.version_name%TYPE,
225: activity_description ota_activity_versions_vl.description%TYPE,
226: activity_objectives ota_activity_versions_vl.objectives%TYPE,
227: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
228: activity_keywords ota_activity_versions_vl.keywords%TYPE,
229: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
230: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,

Line 227: activity_audience ota_activity_versions_vl.intended_audience%TYPE,

223: activity_version_id ota_activity_versions_vl.activity_version_id%TYPE,
224: activity_version_name ota_activity_versions_vl.version_name%TYPE,
225: activity_description ota_activity_versions_vl.description%TYPE,
226: activity_objectives ota_activity_versions_vl.objectives%TYPE,
227: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
228: activity_keywords ota_activity_versions_vl.keywords%TYPE,
229: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
230: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
231: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,

Line 228: activity_keywords ota_activity_versions_vl.keywords%TYPE,

224: activity_version_name ota_activity_versions_vl.version_name%TYPE,
225: activity_description ota_activity_versions_vl.description%TYPE,
226: activity_objectives ota_activity_versions_vl.objectives%TYPE,
227: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
228: activity_keywords ota_activity_versions_vl.keywords%TYPE,
229: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
230: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
231: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
232: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,

Line 229: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,

225: activity_description ota_activity_versions_vl.description%TYPE,
226: activity_objectives ota_activity_versions_vl.objectives%TYPE,
227: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
228: activity_keywords ota_activity_versions_vl.keywords%TYPE,
229: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
230: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
231: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
232: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
233: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,

Line 230: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,

226: activity_objectives ota_activity_versions_vl.objectives%TYPE,
227: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
228: activity_keywords ota_activity_versions_vl.keywords%TYPE,
229: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
230: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
231: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
232: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
233: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
234: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,

Line 231: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,

227: activity_audience ota_activity_versions_vl.intended_audience%TYPE,
228: activity_keywords ota_activity_versions_vl.keywords%TYPE,
229: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
230: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
231: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
232: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
233: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
234: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
235: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,

Line 232: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,

228: activity_keywords ota_activity_versions_vl.keywords%TYPE,
229: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
230: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
231: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
232: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
233: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
234: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
235: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
236: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,

Line 233: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,

229: tav_information_category ota_activity_versions_vl.tav_information_category%TYPE,
230: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
231: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
232: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
233: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
234: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
235: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
236: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
237: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,

Line 234: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,

230: tav_information1 ota_activity_versions_vl.tav_information1%TYPE,
231: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
232: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
233: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
234: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
235: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
236: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
237: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
238: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,

Line 235: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,

231: tav_information2 ota_activity_versions_vl.tav_information2%TYPE,
232: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
233: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
234: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
235: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
236: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
237: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
238: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
239: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,

Line 236: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,

232: tav_information3 ota_activity_versions_vl.tav_information3%TYPE,
233: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
234: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
235: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
236: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
237: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
238: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
239: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
240: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,

Line 237: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,

233: tav_information4 ota_activity_versions_vl.tav_information4%TYPE,
234: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
235: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
236: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
237: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
238: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
239: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
240: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
241: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,

Line 238: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,

234: tav_information5 ota_activity_versions_vl.tav_information5%TYPE,
235: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
236: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
237: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
238: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
239: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
240: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
241: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
242: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,

Line 239: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,

235: tav_information6 ota_activity_versions_vl.tav_information6%TYPE,
236: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
237: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
238: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
239: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
240: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
241: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
242: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
243: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,

Line 240: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,

236: tav_information7 ota_activity_versions_vl.tav_information7%TYPE,
237: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
238: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
239: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
240: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
241: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
242: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
243: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
244: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,

Line 241: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,

237: tav_information8 ota_activity_versions_vl.tav_information8%TYPE,
238: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
239: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
240: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
241: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
242: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
243: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
244: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
245: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,

Line 242: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,

238: tav_information9 ota_activity_versions_vl.tav_information9%TYPE,
239: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
240: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
241: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
242: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
243: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
244: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
245: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
246: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,

Line 243: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,

239: tav_information10 ota_activity_versions_vl.tav_information10%TYPE,
240: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
241: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
242: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
243: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
244: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
245: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
246: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
247: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,

Line 244: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,

240: tav_information11 ota_activity_versions_vl.tav_information11%TYPE,
241: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
242: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
243: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
244: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
245: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
246: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
247: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
248: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,

Line 245: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,

241: tav_information12 ota_activity_versions_vl.tav_information12%TYPE,
242: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
243: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
244: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
245: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
246: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
247: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
248: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
249: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,

Line 246: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,

242: tav_information13 ota_activity_versions_vl.tav_information13%TYPE,
243: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
244: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
245: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
246: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
247: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
248: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
249: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
250: activity_version_code ota_activity_versions_vl.version_code%TYPE,

Line 247: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,

243: tav_information14 ota_activity_versions_vl.tav_information14%TYPE,
244: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
245: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
246: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
247: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
248: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
249: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
250: activity_version_code ota_activity_versions_vl.version_code%TYPE,
251: success_criteria hr_lookups.meaning%TYPE,

Line 248: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,

244: tav_information15 ota_activity_versions_vl.tav_information15%TYPE,
245: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
246: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
247: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
248: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
249: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
250: activity_version_code ota_activity_versions_vl.version_code%TYPE,
251: success_criteria hr_lookups.meaning%TYPE,
252: professional_credits ota_activity_versions_vl.professional_credits%TYPE,

Line 249: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,

245: tav_information16 ota_activity_versions_vl.tav_information16%TYPE,
246: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
247: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
248: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
249: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
250: activity_version_code ota_activity_versions_vl.version_code%TYPE,
251: success_criteria hr_lookups.meaning%TYPE,
252: professional_credits ota_activity_versions_vl.professional_credits%TYPE,
253: professional_credit_meaning hr_lookups.meaning%TYPE,

Line 250: activity_version_code ota_activity_versions_vl.version_code%TYPE,

246: tav_information17 ota_activity_versions_vl.tav_information17%TYPE,
247: tav_information18 ota_activity_versions_vl.tav_information18%TYPE,
248: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
249: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
250: activity_version_code ota_activity_versions_vl.version_code%TYPE,
251: success_criteria hr_lookups.meaning%TYPE,
252: professional_credits ota_activity_versions_vl.professional_credits%TYPE,
253: professional_credit_meaning hr_lookups.meaning%TYPE,
254: controlling_person_id ota_activity_versions.controlling_person_id%type,

Line 252: professional_credits ota_activity_versions_vl.professional_credits%TYPE,

248: tav_information19 ota_activity_versions_vl.tav_information19%TYPE,
249: tav_information20 ota_activity_versions_vl.tav_information20%TYPE,
250: activity_version_code ota_activity_versions_vl.version_code%TYPE,
251: success_criteria hr_lookups.meaning%TYPE,
252: professional_credits ota_activity_versions_vl.professional_credits%TYPE,
253: professional_credit_meaning hr_lookups.meaning%TYPE,
254: controlling_person_id ota_activity_versions.controlling_person_id%type,
255: events event_tabletype,
256: booking booking_rectype,

Line 254: controlling_person_id ota_activity_versions.controlling_person_id%type,

250: activity_version_code ota_activity_versions_vl.version_code%TYPE,
251: success_criteria hr_lookups.meaning%TYPE,
252: professional_credits ota_activity_versions_vl.professional_credits%TYPE,
253: professional_credit_meaning hr_lookups.meaning%TYPE,
254: controlling_person_id ota_activity_versions.controlling_person_id%type,
255: events event_tabletype,
256: booking booking_rectype,
257: event_action VARCHAR2(50)
258: );

Line 280: course_id ota_activity_versions.activity_id%TYPE DEFAULT NULL,

276: (
277: person_id ota_delegate_bookings.delegate_person_id%TYPE DEFAULT NULL,
278: start_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
279: end_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
280: course_id ota_activity_versions.activity_id%TYPE DEFAULT NULL,
281: delegate_booking_id ota_delegate_bookings.booking_id%TYPE DEFAULT NULL,
282: view_history BOOLEAN DEFAULT FALSE,
283: options query_options
284: );