APPS.GMO_INSTR_SET_INSTANCE_PKG dependencies on GMO_INSTR_SET_INSTANCE_TL

Line 58: insert into GMO_INSTR_SET_INSTANCE_TL (

54: X_LAST_UPDATED_BY,
55: X_LAST_UPDATE_LOGIN
56: );
57:
58: insert into GMO_INSTR_SET_INSTANCE_TL (
59: INSTRUCTION_SET_ID,
60: INSTR_SET_DESC,
61: CREATION_DATE,
62: CREATED_BY,

Line 82: from GMO_INSTR_SET_INSTANCE_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_SET_INSTANCE_TL T
83: where T.INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID
84: and T.LANGUAGE = L.LANGUAGE_CODE);
85:
86: open c;

Line 125: from GMO_INSTR_SET_INSTANCE_TL

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

Line 210: update GMO_INSTR_SET_INSTANCE_TL set

206: if (sql%notfound) then
207: raise no_data_found;
208: end if;
209:
210: update GMO_INSTR_SET_INSTANCE_TL set
211: INSTR_SET_DESC = X_INSTR_SET_DESC,
212: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
213: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
214: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 228: delete from GMO_INSTR_SET_INSTANCE_TL

224: procedure DELETE_ROW (
225: X_INSTRUCTION_SET_ID in NUMBER
226: ) is
227: begin
228: delete from GMO_INSTR_SET_INSTANCE_TL
229: where INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID;
230:
231: if (sql%notfound) then
232: raise no_data_found;

Line 246: delete from GMO_INSTR_SET_INSTANCE_TL T

242:
243: procedure ADD_LANGUAGE
244: is
245: begin
246: delete from GMO_INSTR_SET_INSTANCE_TL T
247: where not exists
248: (select NULL
249: from GMO_INSTR_SET_INSTANCE_B B
250: where B.INSTRUCTION_SET_ID = T.INSTRUCTION_SET_ID

Line 253: update GMO_INSTR_SET_INSTANCE_TL T set (

249: from GMO_INSTR_SET_INSTANCE_B B
250: where B.INSTRUCTION_SET_ID = T.INSTRUCTION_SET_ID
251: );
252:
253: update GMO_INSTR_SET_INSTANCE_TL T set (
254: INSTR_SET_DESC
255: ) = (select
256: B.INSTR_SET_DESC
257: from GMO_INSTR_SET_INSTANCE_TL B

Line 257: from GMO_INSTR_SET_INSTANCE_TL B

253: update GMO_INSTR_SET_INSTANCE_TL T set (
254: INSTR_SET_DESC
255: ) = (select
256: B.INSTR_SET_DESC
257: from GMO_INSTR_SET_INSTANCE_TL B
258: where B.INSTRUCTION_SET_ID = T.INSTRUCTION_SET_ID
259: and B.LANGUAGE = T.SOURCE_LANG)
260: where (
261: T.INSTRUCTION_SET_ID,

Line 266: from GMO_INSTR_SET_INSTANCE_TL SUBB, GMO_INSTR_SET_INSTANCE_TL SUBT

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

Line 274: insert into GMO_INSTR_SET_INSTANCE_TL (

270: or (SUBB.INSTR_SET_DESC is null and SUBT.INSTR_SET_DESC is not null)
271: or (SUBB.INSTR_SET_DESC is not null and SUBT.INSTR_SET_DESC is null)
272: ));
273:
274: insert into GMO_INSTR_SET_INSTANCE_TL (
275: INSTRUCTION_SET_ID,
276: INSTR_SET_DESC,
277: CREATION_DATE,
278: CREATED_BY,

Line 294: from GMO_INSTR_SET_INSTANCE_TL B, FND_LANGUAGES L

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

Line 299: from GMO_INSTR_SET_INSTANCE_TL T

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