APPS.GMO_INSTR_TASK_DEFN_PKG dependencies on GMO_INSTR_TASK_DEFN_TL

Line 61: insert into GMO_INSTR_TASK_DEFN_TL (

57: X_LAST_UPDATE_LOGIN,
58: X_MAX_ALLOWED_TASK
59: );
60:
61: insert into GMO_INSTR_TASK_DEFN_TL (
62: TASK_ID,
63: DISPLAY_NAME,
64: CREATION_DATE,
65: CREATED_BY,

Line 85: from GMO_INSTR_TASK_DEFN_TL T

81: from FND_LANGUAGES L
82: where L.INSTALLED_FLAG in ('I', 'B')
83: and not exists
84: (select NULL
85: from GMO_INSTR_TASK_DEFN_TL T
86: where T.TASK_ID = X_TASK_ID
87: and T.LANGUAGE = L.LANGUAGE_CODE);
88:
89: open c;

Line 130: from GMO_INSTR_TASK_DEFN_TL

126:
127: cursor c1 is select
128: DISPLAY_NAME,
129: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
130: from GMO_INSTR_TASK_DEFN_TL
131: where TASK_ID = X_TASK_ID
132: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
133: for update of TASK_ID nowait;
134: begin

Line 213: update GMO_INSTR_TASK_DEFN_TL set

209: if (sql%notfound) then
210: raise no_data_found;
211: end if;
212:
213: update GMO_INSTR_TASK_DEFN_TL set
214: DISPLAY_NAME = X_DISPLAY_NAME,
215: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
216: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
217: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 231: delete from GMO_INSTR_TASK_DEFN_TL

227: procedure DELETE_ROW (
228: X_TASK_ID in NUMBER
229: ) is
230: begin
231: delete from GMO_INSTR_TASK_DEFN_TL
232: where TASK_ID = X_TASK_ID;
233:
234: if (sql%notfound) then
235: raise no_data_found;

Line 249: delete from GMO_INSTR_TASK_DEFN_TL T

245:
246: procedure ADD_LANGUAGE
247: is
248: begin
249: delete from GMO_INSTR_TASK_DEFN_TL T
250: where not exists
251: (select NULL
252: from GMO_INSTR_TASK_DEFN_B B
253: where B.TASK_ID = T.TASK_ID

Line 256: update GMO_INSTR_TASK_DEFN_TL T set (

252: from GMO_INSTR_TASK_DEFN_B B
253: where B.TASK_ID = T.TASK_ID
254: );
255:
256: update GMO_INSTR_TASK_DEFN_TL T set (
257: DISPLAY_NAME
258: ) = (select
259: B.DISPLAY_NAME
260: from GMO_INSTR_TASK_DEFN_TL B

Line 260: from GMO_INSTR_TASK_DEFN_TL B

256: update GMO_INSTR_TASK_DEFN_TL T set (
257: DISPLAY_NAME
258: ) = (select
259: B.DISPLAY_NAME
260: from GMO_INSTR_TASK_DEFN_TL B
261: where B.TASK_ID = T.TASK_ID
262: and B.LANGUAGE = T.SOURCE_LANG)
263: where (
264: T.TASK_ID,

Line 269: from GMO_INSTR_TASK_DEFN_TL SUBB, GMO_INSTR_TASK_DEFN_TL SUBT

265: T.LANGUAGE
266: ) in (select
267: SUBT.TASK_ID,
268: SUBT.LANGUAGE
269: from GMO_INSTR_TASK_DEFN_TL SUBB, GMO_INSTR_TASK_DEFN_TL SUBT
270: where SUBB.TASK_ID = SUBT.TASK_ID
271: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
272: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
273: ));

Line 275: insert into GMO_INSTR_TASK_DEFN_TL (

271: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
272: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
273: ));
274:
275: insert into GMO_INSTR_TASK_DEFN_TL (
276: TASK_ID,
277: DISPLAY_NAME,
278: CREATION_DATE,
279: CREATED_BY,

Line 295: from GMO_INSTR_TASK_DEFN_TL B, FND_LANGUAGES L

291: B.LAST_UPDATED_BY,
292: B.LAST_UPDATE_LOGIN,
293: L.LANGUAGE_CODE,
294: B.SOURCE_LANG
295: from GMO_INSTR_TASK_DEFN_TL B, FND_LANGUAGES L
296: where L.INSTALLED_FLAG in ('I', 'B')
297: and B.LANGUAGE = userenv('LANG')
298: and not exists
299: (select NULL

Line 300: from GMO_INSTR_TASK_DEFN_TL T

296: where L.INSTALLED_FLAG in ('I', 'B')
297: and B.LANGUAGE = userenv('LANG')
298: and not exists
299: (select NULL
300: from GMO_INSTR_TASK_DEFN_TL T
301: where T.TASK_ID = B.TASK_ID
302: and T.LANGUAGE = L.LANGUAGE_CODE);
303: end ADD_LANGUAGE;
304: