APPS.OTA_CPE_UTIL dependencies on OTA_SCORM_OBJ_ATTEMPTS

Line 1594: FROM OTA_SCORM_OBJ_ATTEMPTS

1590: FOR UPDATE;
1591:
1592: CURSOR csr_scorm_attempt(p_attempt_id ota_attempts.attempt_id%type) IS
1593: SELECT objective_id
1594: FROM OTA_SCORM_OBJ_ATTEMPTS
1595: WHERE attempt_id = p_attempt_id
1596: FOR UPDATE;
1597:
1598: CURSOR csr_utest_ques(p_attempt_id ota_attempts.attempt_id%type) IS

Line 1617: DELETE FROM OTA_SCORM_OBJ_ATTEMPTS

1613: DELETE FROM OTA_SCORM_OBJ_PERFS
1614: WHERE objective_id = scorm_attempt_rec.objective_id;
1615:
1616: --Delete the fetched scorm attempt
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