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_INCIDENT_CTX_PKG dependencies on DBMS_SQL

Line 12: cursor_name := dbms_sql.open_cursor;

8: rows_processed INTEGER; -- Not used currently
9: BEGIN
10:
11: IF result_table is not NULL THEN
12: cursor_name := dbms_sql.open_cursor;
13: dbms_sql.parse(cursor_name,'TRUNCATE TABLE '||result_table,dbms_sql.v7);
14: rows_processed := dbms_sql.execute(cursor_name);
15: dbms_sql.close_cursor(cursor_name);
16: END IF;

Line 13: dbms_sql.parse(cursor_name,'TRUNCATE TABLE '||result_table,dbms_sql.v7);

9: BEGIN
10:
11: IF result_table is not NULL THEN
12: cursor_name := dbms_sql.open_cursor;
13: dbms_sql.parse(cursor_name,'TRUNCATE TABLE '||result_table,dbms_sql.v7);
14: rows_processed := dbms_sql.execute(cursor_name);
15: dbms_sql.close_cursor(cursor_name);
16: END IF;
17:

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

10:
11: IF result_table is not NULL THEN
12: cursor_name := dbms_sql.open_cursor;
13: dbms_sql.parse(cursor_name,'TRUNCATE TABLE '||result_table,dbms_sql.v7);
14: rows_processed := dbms_sql.execute(cursor_name);
15: dbms_sql.close_cursor(cursor_name);
16: END IF;
17:
18: IF str1 is NOT NULL THEN

Line 15: dbms_sql.close_cursor(cursor_name);

11: IF result_table is not NULL THEN
12: cursor_name := dbms_sql.open_cursor;
13: dbms_sql.parse(cursor_name,'TRUNCATE TABLE '||result_table,dbms_sql.v7);
14: rows_processed := dbms_sql.execute(cursor_name);
15: dbms_sql.close_cursor(cursor_name);
16: END IF;
17:
18: IF str1 is NOT NULL THEN
19: cursor_name := dbms_sql.open_cursor;

Line 19: cursor_name := dbms_sql.open_cursor;

15: dbms_sql.close_cursor(cursor_name);
16: END IF;
17:
18: IF str1 is NOT NULL THEN
19: cursor_name := dbms_sql.open_cursor;
20: dbms_sql.parse(cursor_name,str1,dbms_sql.v7);
21: rows_processed := dbms_sql.execute(cursor_name);
22: dbms_sql.close_cursor(cursor_name);
23: END IF;

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

16: END IF;
17:
18: IF str1 is NOT NULL THEN
19: cursor_name := dbms_sql.open_cursor;
20: dbms_sql.parse(cursor_name,str1,dbms_sql.v7);
21: rows_processed := dbms_sql.execute(cursor_name);
22: dbms_sql.close_cursor(cursor_name);
23: END IF;
24:

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

17:
18: IF str1 is NOT NULL THEN
19: cursor_name := dbms_sql.open_cursor;
20: dbms_sql.parse(cursor_name,str1,dbms_sql.v7);
21: rows_processed := dbms_sql.execute(cursor_name);
22: dbms_sql.close_cursor(cursor_name);
23: END IF;
24:
25: IF str2 is NOT NULL THEN

Line 22: dbms_sql.close_cursor(cursor_name);

18: IF str1 is NOT NULL THEN
19: cursor_name := dbms_sql.open_cursor;
20: dbms_sql.parse(cursor_name,str1,dbms_sql.v7);
21: rows_processed := dbms_sql.execute(cursor_name);
22: dbms_sql.close_cursor(cursor_name);
23: END IF;
24:
25: IF str2 is NOT NULL THEN
26: cursor_name := dbms_sql.open_cursor;

Line 26: cursor_name := dbms_sql.open_cursor;

22: dbms_sql.close_cursor(cursor_name);
23: END IF;
24:
25: IF str2 is NOT NULL THEN
26: cursor_name := dbms_sql.open_cursor;
27: dbms_sql.parse(cursor_name,str2,dbms_sql.v7);
28: rows_processed := dbms_sql.execute(cursor_name);
29: dbms_sql.close_cursor(cursor_name);
30: END IF;

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

