DBA Data[Home] [Help]

APPS.OTA_CPE_UTIL dependencies on OTA_UTEST_RESPONSES

Line 1622: --OTA_UTEST_RESPONSES

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

Line 1626: DELETE FROM OTA_UTEST_RESPONSES

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