1211: l_count PLS_INTEGER;
1212: l_migrate_count PLS_INTEGER;
1213:
1214: CURSOR c_opm_grades IS
1215: SELECT * FROM gmd_grades_b
1216: WHERE migrated_ind is NULL;
1217:
1218: CURSOR c_opm_grades_tl (p_qc_grade VARCHAR2) IS
1219: SELECT * FROM gmd_grades_tl
1316: grade_code = gt.qc_grade AND
1317: language = gt.language;
1318: END LOOP;
1319:
1320: UPDATE gmd_grades_b
1321: SET migrated_ind = 1
1322: WHERE qc_grade = g.qc_grade;
1323:
1324: IF (p_commit <> FND_API.G_FALSE) THEN
1326: END IF;
1327: l_migrate_count := l_migrate_count + 1;
1328: EXCEPTION
1329: WHEN e_already_exists THEN
1330: UPDATE gmd_grades_b
1331: SET migrated_ind = 1
1332: WHERE qc_grade = g.qc_grade;
1333: END;
1334: END LOOP;