APPS.IMC_THREE_SIXTY_QUERY_PKG dependencies on IMC_THREE_SIXTY_QUERY_TL

Line 98: insert into IMC_THREE_SIXTY_QUERY_TL (

94: 1
95: );
96:
97:
98: insert into IMC_THREE_SIXTY_QUERY_TL (
99: QUERY_ID,
100: TRANSACTION_NAME,
101: HEADER_TEXT,
102: LAST_UPDATE_DATE,

Line 126: from IMC_THREE_SIXTY_QUERY_TL T

122: from FND_LANGUAGES L
123: where L.INSTALLED_FLAG in ('I', 'B')
124: and not exists
125: (select NULL
126: from IMC_THREE_SIXTY_QUERY_TL T
127: where T.QUERY_ID = X_QUERY_ID
128: and T.LANGUAGE = L.LANGUAGE_CODE);
129:
130: end;

Line 187: from IMC_THREE_SIXTY_QUERY_TL

183: cursor c1 is select
184: TRANSACTION_NAME,
185: HEADER_TEXT,
186: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
187: from IMC_THREE_SIXTY_QUERY_TL
188: where QUERY_ID = X_QUERY_ID
189: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
190: for update of QUERY_ID nowait;
191: begin

Line 295: update IMC_THREE_SIXTY_QUERY_TL set

291: if (sql%notfound) then
292: raise no_data_found;
293: end if;
294:
295: update IMC_THREE_SIXTY_QUERY_TL set
296: TRANSACTION_NAME = X_TRANSACTION_NAME,
297: HEADER_TEXT = X_HEADER_TEXT,
298: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
299: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 315: delete from IMC_THREE_SIXTY_QUERY_TL

311: procedure DELETE_ROW (
312: X_QUERY_ID in NUMBER
313: ) is
314: begin
315: delete from IMC_THREE_SIXTY_QUERY_TL
316: where QUERY_ID = X_QUERY_ID;
317:
318: if (sql%notfound) then
319: raise no_data_found;

Line 333: delete from IMC_THREE_SIXTY_QUERY_TL T

329:
330: procedure ADD_LANGUAGE
331: is
332: begin
333: delete from IMC_THREE_SIXTY_QUERY_TL T
334: where not exists
335: (select NULL
336: from IMC_THREE_SIXTY_QUERY_B B
337: where B.QUERY_ID = T.QUERY_ID

Line 340: update IMC_THREE_SIXTY_QUERY_TL T set (

336: from IMC_THREE_SIXTY_QUERY_B B
337: where B.QUERY_ID = T.QUERY_ID
338: );
339:
340: update IMC_THREE_SIXTY_QUERY_TL T set (
341: TRANSACTION_NAME,
342: HEADER_TEXT
343: ) = (select
344: B.TRANSACTION_NAME,

Line 346: from IMC_THREE_SIXTY_QUERY_TL B

342: HEADER_TEXT
343: ) = (select
344: B.TRANSACTION_NAME,
345: B.HEADER_TEXT
346: from IMC_THREE_SIXTY_QUERY_TL B
347: where B.QUERY_ID = T.QUERY_ID
348: and B.LANGUAGE = T.SOURCE_LANG)
349: where (
350: T.QUERY_ID,

Line 355: from IMC_THREE_SIXTY_QUERY_TL SUBB, IMC_THREE_SIXTY_QUERY_TL SUBT

351: T.LANGUAGE
352: ) in (select
353: SUBT.QUERY_ID,
354: SUBT.LANGUAGE
355: from IMC_THREE_SIXTY_QUERY_TL SUBB, IMC_THREE_SIXTY_QUERY_TL SUBT
356: where SUBB.QUERY_ID = SUBT.QUERY_ID
357: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
358: and (SUBB.TRANSACTION_NAME <> SUBT.TRANSACTION_NAME
359: or SUBB.HEADER_TEXT <> SUBT.HEADER_TEXT

Line 364: insert into IMC_THREE_SIXTY_QUERY_TL (

360: or (SUBB.HEADER_TEXT is null and SUBT.HEADER_TEXT is not null)
361: or (SUBB.HEADER_TEXT is not null and SUBT.HEADER_TEXT is null)
362: ));
363:
364: insert into IMC_THREE_SIXTY_QUERY_TL (
365: QUERY_ID,
366: TRANSACTION_NAME,
367: HEADER_TEXT,
368: LAST_UPDATE_DATE,

Line 388: from IMC_THREE_SIXTY_QUERY_TL B, FND_LANGUAGES L

384: B.LAST_UPDATE_LOGIN,
385: B.OBJECT_VERSION_NUMBER,
386: L.LANGUAGE_CODE,
387: B.SOURCE_LANG
388: from IMC_THREE_SIXTY_QUERY_TL B, FND_LANGUAGES L
389: where L.INSTALLED_FLAG in ('I', 'B')
390: and B.LANGUAGE = userenv('LANG')
391: and not exists
392: (select NULL

Line 393: from IMC_THREE_SIXTY_QUERY_TL T

389: where L.INSTALLED_FLAG in ('I', 'B')
390: and B.LANGUAGE = userenv('LANG')
391: and not exists
392: (select NULL
393: from IMC_THREE_SIXTY_QUERY_TL T
394: where T.QUERY_ID = B.QUERY_ID
395: and T.LANGUAGE = L.LANGUAGE_CODE);
396: end ADD_LANGUAGE;
397:

Line 406: update IMC_THREE_SIXTY_QUERY_TL set

402: X_OWNER in VARCHAR2) IS
403:
404: BEGIN
405: -- only update rows that have not been altered by user
406: update IMC_THREE_SIXTY_QUERY_TL set
407: TRANSACTION_NAME= X_TRANSACTION_NAME,
408: HEADER_TEXT = X_HEADER_TEXT,
409: source_lang = userenv('LANG'),
410: last_update_date = sysdate,