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 1588: FROM ota_attempts

1584: p_return_code OUT NOCOPY varchar2) IS
1585:
1586: CURSOR csr_attempt IS
1587: SELECT attempt_id
1588: FROM ota_attempts
1589: WHERE cert_prd_enrollment_id = p_cert_prd_enrollment_id
1590: FOR UPDATE;
1591:
1592: CURSOR csr_scorm_attempt(p_attempt_id ota_attempts.attempt_id%type) IS

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

1588: FROM ota_attempts
1589: WHERE cert_prd_enrollment_id = p_cert_prd_enrollment_id
1590: FOR UPDATE;
1591:
1592: CURSOR csr_scorm_attempt(p_attempt_id ota_attempts.attempt_id%type) IS
1593: SELECT objective_id
1594: FROM OTA_SCORM_OBJ_ATTEMPTS
1595: WHERE attempt_id = p_attempt_id
1596: FOR UPDATE;

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

1594: FROM OTA_SCORM_OBJ_ATTEMPTS
1595: WHERE attempt_id = p_attempt_id
1596: FOR UPDATE;
1597:
1598: CURSOR csr_utest_ques(p_attempt_id ota_attempts.attempt_id%type) IS
1599: SELECT USER_TEST_QUESTION_ID
1600: FROM OTA_UTEST_QUESTIONS
1601: WHERE attempt_id = p_attempt_id
1602: FOR UPDATE;

Line 1636: DELETE FROM OTA_ATTEMPTS

1632:
1633: END LOOP;
1634:
1635: --Delete the fetched attempt record
1636: DELETE FROM OTA_ATTEMPTS
1637: WHERE CURRENT OF csr_attempt;
1638:
1639: END LOOP;
1640: