APPS.GMD_FORMULA_CLASS_PKG dependencies on GMD_FORMULA_CLASS_TL

Line 42: insert into GMD_FORMULA_CLASS_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into GMD_FORMULA_CLASS_TL (
43: LAST_UPDATED_BY,
44: LAST_UPDATE_DATE,
45: LAST_UPDATE_LOGIN,
46: FORMULA_CLASS,

Line 66: from GMD_FORMULA_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_FORMULA_CLASS_TL T
67: where T.FORMULA_CLASS = X_FORMULA_CLASS
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 99: from GMD_FORMULA_CLASS_TL

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

Line 162: update GMD_FORMULA_CLASS_TL set

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

197:
198: procedure ADD_LANGUAGE
199: is
200: begin
201: delete from GMD_FORMULA_CLASS_TL T
202: where not exists
203: (select NULL
204: from GMD_FORMULA_CLASS_B B
205: where B.FORMULA_CLASS = T.FORMULA_CLASS

Line 208: update GMD_FORMULA_CLASS_TL T set (

204: from GMD_FORMULA_CLASS_B B
205: where B.FORMULA_CLASS = T.FORMULA_CLASS
206: );
207:
208: update GMD_FORMULA_CLASS_TL T set (
209: FORMULA_CLASS_DESC
210: ) = (select
211: B.FORMULA_CLASS_DESC
212: from GMD_FORMULA_CLASS_TL B

Line 212: from GMD_FORMULA_CLASS_TL B

208: update GMD_FORMULA_CLASS_TL T set (
209: FORMULA_CLASS_DESC
210: ) = (select
211: B.FORMULA_CLASS_DESC
212: from GMD_FORMULA_CLASS_TL B
213: where B.FORMULA_CLASS = T.FORMULA_CLASS
214: and B.LANGUAGE = T.SOURCE_LANG)
215: where (
216: T.FORMULA_CLASS,

Line 221: from GMD_FORMULA_CLASS_TL SUBB, GMD_FORMULA_CLASS_TL SUBT

217: T.LANGUAGE
218: ) in (select
219: SUBT.FORMULA_CLASS,
220: SUBT.LANGUAGE
221: from GMD_FORMULA_CLASS_TL SUBB, GMD_FORMULA_CLASS_TL SUBT
222: where SUBB.FORMULA_CLASS = SUBT.FORMULA_CLASS
223: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
224: and (SUBB.FORMULA_CLASS_DESC <> SUBT.FORMULA_CLASS_DESC
225: ));

Line 227: insert into GMD_FORMULA_CLASS_TL (

223: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
224: and (SUBB.FORMULA_CLASS_DESC <> SUBT.FORMULA_CLASS_DESC
225: ));
226:
227: insert into GMD_FORMULA_CLASS_TL (
228: LAST_UPDATED_BY,
229: LAST_UPDATE_DATE,
230: LAST_UPDATE_LOGIN,
231: FORMULA_CLASS,

Line 247: from GMD_FORMULA_CLASS_TL B, FND_LANGUAGES L

243: B.CREATED_BY,
244: B.CREATION_DATE,
245: L.LANGUAGE_CODE,
246: B.SOURCE_LANG
247: from GMD_FORMULA_CLASS_TL B, FND_LANGUAGES L
248: where L.INSTALLED_FLAG in ('I', 'B')
249: and B.LANGUAGE = userenv('LANG')
250: and not exists
251: (select NULL

Line 252: from GMD_FORMULA_CLASS_TL T

248: where L.INSTALLED_FLAG in ('I', 'B')
249: and B.LANGUAGE = userenv('LANG')
250: and not exists
251: (select NULL
252: from GMD_FORMULA_CLASS_TL T
253: where T.FORMULA_CLASS = B.FORMULA_CLASS
254: and T.LANGUAGE = L.LANGUAGE_CODE);
255: end ADD_LANGUAGE;
256: