eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CTX_PKG dependencies on DBMS_SQL

Line 94: cursor_name := dbms_sql.open_cursor;

90: ctxsys.dr$preference_usage pu Where pa.pat_name = ''STOP_WORD''
91: AND pa.pat_pre_id = pu.pus_pre_id AND pu.pus_pol_id = po.pol_id
92: AND po.pol_name in (' || policies || ')' ;
93:
94: cursor_name := dbms_sql.open_cursor;
95: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
96: dbms_sql.define_column(cursor_name,1,stop_word,100);
97: rows_processed := dbms_sql.execute(cursor_name);
98: LOOP

Line 95: dbms_sql.parse(cursor_name,string,dbms_sql.v7);

91: AND pa.pat_pre_id = pu.pus_pre_id AND pu.pus_pol_id = po.pol_id
92: AND po.pol_name in (' || policies || ')' ;
93:
94: cursor_name := dbms_sql.open_cursor;
95: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
96: dbms_sql.define_column(cursor_name,1,stop_word,100);
97: rows_processed := dbms_sql.execute(cursor_name);
98: LOOP
99: IF dbms_sql.fetch_rows(cursor_name) >0 THEN

Line 96: dbms_sql.define_column(cursor_name,1,stop_word,100);

92: AND po.pol_name in (' || policies || ')' ;
93:
94: cursor_name := dbms_sql.open_cursor;
95: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
96: dbms_sql.define_column(cursor_name,1,stop_word,100);
97: rows_processed := dbms_sql.execute(cursor_name);
98: LOOP
99: IF dbms_sql.fetch_rows(cursor_name) >0 THEN
100: -- get column values of the row.

Line 97: rows_processed := dbms_sql.execute(cursor_name);

93:
94: cursor_name := dbms_sql.open_cursor;
95: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
96: dbms_sql.define_column(cursor_name,1,stop_word,100);
97: rows_processed := dbms_sql.execute(cursor_name);
98: LOOP
99: IF dbms_sql.fetch_rows(cursor_name) >0 THEN
100: -- get column values of the row.
101: dbms_sql.column_value(cursor_name,1,stop_word);

Line 99: IF dbms_sql.fetch_rows(cursor_name) >0 THEN

95: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
96: dbms_sql.define_column(cursor_name,1,stop_word,100);
97: rows_processed := dbms_sql.execute(cursor_name);
98: LOOP
99: IF dbms_sql.fetch_rows(cursor_name) >0 THEN
100: -- get column values of the row.
101: dbms_sql.column_value(cursor_name,1,stop_word);
102: all_stop_words := all_stop_words || stop_word || ' ';
103: ELSE

Line 101: dbms_sql.column_value(cursor_name,1,stop_word);

97: rows_processed := dbms_sql.execute(cursor_name);
98: LOOP
99: IF dbms_sql.fetch_rows(cursor_name) >0 THEN
100: -- get column values of the row.
101: dbms_sql.column_value(cursor_name,1,stop_word);
102: all_stop_words := all_stop_words || stop_word || ' ';
103: ELSE
104: EXIT;
105: END IF;

Line 107: dbms_sql.close_cursor(cursor_name);

103: ELSE
104: EXIT;
105: END IF;
106: END LOOP;
107: dbms_sql.close_cursor(cursor_name);
108: stop_word_list:=all_stop_words;
109: EXCEPTION
110: WHEN OTHERS THEN
111: IF dbms_sql.is_open(cursor_name) THEN

Line 111: IF dbms_sql.is_open(cursor_name) THEN

107: dbms_sql.close_cursor(cursor_name);
108: stop_word_list:=all_stop_words;
109: EXCEPTION
110: WHEN OTHERS THEN
111: IF dbms_sql.is_open(cursor_name) THEN
112: dbms_sql.close_cursor(cursor_name);
113: END IF;
114: raise;
115: END; -- Get_Context_Stop_Words.

Line 112: dbms_sql.close_cursor(cursor_name);

108: stop_word_list:=all_stop_words;
109: EXCEPTION
110: WHEN OTHERS THEN
111: IF dbms_sql.is_open(cursor_name) THEN
112: dbms_sql.close_cursor(cursor_name);
113: END IF;
114: raise;
115: END; -- Get_Context_Stop_Words.
116:

Line 174: cursor_name := dbms_sql.open_cursor;

