APPS.MTL_GRADES_PVT dependencies on MTL_GRADES_TL

Line 129: insert into MTL_GRADES_TL (

125: X_LAST_UPDATED_BY,
126: X_LAST_UPDATE_LOGIN
127: );
128:
129: insert into MTL_GRADES_TL (
130: GRADE_CODE,
131: DESCRIPTION,
132: CREATION_DATE,
133: CREATED_BY,

Line 153: from MTL_GRADES_TL T

149: from FND_LANGUAGES L
150: where L.INSTALLED_FLAG in ('I', 'B')
151: and not exists
152: (select NULL
153: from MTL_GRADES_TL T
154: where T.GRADE_CODE = X_GRADE_CODE
155: and T.LANGUAGE = L.LANGUAGE_CODE);
156:
157: open c;

Line 244: from MTL_GRADES_TL

240:
241: cursor c1 is select
242: DESCRIPTION,
243: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
244: from MTL_GRADES_TL
245: where GRADE_CODE = X_GRADE_CODE
246: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
247: for update of GRADE_CODE nowait;
248: begin

Line 424: update MTL_GRADES_TL set

420: if (sql%notfound) then
421: raise no_data_found;
422: end if;
423:
424: update MTL_GRADES_TL set
425: DESCRIPTION = X_DESCRIPTION,
426: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
427: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
428: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 442: delete from MTL_GRADES_TL

438: procedure DELETE_ROW (
439: X_GRADE_CODE in VARCHAR2
440: ) is
441: begin
442: delete from MTL_GRADES_TL
443: where GRADE_CODE = X_GRADE_CODE;
444:
445: if (sql%notfound) then
446: raise no_data_found;

Line 460: delete from MTL_GRADES_TL T

456:
457: procedure ADD_LANGUAGE
458: is
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

Line 467: update MTL_GRADES_TL T set (

463: from MTL_GRADES_B B
464: where B.GRADE_CODE = T.GRADE_CODE
465: );
466:
467: update MTL_GRADES_TL T set (
468: DESCRIPTION
469: ) = (select
470: B.DESCRIPTION
471: from MTL_GRADES_TL B

Line 471: from MTL_GRADES_TL B

467: update MTL_GRADES_TL T set (
468: DESCRIPTION
469: ) = (select
470: B.DESCRIPTION
471: from MTL_GRADES_TL B
472: where B.GRADE_CODE = T.GRADE_CODE
473: and B.LANGUAGE = T.SOURCE_LANG)
474: where (
475: T.GRADE_CODE,

Line 480: from MTL_GRADES_TL SUBB, MTL_GRADES_TL SUBT

476: T.LANGUAGE
477: ) in (select
478: SUBT.GRADE_CODE,
479: SUBT.LANGUAGE
480: from MTL_GRADES_TL SUBB, MTL_GRADES_TL SUBT
481: where SUBB.GRADE_CODE = SUBT.GRADE_CODE
482: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
483: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
484: ));

Line 486: insert into MTL_GRADES_TL (

482: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
483: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
484: ));
485:
486: insert into MTL_GRADES_TL (
487: GRADE_CODE,
488: DESCRIPTION,
489: CREATION_DATE,
490: CREATED_BY,

Line 506: from MTL_GRADES_TL B, FND_LANGUAGES L

502: B.LAST_UPDATED_BY,
503: B.LAST_UPDATE_LOGIN,
504: L.LANGUAGE_CODE,
505: B.SOURCE_LANG
506: from MTL_GRADES_TL B, FND_LANGUAGES L
507: where L.INSTALLED_FLAG in ('I', 'B')
508: and B.LANGUAGE = userenv('LANG')
509: and not exists
510: (select NULL

Line 511: from MTL_GRADES_TL T

507: where L.INSTALLED_FLAG in ('I', 'B')
508: and B.LANGUAGE = userenv('LANG')
509: and not exists
510: (select NULL
511: from MTL_GRADES_TL T
512: where T.GRADE_CODE = B.GRADE_CODE
513: and T.LANGUAGE = L.LANGUAGE_CODE);
514: end ADD_LANGUAGE;
515: