APPS.JTF_GRID_DATASOURCES_PKG dependencies on JTF_CUSTOM_GRIDS

Line 262: l_custom_grid_id jtf_custom_grids.custom_grid_id%TYPE;

258:
259: procedure DELETE_ROW (
260: X_GRID_DATASOURCE_NAME in VARCHAR2
261: ) is
262: l_custom_grid_id jtf_custom_grids.custom_grid_id%TYPE;
263:
264: cursor custom_grid(x_grid_datasource_name in varchar2) is
265: select custom_grid_id
266: from jtf_custom_grids

Line 266: from jtf_custom_grids

262: l_custom_grid_id jtf_custom_grids.custom_grid_id%TYPE;
263:
264: cursor custom_grid(x_grid_datasource_name in varchar2) is
265: select custom_grid_id
266: from jtf_custom_grids
267: where grid_datasource_name = x_grid_datasource_name;
268:
269: cursor sort_cols(x_grid_datasource_name in varchar2) is
270: select 'X'

Line 289: delete from JTF_CUSTOM_GRIDS

285:
286: delete from JTF_DEF_CUSTOM_GRIDS
287: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;
288:
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

Line 571: from jtf_custom_grids

567: /*
568: -- if customizations exist return FALSE
569: select 'x'
570: into l_custom_exists
571: from jtf_custom_grids
572: where grid_Datasource_name = p_datasource_name;
573:
574: if l_custom_exists = 'x' then
575: return FALSE;