170:
171: -- Call ctx's contains
172:
173: IF str1 is NOT NULL THEN
174: cursor_name := dbms_sql.open_cursor;
175: dbms_sql.parse(cursor_name,str1,dbms_sql.v7);
176: rows_processed := dbms_sql.execute(cursor_name);
177: dbms_sql.close_cursor(cursor_name);
178: END IF;

Line 175: dbms_sql.parse(cursor_name,str1,dbms_sql.v7);

171: -- Call ctx's contains
172:
173: IF str1 is NOT NULL THEN
174: cursor_name := dbms_sql.open_cursor;
175: dbms_sql.parse(cursor_name,str1,dbms_sql.v7);
176: rows_processed := dbms_sql.execute(cursor_name);
177: dbms_sql.close_cursor(cursor_name);
178: END IF;
179:

Line 176: rows_processed := dbms_sql.execute(cursor_name);

172:
173: IF str1 is NOT NULL THEN
174: cursor_name := dbms_sql.open_cursor;
175: dbms_sql.parse(cursor_name,str1,dbms_sql.v7);
176: rows_processed := dbms_sql.execute(cursor_name);
177: dbms_sql.close_cursor(cursor_name);
178: END IF;
179:
180: IF str2 is NOT NULL THEN

Line 177: dbms_sql.close_cursor(cursor_name);

173: IF str1 is NOT NULL THEN
174: cursor_name := dbms_sql.open_cursor;
175: dbms_sql.parse(cursor_name,str1,dbms_sql.v7);
176: rows_processed := dbms_sql.execute(cursor_name);
177: dbms_sql.close_cursor(cursor_name);
178: END IF;
179:
180: IF str2 is NOT NULL THEN
181: cursor_name := dbms_sql.open_cursor;

Line 181: cursor_name := dbms_sql.open_cursor;

177: dbms_sql.close_cursor(cursor_name);
178: END IF;
179:
180: IF str2 is NOT NULL THEN
181: cursor_name := dbms_sql.open_cursor;
182: dbms_sql.parse(cursor_name,str2,dbms_sql.v7);
183: rows_processed := dbms_sql.execute(cursor_name);
184: dbms_sql.close_cursor(cursor_name);
185: END IF;

Line 182: dbms_sql.parse(cursor_name,str2,dbms_sql.v7);

178: END IF;
179:
180: IF str2 is NOT NULL THEN
181: cursor_name := dbms_sql.open_cursor;
182: dbms_sql.parse(cursor_name,str2,dbms_sql.v7);
183: rows_processed := dbms_sql.execute(cursor_name);
184: dbms_sql.close_cursor(cursor_name);
185: END IF;
186:

Line 183: rows_processed := dbms_sql.execute(cursor_name);

179:
180: IF str2 is NOT NULL THEN
181: cursor_name := dbms_sql.open_cursor;
182: dbms_sql.parse(cursor_name,str2,dbms_sql.v7);
183: rows_processed := dbms_sql.execute(cursor_name);
184: dbms_sql.close_cursor(cursor_name);
185: END IF;
186:
187:

Line 184: dbms_sql.close_cursor(cursor_name);

180: IF str2 is NOT NULL THEN
181: cursor_name := dbms_sql.open_cursor;
182: dbms_sql.parse(cursor_name,str2,dbms_sql.v7);
183: rows_processed := dbms_sql.execute(cursor_name);
184: dbms_sql.close_cursor(cursor_name);
185: END IF;
186:
187:
188: IF str3 is NOT NULL THEN

Line 189: cursor_name := dbms_sql.open_cursor;

185: END IF;
186:
187:
188: IF str3 is NOT NULL THEN
189: cursor_name := dbms_sql.open_cursor;
190: dbms_sql.parse(cursor_name,str3,dbms_sql.v7);
191: rows_processed := dbms_sql.execute(cursor_name);
192: dbms_sql.close_cursor(cursor_name);
193: END IF;

Line 190: dbms_sql.parse(cursor_name,str3,dbms_sql.v7);

186:
187:
188: IF str3 is NOT NULL THEN
189: cursor_name := dbms_sql.open_cursor;
190: dbms_sql.parse(cursor_name,str3,dbms_sql.v7);
191: rows_processed := dbms_sql.execute(cursor_name);
192: dbms_sql.close_cursor(cursor_name);
193: END IF;
194:

Line 191: rows_processed := dbms_sql.execute(cursor_name);

