APPS.GMO_INSTR_DEFN_PKG dependencies on GMO_INSTR_DEFN_TL

Line 56: insert into GMO_INSTR_DEFN_TL (

52: X_LAST_UPDATED_BY,
53: X_LAST_UPDATE_LOGIN
54: );
55:
56: insert into GMO_INSTR_DEFN_TL (
57: TASK_LABEL,
58: INSTRUCTION_ID,
59: INSTRUCTION_TEXT,
60: CREATION_DATE,

Line 82: from GMO_INSTR_DEFN_TL T

78: from FND_LANGUAGES L
79: where L.INSTALLED_FLAG in ('I', 'B')
80: and not exists
81: (select NULL
82: from GMO_INSTR_DEFN_TL T
83: where T.INSTRUCTION_ID = X_INSTRUCTION_ID
84: and T.LANGUAGE = L.LANGUAGE_CODE);
85:
86: open c;

Line 125: from GMO_INSTR_DEFN_TL

121: cursor c1 is select
122: INSTRUCTION_TEXT,
123: TASK_LABEL,
124: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
125: from GMO_INSTR_DEFN_TL
126: where INSTRUCTION_ID = X_INSTRUCTION_ID
127: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
128: for update of INSTRUCTION_ID nowait;
129: begin

Line 207: update GMO_INSTR_DEFN_TL set

203: if (sql%notfound) then
204: raise no_data_found;
205: end if;
206:
207: update GMO_INSTR_DEFN_TL set
208: INSTRUCTION_TEXT = X_INSTRUCTION_TEXT,
209: TASK_LABEL = X_TASK_LABEL,
210: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
211: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 226: delete from GMO_INSTR_DEFN_TL

222: procedure DELETE_ROW (
223: X_INSTRUCTION_ID in NUMBER
224: ) is
225: begin
226: delete from GMO_INSTR_DEFN_TL
227: where INSTRUCTION_ID = X_INSTRUCTION_ID;
228:
229: if (sql%notfound) then
230: raise no_data_found;

Line 244: delete from GMO_INSTR_DEFN_TL T

240:
241: procedure ADD_LANGUAGE
242: is
243: begin
244: delete from GMO_INSTR_DEFN_TL T
245: where not exists
246: (select NULL
247: from GMO_INSTR_DEFN_B B
248: where B.INSTRUCTION_ID = T.INSTRUCTION_ID

Line 251: update GMO_INSTR_DEFN_TL T set (

247: from GMO_INSTR_DEFN_B B
248: where B.INSTRUCTION_ID = T.INSTRUCTION_ID
249: );
250:
251: update GMO_INSTR_DEFN_TL T set (
252: INSTRUCTION_TEXT,
253: TASK_LABEL
254: ) = (select
255: B.INSTRUCTION_TEXT,

Line 257: from GMO_INSTR_DEFN_TL B

253: TASK_LABEL
254: ) = (select
255: B.INSTRUCTION_TEXT,
256: B.TASK_LABEL
257: from GMO_INSTR_DEFN_TL B
258: where B.INSTRUCTION_ID = T.INSTRUCTION_ID
259: and B.LANGUAGE = T.SOURCE_LANG)
260: where (
261: T.INSTRUCTION_ID,

Line 266: from GMO_INSTR_DEFN_TL SUBB, GMO_INSTR_DEFN_TL SUBT

262: T.LANGUAGE
263: ) in (select
264: SUBT.INSTRUCTION_ID,
265: SUBT.LANGUAGE
266: from GMO_INSTR_DEFN_TL SUBB, GMO_INSTR_DEFN_TL SUBT
267: where SUBB.INSTRUCTION_ID = SUBT.INSTRUCTION_ID
268: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
269: and (SUBB.INSTRUCTION_TEXT <> SUBT.INSTRUCTION_TEXT
270: or (SUBB.INSTRUCTION_TEXT is null and SUBT.INSTRUCTION_TEXT is not null)

Line 277: insert into GMO_INSTR_DEFN_TL (

273: or (SUBB.TASK_LABEL is null and SUBT.TASK_LABEL is not null)
274: or (SUBB.TASK_LABEL is not null and SUBT.TASK_LABEL is null)
275: ));
276:
277: insert into GMO_INSTR_DEFN_TL (
278: TASK_LABEL,
279: INSTRUCTION_ID,
280: INSTRUCTION_TEXT,
281: CREATION_DATE,

Line 299: from GMO_INSTR_DEFN_TL B, FND_LANGUAGES L

295: B.LAST_UPDATED_BY,
296: B.LAST_UPDATE_LOGIN,
297: L.LANGUAGE_CODE,
298: B.SOURCE_LANG
299: from GMO_INSTR_DEFN_TL B, FND_LANGUAGES L
300: where L.INSTALLED_FLAG in ('I', 'B')
301: and B.LANGUAGE = userenv('LANG')
302: and not exists
303: (select NULL

Line 304: from GMO_INSTR_DEFN_TL T

300: where L.INSTALLED_FLAG in ('I', 'B')
301: and B.LANGUAGE = userenv('LANG')
302: and not exists
303: (select NULL
304: from GMO_INSTR_DEFN_TL T
305: where T.INSTRUCTION_ID = B.INSTRUCTION_ID
306: and T.LANGUAGE = L.LANGUAGE_CODE);
307: end ADD_LANGUAGE;
308: