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 1600: FROM OTA_UTEST_QUESTIONS

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

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

1617: DELETE FROM OTA_SCORM_OBJ_ATTEMPTS
1618: WHERE CURRENT OF csr_scorm_attempt;
1619: END LOOP;
1620:
1621: --Delete attempt specific test data, OTA_UTEST_QUESTIONS
1622: --OTA_UTEST_RESPONSES
1623: FOR utest_ques_rec IN csr_utest_ques(attempt_rec.attempt_id)
1624: LOOP
1625: --for each utest ques delete utest responses

Line 1630: DELETE FROM OTA_UTEST_QUESTIONS

1626: DELETE FROM OTA_UTEST_RESPONSES
1627: WHERE USER_TEST_QUESTION_ID = utest_ques_rec.USER_TEST_QUESTION_ID;
1628:
1629: --Delete the fetched utest ques record
1630: DELETE FROM OTA_UTEST_QUESTIONS
1631: WHERE CURRENT OF csr_utest_ques;
1632:
1633: END LOOP;
1634: