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_CERT_ENROLLMENTS

Line 31: certification_status_code ota_cert_enrollments.certification_status_code%TYPE,

27: purpose ota_certifications_tl.purpose%TYPE,
28: keywords ota_certifications_tl.keywords%TYPE,
29: initial_period_comments ota_certifications_tl.initial_period_comments%TYPE,
30: renewal_period_comments ota_certifications_tl.renewal_period_comments%TYPE,
31: certification_status_code ota_cert_enrollments.certification_status_code%TYPE,
32: cert_status_meaning hr_lookups.meaning%TYPE,
33: period_status_code ota_cert_prd_enrollments.period_status_code%TYPE,
34: period_status_meaning hr_lookups.meaning%TYPE,
35: expiration_date ota_cert_enrollments.expiration_date%TYPE,

Line 35: expiration_date ota_cert_enrollments.expiration_date%TYPE,

31: certification_status_code ota_cert_enrollments.certification_status_code%TYPE,
32: cert_status_meaning hr_lookups.meaning%TYPE,
33: period_status_code ota_cert_prd_enrollments.period_status_code%TYPE,
34: period_status_meaning hr_lookups.meaning%TYPE,
35: expiration_date ota_cert_enrollments.expiration_date%TYPE,
36: earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%TYPE,
37: cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%TYPE,
38: cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%TYPE,
39: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE,

Line 36: earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%TYPE,

32: cert_status_meaning hr_lookups.meaning%TYPE,
33: period_status_code ota_cert_prd_enrollments.period_status_code%TYPE,
34: period_status_meaning hr_lookups.meaning%TYPE,
35: expiration_date ota_cert_enrollments.expiration_date%TYPE,
36: earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%TYPE,
37: cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%TYPE,
38: cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%TYPE,
39: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE,
40: cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,

Line 39: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE,

35: expiration_date ota_cert_enrollments.expiration_date%TYPE,
36: earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%TYPE,
37: cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%TYPE,
38: cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%TYPE,
39: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE,
40: cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
41: cre_completion_date ota_cert_enrollments.completion_date%TYPE
42: );
43:

Line 41: cre_completion_date ota_cert_enrollments.completion_date%TYPE

