APPS.JTF_GRID_DATASOURCES_PKG dependencies on JTF_GRID_SORT_COLS

Line 231: from jtf_grid_sort_cols

227: X_GRID_DATASOURCE_NAME in VARCHAR2
228: ) is
229: cursor sort_cols(x_grid_datasource_name in varchar2) is
230: select 'X'
231: from jtf_grid_sort_cols
232: where grid_datasource_name = x_grid_datasource_name;
233:
234: begin
235: -- cascade delete to all related tables except customization tables

Line 238: delete from JTF_GRID_SORT_COLS

234: begin
235: -- cascade delete to all related tables except customization tables
236:
237: for i in sort_cols(x_grid_datasource_name) loop
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

Line 271: from jtf_grid_sort_cols

267: where grid_datasource_name = x_grid_datasource_name;
268:
269: cursor sort_cols(x_grid_datasource_name in varchar2) is
270: select 'X'
271: from jtf_grid_sort_cols
272: where grid_datasource_name = x_grid_datasource_name;
273:
274: begin
275: -- cascade delete to all related tables except JTF_GRID_COLS

Line 293: delete from JTF_GRID_SORT_COLS

289: delete from JTF_CUSTOM_GRIDS
290: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;
291:
292: for i in sort_cols(x_grid_datasource_name) loop
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