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_UTEST_QUESTIONS

Line 1614: FROM OTA_UTEST_QUESTIONS

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;
1617:
1618: l_return_code varchar2(1) := 'S';

Line 1635: --Delete attempt specific test data, OTA_UTEST_QUESTIONS

1631: DELETE FROM OTA_SCORM_OBJ_ATTEMPTS
1632: WHERE CURRENT OF csr_scorm_attempt;
1633: END LOOP;
1634:
1635: --Delete attempt specific test data, OTA_UTEST_QUESTIONS
1636: --OTA_UTEST_RESPONSES
1637: FOR utest_ques_rec IN csr_utest_ques(attempt_rec.attempt_id)
1638: LOOP
1639: --for each utest ques delete utest responses

Line 1644: DELETE FROM OTA_UTEST_QUESTIONS

1640: DELETE FROM OTA_UTEST_RESPONSES
1641: WHERE USER_TEST_QUESTION_ID = utest_ques_rec.USER_TEST_QUESTION_ID;
1642:
1643: --Delete the fetched utest ques record
1644: DELETE FROM OTA_UTEST_QUESTIONS
1645: WHERE CURRENT OF csr_utest_ques;
1646:
1647: END LOOP;
1648: