DBA Data[Home] [Help]

APPS.INV_GMI_MIGRATION dependencies on GMD_GRADES_B

Line 1307: SELECT * FROM gmd_grades_b

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

Line 1412: UPDATE gmd_grades_b

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

Line 1422: UPDATE gmd_grades_b

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;