APPS.JTF_GRIDDB dependencies on JTF_CUSTOM_GRID_COLS

Line 1167: ,jtf_custom_grid_cols cgc

1163: ,grc.fire_post_query_flag
1164: ,grc.image_description_col
1165: ,null -- sql column alias
1166: from jtf_grid_cols_vl grc
1167: ,jtf_custom_grid_cols cgc
1168: where grc.grid_datasource_name = dataSource
1169: and grc.grid_datasource_name = cgc.grid_datasource_name(+)
1170: and grc.grid_col_alias = cgc.grid_col_alias(+)
1171: and cgc.custom_grid_id(+) = x_custom_grid_id

Line 1184: ,jtf_custom_grid_cols cgc

1180:
1181: cursor folderDisplaySeq(dataSource in varchar2, x_custom_grid_id in number) is
1182: select grc.grid_col_alias
1183: from jtf_grid_cols_vl grc
1184: ,jtf_custom_grid_cols cgc
1185: where grc.grid_datasource_name = datasource
1186: and grc.grid_datasource_name = cgc.grid_datasource_name(+)
1187: and grc.grid_col_alias = cgc.grid_col_alias(+)
1188: and cgc.custom_grid_id(+) = x_custom_grid_id

Line 1668: from jtf_custom_grid_cols

1664: cursor folderColumnExists(x_custom_grid_id in number
1665: ,x_grid_datasource_name in varchar2
1666: ,x_grid_col_alias in varchar2) is
1667: select label_text
1668: from jtf_custom_grid_cols
1669: where custom_grid_id = x_custom_grid_id
1670: and grid_datasource_name = x_grid_datasource_name
1671: and grid_col_alias = x_grid_col_alias;
1672:

Line 1834: insert into jtf_custom_grid_cols

1830: end if;
1831:
1832: if folderColumnExists%NOTFOUND then
1833: close folderColumnExists;
1834: insert into jtf_custom_grid_cols
1835: (custom_grid_id
1836: ,grid_datasource_name
1837: ,grid_col_alias
1838: ,sort_asc_by_default_flag

Line 1866: update jtf_custom_grid_cols

1862: ,l_label_text
1863: );
1864: else
1865: close folderColumnExists;
1866: update jtf_custom_grid_cols
1867: set sort_asc_by_default_flag = l_sort_asc_by_default
1868: ,visible_flag = l_visible_flag
1869: ,display_seq = l_display_seq
1870: ,display_hsize = l_display_hsize

Line 1935: delete from jtf_custom_grid_cols

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
1938: where custom_grid_id = l_custom_grid_id;
1939: tableDefs(i).custom_grid_id := null;