23: END IF;
24:
25: IF str2 is NOT NULL THEN
26: cursor_name := dbms_sql.open_cursor;
27: dbms_sql.parse(cursor_name,str2,dbms_sql.v7);
28: rows_processed := dbms_sql.execute(cursor_name);
29: dbms_sql.close_cursor(cursor_name);
30: END IF;
31:

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

24:
25: IF str2 is NOT NULL THEN
26: cursor_name := dbms_sql.open_cursor;
27: dbms_sql.parse(cursor_name,str2,dbms_sql.v7);
28: rows_processed := dbms_sql.execute(cursor_name);
29: dbms_sql.close_cursor(cursor_name);
30: END IF;
31:
32: IF str3 is NOT NULL THEN

Line 29: dbms_sql.close_cursor(cursor_name);

25: IF str2 is NOT NULL THEN
26: cursor_name := dbms_sql.open_cursor;
27: dbms_sql.parse(cursor_name,str2,dbms_sql.v7);
28: rows_processed := dbms_sql.execute(cursor_name);
29: dbms_sql.close_cursor(cursor_name);
30: END IF;
31:
32: IF str3 is NOT NULL THEN
33: cursor_name := dbms_sql.open_cursor;

Line 33: cursor_name := dbms_sql.open_cursor;

29: dbms_sql.close_cursor(cursor_name);
30: END IF;
31:
32: IF str3 is NOT NULL THEN
33: cursor_name := dbms_sql.open_cursor;
34: dbms_sql.parse(cursor_name,str3,dbms_sql.v7);
35: rows_processed := dbms_sql.execute(cursor_name);
36: dbms_sql.close_cursor(cursor_name);
37: END IF;

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

30: END IF;
31:
32: IF str3 is NOT NULL THEN
33: cursor_name := dbms_sql.open_cursor;
34: dbms_sql.parse(cursor_name,str3,dbms_sql.v7);
35: rows_processed := dbms_sql.execute(cursor_name);
36: dbms_sql.close_cursor(cursor_name);
37: END IF;
38:

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

31:
32: IF str3 is NOT NULL THEN
33: cursor_name := dbms_sql.open_cursor;
34: dbms_sql.parse(cursor_name,str3,dbms_sql.v7);
35: rows_processed := dbms_sql.execute(cursor_name);
36: dbms_sql.close_cursor(cursor_name);
37: END IF;
38:
39: IF str4 is NOT NULL THEN

Line 36: dbms_sql.close_cursor(cursor_name);

32: IF str3 is NOT NULL THEN
33: cursor_name := dbms_sql.open_cursor;
34: dbms_sql.parse(cursor_name,str3,dbms_sql.v7);
35: rows_processed := dbms_sql.execute(cursor_name);
36: dbms_sql.close_cursor(cursor_name);
37: END IF;
38:
39: IF str4 is NOT NULL THEN
40: cursor_name := dbms_sql.open_cursor;

Line 40: cursor_name := dbms_sql.open_cursor;

36: dbms_sql.close_cursor(cursor_name);
37: END IF;
38:
39: IF str4 is NOT NULL THEN
40: cursor_name := dbms_sql.open_cursor;
41: dbms_sql.parse(cursor_name,str4,dbms_sql.v7);
42: rows_processed := dbms_sql.execute(cursor_name);
43: dbms_sql.close_cursor(cursor_name);
44: END IF;

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

37: END IF;
38:
39: IF str4 is NOT NULL THEN
40: cursor_name := dbms_sql.open_cursor;
41: dbms_sql.parse(cursor_name,str4,dbms_sql.v7);
42: rows_processed := dbms_sql.execute(cursor_name);
43: dbms_sql.close_cursor(cursor_name);
44: END IF;
45:

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

38:
39: IF str4 is NOT NULL THEN
40: cursor_name := dbms_sql.open_cursor;
41: dbms_sql.parse(cursor_name,str4,dbms_sql.v7);
42: rows_processed := dbms_sql.execute(cursor_name);
43: dbms_sql.close_cursor(cursor_name);
44: END IF;
45:
46: EXCEPTION

Line 43: dbms_sql.close_cursor(cursor_name);

