[Home] [Help]
6:
7: cursor l_check_from_clause(p_table_name varchar2) is
8: /* TSHORT 4890086 - needed for optional query in find */
9: select from_clause, where_clause
10: from fnd_audit_disp_cols, fnd_tables
11: where table_name = p_table_name and
12: fnd_tables.table_id = fnd_audit_disp_cols.table_id;
13:
14: TYPE RETRIEVE_DATA IS REF CURSOR;
8: /* TSHORT 4890086 - needed for optional query in find */
9: select from_clause, where_clause
10: from fnd_audit_disp_cols, fnd_tables
11: where table_name = p_table_name and
12: fnd_tables.table_id = fnd_audit_disp_cols.table_id;
13:
14: TYPE RETRIEVE_DATA IS REF CURSOR;
15: AUDIT_TABLE RETRIEVE_DATA; -- declare cursor variable
16: TABLE_DATA RETRIEVE_DATA; -- declare cursor variable
146: SELECT COL_DISP_IND ,
147: SELECT_CLAUSE,
148: FROM_CLAUSE,
149: WHERE_CLAUSE
150: FROM FND_AUDIT_DISP_COLS
151: WHERE APPLICATION_ID = P_APPLICATION_ID
152: AND TABLE_ID = P_TABLE_ID;
153:
154: User_key_columns_rec GET_USER_KEY_COLUMNS%ROWTYPE;