DBA Data[Home] [Help]

APPS.JTF_GRIDDB dependencies on JTF_GRID_COLS_B

Line 1004: from jtf_grid_cols_b

1000: ,jtf_grid_sort_cols gsc
1001: ,(
1002: select grid_datasource_name
1003: ,count(*) cols
1004: from jtf_grid_cols_b
1005: group by grid_datasource_name
1006: ) grc
1007: where grd.grid_datasource_name = dataSource
1008: and grd.grid_datasource_name = gsc.grid_datasource_name(+)

Line 1177: from jtf_grid_cols_b grc

1173:
1174:
1175: cursor displaySeq(dataSource in varchar2) is
1176: select grc.grid_col_alias
1177: from jtf_grid_cols_b grc
1178: where grc.grid_datasource_name = datasource
1179: order by grc.display_seq;
1180:
1181: cursor folderDisplaySeq(dataSource in varchar2, x_custom_grid_id in number) is

Line 1194: from jtf_grid_cols_b grc

1190:
1191:
1192: cursor currency_col_alias(x_dataSource in varchar2,x_db_currency_code_col in varchar2) is
1193: select grc.grid_col_alias
1194: from jtf_grid_cols_b grc
1195: where grc.grid_datasource_name = x_dataSource
1196: and grc.db_col_name = x_db_currency_code_col;
1197:
1198: INVALID_DATASOURCE exception;

Line 1393: -- JTF_GRID_COLS_B

1389: -- 2. Saves the customizations.
1390: -- 3. The columns that the end user sorted on are deleted from the
1391: -- metadata definition.
1392: -- 4. The columndefinition for the column used in the sort order was deleted from
1393: -- JTF_GRID_COLS_B
1394: -- If corrupt we return false, the caller is responsible for calling repairSortColumns
1395: -- to do the dirty work.
1396: procedure validateSortColumns(gridName in varchar2
1397: ,tableIndex in binary_integer