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_LO_UTILITY

Line 571: OTA_LO_UTILITY.get_cme_online_event_id(NVL(cre.person_id, cre.contact_id),

567: tav.Start_Date Start_Date,
568: tav.End_Date End_Date,
569: cmb.certification_member_id certification_member_id,
570: cmb.MEMBER_SEQUENCE MEMBER_SEQUENCE,
571: OTA_LO_UTILITY.get_cme_online_event_id(NVL(cre.person_id, cre.contact_id),
572: DECODE(cre.person_id, NULL, 'C', 'E'),
573: cme.cert_mbr_enrollment_id) as Event_Id,
574: OTA_LO_UTILITY.get_cert_lo_status(NVL(cre.person_id, cre.contact_id),
575: DECODE(cre.person_id, NULL, 'C', 'E'),

Line 574: OTA_LO_UTILITY.get_cert_lo_status(NVL(cre.person_id, cre.contact_id),

570: cmb.MEMBER_SEQUENCE MEMBER_SEQUENCE,
571: OTA_LO_UTILITY.get_cme_online_event_id(NVL(cre.person_id, cre.contact_id),
572: DECODE(cre.person_id, NULL, 'C', 'E'),
573: cme.cert_mbr_enrollment_id) as Event_Id,
574: OTA_LO_UTILITY.get_cert_lo_status(NVL(cre.person_id, cre.contact_id),
575: DECODE(cre.person_id, NULL, 'C', 'E'),
576: cme.cert_mbr_enrollment_id) as Perf_Status, cme.Cert_Prd_Enrollment_Id,
577: cre.Cert_Enrollment_Id,
578: cre.Certification_Id,

Line 585: where e.event_id = OTA_LO_UTILITY.get_cme_online_event_id(NVL(cre.person_id, cre.contact_id),

581: fnd_profile.value('USERNAME') AS FND_USER_NAME ,
582: WFA_HTML.CONV_SPECIAL_URL_CHARS(fnd_profile.value('OTA_ILEARNING_SITE_ADDRESS')) Encoded_Site_Address ,
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,

Line 862: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), null) player_status

858: a.professional_credits,
859: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
860: a.Controlling_Person_Id Controlling_Person_Id,
861: ST.NAME status,
862: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), null) player_status
863: ,D.BOOKING_ID
864: ,D.DELEGATE_PERSON_ID
865: ,D.IS_HISTORY_FLAG
866: ,D.DATE_STATUS_CHANGED

Line 1037: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), null) player_status

1033: a.professional_credits,
1034: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1035: a.Controlling_Person_Id Controlling_Person_Id,
1036: ST.NAME status,
1037: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), null) player_status
1038: ,D.BOOKING_ID
1039: ,D.DELEGATE_PERSON_ID
1040: ,D.IS_HISTORY_FLAG
1041: ,D.DATE_STATUS_CHANGED

Line 1275: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), null) player_status

1271: a.professional_credits,
1272: hr_general.decode_lookup('PROFESSIONAL_CREDIT_TYPE', a.professional_credit_type) Professional_Credit_Meaning,
1273: a.Controlling_Person_Id Controlling_Person_Id,
1274: ST.NAME status,
1275: DECODE(C.ONLINE_FLAG ,'Y',OTA_LO_UTILITY.get_enroll_lo_status(NVL(D.delegate_person_id, D.contact_id), DECODE(D.delegate_person_id, NULL, 'C', 'E') , E.EVENT_ID,D.BOOKING_STATUS_TYPE_ID,D.BOOKING_ID,null,'N'), null) player_status
1276: ,D.BOOKING_ID
1277: ,D.DELEGATE_PERSON_ID
1278: ,D.IS_HISTORY_FLAG
1279: ,D.DATE_STATUS_CHANGED