187:
188: IF str3 is NOT NULL THEN
189: cursor_name := dbms_sql.open_cursor;
190: dbms_sql.parse(cursor_name,str3,dbms_sql.v7);
191: rows_processed := dbms_sql.execute(cursor_name);
192: dbms_sql.close_cursor(cursor_name);
193: END IF;
194:
195: IF str4 is NOT NULL THEN

Line 192: dbms_sql.close_cursor(cursor_name);

188: IF str3 is NOT NULL THEN
189: cursor_name := dbms_sql.open_cursor;
190: dbms_sql.parse(cursor_name,str3,dbms_sql.v7);
191: rows_processed := dbms_sql.execute(cursor_name);
192: dbms_sql.close_cursor(cursor_name);
193: END IF;
194:
195: IF str4 is NOT NULL THEN
196: cursor_name := dbms_sql.open_cursor;

Line 196: cursor_name := dbms_sql.open_cursor;

192: dbms_sql.close_cursor(cursor_name);
193: END IF;
194:
195: IF str4 is NOT NULL THEN
196: cursor_name := dbms_sql.open_cursor;
197: dbms_sql.parse(cursor_name,str4,dbms_sql.v7);
198: rows_processed := dbms_sql.execute(cursor_name);
199: dbms_sql.close_cursor(cursor_name);
200: END IF;

Line 197: dbms_sql.parse(cursor_name,str4,dbms_sql.v7);

193: END IF;
194:
195: IF str4 is NOT NULL THEN
196: cursor_name := dbms_sql.open_cursor;
197: dbms_sql.parse(cursor_name,str4,dbms_sql.v7);
198: rows_processed := dbms_sql.execute(cursor_name);
199: dbms_sql.close_cursor(cursor_name);
200: END IF;
201:

Line 198: rows_processed := dbms_sql.execute(cursor_name);

194:
195: IF str4 is NOT NULL THEN
196: cursor_name := dbms_sql.open_cursor;
197: dbms_sql.parse(cursor_name,str4,dbms_sql.v7);
198: rows_processed := dbms_sql.execute(cursor_name);
199: dbms_sql.close_cursor(cursor_name);
200: END IF;
201:
202: EXCEPTION

Line 199: dbms_sql.close_cursor(cursor_name);

195: IF str4 is NOT NULL THEN
196: cursor_name := dbms_sql.open_cursor;
197: dbms_sql.parse(cursor_name,str4,dbms_sql.v7);
198: rows_processed := dbms_sql.execute(cursor_name);
199: dbms_sql.close_cursor(cursor_name);
200: END IF;
201:
202: EXCEPTION
203: WHEN OTHERS THEN

Line 205: IF dbms_sql.is_open(cursor_name) THEN

201:
202: EXCEPTION
203: WHEN OTHERS THEN
204: IF instr(sqlerrm,'DRG-10308') <>0 THEN
205: IF dbms_sql.is_open(cursor_name) THEN
206: dbms_sql.close_cursor(cursor_name);
207: END IF;
208: fnd_message.set_name('CS','CS_INC_CTX_NO_SERVER');
209: app_exception.raise_exception;

Line 206: dbms_sql.close_cursor(cursor_name);

202: EXCEPTION
203: WHEN OTHERS THEN
204: IF instr(sqlerrm,'DRG-10308') <>0 THEN
205: IF dbms_sql.is_open(cursor_name) THEN
206: dbms_sql.close_cursor(cursor_name);
207: END IF;
208: fnd_message.set_name('CS','CS_INC_CTX_NO_SERVER');
209: app_exception.raise_exception;
210: ELSE

Line 211: dbms_sql.close_cursor(cursor_name);

207: END IF;
208: fnd_message.set_name('CS','CS_INC_CTX_NO_SERVER');
209: app_exception.raise_exception;
210: ELSE
211: dbms_sql.close_cursor(cursor_name);
212: fnd_message.set_name('CS','CS_SR_CONTEXT_ERROR');
213: fnd_message.set_token('ERRORM',sqlerrm);
214: app_exception.raise_exception;
215: END IF;

Line 233: cursor_name := dbms_sql.open_cursor;

229: rows_processed INTEGER; -- Not used currently
230: BEGIN
231: string := 'BEGIN ctx_dml.reindex('''||policy_name||''','''||primary_key||'
232: ''); END;';
233: cursor_name := dbms_sql.open_cursor;
234: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
235: rows_processed := dbms_sql.execute(cursor_name);
236: dbms_sql.close_cursor(cursor_name);
237: EXCEPTION

