DBA Data[Home] [Help]

APPS.OTA_CPE_UTIL dependencies on OTA_UTEST_RESPONSES

Line 1636: --OTA_UTEST_RESPONSES

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
1640: DELETE FROM OTA_UTEST_RESPONSES

Line 1640: DELETE FROM OTA_UTEST_RESPONSES

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
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