39: IF str4 is NOT NULL THEN
40: cursor_name := dbms_sql.open_cursor;
41: dbms_sql.parse(cursor_name,str4,dbms_sql.v7);
42: rows_processed := dbms_sql.execute(cursor_name);
43: dbms_sql.close_cursor(cursor_name);
44: END IF;
45:
46: EXCEPTION
47: WHEN OTHERS THEN

Line 53: IF dbms_sql.is_open(cursor_name) THEN

49: -- query string contains any stop words. Not required as we are
50: -- now filterung off stop words.)
51:
52: IF instr(sqlerrm,'DRG-10308') <>0 THEN
53: IF dbms_sql.is_open(cursor_name) THEN
54: dbms_sql.close_cursor(cursor_name);
55: END IF;
56: fnd_message.set_name('CS','CS_INC_CTX_NO_SERVER');
57: app_exception.raise_exception;

Line 54: dbms_sql.close_cursor(cursor_name);

50: -- now filterung off stop words.)
51:
52: IF instr(sqlerrm,'DRG-10308') <>0 THEN
53: IF dbms_sql.is_open(cursor_name) THEN
54: dbms_sql.close_cursor(cursor_name);
55: END IF;
56: fnd_message.set_name('CS','CS_INC_CTX_NO_SERVER');
57: app_exception.raise_exception;
58: ELSE

Line 59: dbms_sql.close_cursor(cursor_name);

55: END IF;
56: fnd_message.set_name('CS','CS_INC_CTX_NO_SERVER');
57: app_exception.raise_exception;
58: ELSE
59: dbms_sql.close_cursor(cursor_name);
60: fnd_message.set_name('CS','CS_SR_CONTEXT_ERROR');
61: fnd_message.set_token('ERRORM',sqlerrm);
62: app_exception.raise_exception;
63: --raise;

Line 76: cursor_name := dbms_sql.open_cursor;

