1303: l_count PLS_INTEGER;
1304: l_migrate_count PLS_INTEGER;
1305:
1306: CURSOR c_opm_grades IS
1307: SELECT * FROM gmd_grades_b
1308: WHERE migrated_ind is NULL;
1309:
1310: CURSOR c_opm_grades_tl (p_qc_grade VARCHAR2) IS
1311: SELECT * FROM gmd_grades_tl
1408: grade_code = gt.qc_grade AND
1409: language = gt.language;
1410: END LOOP;
1411:
1412: UPDATE gmd_grades_b
1413: SET migrated_ind = 1
1414: WHERE qc_grade = g.qc_grade;
1415:
1416: IF (p_commit <> FND_API.G_FALSE) THEN
1418: END IF;
1419: l_migrate_count := l_migrate_count + 1;
1420: EXCEPTION
1421: WHEN e_already_exists THEN
1422: UPDATE gmd_grades_b
1423: SET migrated_ind = 1
1424: WHERE qc_grade = g.qc_grade;
1425: END;
1426: END LOOP;