DBA Data[Home] [Help]

APPS.INV_GMI_MIGRATION dependencies on GMD_GRADES_B

Line 1215: SELECT * FROM gmd_grades_b

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

Line 1320: UPDATE gmd_grades_b

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

Line 1330: UPDATE gmd_grades_b

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;