APPS.GMO_INSTR_INSTANCE_PKG dependencies on GMO_INSTR_INSTANCE_TL

Line 69: insert into GMO_INSTR_INSTANCE_TL (

65: X_LAST_UPDATED_BY,
66: X_LAST_UPDATE_LOGIN
67: );
68:
69: insert into GMO_INSTR_INSTANCE_TL (
70: TASK_LABEL,
71: INSTRUCTION_ID,
72: INSTRUCTION_TEXT,
73: COMMENTS,

Line 97: from GMO_INSTR_INSTANCE_TL T

93: from FND_LANGUAGES L
94: where L.INSTALLED_FLAG in ('I', 'B')
95: and not exists
96: (select NULL
97: from GMO_INSTR_INSTANCE_TL T
98: where T.INSTRUCTION_ID = X_INSTRUCTION_ID
99: and T.LANGUAGE = L.LANGUAGE_CODE);
100:
101: open c;

Line 150: from GMO_INSTR_INSTANCE_TL

146: INSTRUCTION_TEXT,
147: COMMENTS,
148: TASK_LABEL,
149: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
150: from GMO_INSTR_INSTANCE_TL
151: where INSTRUCTION_ID = X_INSTRUCTION_ID
152: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
153: for update of INSTRUCTION_ID nowait;
154: begin

Line 250: update GMO_INSTR_INSTANCE_TL set

246: if (sql%notfound) then
247: raise no_data_found;
248: end if;
249:
250: update GMO_INSTR_INSTANCE_TL set
251: INSTRUCTION_TEXT = X_INSTRUCTION_TEXT,
252: COMMENTS = X_COMMENTS,
253: TASK_LABEL = X_TASK_LABEL,
254: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 270: delete from GMO_INSTR_INSTANCE_TL

266: procedure DELETE_ROW (
267: X_INSTRUCTION_ID in NUMBER
268: ) is
269: begin
270: delete from GMO_INSTR_INSTANCE_TL
271: where INSTRUCTION_ID = X_INSTRUCTION_ID;
272:
273: if (sql%notfound) then
274: raise no_data_found;

Line 288: delete from GMO_INSTR_INSTANCE_TL T

284:
285: procedure ADD_LANGUAGE
286: is
287: begin
288: delete from GMO_INSTR_INSTANCE_TL T
289: where not exists
290: (select NULL
291: from GMO_INSTR_INSTANCE_B B
292: where B.INSTRUCTION_ID = T.INSTRUCTION_ID

Line 295: update GMO_INSTR_INSTANCE_TL T set (

291: from GMO_INSTR_INSTANCE_B B
292: where B.INSTRUCTION_ID = T.INSTRUCTION_ID
293: );
294:
295: update GMO_INSTR_INSTANCE_TL T set (
296: INSTRUCTION_TEXT,
297: COMMENTS,
298: TASK_LABEL
299: ) = (select

Line 303: from GMO_INSTR_INSTANCE_TL B

299: ) = (select
300: B.INSTRUCTION_TEXT,
301: B.COMMENTS,
302: B.TASK_LABEL
303: from GMO_INSTR_INSTANCE_TL B
304: where B.INSTRUCTION_ID = T.INSTRUCTION_ID
305: and B.LANGUAGE = T.SOURCE_LANG)
306: where (
307: T.INSTRUCTION_ID,

Line 312: from GMO_INSTR_INSTANCE_TL SUBB, GMO_INSTR_INSTANCE_TL SUBT

308: T.LANGUAGE
309: ) in (select
310: SUBT.INSTRUCTION_ID,
311: SUBT.LANGUAGE
312: from GMO_INSTR_INSTANCE_TL SUBB, GMO_INSTR_INSTANCE_TL SUBT
313: where SUBB.INSTRUCTION_ID = SUBT.INSTRUCTION_ID
314: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
315: and (SUBB.INSTRUCTION_TEXT <> SUBT.INSTRUCTION_TEXT
316: or (SUBB.INSTRUCTION_TEXT is null and SUBT.INSTRUCTION_TEXT is not null)

Line 326: insert into GMO_INSTR_INSTANCE_TL (

322: or (SUBB.TASK_LABEL is null and SUBT.TASK_LABEL is not null)
323: or (SUBB.TASK_LABEL is not null and SUBT.TASK_LABEL is null)
324: ));
325:
326: insert into GMO_INSTR_INSTANCE_TL (
327: TASK_LABEL,
328: INSTRUCTION_ID,
329: INSTRUCTION_TEXT,
330: COMMENTS,

Line 350: from GMO_INSTR_INSTANCE_TL B, FND_LANGUAGES L

346: B.LAST_UPDATED_BY,
347: B.LAST_UPDATE_LOGIN,
348: L.LANGUAGE_CODE,
349: B.SOURCE_LANG
350: from GMO_INSTR_INSTANCE_TL B, FND_LANGUAGES L
351: where L.INSTALLED_FLAG in ('I', 'B')
352: and B.LANGUAGE = userenv('LANG')
353: and not exists
354: (select NULL

Line 355: from GMO_INSTR_INSTANCE_TL T

351: where L.INSTALLED_FLAG in ('I', 'B')
352: and B.LANGUAGE = userenv('LANG')
353: and not exists
354: (select NULL
355: from GMO_INSTR_INSTANCE_TL T
356: where T.INSTRUCTION_ID = B.INSTRUCTION_ID
357: and T.LANGUAGE = L.LANGUAGE_CODE);
358: end ADD_LANGUAGE;
359: