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_CPE_UTIL dependencies on OTA_ATTEMPTS

Line 1602: FROM ota_attempts

1598: p_return_code OUT NOCOPY varchar2) IS
1599:
1600: CURSOR csr_attempt IS
1601: SELECT attempt_id
1602: FROM ota_attempts
1603: WHERE cert_prd_enrollment_id = p_cert_prd_enrollment_id
1604: FOR UPDATE;
1605:
1606: CURSOR csr_scorm_attempt(p_attempt_id ota_attempts.attempt_id%type) IS

Line 1606: CURSOR csr_scorm_attempt(p_attempt_id ota_attempts.attempt_id%type) IS

1602: FROM ota_attempts
1603: WHERE cert_prd_enrollment_id = p_cert_prd_enrollment_id
1604: FOR UPDATE;
1605:
1606: CURSOR csr_scorm_attempt(p_attempt_id ota_attempts.attempt_id%type) IS
1607: SELECT objective_id
1608: FROM OTA_SCORM_OBJ_ATTEMPTS
1609: WHERE attempt_id = p_attempt_id
1610: FOR UPDATE;

Line 1612: CURSOR csr_utest_ques(p_attempt_id ota_attempts.attempt_id%type) IS

1608: FROM OTA_SCORM_OBJ_ATTEMPTS
1609: WHERE attempt_id = p_attempt_id
1610: FOR UPDATE;
1611:
1612: CURSOR csr_utest_ques(p_attempt_id ota_attempts.attempt_id%type) IS
1613: SELECT USER_TEST_QUESTION_ID
1614: FROM OTA_UTEST_QUESTIONS
1615: WHERE attempt_id = p_attempt_id
1616: FOR UPDATE;

Line 1650: DELETE FROM OTA_ATTEMPTS

1646:
1647: END LOOP;
1648:
1649: --Delete the fetched attempt record
1650: DELETE FROM OTA_ATTEMPTS
1651: WHERE CURRENT OF csr_attempt;
1652:
1653: END LOOP;
1654: