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_CERTIFICATIONS_B

Line 11: certification_id ota_certifications_b.certification_id%TYPE,

7: * @rep:displayname OTA_TRAINING_RECORD
8: */
9: TYPE cert_description_rectype IS RECORD
10: (
11: certification_id ota_certifications_b.certification_id%TYPE,
12: initial_completion_date ota_certifications_b.initial_completion_date%TYPE,
13: initial_completion_duration ota_certifications_b.initial_completion_duration%TYPE,
14: initial_compl_duration_units ota_certifications_b.initial_compl_duration_units%TYPE,
15: renewal_duration ota_certifications_b.renewal_duration%TYPE,

Line 12: initial_completion_date ota_certifications_b.initial_completion_date%TYPE,

8: */
9: TYPE cert_description_rectype IS RECORD
10: (
11: certification_id ota_certifications_b.certification_id%TYPE,
12: initial_completion_date ota_certifications_b.initial_completion_date%TYPE,
13: initial_completion_duration ota_certifications_b.initial_completion_duration%TYPE,
14: initial_compl_duration_units ota_certifications_b.initial_compl_duration_units%TYPE,
15: renewal_duration ota_certifications_b.renewal_duration%TYPE,
16: renewal_duration_units ota_certifications_b.renewal_duration_units%TYPE,

Line 13: initial_completion_duration ota_certifications_b.initial_completion_duration%TYPE,

9: TYPE cert_description_rectype IS RECORD
10: (
11: certification_id ota_certifications_b.certification_id%TYPE,
12: initial_completion_date ota_certifications_b.initial_completion_date%TYPE,
13: initial_completion_duration ota_certifications_b.initial_completion_duration%TYPE,
14: initial_compl_duration_units ota_certifications_b.initial_compl_duration_units%TYPE,
15: renewal_duration ota_certifications_b.renewal_duration%TYPE,
16: renewal_duration_units ota_certifications_b.renewal_duration_units%TYPE,
17: notify_days_before_expire ota_certifications_b.notify_days_before_expire%TYPE,

Line 14: initial_compl_duration_units ota_certifications_b.initial_compl_duration_units%TYPE,

10: (
11: certification_id ota_certifications_b.certification_id%TYPE,
12: initial_completion_date ota_certifications_b.initial_completion_date%TYPE,
13: initial_completion_duration ota_certifications_b.initial_completion_duration%TYPE,
14: initial_compl_duration_units ota_certifications_b.initial_compl_duration_units%TYPE,
15: renewal_duration ota_certifications_b.renewal_duration%TYPE,
16: renewal_duration_units ota_certifications_b.renewal_duration_units%TYPE,
17: notify_days_before_expire ota_certifications_b.notify_days_before_expire%TYPE,
18: validity_duration ota_certifications_b.validity_duration%TYPE,

Line 15: renewal_duration ota_certifications_b.renewal_duration%TYPE,

11: certification_id ota_certifications_b.certification_id%TYPE,
12: initial_completion_date ota_certifications_b.initial_completion_date%TYPE,
13: initial_completion_duration ota_certifications_b.initial_completion_duration%TYPE,
14: initial_compl_duration_units ota_certifications_b.initial_compl_duration_units%TYPE,
15: renewal_duration ota_certifications_b.renewal_duration%TYPE,
16: renewal_duration_units ota_certifications_b.renewal_duration_units%TYPE,
17: notify_days_before_expire ota_certifications_b.notify_days_before_expire%TYPE,
18: validity_duration ota_certifications_b.validity_duration%TYPE,
19: validity_duration_units ota_certifications_b.validity_duration_units%TYPE,

Line 16: renewal_duration_units ota_certifications_b.renewal_duration_units%TYPE,

12: initial_completion_date ota_certifications_b.initial_completion_date%TYPE,
13: initial_completion_duration ota_certifications_b.initial_completion_duration%TYPE,
14: initial_compl_duration_units ota_certifications_b.initial_compl_duration_units%TYPE,
15: renewal_duration ota_certifications_b.renewal_duration%TYPE,
16: renewal_duration_units ota_certifications_b.renewal_duration_units%TYPE,
17: notify_days_before_expire ota_certifications_b.notify_days_before_expire%TYPE,
18: validity_duration ota_certifications_b.validity_duration%TYPE,
19: validity_duration_units ota_certifications_b.validity_duration_units%TYPE,
20: renewable_flag_code ota_certifications_b.renewable_flag%TYPE,

Line 17: notify_days_before_expire ota_certifications_b.notify_days_before_expire%TYPE,

13: initial_completion_duration ota_certifications_b.initial_completion_duration%TYPE,
14: initial_compl_duration_units ota_certifications_b.initial_compl_duration_units%TYPE,
15: renewal_duration ota_certifications_b.renewal_duration%TYPE,
16: renewal_duration_units ota_certifications_b.renewal_duration_units%TYPE,
17: notify_days_before_expire ota_certifications_b.notify_days_before_expire%TYPE,
18: validity_duration ota_certifications_b.validity_duration%TYPE,
19: validity_duration_units ota_certifications_b.validity_duration_units%TYPE,
20: renewable_flag_code ota_certifications_b.renewable_flag%TYPE,
21: renewable_flag_meaning hr_lookups.meaning%TYPE,

Line 18: validity_duration ota_certifications_b.validity_duration%TYPE,

14: initial_compl_duration_units ota_certifications_b.initial_compl_duration_units%TYPE,
15: renewal_duration ota_certifications_b.renewal_duration%TYPE,
16: renewal_duration_units ota_certifications_b.renewal_duration_units%TYPE,
17: notify_days_before_expire ota_certifications_b.notify_days_before_expire%TYPE,
18: validity_duration ota_certifications_b.validity_duration%TYPE,
19: validity_duration_units ota_certifications_b.validity_duration_units%TYPE,
20: renewable_flag_code ota_certifications_b.renewable_flag%TYPE,
21: renewable_flag_meaning hr_lookups.meaning%TYPE,
22: start_date_active ota_certifications_b.start_date_active%TYPE,

Line 19: validity_duration_units ota_certifications_b.validity_duration_units%TYPE,

15: renewal_duration ota_certifications_b.renewal_duration%TYPE,
16: renewal_duration_units ota_certifications_b.renewal_duration_units%TYPE,
17: notify_days_before_expire ota_certifications_b.notify_days_before_expire%TYPE,
18: validity_duration ota_certifications_b.validity_duration%TYPE,
19: validity_duration_units ota_certifications_b.validity_duration_units%TYPE,
20: renewable_flag_code ota_certifications_b.renewable_flag%TYPE,
21: renewable_flag_meaning hr_lookups.meaning%TYPE,
22: start_date_active ota_certifications_b.start_date_active%TYPE,
23: end_date_active ota_certifications_b.end_date_active%TYPE,

Line 20: renewable_flag_code ota_certifications_b.renewable_flag%TYPE,

16: renewal_duration_units ota_certifications_b.renewal_duration_units%TYPE,
17: notify_days_before_expire ota_certifications_b.notify_days_before_expire%TYPE,
18: validity_duration ota_certifications_b.validity_duration%TYPE,
19: validity_duration_units ota_certifications_b.validity_duration_units%TYPE,
20: renewable_flag_code ota_certifications_b.renewable_flag%TYPE,
21: renewable_flag_meaning hr_lookups.meaning%TYPE,
22: start_date_active ota_certifications_b.start_date_active%TYPE,
23: end_date_active ota_certifications_b.end_date_active%TYPE,
24: name ota_certifications_tl.name%TYPE,

Line 22: start_date_active ota_certifications_b.start_date_active%TYPE,

18: validity_duration ota_certifications_b.validity_duration%TYPE,
19: validity_duration_units ota_certifications_b.validity_duration_units%TYPE,
20: renewable_flag_code ota_certifications_b.renewable_flag%TYPE,
21: renewable_flag_meaning hr_lookups.meaning%TYPE,
22: start_date_active ota_certifications_b.start_date_active%TYPE,
23: end_date_active ota_certifications_b.end_date_active%TYPE,
24: name ota_certifications_tl.name%TYPE,
25: description ota_certifications_tl.description%TYPE,
26: objectives ota_certifications_tl.objectives%TYPE,

Line 23: end_date_active ota_certifications_b.end_date_active%TYPE,

19: validity_duration_units ota_certifications_b.validity_duration_units%TYPE,
20: renewable_flag_code ota_certifications_b.renewable_flag%TYPE,
21: renewable_flag_meaning hr_lookups.meaning%TYPE,
22: start_date_active ota_certifications_b.start_date_active%TYPE,
23: end_date_active ota_certifications_b.end_date_active%TYPE,
24: name ota_certifications_tl.name%TYPE,
25: description ota_certifications_tl.description%TYPE,
26: objectives ota_certifications_tl.objectives%TYPE,
27: purpose ota_certifications_tl.purpose%TYPE,

Line 102: renewable_flag ota_certifications_b.renewable_flag%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,
106: start_date_active ota_certifications_b.start_date_active%TYPE,

Line 106: start_date_active ota_certifications_b.start_date_active%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,
110: cert_competencies cert_competencies_tabletype,

Line 107: end_date_active ota_certifications_b.end_date_active%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,
110: cert_competencies cert_competencies_tabletype,
111: cert_components components_tabletype,

Line 270: certification_id ota_certifications_b.certification_id%TYPE DEFAULT NULL,

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
274: );