APPS.JTF_GRID_DATASOURCES_PKG dependencies on JTF_GRID_DATASOURCES_TL

Line 57: insert into JTF_GRID_DATASOURCES_TL (

53: X_LAST_UPDATE_LOGIN,
54: X_FETCH_SIZE
55: );
56:
57: insert into JTF_GRID_DATASOURCES_TL (
58: GRID_DATASOURCE_NAME,
59: TITLE_TEXT,
60: CREATED_BY,
61: CREATION_DATE,

Line 81: from JTF_GRID_DATASOURCES_TL T

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

Line 124: from JTF_GRID_DATASOURCES_TL

120:
121: cursor c1 is select
122: TITLE_TEXT,
123: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
124: from JTF_GRID_DATASOURCES_TL
125: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
126: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
127: for update of GRID_DATASOURCE_NAME nowait;
128: begin

Line 203: update JTF_GRID_DATASOURCES_TL set

199: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;
200: if (sql%notfound) then
201: raise no_data_found;
202: end if;
203: update JTF_GRID_DATASOURCES_TL set
204: TITLE_TEXT = X_TITLE_TEXT,
205: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
206: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
207: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 242: delete from JTF_GRID_DATASOURCES_TL

238: delete from JTF_GRID_SORT_COLS
239: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;
240: end loop;
241:
242: delete from JTF_GRID_DATASOURCES_TL
243: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;
244:
245: delete from JTF_GRID_DATASOURCES_B
246: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;

Line 297: delete from JTF_GRID_DATASOURCES_TL

293: delete from JTF_GRID_SORT_COLS
294: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;
295: end loop;
296:
297: delete from JTF_GRID_DATASOURCES_TL
298: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;
299:
300: delete from JTF_GRID_DATASOURCES_B
301: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;

Line 311: delete from JTF_GRID_DATASOURCES_TL T

307:
308: procedure ADD_LANGUAGE
309: is
310: begin
311: delete from JTF_GRID_DATASOURCES_TL T
312: where not exists
313: (select NULL
314: from JTF_GRID_DATASOURCES_B B
315: where B.GRID_DATASOURCE_NAME = T.GRID_DATASOURCE_NAME

Line 318: update JTF_GRID_DATASOURCES_TL T set (

314: from JTF_GRID_DATASOURCES_B B
315: where B.GRID_DATASOURCE_NAME = T.GRID_DATASOURCE_NAME
316: );
317:
318: update JTF_GRID_DATASOURCES_TL T set (
319: TITLE_TEXT
320: ) = (select
321: B.TITLE_TEXT
322: from JTF_GRID_DATASOURCES_TL B

Line 322: from JTF_GRID_DATASOURCES_TL B

318: update JTF_GRID_DATASOURCES_TL T set (
319: TITLE_TEXT
320: ) = (select
321: B.TITLE_TEXT
322: from JTF_GRID_DATASOURCES_TL B
323: where B.GRID_DATASOURCE_NAME = T.GRID_DATASOURCE_NAME
324: and B.LANGUAGE = T.SOURCE_LANG)
325: where (
326: T.GRID_DATASOURCE_NAME,

Line 331: from JTF_GRID_DATASOURCES_TL SUBB, JTF_GRID_DATASOURCES_TL SUBT

327: T.LANGUAGE
328: ) in (select
329: SUBT.GRID_DATASOURCE_NAME,
330: SUBT.LANGUAGE
331: from JTF_GRID_DATASOURCES_TL SUBB, JTF_GRID_DATASOURCES_TL SUBT
332: where SUBB.GRID_DATASOURCE_NAME = SUBT.GRID_DATASOURCE_NAME
333: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
334: and (SUBB.TITLE_TEXT <> SUBT.TITLE_TEXT
335: ));

Line 337: insert into JTF_GRID_DATASOURCES_TL (

333: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
334: and (SUBB.TITLE_TEXT <> SUBT.TITLE_TEXT
335: ));
336:
337: insert into JTF_GRID_DATASOURCES_TL (
338: GRID_DATASOURCE_NAME,
339: TITLE_TEXT,
340: CREATED_BY,
341: CREATION_DATE,

Line 357: from JTF_GRID_DATASOURCES_TL B, FND_LANGUAGES L

353: B.LAST_UPDATE_DATE,
354: B.LAST_UPDATE_LOGIN,
355: L.LANGUAGE_CODE,
356: B.SOURCE_LANG
357: from JTF_GRID_DATASOURCES_TL B, FND_LANGUAGES L
358: where L.INSTALLED_FLAG in ('I', 'B')
359: and B.LANGUAGE = userenv('LANG')
360: and not exists
361: (select NULL

Line 362: from JTF_GRID_DATASOURCES_TL T

358: where L.INSTALLED_FLAG in ('I', 'B')
359: and B.LANGUAGE = userenv('LANG')
360: and not exists
361: (select NULL
362: from JTF_GRID_DATASOURCES_TL T
363: where T.GRID_DATASOURCE_NAME = B.GRID_DATASOURCE_NAME
364: and T.LANGUAGE = L.LANGUAGE_CODE);
365: end ADD_LANGUAGE;
366:

Line 500: from JTF_GRID_DATASOURCES_TL

496:
497:
498: select LAST_UPDATED_BY, LAST_UPDATE_DATE
499: into db_luby, db_ludate
500: from JTF_GRID_DATASOURCES_TL
501: where GRID_DATASOURCE_NAME = x_grid_datasource_name
502: and LANGUAGE = userenv('LANG');
503:
504: -- Test for customization and version

Line 509: update JTF_GRID_DATASOURCES_TL

505: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
506: db_ludate, X_CUSTOM_MODE)) then
507: begin
508:
509: update JTF_GRID_DATASOURCES_TL
510: set TITLE_TEXT = X_TITLE_TEXT
511: ,LAST_UPDATE_DATE = f_ludate
512: ,LAST_UPDATED_BY = f_luby
513: ,LAST_UPDATE_LOGIN = 0