Line 234: dbms_sql.parse(cursor_name,string,dbms_sql.v7);

230: BEGIN
231: string := 'BEGIN ctx_dml.reindex('''||policy_name||''','''||primary_key||'
232: ''); END;';
233: cursor_name := dbms_sql.open_cursor;
234: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
235: rows_processed := dbms_sql.execute(cursor_name);
236: dbms_sql.close_cursor(cursor_name);
237: EXCEPTION
238: WHEN OTHERS THEN

Line 235: rows_processed := dbms_sql.execute(cursor_name);

231: string := 'BEGIN ctx_dml.reindex('''||policy_name||''','''||primary_key||'
232: ''); END;';
233: cursor_name := dbms_sql.open_cursor;
234: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
235: rows_processed := dbms_sql.execute(cursor_name);
236: dbms_sql.close_cursor(cursor_name);
237: EXCEPTION
238: WHEN OTHERS THEN
239: IF dbms_sql.is_open(cursor_name) THEN

Line 236: dbms_sql.close_cursor(cursor_name);

232: ''); END;';
233: cursor_name := dbms_sql.open_cursor;
234: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
235: rows_processed := dbms_sql.execute(cursor_name);
236: dbms_sql.close_cursor(cursor_name);
237: EXCEPTION
238: WHEN OTHERS THEN
239: IF dbms_sql.is_open(cursor_name) THEN
240: dbms_sql.close_cursor(cursor_name);

Line 239: IF dbms_sql.is_open(cursor_name) THEN

235: rows_processed := dbms_sql.execute(cursor_name);
236: dbms_sql.close_cursor(cursor_name);
237: EXCEPTION
238: WHEN OTHERS THEN
239: IF dbms_sql.is_open(cursor_name) THEN
240: dbms_sql.close_cursor(cursor_name);
241: END IF;
242: raise;
243: END; -- update_context_index.

Line 240: dbms_sql.close_cursor(cursor_name);

236: dbms_sql.close_cursor(cursor_name);
237: EXCEPTION
238: WHEN OTHERS THEN
239: IF dbms_sql.is_open(cursor_name) THEN
240: dbms_sql.close_cursor(cursor_name);
241: END IF;
242: raise;
243: END; -- update_context_index.
244:

Line 265: cursor_name := dbms_sql.open_cursor;

261: cursor_name INTEGER;
262: string VARCHAR2(200);
263: rows_processed INTEGER; -- Not used currently
264: BEGIN
265: cursor_name := dbms_sql.open_cursor;
266: dbms_sql.parse(cursor_name,'DELETE FROM '||results_table||' WHERE conid IN (:c1,:c2,:c3,:c4)',dbms_sql.v7);
267: dbms_sql.bind_variable(cursor_name, ':c1',conid1);
268: dbms_sql.bind_variable(cursor_name, ':c2',conid2);
269: dbms_sql.bind_variable(cursor_name, ':c3',conid3);

Line 266: dbms_sql.parse(cursor_name,'DELETE FROM '||results_table||' WHERE conid IN (:c1,:c2,:c3,:c4)',dbms_sql.v7);

262: string VARCHAR2(200);
263: rows_processed INTEGER; -- Not used currently
264: BEGIN
265: cursor_name := dbms_sql.open_cursor;
266: dbms_sql.parse(cursor_name,'DELETE FROM '||results_table||' WHERE conid IN (:c1,:c2,:c3,:c4)',dbms_sql.v7);
267: dbms_sql.bind_variable(cursor_name, ':c1',conid1);
268: dbms_sql.bind_variable(cursor_name, ':c2',conid2);
269: dbms_sql.bind_variable(cursor_name, ':c3',conid3);
270: dbms_sql.bind_variable(cursor_name, ':c4',conid4);

Line 267: dbms_sql.bind_variable(cursor_name, ':c1',conid1);

263: rows_processed INTEGER; -- Not used currently
264: BEGIN
265: cursor_name := dbms_sql.open_cursor;
266: dbms_sql.parse(cursor_name,'DELETE FROM '||results_table||' WHERE conid IN (:c1,:c2,:c3,:c4)',dbms_sql.v7);
267: dbms_sql.bind_variable(cursor_name, ':c1',conid1);
268: dbms_sql.bind_variable(cursor_name, ':c2',conid2);
269: dbms_sql.bind_variable(cursor_name, ':c3',conid3);
270: dbms_sql.bind_variable(cursor_name, ':c4',conid4);
271: rows_processed := dbms_sql.execute(cursor_name);

