APPS.OTA_CPE_UTIL dependencies on OTA_SCORM_OBJ_ATTEMPTS

Line 1608: FROM OTA_SCORM_OBJ_ATTEMPTS

1604: FOR UPDATE;
1605:
1606: CURSOR csr_scorm_attempt(p_attempt_id ota_attempts.attempt_id%type) IS
1607: SELECT objective_id
1608: FROM OTA_SCORM_OBJ_ATTEMPTS
1609: WHERE attempt_id = p_attempt_id
1610: FOR UPDATE;
1611:
1612: CURSOR csr_utest_ques(p_attempt_id ota_attempts.attempt_id%type) IS

Line 1631: DELETE FROM OTA_SCORM_OBJ_ATTEMPTS

1627: DELETE FROM OTA_SCORM_OBJ_PERFS
1628: WHERE objective_id = scorm_attempt_rec.objective_id;
1629:
1630: --Delete the fetched scorm attempt
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