72: string VARCHAR2(200);
73: rows_processed INTEGER; -- Not used currently
74: BEGIN
75: string := 'BEGIN ctx_dml.reindex('''||policy_name||''','''||primary_key||'''); END;';
76: cursor_name := dbms_sql.open_cursor;
77: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
78: rows_processed := dbms_sql.execute(cursor_name);
79: dbms_sql.close_cursor(cursor_name);
80: EXCEPTION

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

73: rows_processed INTEGER; -- Not used currently
74: BEGIN
75: string := 'BEGIN ctx_dml.reindex('''||policy_name||''','''||primary_key||'''); END;';
76: cursor_name := dbms_sql.open_cursor;
77: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
78: rows_processed := dbms_sql.execute(cursor_name);
79: dbms_sql.close_cursor(cursor_name);
80: EXCEPTION
81: WHEN OTHERS THEN

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

74: BEGIN
75: string := 'BEGIN ctx_dml.reindex('''||policy_name||''','''||primary_key||'''); END;';
76: cursor_name := dbms_sql.open_cursor;
77: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
78: rows_processed := dbms_sql.execute(cursor_name);
79: dbms_sql.close_cursor(cursor_name);
80: EXCEPTION
81: WHEN OTHERS THEN
82: IF dbms_sql.is_open(cursor_name) THEN

Line 79: dbms_sql.close_cursor(cursor_name);

75: string := 'BEGIN ctx_dml.reindex('''||policy_name||''','''||primary_key||'''); END;';
76: cursor_name := dbms_sql.open_cursor;
77: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
78: rows_processed := dbms_sql.execute(cursor_name);
79: dbms_sql.close_cursor(cursor_name);
80: EXCEPTION
81: WHEN OTHERS THEN
82: IF dbms_sql.is_open(cursor_name) THEN
83: dbms_sql.close_cursor(cursor_name);

Line 82: IF dbms_sql.is_open(cursor_name) THEN

78: rows_processed := dbms_sql.execute(cursor_name);
79: dbms_sql.close_cursor(cursor_name);
80: EXCEPTION
81: WHEN OTHERS THEN
82: IF dbms_sql.is_open(cursor_name) THEN
83: dbms_sql.close_cursor(cursor_name);
84: END IF;
85: raise;
86: END; -- update_context_index.

Line 83: dbms_sql.close_cursor(cursor_name);

79: dbms_sql.close_cursor(cursor_name);
80: EXCEPTION
81: WHEN OTHERS THEN
82: IF dbms_sql.is_open(cursor_name) THEN
83: dbms_sql.close_cursor(cursor_name);
84: END IF;
85: raise;
86: END; -- update_context_index.
87:

Line 112: cursor_name := dbms_sql.open_cursor;

108: AND po.pol_name in
109: (''CS_INCIDENTS_SUMMARY'',''CS_INCIDENTS_COMMENTS'',
110: ''CS_INCIDENTS_PROBLEM_DESC'', ''CS_INCIDENTS_RESOLUTION_DESC'')';
111:
112: cursor_name := dbms_sql.open_cursor;
113: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
114: dbms_sql.define_column(cursor_name,1,stop_word,100);
115: rows_processed := dbms_sql.execute(cursor_name);
116: LOOP

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

109: (''CS_INCIDENTS_SUMMARY'',''CS_INCIDENTS_COMMENTS'',
110: ''CS_INCIDENTS_PROBLEM_DESC'', ''CS_INCIDENTS_RESOLUTION_DESC'')';
111:
112: cursor_name := dbms_sql.open_cursor;
113: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
114: dbms_sql.define_column(cursor_name,1,stop_word,100);
115: rows_processed := dbms_sql.execute(cursor_name);
116: LOOP
117: IF dbms_sql.fetch_rows(cursor_name) >0 THEN

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

110: ''CS_INCIDENTS_PROBLEM_DESC'', ''CS_INCIDENTS_RESOLUTION_DESC'')';
111:
112: cursor_name := dbms_sql.open_cursor;
113: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
114: dbms_sql.define_column(cursor_name,1,stop_word,100);
115: rows_processed := dbms_sql.execute(cursor_name);
116: LOOP
117: IF dbms_sql.fetch_rows(cursor_name) >0 THEN
118: -- get column values of the row.

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

111:
112: cursor_name := dbms_sql.open_cursor;
113: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
114: dbms_sql.define_column(cursor_name,1,stop_word,100);
115: rows_processed := dbms_sql.execute(cursor_name);
116: LOOP
117: IF dbms_sql.fetch_rows(cursor_name) >0 THEN
118: -- get column values of the row.
119: dbms_sql.column_value(cursor_name,1,stop_word);

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

113: dbms_sql.parse(cursor_name,string,dbms_sql.v7);
114: dbms_sql.define_column(cursor_name,1,stop_word,100);
115: rows_processed := dbms_sql.execute(cursor_name);
116: LOOP
117: IF dbms_sql.fetch_rows(cursor_name) >0 THEN
118: -- get column values of the row.
119: dbms_sql.column_value(cursor_name,1,stop_word);
120: all_stop_words := all_stop_words || stop_word || ' ';
121: ELSE

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

115: rows_processed := dbms_sql.execute(cursor_name);
116: LOOP
117: IF dbms_sql.fetch_rows(cursor_name) >0 THEN
118: -- get column values of the row.
119: dbms_sql.column_value(cursor_name,1,stop_word);
120: all_stop_words := all_stop_words || stop_word || ' ';
121: ELSE
122: EXIT;
123: END IF;

Line 125: dbms_sql.close_cursor(cursor_name);

121: ELSE
122: EXIT;
123: END IF;
124: END LOOP;
125: dbms_sql.close_cursor(cursor_name);
126: stop_word_list:=all_stop_words;
127: EXCEPTION
128: WHEN OTHERS THEN
129: IF dbms_sql.is_open(cursor_name) THEN

Line 129: IF dbms_sql.is_open(cursor_name) THEN

125: dbms_sql.close_cursor(cursor_name);
126: stop_word_list:=all_stop_words;
127: EXCEPTION
128: WHEN OTHERS THEN
129: IF dbms_sql.is_open(cursor_name) THEN
130: dbms_sql.close_cursor(cursor_name);
131: END IF;
132: raise;
133: END; -- Get_Stop_Words.

Line 130: dbms_sql.close_cursor(cursor_name);

126: stop_word_list:=all_stop_words;
127: EXCEPTION
128: WHEN OTHERS THEN
129: IF dbms_sql.is_open(cursor_name) THEN
130: dbms_sql.close_cursor(cursor_name);
131: END IF;
132: raise;
133: END; -- Get_Stop_Words.
134:

Line 146: cursor_name := dbms_sql.open_cursor;

142: rows_processed INTEGER; -- Not used currently
143: BEGIN
144: str := 'BEGIN CTX_QUERY.GETTAB(CTX_QUERY.hittab,:res_tab); END;';
145:
146: cursor_name := dbms_sql.open_cursor;
147: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
148: dbms_sql.bind_variable(cursor_name,':res_tab',null,100);
149: rows_processed := dbms_sql.execute(cursor_name);
150: dbms_sql.variable_value(cursor_name,':res_tab',result_table);

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

143: BEGIN
144: str := 'BEGIN CTX_QUERY.GETTAB(CTX_QUERY.hittab,:res_tab); END;';
145:
146: cursor_name := dbms_sql.open_cursor;
147: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
148: dbms_sql.bind_variable(cursor_name,':res_tab',null,100);
149: rows_processed := dbms_sql.execute(cursor_name);
150: dbms_sql.variable_value(cursor_name,':res_tab',result_table);
151: dbms_sql.close_cursor(cursor_name);

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

144: str := 'BEGIN CTX_QUERY.GETTAB(CTX_QUERY.hittab,:res_tab); END;';
145:
146: cursor_name := dbms_sql.open_cursor;
147: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
148: dbms_sql.bind_variable(cursor_name,':res_tab',null,100);
149: rows_processed := dbms_sql.execute(cursor_name);
150: dbms_sql.variable_value(cursor_name,':res_tab',result_table);
151: dbms_sql.close_cursor(cursor_name);
152:

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

145:
146: cursor_name := dbms_sql.open_cursor;
147: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
148: dbms_sql.bind_variable(cursor_name,':res_tab',null,100);
149: rows_processed := dbms_sql.execute(cursor_name);
150: dbms_sql.variable_value(cursor_name,':res_tab',result_table);
151: dbms_sql.close_cursor(cursor_name);
152:
153: END Get_Result_Table;

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

146: cursor_name := dbms_sql.open_cursor;
147: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
148: dbms_sql.bind_variable(cursor_name,':res_tab',null,100);
149: rows_processed := dbms_sql.execute(cursor_name);
150: dbms_sql.variable_value(cursor_name,':res_tab',result_table);
151: dbms_sql.close_cursor(cursor_name);
152:
153: END Get_Result_Table;
154:

Line 151: dbms_sql.close_cursor(cursor_name);

147: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
148: dbms_sql.bind_variable(cursor_name,':res_tab',null,100);
149: rows_processed := dbms_sql.execute(cursor_name);
150: dbms_sql.variable_value(cursor_name,':res_tab',result_table);
151: dbms_sql.close_cursor(cursor_name);
152:
153: END Get_Result_Table;
154:
155: /***********************************************************************

Line 166: cursor_name := dbms_sql.open_cursor;

162: rows_processed INTEGER; -- Not used currently
163: BEGIN
164: str := 'BEGIN CTX_QUERY.RELTAB('''|| result_table || '''); END;';
165:
166: cursor_name := dbms_sql.open_cursor;
167: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
168: rows_processed := dbms_sql.execute(cursor_name);
169: dbms_sql.close_cursor(cursor_name);
170: END Release_Result_Table;

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

163: BEGIN
164: str := 'BEGIN CTX_QUERY.RELTAB('''|| result_table || '''); END;';
165:
166: cursor_name := dbms_sql.open_cursor;
167: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
168: rows_processed := dbms_sql.execute(cursor_name);
169: dbms_sql.close_cursor(cursor_name);
170: END Release_Result_Table;
171:

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

164: str := 'BEGIN CTX_QUERY.RELTAB('''|| result_table || '''); END;';
165:
166: cursor_name := dbms_sql.open_cursor;
167: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
168: rows_processed := dbms_sql.execute(cursor_name);
169: dbms_sql.close_cursor(cursor_name);
170: END Release_Result_Table;
171:
172:

Line 169: dbms_sql.close_cursor(cursor_name);

165:
166: cursor_name := dbms_sql.open_cursor;
167: dbms_sql.parse(cursor_name,str,dbms_sql.v7);
168: rows_processed := dbms_sql.execute(cursor_name);
169: dbms_sql.close_cursor(cursor_name);
170: END Release_Result_Table;
171:
172:
173: END;