APPS.MTL_GRADES_PVT dependencies on MTL_GRADES_B

Line 45: cursor C is select ROWID from MTL_GRADES_B

41: X_LAST_UPDATE_DATE in DATE,
42: X_LAST_UPDATED_BY in NUMBER,
43: X_LAST_UPDATE_LOGIN in NUMBER
44: ) is
45: cursor C is select ROWID from MTL_GRADES_B
46: where GRADE_CODE = X_GRADE_CODE
47: ;
48: begin
49: insert into MTL_GRADES_B (

Line 49: insert into MTL_GRADES_B (

45: cursor C is select ROWID from MTL_GRADES_B
46: where GRADE_CODE = X_GRADE_CODE
47: ;
48: begin
49: insert into MTL_GRADES_B (
50: GRADE_CODE,
51: DISABLE_FLAG,
52: ATTRIBUTE1,
53: ATTRIBUTE2,

Line 236: from MTL_GRADES_B

232: ATTRIBUTE28,
233: ATTRIBUTE29,
234: ATTRIBUTE30,
235: ATTRIBUTE_CATEGORY
236: from MTL_GRADES_B
237: where GRADE_CODE = X_GRADE_CODE
238: for update of GRADE_CODE nowait;
239: recinfo c%rowtype;
240:

Line 382: update MTL_GRADES_B set

378: X_LAST_UPDATED_BY in NUMBER,
379: X_LAST_UPDATE_LOGIN in NUMBER
380: ) is
381: begin
382: update MTL_GRADES_B set
383: DISABLE_FLAG = X_DISABLE_FLAG,
384: ATTRIBUTE1 = X_ATTRIBUTE1,
385: ATTRIBUTE2 = X_ATTRIBUTE2,
386: ATTRIBUTE3 = X_ATTRIBUTE3,

Line 449: delete from MTL_GRADES_B

445: if (sql%notfound) then
446: raise no_data_found;
447: end if;
448:
449: delete from MTL_GRADES_B
450: where GRADE_CODE = X_GRADE_CODE;
451:
452: if (sql%notfound) then
453: raise no_data_found;

Line 463: from MTL_GRADES_B B

459: begin
460: delete from MTL_GRADES_TL T
461: where not exists
462: (select NULL
463: from MTL_GRADES_B B
464: where B.GRADE_CODE = T.GRADE_CODE
465: );
466:
467: update MTL_GRADES_TL T set (