APPS.GMD_GRADES_PVT dependencies on GMD_GRADES_TL

Line 135: insert into GMD_GRADES_TL (

131: X_LAST_UPDATED_BY,
132: X_LAST_UPDATE_LOGIN
133: );
134:
135: insert into GMD_GRADES_TL (
136: QC_GRADE,
137: QC_GRADE_DESC,
138: CREATION_DATE,
139: CREATED_BY,

Line 159: from GMD_GRADES_TL T

155: from FND_LANGUAGES L
156: where L.INSTALLED_FLAG in ('I', 'B')
157: and not exists
158: (select NULL
159: from GMD_GRADES_TL T
160: where T.QC_GRADE = X_QC_GRADE
161: and T.LANGUAGE = L.LANGUAGE_CODE);
162:
163: open c;

Line 254: from GMD_GRADES_TL

250:
251: cursor c1 is select
252: QC_GRADE_DESC,
253: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
254: from GMD_GRADES_TL
255: where QC_GRADE = X_QC_GRADE
256: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
257: for update of QC_GRADE nowait;
258: begin

Line 441: update GMD_GRADES_TL set

437: if (sql%notfound) then
438: raise no_data_found;
439: end if;
440:
441: update GMD_GRADES_TL set
442: QC_GRADE_DESC = X_QC_GRADE_DESC,
443: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
444: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
445: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 459: delete from GMD_GRADES_TL

455: procedure DELETE_ROW (
456: X_QC_GRADE in VARCHAR2
457: ) is
458: begin
459: delete from GMD_GRADES_TL
460: where QC_GRADE = X_QC_GRADE;
461:
462: if (sql%notfound) then
463: raise no_data_found;

Line 477: delete from GMD_GRADES_TL T

473:
474: procedure ADD_LANGUAGE
475: is
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

Line 484: update GMD_GRADES_TL T set (

480: from GMD_GRADES_B B
481: where B.QC_GRADE = T.QC_GRADE
482: );
483:
484: update GMD_GRADES_TL T set (
485: QC_GRADE_DESC
486: ) = (select
487: B.QC_GRADE_DESC
488: from GMD_GRADES_TL B

Line 488: from GMD_GRADES_TL B

484: update GMD_GRADES_TL T set (
485: QC_GRADE_DESC
486: ) = (select
487: B.QC_GRADE_DESC
488: from GMD_GRADES_TL B
489: where B.QC_GRADE = T.QC_GRADE
490: and B.LANGUAGE = T.SOURCE_LANG)
491: where (
492: T.QC_GRADE,

Line 497: from GMD_GRADES_TL SUBB, GMD_GRADES_TL SUBT

493: T.LANGUAGE
494: ) in (select
495: SUBT.QC_GRADE,
496: SUBT.LANGUAGE
497: from GMD_GRADES_TL SUBB, GMD_GRADES_TL SUBT
498: where SUBB.QC_GRADE = SUBT.QC_GRADE
499: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
500: and (SUBB.QC_GRADE_DESC <> SUBT.QC_GRADE_DESC
501: ));

Line 503: insert into GMD_GRADES_TL (

499: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
500: and (SUBB.QC_GRADE_DESC <> SUBT.QC_GRADE_DESC
501: ));
502:
503: insert into GMD_GRADES_TL (
504: QC_GRADE,
505: QC_GRADE_DESC,
506: CREATION_DATE,
507: CREATED_BY,

Line 523: from GMD_GRADES_TL B, FND_LANGUAGES L

519: B.LAST_UPDATED_BY,
520: B.LAST_UPDATE_LOGIN,
521: L.LANGUAGE_CODE,
522: B.SOURCE_LANG
523: from GMD_GRADES_TL B, FND_LANGUAGES L
524: where L.INSTALLED_FLAG in ('I', 'B')
525: and B.LANGUAGE = userenv('LANG')
526: and not exists
527: (select NULL

Line 528: from GMD_GRADES_TL T

524: where L.INSTALLED_FLAG in ('I', 'B')
525: and B.LANGUAGE = userenv('LANG')
526: and not exists
527: (select NULL
528: from GMD_GRADES_TL T
529: where T.QC_GRADE = B.QC_GRADE
530: and T.LANGUAGE = L.LANGUAGE_CODE);
531: end ADD_LANGUAGE;
532: