APPS.JTF_GRIDDB dependencies on JTF_CUSTOM_GRIDS

Line 1022: from jtf_custom_grids cgs

1018: ,cgs.grid_sort_col_alias2
1019: ,cgs.grid_sort_col_alias3
1020: ,cgs.public_flag
1021: ,cgs.created_by -- this is the owner
1022: from jtf_custom_grids cgs
1023: ,jtf_def_custom_grids dcg
1024: where dcg.grid_datasource_name = dataSource
1025: and dcg.created_by = fnd_global.user_id
1026: and dcg.custom_grid_id = cgs.custom_grid_id

Line 1347: update jtf_custom_grids

1343: close sortCols;
1344: tableDefs(tableIndex).grid_sort_col_alias1 := l_grid_sort_col_alias1;
1345: tableDefs(tableIndex).grid_sort_col_alias2 := l_grid_sort_col_alias2;
1346: tableDefs(tableIndex).grid_sort_col_alias3 := l_grid_sort_col_alias3;
1347: update jtf_custom_grids
1348: set grid_sort_col_alias1 = l_grid_sort_col_alias1
1349: ,grid_sort_col_alias2 = l_grid_sort_col_alias2
1350: ,grid_sort_col_alias3 = l_grid_sort_col_alias3
1351: where custom_grid_id = tableDefs(tableIndex).custom_grid_id;

Line 1722: select jtf_custom_grids_s.nextval

1718: --
1719: if tableDefs(i).custom_grid_id is null
1720: and customGridId is null then
1721:
1722: select jtf_custom_grids_s.nextval
1723: into l_custom_grid_id
1724: from dual;
1725:
1726: insert into jtf_custom_grids

Line 1726: insert into jtf_custom_grids

1722: select jtf_custom_grids_s.nextval
1723: into l_custom_grid_id
1724: from dual;
1725:
1726: insert into jtf_custom_grids
1727: (custom_grid_id
1728: ,grid_datasource_name
1729: ,custom_grid_name
1730: ,language

Line 1787: update jtf_custom_grids

1783: l_custom_grid_id := tableDefs(i).custom_grid_id;
1784: else
1785: l_custom_grid_id := customGridId;
1786: end if;
1787: update jtf_custom_grids
1788: set custom_grid_name = l_custom_grid_name
1789: ,grid_sort_col_alias1 = l_grid_sort_col_alias1
1790: ,grid_sort_col_alias2 = l_grid_sort_col_alias2
1791: ,grid_sort_col_alias3 = l_grid_sort_col_alias3

Line 1937: delete from jtf_custom_grids

1933: delete from jtf_def_custom_grids
1934: where custom_grid_id = l_custom_grid_id;
1935: delete from jtf_custom_grid_cols
1936: where custom_grid_id = l_custom_grid_id;
1937: delete from jtf_custom_grids
1938: where custom_grid_id = l_custom_grid_id;
1939: tableDefs(i).custom_grid_id := null;
1940: tableDefs(i).custom_grid_name := null;
1941: tableDefs(i).public_flag := null;