APPS.GMD_ROUTING_CLASS_PKG dependencies on GMD_ROUTING_CLASS_TL

Line 45: insert into GMD_ROUTING_CLASS_TL (

41: X_LAST_UPDATED_BY,
42: X_LAST_UPDATE_LOGIN
43: );
44:
45: insert into GMD_ROUTING_CLASS_TL (
46: ROUTING_CLASS,
47: ROUTING_CLASS_DESC,
48: LAST_UPDATE_DATE,
49: CREATED_BY,

Line 69: from GMD_ROUTING_CLASS_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from GMD_ROUTING_CLASS_TL T
70: where T.ROUTING_CLASS = X_ROUTING_CLASS
71: and T.LANGUAGE = L.LANGUAGE_CODE);
72:
73: open c;

Line 104: from GMD_ROUTING_CLASS_TL

100:
101: cursor c1 is select
102: ROUTING_CLASS_DESC,
103: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
104: from GMD_ROUTING_CLASS_TL
105: where ROUTING_CLASS = X_ROUTING_CLASS
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of ROUTING_CLASS nowait;
108: begin

Line 171: update GMD_ROUTING_CLASS_TL set

167: if (sql%notfound) then
168: raise no_data_found;
169: end if;
170:
171: update GMD_ROUTING_CLASS_TL set
172: ROUTING_CLASS_DESC = X_ROUTING_CLASS_DESC,
173: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
174: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
175: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 202: delete from GMD_ROUTING_CLASS_TL T

198:
199: procedure ADD_LANGUAGE
200: is
201: begin
202: delete from GMD_ROUTING_CLASS_TL T
203: where not exists
204: (select NULL
205: from GMD_ROUTING_CLASS_B B
206: where B.ROUTING_CLASS = T.ROUTING_CLASS

Line 209: update GMD_ROUTING_CLASS_TL T set (

205: from GMD_ROUTING_CLASS_B B
206: where B.ROUTING_CLASS = T.ROUTING_CLASS
207: );
208:
209: update GMD_ROUTING_CLASS_TL T set (
210: ROUTING_CLASS_DESC
211: ) = (select
212: B.ROUTING_CLASS_DESC
213: from GMD_ROUTING_CLASS_TL B

Line 213: from GMD_ROUTING_CLASS_TL B

209: update GMD_ROUTING_CLASS_TL T set (
210: ROUTING_CLASS_DESC
211: ) = (select
212: B.ROUTING_CLASS_DESC
213: from GMD_ROUTING_CLASS_TL B
214: where B.ROUTING_CLASS = T.ROUTING_CLASS
215: and B.LANGUAGE = T.SOURCE_LANG)
216: where (
217: T.ROUTING_CLASS,

Line 222: from GMD_ROUTING_CLASS_TL SUBB, GMD_ROUTING_CLASS_TL SUBT

218: T.LANGUAGE
219: ) in (select
220: SUBT.ROUTING_CLASS,
221: SUBT.LANGUAGE
222: from GMD_ROUTING_CLASS_TL SUBB, GMD_ROUTING_CLASS_TL SUBT
223: where SUBB.ROUTING_CLASS = SUBT.ROUTING_CLASS
224: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
225: and (SUBB.ROUTING_CLASS_DESC <> SUBT.ROUTING_CLASS_DESC
226: ));

Line 228: insert into GMD_ROUTING_CLASS_TL (

224: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
225: and (SUBB.ROUTING_CLASS_DESC <> SUBT.ROUTING_CLASS_DESC
226: ));
227:
228: insert into GMD_ROUTING_CLASS_TL (
229: ROUTING_CLASS,
230: ROUTING_CLASS_DESC,
231: LAST_UPDATE_DATE,
232: CREATED_BY,

Line 248: from GMD_ROUTING_CLASS_TL B, FND_LANGUAGES L

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

Line 253: from GMD_ROUTING_CLASS_TL T

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