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 134: PROCEDURE get_completed_certifications(p_start_person_id IN ota_cert_enrollments.person_id%TYPE

130: CLOSE cur_event;
131: p_events_tbl := l_events_tbl;
132: END get_events;
133:
134: PROCEDURE get_completed_certifications(p_start_person_id IN ota_cert_enrollments.person_id%TYPE
135: ,p_end_person_id IN ota_cert_enrollments.person_id%TYPE
136: ,p_certification_tbl OUT NOCOPY certification_tabletype)
137: IS
138: CURSOR get_certification IS

Line 135: ,p_end_person_id IN ota_cert_enrollments.person_id%TYPE

131: p_events_tbl := l_events_tbl;
132: END get_events;
133:
134: PROCEDURE get_completed_certifications(p_start_person_id IN ota_cert_enrollments.person_id%TYPE
135: ,p_end_person_id IN ota_cert_enrollments.person_id%TYPE
136: ,p_certification_tbl OUT NOCOPY certification_tabletype)
137: IS
138: CURSOR get_certification IS
139: SELECT ctl.name cert_name,

Line 161: ,ota_cert_enrollments cre

157: crt.start_date_active,
158: crt.end_date_active
159: FROM ota_certifications_b crt
160: ,ota_certifications_tl ctl
161: ,ota_cert_enrollments cre
162: ,ota_cert_prd_enrollments cpe
163: ,hr_lookups cpe_lkp
164: WHERE cre.person_id BETWEEN nvl(p_start_person_id, cre.person_id)
165: AND nvl(p_end_person_id, cre.person_id)

Line 216: PROCEDURE get_certifications(p_person_id IN ota_cert_enrollments.person_id%TYPE

212: CLOSE get_certification;
213: p_certification_tbl := l_certification_tbl;
214: END get_completed_certifications;
215:
216: PROCEDURE get_certifications(p_person_id IN ota_cert_enrollments.person_id%TYPE
217: ,p_start_person_id IN ota_cert_enrollments.person_id%TYPE
218: ,p_end_person_id IN ota_cert_enrollments.person_id%TYPE
219: ,p_is_history_flag IN varchar2
220: ,p_certification_tbl OUT NOCOPY certification_tabletype)

Line 217: ,p_start_person_id IN ota_cert_enrollments.person_id%TYPE

213: p_certification_tbl := l_certification_tbl;
214: END get_completed_certifications;
215:
216: PROCEDURE get_certifications(p_person_id IN ota_cert_enrollments.person_id%TYPE
217: ,p_start_person_id IN ota_cert_enrollments.person_id%TYPE
218: ,p_end_person_id IN ota_cert_enrollments.person_id%TYPE
219: ,p_is_history_flag IN varchar2
220: ,p_certification_tbl OUT NOCOPY certification_tabletype)
221: IS

Line 218: ,p_end_person_id IN ota_cert_enrollments.person_id%TYPE

214: END get_completed_certifications;
215:
216: PROCEDURE get_certifications(p_person_id IN ota_cert_enrollments.person_id%TYPE
217: ,p_start_person_id IN ota_cert_enrollments.person_id%TYPE
218: ,p_end_person_id IN ota_cert_enrollments.person_id%TYPE
219: ,p_is_history_flag IN varchar2
220: ,p_certification_tbl OUT NOCOPY certification_tabletype)
221: IS
222: CURSOR get_certification IS

Line 245: ,ota_cert_enrollments cre

241: crt.start_date_active,
242: crt.end_date_active
243: FROM ota_certifications_b crt
244: ,ota_certifications_tl ctl
245: ,ota_cert_enrollments cre
246: ,ota_cert_prd_enrollments cpe
247: ,hr_lookups cpe_lkp
248: WHERE
249: nvl(p_person_id, cre.person_id) = cre.person_id

Line 317: PROCEDURE get_certifications(p_person_id IN ota_cert_enrollments.person_id%TYPE

313: CLOSE get_certification;
314: p_certification_tbl := l_certification_tbl;
315: END get_certifications;
316:
317: PROCEDURE get_certifications(p_person_id IN ota_cert_enrollments.person_id%TYPE
318: ,p_certification_id IN ota_cert_enrollments.certification_id%TYPE
319: ,p_certification_tbl OUT NOCOPY certification_tabletype)
320: IS
321: CURSOR get_certification IS

Line 318: ,p_certification_id IN ota_cert_enrollments.certification_id%TYPE

314: p_certification_tbl := l_certification_tbl;
315: END get_certifications;
316:
317: PROCEDURE get_certifications(p_person_id IN ota_cert_enrollments.person_id%TYPE
318: ,p_certification_id IN ota_cert_enrollments.certification_id%TYPE
319: ,p_certification_tbl OUT NOCOPY certification_tabletype)
320: IS
321: CURSOR get_certification IS
322: select ctl.name cert_name,

Line 344: ,ota_cert_enrollments cre

340: crt.start_date_active,
341: crt.end_date_active
342: FROM ota_certifications_b crt
343: ,ota_certifications_tl ctl
344: ,ota_cert_enrollments cre
345: ,ota_cert_prd_enrollments cpe
346: ,hr_lookups cpe_lkp
347: WHERE ((p_person_id IS NULL) OR (p_person_id IS NOT NULL AND cre.person_id = p_person_id))
348: AND ((p_certification_id IS NULL) OR (cre.certification_id = p_certification_id))

Line 401: p_cert_enrollment_id IN ota_cert_enrollments.cert_enrollment_id%TYPE,

397: p_certification_tbl := l_certification_tbl;
398: END get_certifications;
399:
400: PROCEDURE get_certification_description(p_certification_id IN ota_certifications_b.certification_id%TYPE,
401: p_cert_enrollment_id IN ota_cert_enrollments.cert_enrollment_id%TYPE,
402: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
403: p_certification_desc_rec OUT NOCOPY cert_description_rectype)
404: IS
405: CURSOR get_cert_description IS

Line 447: FROM ota_cert_enrollments cre

443: , cpe.cert_period_end_date cert_period_end_date
444: , cre.cert_enrollment_id cert_enrollment_id
445: , cpe.cert_prd_enrollment_id cert_prd_enrollment_id
446: , cre.completion_date cre_completion_date
447: FROM ota_cert_enrollments cre
448: , ota_cert_prd_enrollments cpe
449: , hr_lookups crt_lkp
450: , hr_lookups cpe_lkp
451: WHERE cre.cert_enrollment_id = cpe.cert_enrollment_id (+)

Line 587: from ota_cert_enrollments cre,

583: (select e.offering_id
584: from ota_events e
585: where e.event_id = OTA_LO_UTILITY.get_cme_online_event_id(NVL(cre.person_id, cre.contact_id),
586: DECODE(cre.person_id, NULL, 'C', 'E'), cme.cert_mbr_enrollment_id))AS CLASSROOM_ID
587: from ota_cert_enrollments cre,
588: ota_cert_prd_enrollments cpe,
589: ota_cert_mbr_enrollments cme,
590: ota_certification_members cmb,
591: ota_activity_versions_vl tav,

Line 625: PROCEDURE get_learner(p_cert_enrollment_id IN ota_cert_enrollments.cert_enrollment_id%TYPE,

621: CLOSE get_components;
622: p_components_tbl := l_components_tbl;
623: END get_cert_components;
624:
625: PROCEDURE get_learner(p_cert_enrollment_id IN ota_cert_enrollments.cert_enrollment_id%TYPE,
626: p_person_id OUT NOCOPY ota_cert_enrollments.person_id%TYPE,
627: p_certification_id OUT NOCOPY ota_cert_enrollments.certification_id%TYPE)
628: IS
629: CURSOR get_info IS

Line 626: p_person_id OUT NOCOPY ota_cert_enrollments.person_id%TYPE,

622: p_components_tbl := l_components_tbl;
623: END get_cert_components;
624:
625: PROCEDURE get_learner(p_cert_enrollment_id IN ota_cert_enrollments.cert_enrollment_id%TYPE,
626: p_person_id OUT NOCOPY ota_cert_enrollments.person_id%TYPE,
627: p_certification_id OUT NOCOPY ota_cert_enrollments.certification_id%TYPE)
628: IS
629: CURSOR get_info IS
630: SELECT oce.person_id,

Line 627: p_certification_id OUT NOCOPY ota_cert_enrollments.certification_id%TYPE)

623: END get_cert_components;
624:
625: PROCEDURE get_learner(p_cert_enrollment_id IN ota_cert_enrollments.cert_enrollment_id%TYPE,
626: p_person_id OUT NOCOPY ota_cert_enrollments.person_id%TYPE,
627: p_certification_id OUT NOCOPY ota_cert_enrollments.certification_id%TYPE)
628: IS
629: CURSOR get_info IS
630: SELECT oce.person_id,
631: oce.certification_id

Line 632: FROM ota_cert_enrollments oce

628: IS
629: CURSOR get_info IS
630: SELECT oce.person_id,
631: oce.certification_id
632: FROM ota_cert_enrollments oce
633: WHERE oce.cert_enrollment_id = p_cert_enrollment_id;
634:
635: l_person_id ota_cert_enrollments.person_id%TYPE;
636: l_certification_id ota_cert_enrollments.certification_id%TYPE;

Line 635: l_person_id ota_cert_enrollments.person_id%TYPE;

631: oce.certification_id
632: FROM ota_cert_enrollments oce
633: WHERE oce.cert_enrollment_id = p_cert_enrollment_id;
634:
635: l_person_id ota_cert_enrollments.person_id%TYPE;
636: l_certification_id ota_cert_enrollments.certification_id%TYPE;
637:
638: BEGIN
639: OPEN get_info;

Line 636: l_certification_id ota_cert_enrollments.certification_id%TYPE;

632: FROM ota_cert_enrollments oce
633: WHERE oce.cert_enrollment_id = p_cert_enrollment_id;
634:
635: l_person_id ota_cert_enrollments.person_id%TYPE;
636: l_certification_id ota_cert_enrollments.certification_id%TYPE;
637:
638: BEGIN
639: OPEN get_info;
640: FETCH get_info into l_person_id, l_certification_id;

Line 662: l_person_id ota_cert_enrollments.person_id%TYPE := NULL;

658: l_certification_tbl certification_tabletype;
659: l_competencies_tbl cert_competencies_tabletype;
660: l_components_tbl components_tabletype;
661:
662: l_person_id ota_cert_enrollments.person_id%TYPE := NULL;
663: l_certification_id ota_cert_enrollments.certification_id%TYPE := NULL;
664:
665: l_details_required BOOLEAN := FALSE;
666: l_competencies_required BOOLEAN := FALSE;

Line 663: l_certification_id ota_cert_enrollments.certification_id%TYPE := NULL;

659: l_competencies_tbl cert_competencies_tabletype;
660: l_components_tbl components_tabletype;
661:
662: l_person_id ota_cert_enrollments.person_id%TYPE := NULL;
663: l_certification_id ota_cert_enrollments.certification_id%TYPE := NULL;
664:
665: l_details_required BOOLEAN := FALSE;
666: l_competencies_required BOOLEAN := FALSE;
667: l_components_required BOOLEAN := FALSE;

Line 751: p_cert_enrollment_id OUT NOCOPY ota_cert_enrollments.cert_enrollment_id%TYPE) RETURN BOOLEAN

747: p_certifications := certification_tabletype();
748: END get_certification_details;
749:
750: FUNCTION is_part_of_certification(p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
751: p_cert_enrollment_id OUT NOCOPY ota_cert_enrollments.cert_enrollment_id%TYPE) RETURN BOOLEAN
752: IS
753:
754: CURSOR get_enrollments IS
755: SELECT *

Line 775: ota_cert_enrollments cre,

771: hr_all_organization_units_tl haotl,
772: ota_activity_versions a,
773: ota_delegate_bookings b,
774: ota_booking_status_types_VL s,
775: ota_cert_enrollments cre,
776: ota_cert_prd_enrollments cpe,
777: ota_cert_mbr_enrollments cme,
778: ota_certification_members cmb,
779: ota_offerings ofr,

Line 1413: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;

1409: p_ispartofcertification OUT NOCOPY BOOLEAN)
1410: IS
1411: l_person_id ota_delegate_bookings.delegate_person_id%TYPE := NULL;
1412: l_activity_version_id ota_activity_versions.activity_id%TYPE := NULL;
1413: l_cert_enrollment_id ota_cert_enrollments.cert_enrollment_id%TYPE;
1414: l_event_id ota_events.event_id%TYPE := NULL;
1415: l_activity_rec activity_rectype;
1416: l_event_rec event_rectype;
1417: