APPS.GMD_OPERATION_CLASS_PKG dependencies on GMD_OPERATION_CLASS_TL

Line 42: insert into GMD_OPERATION_CLASS_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into GMD_OPERATION_CLASS_TL (
43: OPRN_CLASS,
44: OPRN_CLASS_DESC,
45: CREATION_DATE,
46: LAST_UPDATE_DATE,

Line 66: from GMD_OPERATION_CLASS_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_OPERATION_CLASS_TL T
67: where T.OPRN_CLASS = X_OPRN_CLASS
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 99: from GMD_OPERATION_CLASS_TL

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

Line 162: update GMD_OPERATION_CLASS_TL set

158: if (sql%notfound) then
159: raise no_data_found;
160: end if;
161:
162: update GMD_OPERATION_CLASS_TL set
163: OPRN_CLASS_DESC = X_OPRN_CLASS_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 193: delete from GMD_OPERATION_CLASS_TL T

189:
190: procedure ADD_LANGUAGE
191: is
192: begin
193: delete from GMD_OPERATION_CLASS_TL T
194: where not exists
195: (select NULL
196: from GMD_OPERATION_CLASS_B B
197: where B.OPRN_CLASS = T.OPRN_CLASS

Line 200: update GMD_OPERATION_CLASS_TL T set (

196: from GMD_OPERATION_CLASS_B B
197: where B.OPRN_CLASS = T.OPRN_CLASS
198: );
199:
200: update GMD_OPERATION_CLASS_TL T set (
201: OPRN_CLASS_DESC
202: ) = (select
203: B.OPRN_CLASS_DESC
204: from GMD_OPERATION_CLASS_TL B

Line 204: from GMD_OPERATION_CLASS_TL B

200: update GMD_OPERATION_CLASS_TL T set (
201: OPRN_CLASS_DESC
202: ) = (select
203: B.OPRN_CLASS_DESC
204: from GMD_OPERATION_CLASS_TL B
205: where B.OPRN_CLASS = T.OPRN_CLASS
206: and B.LANGUAGE = T.SOURCE_LANG)
207: where (
208: T.OPRN_CLASS,

Line 213: from GMD_OPERATION_CLASS_TL SUBB, GMD_OPERATION_CLASS_TL SUBT

209: T.LANGUAGE
210: ) in (select
211: SUBT.OPRN_CLASS,
212: SUBT.LANGUAGE
213: from GMD_OPERATION_CLASS_TL SUBB, GMD_OPERATION_CLASS_TL SUBT
214: where SUBB.OPRN_CLASS = SUBT.OPRN_CLASS
215: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
216: and (SUBB.OPRN_CLASS_DESC <> SUBT.OPRN_CLASS_DESC
217: ));

Line 219: insert into GMD_OPERATION_CLASS_TL (

215: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
216: and (SUBB.OPRN_CLASS_DESC <> SUBT.OPRN_CLASS_DESC
217: ));
218:
219: insert into GMD_OPERATION_CLASS_TL (
220: OPRN_CLASS,
221: OPRN_CLASS_DESC,
222: CREATION_DATE,
223: LAST_UPDATE_DATE,

Line 239: from GMD_OPERATION_CLASS_TL B, FND_LANGUAGES L

235: B.LAST_UPDATED_BY,
236: B.LAST_UPDATE_LOGIN,
237: L.LANGUAGE_CODE,
238: B.SOURCE_LANG
239: from GMD_OPERATION_CLASS_TL B, FND_LANGUAGES L
240: where L.INSTALLED_FLAG in ('I', 'B')
241: and B.LANGUAGE = userenv('LANG')
242: and not exists
243: (select NULL

Line 244: from GMD_OPERATION_CLASS_TL T

240: where L.INSTALLED_FLAG in ('I', 'B')
241: and B.LANGUAGE = userenv('LANG')
242: and not exists
243: (select NULL
244: from GMD_OPERATION_CLASS_TL T
245: where T.OPRN_CLASS = B.OPRN_CLASS
246: and T.LANGUAGE = L.LANGUAGE_CODE);
247: end ADD_LANGUAGE;
248: