APPS.ETRM_SEARCH dependencies on FND_TABLES

Line 126: cursor cur_table(n_appid in fnd_tables.application_id%type

122:
123:
124: function find_table(c_search in varchar2) return number is
125:
126: cursor cur_table(n_appid in fnd_tables.application_id%type
127: , n_tabid in fnd_tables.table_id%type) is
128: select table_name
129: , description
130: from fnd_tables

Line 127: , n_tabid in fnd_tables.table_id%type) is

123:
124: function find_table(c_search in varchar2) return number is
125:
126: cursor cur_table(n_appid in fnd_tables.application_id%type
127: , n_tabid in fnd_tables.table_id%type) is
128: select table_name
129: , description
130: from fnd_tables
131: where application_id = n_appid

Line 130: from fnd_tables

126: cursor cur_table(n_appid in fnd_tables.application_id%type
127: , n_tabid in fnd_tables.table_id%type) is
128: select table_name
129: , description
130: from fnd_tables
131: where application_id = n_appid
132: and table_id = n_tabid;
133:
134: cursor cur_view(n_appid in fnd_tables.application_id%type

Line 134: cursor cur_view(n_appid in fnd_tables.application_id%type

130: from fnd_tables
131: where application_id = n_appid
132: and table_id = n_tabid;
133:
134: cursor cur_view(n_appid in fnd_tables.application_id%type
135: , n_tabid in fnd_tables.table_id%type) is
136: select view_name
137: , description
138: from fnd_views

Line 135: , n_tabid in fnd_tables.table_id%type) is

131: where application_id = n_appid
132: and table_id = n_tabid;
133:
134: cursor cur_view(n_appid in fnd_tables.application_id%type
135: , n_tabid in fnd_tables.table_id%type) is
136: select view_name
137: , description
138: from fnd_views
139: where application_id = n_appid

Line 164: v_table_name fnd_tables.table_name%type;

160: vl_obj_type va_obj_type;
161: vl_col_count va_col_count;
162:
163:
164: v_table_name fnd_tables.table_name%type;
165: v_column_name fnd_columns.column_name%type;
166: v_description fnd_tables.description%type;
167:
168: v_display_count number(3) := 150;

Line 166: v_description fnd_tables.description%type;

162:
163:
164: v_table_name fnd_tables.table_name%type;
165: v_column_name fnd_columns.column_name%type;
166: v_description fnd_tables.description%type;
167:
168: v_display_count number(3) := 150;
169: v_return_value number(8);
170: v_display_text varchar2(256);

Line 187: from fnd_tables c1

183:
184: v_stmt :=
185: 'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)
186: select application_id, table_id, ''TAB''
187: from fnd_tables c1
188: where catsearch(c1.description, :search, null) > 0';
189:
190: execute immediate v_stmt using c_search;
191: