DBA Data[Home] [Help]

APPS.JTF_GRIDDB dependencies on JTF_DEF_CUSTOM_GRIDS

Line 1011: -- load the default folder as defined in jtf_def_custom_grids

1007: where grd.grid_datasource_name = dataSource
1008: and grd.grid_datasource_name = gsc.grid_datasource_name(+)
1009: and grd.grid_datasource_name = grc.grid_datasource_name;
1010:
1011: -- load the default folder as defined in jtf_def_custom_grids
1012: cursor defaultFolderDef(dataSource in varchar2) is
1013: select cgs.custom_grid_id
1014: ,cgs.custom_grid_name
1015: ,cgs.default_row_height

Line 1023: ,jtf_def_custom_grids dcg

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
1027: and cgs.language = userenv('LANG');

Line 1760: insert into jtf_def_custom_grids

1756: ,l_where_clause
1757: );
1758:
1759: -- NOTE: This will have to change for phase 2
1760: insert into jtf_def_custom_grids
1761: (grid_datasource_name
1762: ,created_by
1763: ,creation_date
1764: ,last_updated_by

Line 1912: -- from JTF_DEF_CUSTOM_GRIDS.

1908: end saveSerializedTableDef;
1909:
1910:
1911: -- Delete the given set of customizations. Remove all references to it
1912: -- from JTF_DEF_CUSTOM_GRIDS.
1913: -- If customGridId is null we delete the current set.
1914: function deleteCustomizations(gridName in varchar2
1915: ,customGridId in number
1916: ,p_serverInitDate in date) return boolean is

Line 1933: delete from jtf_def_custom_grids

1929: return true;
1930: end if;
1931: -- If customGridId is null we delete the current set.
1932: l_custom_grid_id := nvl(customGridId,tableDefs(i).custom_grid_id);
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