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_PRD_ENROLLMENTS

Line 33: period_status_code ota_cert_prd_enrollments.period_status_code%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,
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,

Line 37: cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%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,
41: cre_completion_date ota_cert_enrollments.completion_date%TYPE

Line 38: cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%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,
41: cre_completion_date ota_cert_enrollments.completion_date%TYPE
42: );

Line 40: cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%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:
44: TYPE cert_comp_rectype IS RECORD(

Line 92: period_status_code ota_cert_prd_enrollments.period_status_code%TYPE,

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

Line 94: cert_period_start_date ota_cert_prd_enrollments.cert_period_start_date%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,
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,

Line 95: cert_period_end_date ota_cert_prd_enrollments.cert_period_end_date%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,
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,

Line 96: cre_completion_date ota_cert_prd_enrollments.completion_date%TYPE,

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

Line 100: cert_prd_enrollment_id ota_cert_prd_enrollments.cert_prd_enrollment_id%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),
104: earliest_enroll_date ota_cert_enrollments.earliest_enroll_date%TYPE,

Line 105: expiration_date ota_cert_prd_enrollments.expiration_date%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,
109: cert_description cert_description_rectype,