APPS.GMO_INSTR_SET_DEFN_PKG dependencies on GMO_INSTR_SET_DEFN_TL

Line 54: insert into GMO_INSTR_SET_DEFN_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into GMO_INSTR_SET_DEFN_TL (
55: INSTRUCTION_SET_ID,
56: INSTR_SET_DESC,
57: CREATION_DATE,
58: CREATED_BY,

Line 78: from GMO_INSTR_SET_DEFN_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from GMO_INSTR_SET_DEFN_TL T
79: where T.INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 119: from GMO_INSTR_SET_DEFN_TL

115:
116: cursor c1 is select
117: INSTR_SET_DESC,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from GMO_INSTR_SET_DEFN_TL
120: where INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of INSTRUCTION_SET_ID nowait;
123: begin

Line 200: update GMO_INSTR_SET_DEFN_TL set

196: if (sql%notfound) then
197: raise no_data_found;
198: end if;
199:
200: update GMO_INSTR_SET_DEFN_TL set
201: INSTR_SET_DESC = X_INSTR_SET_DESC,
202: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
203: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
204: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 218: delete from GMO_INSTR_SET_DEFN_TL

214: procedure DELETE_ROW (
215: X_INSTRUCTION_SET_ID in NUMBER
216: ) is
217: begin
218: delete from GMO_INSTR_SET_DEFN_TL
219: where INSTRUCTION_SET_ID = X_INSTRUCTION_SET_ID;
220:
221: if (sql%notfound) then
222: raise no_data_found;

Line 236: delete from GMO_INSTR_SET_DEFN_TL T

232:
233: procedure ADD_LANGUAGE
234: is
235: begin
236: delete from GMO_INSTR_SET_DEFN_TL T
237: where not exists
238: (select NULL
239: from GMO_INSTR_SET_DEFN_B B
240: where B.INSTRUCTION_SET_ID = T.INSTRUCTION_SET_ID

Line 243: update GMO_INSTR_SET_DEFN_TL T set (

239: from GMO_INSTR_SET_DEFN_B B
240: where B.INSTRUCTION_SET_ID = T.INSTRUCTION_SET_ID
241: );
242:
243: update GMO_INSTR_SET_DEFN_TL T set (
244: INSTR_SET_DESC
245: ) = (select
246: B.INSTR_SET_DESC
247: from GMO_INSTR_SET_DEFN_TL B

Line 247: from GMO_INSTR_SET_DEFN_TL B

243: update GMO_INSTR_SET_DEFN_TL T set (
244: INSTR_SET_DESC
245: ) = (select
246: B.INSTR_SET_DESC
247: from GMO_INSTR_SET_DEFN_TL B
248: where B.INSTRUCTION_SET_ID = T.INSTRUCTION_SET_ID
249: and B.LANGUAGE = T.SOURCE_LANG)
250: where (
251: T.INSTRUCTION_SET_ID,

Line 256: from GMO_INSTR_SET_DEFN_TL SUBB, GMO_INSTR_SET_DEFN_TL SUBT

252: T.LANGUAGE
253: ) in (select
254: SUBT.INSTRUCTION_SET_ID,
255: SUBT.LANGUAGE
256: from GMO_INSTR_SET_DEFN_TL SUBB, GMO_INSTR_SET_DEFN_TL SUBT
257: where SUBB.INSTRUCTION_SET_ID = SUBT.INSTRUCTION_SET_ID
258: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
259: and (SUBB.INSTR_SET_DESC <> SUBT.INSTR_SET_DESC
260: or (SUBB.INSTR_SET_DESC is null and SUBT.INSTR_SET_DESC is not null)

Line 264: insert into GMO_INSTR_SET_DEFN_TL (

260: or (SUBB.INSTR_SET_DESC is null and SUBT.INSTR_SET_DESC is not null)
261: or (SUBB.INSTR_SET_DESC is not null and SUBT.INSTR_SET_DESC is null)
262: ));
263:
264: insert into GMO_INSTR_SET_DEFN_TL (
265: INSTRUCTION_SET_ID,
266: INSTR_SET_DESC,
267: CREATION_DATE,
268: CREATED_BY,

Line 284: from GMO_INSTR_SET_DEFN_TL B, FND_LANGUAGES L

280: B.LAST_UPDATED_BY,
281: B.LAST_UPDATE_LOGIN,
282: L.LANGUAGE_CODE,
283: B.SOURCE_LANG
284: from GMO_INSTR_SET_DEFN_TL B, FND_LANGUAGES L
285: where L.INSTALLED_FLAG in ('I', 'B')
286: and B.LANGUAGE = userenv('LANG')
287: and not exists
288: (select NULL

Line 289: from GMO_INSTR_SET_DEFN_TL T

285: where L.INSTALLED_FLAG in ('I', 'B')
286: and B.LANGUAGE = userenv('LANG')
287: and not exists
288: (select NULL
289: from GMO_INSTR_SET_DEFN_TL T
290: where T.INSTRUCTION_SET_ID = B.INSTRUCTION_SET_ID
291: and T.LANGUAGE = L.LANGUAGE_CODE);
292: end ADD_LANGUAGE;
293: