APPS.GMD_GRADES_PKG dependencies on GMD_GRADES_TL

Line 42: insert into GMD_GRADES_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into GMD_GRADES_TL (
43: QC_GRADE,
44: QC_GRADE_DESC,
45: CREATION_DATE,
46: CREATED_BY,

Line 66: from GMD_GRADES_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from GMD_GRADES_TL T
67: where T.QC_GRADE = X_QC_GRADE
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 99: from GMD_GRADES_TL

95:
96: cursor c1 is select
97: QC_GRADE_DESC,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from GMD_GRADES_TL
100: where QC_GRADE = X_QC_GRADE
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of QC_GRADE nowait;
103: begin

Line 162: update GMD_GRADES_TL set

158: if (sql%notfound) then
159: raise no_data_found;
160: end if;
161:
162: update GMD_GRADES_TL set
163: QC_GRADE_DESC = X_QC_GRADE_DESC,
164: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
166: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 180: delete from GMD_GRADES_TL

176: procedure DELETE_ROW (
177: X_QC_GRADE in VARCHAR2
178: ) is
179: begin
180: delete from GMD_GRADES_TL
181: where QC_GRADE = X_QC_GRADE;
182:
183: if (sql%notfound) then
184: raise no_data_found;

Line 198: delete from GMD_GRADES_TL T

194:
195: procedure ADD_LANGUAGE
196: is
197: begin
198: delete from GMD_GRADES_TL T
199: where not exists
200: (select NULL
201: from GMD_GRADES_B B
202: where B.QC_GRADE = T.QC_GRADE

Line 205: update GMD_GRADES_TL T set (

201: from GMD_GRADES_B B
202: where B.QC_GRADE = T.QC_GRADE
203: );
204:
205: update GMD_GRADES_TL T set (
206: QC_GRADE_DESC
207: ) = (select
208: B.QC_GRADE_DESC
209: from GMD_GRADES_TL B

Line 209: from GMD_GRADES_TL B

205: update GMD_GRADES_TL T set (
206: QC_GRADE_DESC
207: ) = (select
208: B.QC_GRADE_DESC
209: from GMD_GRADES_TL B
210: where B.QC_GRADE = T.QC_GRADE
211: and B.LANGUAGE = T.SOURCE_LANG)
212: where (
213: T.QC_GRADE,

Line 218: from GMD_GRADES_TL SUBB, GMD_GRADES_TL SUBT

214: T.LANGUAGE
215: ) in (select
216: SUBT.QC_GRADE,
217: SUBT.LANGUAGE
218: from GMD_GRADES_TL SUBB, GMD_GRADES_TL SUBT
219: where SUBB.QC_GRADE = SUBT.QC_GRADE
220: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
221: and (SUBB.QC_GRADE_DESC <> SUBT.QC_GRADE_DESC
222: ));

Line 224: insert into GMD_GRADES_TL (

220: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
221: and (SUBB.QC_GRADE_DESC <> SUBT.QC_GRADE_DESC
222: ));
223:
224: insert into GMD_GRADES_TL (
225: QC_GRADE,
226: QC_GRADE_DESC,
227: CREATION_DATE,
228: CREATED_BY,

Line 244: from GMD_GRADES_TL B, FND_LANGUAGES L

240: B.LAST_UPDATED_BY,
241: B.LAST_UPDATE_LOGIN,
242: L.LANGUAGE_CODE,
243: B.SOURCE_LANG
244: from GMD_GRADES_TL B, FND_LANGUAGES L
245: where L.INSTALLED_FLAG in ('I', 'B')
246: and B.LANGUAGE = userenv('LANG')
247: and not exists
248: (select NULL

Line 249: from GMD_GRADES_TL T

245: where L.INSTALLED_FLAG in ('I', 'B')
246: and B.LANGUAGE = userenv('LANG')
247: and not exists
248: (select NULL
249: from GMD_GRADES_TL T
250: where T.QC_GRADE = B.QC_GRADE
251: and T.LANGUAGE = L.LANGUAGE_CODE);
252: end ADD_LANGUAGE;
253: