APPS.JTF_GRID_DATASOURCES_PKG dependencies on JTF_GRID_DATASOURCES_B

Line 21: cursor C is select ROWID from JTF_GRID_DATASOURCES_B

17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER,
19: X_FETCH_SIZE in NUMBER
20: ) is
21: cursor C is select ROWID from JTF_GRID_DATASOURCES_B
22: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
23: ;
24: begin
25: insert into JTF_GRID_DATASOURCES_B (

Line 25: insert into JTF_GRID_DATASOURCES_B (

21: cursor C is select ROWID from JTF_GRID_DATASOURCES_B
22: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
23: ;
24: begin
25: insert into JTF_GRID_DATASOURCES_B (
26: GRID_DATASOURCE_NAME,
27: DB_VIEW_NAME,
28: APPLICATION_ID,
29: DEFAULT_ROW_HEIGHT,

Line 116: from JTF_GRID_DATASOURCES_B

112: WHERE_CLAUSE,
113: ALT_COLOR_CODE,
114: ALT_COLOR_INTERVAL,
115: FETCH_SIZE
116: from JTF_GRID_DATASOURCES_B
117: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
118: for update of GRID_DATASOURCE_NAME nowait;
119: recinfo c%rowtype;
120:

Line 187: update JTF_GRID_DATASOURCES_B set

183: X_LAST_UPDATE_LOGIN in NUMBER,
184: X_FETCH_SIZE in NUMBER
185: ) is
186: begin
187: update JTF_GRID_DATASOURCES_B set
188: DB_VIEW_NAME = X_DB_VIEW_NAME,
189: APPLICATION_ID = X_APPLICATION_ID,
190: DEFAULT_ROW_HEIGHT = X_DEFAULT_ROW_HEIGHT,
191: MAX_QUERIED_ROWS = X_MAX_QUERIED_ROWS,

Line 245: delete from JTF_GRID_DATASOURCES_B

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;
247:
248: delete from JTF_GRID_COLS_TL
249: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME ;

Line 300: delete from JTF_GRID_DATASOURCES_B

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;
302:
303: if (sql%notfound) then
304: raise no_data_found;

Line 314: from JTF_GRID_DATASOURCES_B B

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
316: );
317:
318: update JTF_GRID_DATASOURCES_TL T set (

Line 406: from JTF_GRID_DATASOURCES_B

402:
403: begin
404: select LAST_UPDATED_BY, LAST_UPDATE_DATE
405: into db_luby, db_ludate
406: from JTF_GRID_DATASOURCES_B
407: where GRID_DATASOURCE_NAME = x_grid_datasource_name;
408:
409: -- Test for customization and version
410: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 560: from jtf_grid_datasources_b

556: else
557: -- if the last_updated_by is not 'SEED' return false
558: select last_updated_by
559: into l_last_updated_by
560: from jtf_grid_datasources_b
561: where grid_datasource_name = p_datasource_name;
562:
563: if l_last_updated_by <> p_owner then
564: return FALSE;