Line 268: dbms_sql.bind_variable(cursor_name, ':c2',conid2);

264: BEGIN
265: cursor_name := dbms_sql.open_cursor;
266: dbms_sql.parse(cursor_name,'DELETE FROM '||results_table||' WHERE conid IN (:c1,:c2,:c3,:c4)',dbms_sql.v7);
267: dbms_sql.bind_variable(cursor_name, ':c1',conid1);
268: dbms_sql.bind_variable(cursor_name, ':c2',conid2);
269: dbms_sql.bind_variable(cursor_name, ':c3',conid3);
270: dbms_sql.bind_variable(cursor_name, ':c4',conid4);
271: rows_processed := dbms_sql.execute(cursor_name);
272: dbms_sql.close_cursor(cursor_name);

Line 269: dbms_sql.bind_variable(cursor_name, ':c3',conid3);

265: cursor_name := dbms_sql.open_cursor;
266: dbms_sql.parse(cursor_name,'DELETE FROM '||results_table||' WHERE conid IN (:c1,:c2,:c3,:c4)',dbms_sql.v7);
267: dbms_sql.bind_variable(cursor_name, ':c1',conid1);
268: dbms_sql.bind_variable(cursor_name, ':c2',conid2);
269: dbms_sql.bind_variable(cursor_name, ':c3',conid3);
270: dbms_sql.bind_variable(cursor_name, ':c4',conid4);
271: rows_processed := dbms_sql.execute(cursor_name);
272: dbms_sql.close_cursor(cursor_name);
273: EXCEPTION

Line 270: dbms_sql.bind_variable(cursor_name, ':c4',conid4);

266: dbms_sql.parse(cursor_name,'DELETE FROM '||results_table||' WHERE conid IN (:c1,:c2,:c3,:c4)',dbms_sql.v7);
267: dbms_sql.bind_variable(cursor_name, ':c1',conid1);
268: dbms_sql.bind_variable(cursor_name, ':c2',conid2);
269: dbms_sql.bind_variable(cursor_name, ':c3',conid3);
270: dbms_sql.bind_variable(cursor_name, ':c4',conid4);
271: rows_processed := dbms_sql.execute(cursor_name);
272: dbms_sql.close_cursor(cursor_name);
273: EXCEPTION
274: WHEN OTHERS THEN

Line 271: rows_processed := dbms_sql.execute(cursor_name);

267: dbms_sql.bind_variable(cursor_name, ':c1',conid1);
268: dbms_sql.bind_variable(cursor_name, ':c2',conid2);
269: dbms_sql.bind_variable(cursor_name, ':c3',conid3);
270: dbms_sql.bind_variable(cursor_name, ':c4',conid4);
271: rows_processed := dbms_sql.execute(cursor_name);
272: dbms_sql.close_cursor(cursor_name);
273: EXCEPTION
274: WHEN OTHERS THEN
275: IF dbms_sql.is_open(cursor_name) THEN

Line 272: dbms_sql.close_cursor(cursor_name);

268: dbms_sql.bind_variable(cursor_name, ':c2',conid2);
269: dbms_sql.bind_variable(cursor_name, ':c3',conid3);
270: dbms_sql.bind_variable(cursor_name, ':c4',conid4);
271: rows_processed := dbms_sql.execute(cursor_name);
272: dbms_sql.close_cursor(cursor_name);
273: EXCEPTION
274: WHEN OTHERS THEN
275: IF dbms_sql.is_open(cursor_name) THEN
276: dbms_sql.close_cursor(cursor_name);

Line 275: IF dbms_sql.is_open(cursor_name) THEN

271: rows_processed := dbms_sql.execute(cursor_name);
272: dbms_sql.close_cursor(cursor_name);
273: EXCEPTION
274: WHEN OTHERS THEN
275: IF dbms_sql.is_open(cursor_name) THEN
276: dbms_sql.close_cursor(cursor_name);
277: END IF;
278: raise;
279:

Line 276: dbms_sql.close_cursor(cursor_name);