37: cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%TYPE,
38: cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%TYPE,
39: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE,
40: cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
41: cre_completion_date ota_cert_enrollments.completion_date%TYPE
42: );
43:
44: TYPE cert_comp_rectype IS RECORD(
45: competence_id per_competence_elements.competence_id%TYPE,

Line 73: cert_enrollment_id ota_cert_enrollments.cert_enrollment_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,
72: cert_prd_enrollment_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%TYPE,
73: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE,
74: certification_id ota_cert_enrollments.certification_id%TYPE,
75: site_address varchar2(255),
76: site_short_name varchar2(255),
77: fnd_user_name varchar2(255),

Line 74: certification_id ota_cert_enrollments.certification_id%TYPE,

70: event_id ota_events.event_id%TYPE,
71: perf_status ota_booking_status_types_tl.name%TYPE,
72: cert_prd_enrollment_id ota_cert_mbr_enrollments.cert_prd_enrollment_id%TYPE,
73: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE,
74: certification_id ota_cert_enrollments.certification_id%TYPE,
75: site_address varchar2(255),
76: site_short_name varchar2(255),
77: fnd_user_name varchar2(255),
78: encoded_site_address varchar2(32767),

Line 89: certification_id ota_cert_enrollments.certification_id%TYPE,

85:
86: TYPE certification_rectype IS RECORD
87: (
88: cert_name ota_certifications_tl.name%TYPE,
89: certification_id ota_cert_enrollments.certification_id%TYPE,
90: certification_status_code ota_cert_enrollments.certification_status_code%TYPE,
91: cert_status_meaning varchar2(240),
92: period_status_code ota_cert_prd_enrollments.period_status_code%TYPE,
93: period_status_meaning hr_lookups.meaning%TYPE,

Line 90: certification_status_code ota_cert_enrollments.certification_status_code%TYPE,

86: TYPE certification_rectype IS RECORD
87: (
88: cert_name ota_certifications_tl.name%TYPE,
89: certification_id ota_cert_enrollments.certification_id%TYPE,
90: certification_status_code ota_cert_enrollments.certification_status_code%TYPE,
91: cert_status_meaning varchar2(240),
92: period_status_code ota_cert_prd_enrollments.period_status_code%TYPE,
93: period_status_meaning hr_lookups.meaning%TYPE,
94: cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%TYPE,

Line 97: person_id ota_cert_enrollments.person_id%TYPE,

93: period_status_meaning hr_lookups.meaning%TYPE,
94: cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%TYPE,
95: cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%TYPE,
96: cre_completion_date ota_cert_prd_enrollments.completion_date%TYPE,
97: person_id ota_cert_enrollments.person_id%TYPE,
98: contact_id ota_cert_enrollments.contact_id%TYPE,
99: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE,
100: cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
101: is_history_flag ota_cert_enrollments.is_history_flag%TYPE,

Line 98: contact_id ota_cert_enrollments.contact_id%TYPE,

94: cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%TYPE,
95: cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%TYPE,
96: cre_completion_date ota_cert_prd_enrollments.completion_date%TYPE,
97: person_id ota_cert_enrollments.person_id%TYPE,
98: contact_id ota_cert_enrollments.contact_id%TYPE,
99: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE,
100: cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
101: is_history_flag ota_cert_enrollments.is_history_flag%TYPE,
102: renewable_flag ota_certifications_b.renewable_flag%TYPE,

Line 99: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE,

95: cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%TYPE,
96: cre_completion_date ota_cert_prd_enrollments.completion_date%TYPE,
97: person_id ota_cert_enrollments.person_id%TYPE,
98: contact_id ota_cert_enrollments.contact_id%TYPE,
99: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE,
100: cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
101: is_history_flag ota_cert_enrollments.is_history_flag%TYPE,
102: renewable_flag ota_certifications_b.renewable_flag%TYPE,
103: is_period_renewable VARCHAR2(1),

Line 101: is_history_flag ota_cert_enrollments.is_history_flag%TYPE,

97: person_id ota_cert_enrollments.person_id%TYPE,
98: contact_id ota_cert_enrollments.contact_id%TYPE,
99: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE,
100: cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
101: is_history_flag ota_cert_enrollments.is_history_flag%TYPE,
102: renewable_flag ota_certifications_b.renewable_flag%TYPE,
103: is_period_renewable VARCHAR2(1),
104: earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%TYPE,
105: expiration_date ota_cert_prd_enrollments.expiration_date%TYPE,

Line 104: earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%TYPE,

100: cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
101: is_history_flag ota_cert_enrollments.is_history_flag%TYPE,
102: renewable_flag ota_certifications_b.renewable_flag%TYPE,
103: is_period_renewable VARCHAR2(1),
104: earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%TYPE,
105: expiration_date ota_cert_prd_enrollments.expiration_date%TYPE,
106: start_date_active ota_certifications_b.start_date_active%TYPE,
107: end_date_active ota_certifications_b.end_date_active%TYPE,
108: cert_enrollment_id2 ota_cert_enrollments.cert_enrollment_id%TYPE,

Line 108: cert_enrollment_id2 ota_cert_enrollments.cert_enrollment_id%TYPE,

104: earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%TYPE,
105: expiration_date ota_cert_prd_enrollments.expiration_date%TYPE,
106: start_date_active ota_certifications_b.start_date_active%TYPE,
107: end_date_active ota_certifications_b.end_date_active%TYPE,
108: cert_enrollment_id2 ota_cert_enrollments.cert_enrollment_id%TYPE,
109: cert_description cert_description_rectype,
110: cert_competencies cert_competencies_tabletype,
111: cert_components components_tabletype,
112: event_action VARCHAR2(50)

Line 267: person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,

263: TYPE query_options IS TABLE OF VARCHAR2(200) INDEX BY BINARY_INTEGER;
264:
265: TYPE cert_query_input_rectype IS RECORD
266: (
267: person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
268: start_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
269: end_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
270: certification_id ota_certifications_b.certification_id%TYPE DEFAULT NULL,
271: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE DEFAULT NULL,

Line 268: start_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,

264:
265: TYPE cert_query_input_rectype IS RECORD
266: (
267: person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
268: start_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
269: end_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
270: certification_id ota_certifications_b.certification_id%TYPE DEFAULT NULL,
271: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE DEFAULT NULL,
272: view_history BOOLEAN DEFAULT FALSE,

Line 269: end_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,

265: TYPE cert_query_input_rectype IS RECORD
266: (
267: person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
268: start_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
269: end_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
270: certification_id ota_certifications_b.certification_id%TYPE DEFAULT NULL,
271: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE DEFAULT NULL,
272: view_history BOOLEAN DEFAULT FALSE,
273: options query_options

Line 271: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE DEFAULT NULL,

267: person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
268: start_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
269: end_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
270: certification_id ota_certifications_b.certification_id%TYPE DEFAULT NULL,
271: cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE DEFAULT NULL,
272: view_history BOOLEAN DEFAULT FALSE,
273: options query_options
274: );
275:

Line 279: start_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,

275:
276: TYPE course_query_input_rectype IS RECORD
277: (
278: person_id ota_delegate_bookings.delegate_person_id%TYPE DEFAULT NULL,
279: start_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
280: end_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,
281: course_id ota_activity_versions.activity_id%TYPE DEFAULT NULL,
282: delegate_booking_id ota_delegate_bookings.booking_id%TYPE DEFAULT NULL,
283: view_history BOOLEAN DEFAULT FALSE,

Line 280: end_person_id ota_cert_enrollments.person_id%TYPE DEFAULT NULL,

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