APPS.GMD_GRADES_PVT dependencies on GMD_GRADES_B

Line 47: cursor C is select ROWID from GMD_GRADES_B

43: X_LAST_UPDATE_DATE in DATE,
44: X_LAST_UPDATED_BY in NUMBER,
45: X_LAST_UPDATE_LOGIN in NUMBER
46: ) is
47: cursor C is select ROWID from GMD_GRADES_B
48: where QC_GRADE = X_QC_GRADE
49: ;
50: begin
51: insert into GMD_GRADES_B (

Line 51: insert into GMD_GRADES_B (

47: cursor C is select ROWID from GMD_GRADES_B
48: where QC_GRADE = X_QC_GRADE
49: ;
50: begin
51: insert into GMD_GRADES_B (
52: QC_GRADE,
53: DELETE_MARK,
54: TEXT_CODE,
55: TRANS_CNT,

Line 246: from GMD_GRADES_B

242: ATTRIBUTE28,
243: ATTRIBUTE29,
244: ATTRIBUTE30,
245: ATTRIBUTE_CATEGORY
246: from GMD_GRADES_B
247: where QC_GRADE = X_QC_GRADE
248: for update of QC_GRADE nowait;
249: recinfo c%rowtype;
250:

Line 397: update GMD_GRADES_B set

393: X_LAST_UPDATED_BY in NUMBER,
394: X_LAST_UPDATE_LOGIN in NUMBER
395: ) is
396: begin
397: update GMD_GRADES_B set
398: DELETE_MARK = X_DELETE_MARK,
399: TEXT_CODE = X_TEXT_CODE,
400: TRANS_CNT = X_TRANS_CNT,
401: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 466: delete from GMD_GRADES_B

462: if (sql%notfound) then
463: raise no_data_found;
464: end if;
465:
466: delete from GMD_GRADES_B
467: where QC_GRADE = X_QC_GRADE;
468:
469: if (sql%notfound) then
470: raise no_data_found;

Line 480: from GMD_GRADES_B B

476: begin
477: delete from GMD_GRADES_TL T
478: where not exists
479: (select NULL
480: from GMD_GRADES_B B
481: where B.QC_GRADE = T.QC_GRADE
482: );
483:
484: update GMD_GRADES_TL T set (