272: dbms_sql.close_cursor(cursor_name);
273: EXCEPTION
274: WHEN OTHERS THEN
275: IF dbms_sql.is_open(cursor_name) THEN
276: dbms_sql.close_cursor(cursor_name);
277: END IF;
278: raise;
279:
280: END;

Line 307: cursor_name := dbms_sql.open_cursor;

303:
304: seqval := sequence_name||'.nextval';
305:
306: IF no_of_conids >0 THEN
307: cursor_name := dbms_sql.open_cursor;
308: dbms_sql.parse(cursor_name,'SELECT CS_INCIDENTS_CTX_S.nextval FROM DUAL', dbms_sql.v7);
309: dbms_sql.define_column(cursor_name,1,c1);
310: -- dbms_sql.bind_variable(cursor_name, ':c1',conid1);
311: rows_processed := dbms_sql.execute_and_fetch(cursor_name);

Line 308: dbms_sql.parse(cursor_name,'SELECT CS_INCIDENTS_CTX_S.nextval FROM DUAL', dbms_sql.v7);

304: seqval := sequence_name||'.nextval';
305:
306: IF no_of_conids >0 THEN
307: cursor_name := dbms_sql.open_cursor;
308: dbms_sql.parse(cursor_name,'SELECT CS_INCIDENTS_CTX_S.nextval FROM DUAL', dbms_sql.v7);
309: dbms_sql.define_column(cursor_name,1,c1);
310: -- dbms_sql.bind_variable(cursor_name, ':c1',conid1);
311: rows_processed := dbms_sql.execute_and_fetch(cursor_name);
312: dbms_sql.close_cursor(cursor_name);

Line 309: dbms_sql.define_column(cursor_name,1,c1);

305:
306: IF no_of_conids >0 THEN
307: cursor_name := dbms_sql.open_cursor;
308: dbms_sql.parse(cursor_name,'SELECT CS_INCIDENTS_CTX_S.nextval FROM DUAL', dbms_sql.v7);
309: dbms_sql.define_column(cursor_name,1,c1);
310: -- dbms_sql.bind_variable(cursor_name, ':c1',conid1);
311: rows_processed := dbms_sql.execute_and_fetch(cursor_name);
312: dbms_sql.close_cursor(cursor_name);
313:

Line 310: -- dbms_sql.bind_variable(cursor_name, ':c1',conid1);

306: IF no_of_conids >0 THEN
307: cursor_name := dbms_sql.open_cursor;
308: dbms_sql.parse(cursor_name,'SELECT CS_INCIDENTS_CTX_S.nextval FROM DUAL', dbms_sql.v7);
309: dbms_sql.define_column(cursor_name,1,c1);
310: -- dbms_sql.bind_variable(cursor_name, ':c1',conid1);
311: rows_processed := dbms_sql.execute_and_fetch(cursor_name);
312: dbms_sql.close_cursor(cursor_name);
313:
314: conid1:=c1;

Line 311: rows_processed := dbms_sql.execute_and_fetch(cursor_name);

307: cursor_name := dbms_sql.open_cursor;
308: dbms_sql.parse(cursor_name,'SELECT CS_INCIDENTS_CTX_S.nextval FROM DUAL', dbms_sql.v7);
309: dbms_sql.define_column(cursor_name,1,c1);
310: -- dbms_sql.bind_variable(cursor_name, ':c1',conid1);
311: rows_processed := dbms_sql.execute_and_fetch(cursor_name);
312: dbms_sql.close_cursor(cursor_name);
313:
314: conid1:=c1;
315:

Line 312: dbms_sql.close_cursor(cursor_name);

308: dbms_sql.parse(cursor_name,'SELECT CS_INCIDENTS_CTX_S.nextval FROM DUAL', dbms_sql.v7);
309: dbms_sql.define_column(cursor_name,1,c1);
310: -- dbms_sql.bind_variable(cursor_name, ':c1',conid1);
311: rows_processed := dbms_sql.execute_and_fetch(cursor_name);
312: dbms_sql.close_cursor(cursor_name);
313:
314: conid1:=c1;
315:
316: /***

Line 418: cursor_name := dbms_sql.open_cursor;

414: rows_processed INTEGER; -- Not used currently
415: BEGIN
416: str := 'BEGIN CTX_QUERY.GETTAB(CTX_QUERY.hittab,:res_tab); END;';
417:
418: cursor_name := dbms_sql.open_cursor;
419: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
420: dbms_sql.bind_variable(cursor_name,':res_tab',null,100);
421: rows_processed := dbms_sql.execute(cursor_name);
422: dbms_sql.variable_value(cursor_name,':res_tab',result_table);

Line 419: dbms_sql.parse(cursor_name,str,dbms_sql.v7);

415: BEGIN
416: str := 'BEGIN CTX_QUERY.GETTAB(CTX_QUERY.hittab,:res_tab); END;';
417:
418: cursor_name := dbms_sql.open_cursor;
419: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
420: dbms_sql.bind_variable(cursor_name,':res_tab',null,100);
421: rows_processed := dbms_sql.execute(cursor_name);
422: dbms_sql.variable_value(cursor_name,':res_tab',result_table);
423: dbms_sql.close_cursor(cursor_name);

Line 420: dbms_sql.bind_variable(cursor_name,':res_tab',null,100);

416: str := 'BEGIN CTX_QUERY.GETTAB(CTX_QUERY.hittab,:res_tab); END;';
417:
418: cursor_name := dbms_sql.open_cursor;
419: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
420: dbms_sql.bind_variable(cursor_name,':res_tab',null,100);
421: rows_processed := dbms_sql.execute(cursor_name);
422: dbms_sql.variable_value(cursor_name,':res_tab',result_table);
423: dbms_sql.close_cursor(cursor_name);
424:

Line 421: rows_processed := dbms_sql.execute(cursor_name);

417:
418: cursor_name := dbms_sql.open_cursor;
419: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
420: dbms_sql.bind_variable(cursor_name,':res_tab',null,100);
421: rows_processed := dbms_sql.execute(cursor_name);
422: dbms_sql.variable_value(cursor_name,':res_tab',result_table);
423: dbms_sql.close_cursor(cursor_name);
424:
425: END Get_Result_Table;

Line 422: dbms_sql.variable_value(cursor_name,':res_tab',result_table);

418: cursor_name := dbms_sql.open_cursor;
419: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
420: dbms_sql.bind_variable(cursor_name,':res_tab',null,100);
421: rows_processed := dbms_sql.execute(cursor_name);
422: dbms_sql.variable_value(cursor_name,':res_tab',result_table);
423: dbms_sql.close_cursor(cursor_name);
424:
425: END Get_Result_Table;
426:

Line 423: dbms_sql.close_cursor(cursor_name);

419: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
420: dbms_sql.bind_variable(cursor_name,':res_tab',null,100);
421: rows_processed := dbms_sql.execute(cursor_name);
422: dbms_sql.variable_value(cursor_name,':res_tab',result_table);
423: dbms_sql.close_cursor(cursor_name);
424:
425: END Get_Result_Table;
426:
427:

Line 439: cursor_name := dbms_sql.open_cursor;

435: rows_processed INTEGER; -- Not used currently
436: BEGIN
437: str := 'BEGIN CTX_QUERY.RELTAB('''|| result_table || '''); END;';
438:
439: cursor_name := dbms_sql.open_cursor;
440: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
441: rows_processed := dbms_sql.execute(cursor_name);
442: dbms_sql.close_cursor(cursor_name);
443: END Release_Result_Table;

Line 440: dbms_sql.parse(cursor_name,str,dbms_sql.v7);

436: BEGIN
437: str := 'BEGIN CTX_QUERY.RELTAB('''|| result_table || '''); END;';
438:
439: cursor_name := dbms_sql.open_cursor;
440: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
441: rows_processed := dbms_sql.execute(cursor_name);
442: dbms_sql.close_cursor(cursor_name);
443: END Release_Result_Table;
444:

Line 441: rows_processed := dbms_sql.execute(cursor_name);

437: str := 'BEGIN CTX_QUERY.RELTAB('''|| result_table || '''); END;';
438:
439: cursor_name := dbms_sql.open_cursor;
440: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
441: rows_processed := dbms_sql.execute(cursor_name);
442: dbms_sql.close_cursor(cursor_name);
443: END Release_Result_Table;
444:
445:

Line 442: dbms_sql.close_cursor(cursor_name);

438:
439: cursor_name := dbms_sql.open_cursor;
440: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
441: rows_processed := dbms_sql.execute(cursor_name);
442: dbms_sql.close_cursor(cursor_name);
443: END Release_Result_Table;
444:
445:
446: END;