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.EDW_SIZE_WRAPPER dependencies on DBMS_SQL

Line 108: l_cursor_id := dbms_sql.open_cursor;

104: fnd_file.put_line(FND_FILE.LOG, ' ') ;
105: ELSE
106: api_CLAUSE := 'begin ' || l_row_len_proc_name ||' (:s1, :s2, :s3) ; end; ';
107:
108: l_cursor_id := dbms_sql.open_cursor;
109: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
110: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
111: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
112: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);

Line 109: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);

105: ELSE
106: api_CLAUSE := 'begin ' || l_row_len_proc_name ||' (:s1, :s2, :s3) ; end; ';
107:
108: l_cursor_id := dbms_sql.open_cursor;
109: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
110: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
111: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
112: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
113: l_dummy := dbms_sql.execute(l_cursor_id);

Line 110: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);

106: api_CLAUSE := 'begin ' || l_row_len_proc_name ||' (:s1, :s2, :s3) ; end; ';
107:
108: l_cursor_id := dbms_sql.open_cursor;
109: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
110: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
111: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
112: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
113: l_dummy := dbms_sql.execute(l_cursor_id);
114: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);

Line 111: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);

107:
108: l_cursor_id := dbms_sql.open_cursor;
109: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
110: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
111: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
112: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
113: l_dummy := dbms_sql.execute(l_cursor_id);
114: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);
115: dbms_sql.close_cursor(l_cursor_id);

Line 112: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);

108: l_cursor_id := dbms_sql.open_cursor;
109: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
110: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
111: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
112: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
113: l_dummy := dbms_sql.execute(l_cursor_id);
114: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);
115: dbms_sql.close_cursor(l_cursor_id);
116:

Line 113: l_dummy := dbms_sql.execute(l_cursor_id);

109: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
110: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
111: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
112: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
113: l_dummy := dbms_sql.execute(l_cursor_id);
114: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);
115: dbms_sql.close_cursor(l_cursor_id);
116:
117: IF p_input_num_rows = 0 THEN

Line 114: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);

110: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
111: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
112: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
113: l_dummy := dbms_sql.execute(l_cursor_id);
114: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);
115: dbms_sql.close_cursor(l_cursor_id);
116:
117: IF p_input_num_rows = 0 THEN
118: api_CLAUSE := 'begin ' || l_row_cnt_proc_name ||' (:s1, :s2, :s3) ; end; ';

Line 115: dbms_sql.close_cursor(l_cursor_id);

111: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
112: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
113: l_dummy := dbms_sql.execute(l_cursor_id);
114: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);
115: dbms_sql.close_cursor(l_cursor_id);
116:
117: IF p_input_num_rows = 0 THEN
118: api_CLAUSE := 'begin ' || l_row_cnt_proc_name ||' (:s1, :s2, :s3) ; end; ';
119:

Line 120: l_cursor_id := dbms_sql.open_cursor;

116:
117: IF p_input_num_rows = 0 THEN
118: api_CLAUSE := 'begin ' || l_row_cnt_proc_name ||' (:s1, :s2, :s3) ; end; ';
119:
120: l_cursor_id := dbms_sql.open_cursor;
121: dbms_sql.parse(l_cursor_id, api_CLAUSE, DBMS_SQL.V7);
122: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
123: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
124: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);

Line 121: dbms_sql.parse(l_cursor_id, api_CLAUSE, DBMS_SQL.V7);

117: IF p_input_num_rows = 0 THEN
118: api_CLAUSE := 'begin ' || l_row_cnt_proc_name ||' (:s1, :s2, :s3) ; end; ';
119:
120: l_cursor_id := dbms_sql.open_cursor;
121: dbms_sql.parse(l_cursor_id, api_CLAUSE, DBMS_SQL.V7);
122: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
123: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
124: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
125: l_dummy := dbms_sql.execute(l_cursor_id);

Line 122: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);

118: api_CLAUSE := 'begin ' || l_row_cnt_proc_name ||' (:s1, :s2, :s3) ; end; ';
119:
120: l_cursor_id := dbms_sql.open_cursor;
121: dbms_sql.parse(l_cursor_id, api_CLAUSE, DBMS_SQL.V7);
122: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
123: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
124: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
125: l_dummy := dbms_sql.execute(l_cursor_id);
126: dbms_sql.variable_value(l_cursor_id, ':s3', l_num_rows);

Line 123: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);

119:
120: l_cursor_id := dbms_sql.open_cursor;
121: dbms_sql.parse(l_cursor_id, api_CLAUSE, DBMS_SQL.V7);
122: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
123: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
124: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
125: l_dummy := dbms_sql.execute(l_cursor_id);
126: dbms_sql.variable_value(l_cursor_id, ':s3', l_num_rows);
127: dbms_sql.close_cursor(l_cursor_id);

Line 124: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);

120: l_cursor_id := dbms_sql.open_cursor;
121: dbms_sql.parse(l_cursor_id, api_CLAUSE, DBMS_SQL.V7);
122: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
123: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
124: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
125: l_dummy := dbms_sql.execute(l_cursor_id);
126: dbms_sql.variable_value(l_cursor_id, ':s3', l_num_rows);
127: dbms_sql.close_cursor(l_cursor_id);
128: ELSE

Line 125: l_dummy := dbms_sql.execute(l_cursor_id);

121: dbms_sql.parse(l_cursor_id, api_CLAUSE, DBMS_SQL.V7);
122: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
123: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
124: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
125: l_dummy := dbms_sql.execute(l_cursor_id);
126: dbms_sql.variable_value(l_cursor_id, ':s3', l_num_rows);
127: dbms_sql.close_cursor(l_cursor_id);
128: ELSE
129: l_num_rows := p_input_num_rows;

Line 126: dbms_sql.variable_value(l_cursor_id, ':s3', l_num_rows);

122: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
123: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
124: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
125: l_dummy := dbms_sql.execute(l_cursor_id);
126: dbms_sql.variable_value(l_cursor_id, ':s3', l_num_rows);
127: dbms_sql.close_cursor(l_cursor_id);
128: ELSE
129: l_num_rows := p_input_num_rows;
130: END IF;

Line 127: dbms_sql.close_cursor(l_cursor_id);

123: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
124: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
125: l_dummy := dbms_sql.execute(l_cursor_id);
126: dbms_sql.variable_value(l_cursor_id, ':s3', l_num_rows);
127: dbms_sql.close_cursor(l_cursor_id);
128: ELSE
129: l_num_rows := p_input_num_rows;
130: END IF;
131:

Line 172: l_cursor_id := dbms_sql.open_cursor;

168: -- RAISE PACKAGE_NOT_FOUND;
169: ELSE
170: api_CLAUSE := 'begin ' || l_row_len_proc_name ||' (:s1, :s2, :s3) ; end; ';
171:
172: l_cursor_id := dbms_sql.open_cursor;
173: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
174: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
175: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
176: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);

Line 173: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);

169: ELSE
170: api_CLAUSE := 'begin ' || l_row_len_proc_name ||' (:s1, :s2, :s3) ; end; ';
171:
172: l_cursor_id := dbms_sql.open_cursor;
173: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
174: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
175: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
176: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
177: l_dummy := dbms_sql.execute(l_cursor_id);

Line 174: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);

170: api_CLAUSE := 'begin ' || l_row_len_proc_name ||' (:s1, :s2, :s3) ; end; ';
171:
172: l_cursor_id := dbms_sql.open_cursor;
173: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
174: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
175: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
176: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
177: l_dummy := dbms_sql.execute(l_cursor_id);
178: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);

Line 175: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);

171:
172: l_cursor_id := dbms_sql.open_cursor;
173: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
174: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
175: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
176: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
177: l_dummy := dbms_sql.execute(l_cursor_id);
178: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);
179: dbms_sql.close_cursor(l_cursor_id);

Line 176: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);

172: l_cursor_id := dbms_sql.open_cursor;
173: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
174: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
175: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
176: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
177: l_dummy := dbms_sql.execute(l_cursor_id);
178: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);
179: dbms_sql.close_cursor(l_cursor_id);
180:

Line 177: l_dummy := dbms_sql.execute(l_cursor_id);

173: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
174: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
175: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
176: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
177: l_dummy := dbms_sql.execute(l_cursor_id);
178: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);
179: dbms_sql.close_cursor(l_cursor_id);
180:
181: IF p_input_num_rows = 0 THEN

Line 178: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);

174: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
175: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
176: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
177: l_dummy := dbms_sql.execute(l_cursor_id);
178: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);
179: dbms_sql.close_cursor(l_cursor_id);
180:
181: IF p_input_num_rows = 0 THEN
182: api_CLAUSE := 'begin ' || l_row_cnt_proc_name ||' (:s1, :s2, :s3) ; end; ';

Line 179: dbms_sql.close_cursor(l_cursor_id);

175: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
176: dbms_sql.bind_variable(l_cursor_id, ':s3', l_avg_row_len);
177: l_dummy := dbms_sql.execute(l_cursor_id);
178: dbms_sql.variable_value(l_cursor_id, ':s3', l_avg_row_len);
179: dbms_sql.close_cursor(l_cursor_id);
180:
181: IF p_input_num_rows = 0 THEN
182: api_CLAUSE := 'begin ' || l_row_cnt_proc_name ||' (:s1, :s2, :s3) ; end; ';
183:

Line 184: l_cursor_id := dbms_sql.open_cursor;

180:
181: IF p_input_num_rows = 0 THEN
182: api_CLAUSE := 'begin ' || l_row_cnt_proc_name ||' (:s1, :s2, :s3) ; end; ';
183:
184: l_cursor_id := dbms_sql.open_cursor;
185: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
186: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
187: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
188: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);

Line 185: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);

181: IF p_input_num_rows = 0 THEN
182: api_CLAUSE := 'begin ' || l_row_cnt_proc_name ||' (:s1, :s2, :s3) ; end; ';
183:
184: l_cursor_id := dbms_sql.open_cursor;
185: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
186: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
187: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
188: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
189: l_dummy := dbms_sql.execute(l_cursor_id);

Line 186: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);

182: api_CLAUSE := 'begin ' || l_row_cnt_proc_name ||' (:s1, :s2, :s3) ; end; ';
183:
184: l_cursor_id := dbms_sql.open_cursor;
185: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
186: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
187: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
188: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
189: l_dummy := dbms_sql.execute(l_cursor_id);
190:

Line 187: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);

183:
184: l_cursor_id := dbms_sql.open_cursor;
185: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
186: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
187: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
188: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
189: l_dummy := dbms_sql.execute(l_cursor_id);
190:
191: dbms_sql.variable_value(l_cursor_id, ':s3', l_num_rows);

Line 188: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);

184: l_cursor_id := dbms_sql.open_cursor;
185: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
186: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
187: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
188: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
189: l_dummy := dbms_sql.execute(l_cursor_id);
190:
191: dbms_sql.variable_value(l_cursor_id, ':s3', l_num_rows);
192: dbms_sql.close_cursor(l_cursor_id);

Line 189: l_dummy := dbms_sql.execute(l_cursor_id);

185: dbms_sql.parse(l_cursor_id ,api_CLAUSE, DBMS_SQL.V7);
186: dbms_sql.bind_variable(l_cursor_id, ':s1', g_from_date);
187: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
188: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
189: l_dummy := dbms_sql.execute(l_cursor_id);
190:
191: dbms_sql.variable_value(l_cursor_id, ':s3', l_num_rows);
192: dbms_sql.close_cursor(l_cursor_id);
193: ELSE

Line 191: dbms_sql.variable_value(l_cursor_id, ':s3', l_num_rows);

187: dbms_sql.bind_variable(l_cursor_id, ':s2', g_to_date);
188: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
189: l_dummy := dbms_sql.execute(l_cursor_id);
190:
191: dbms_sql.variable_value(l_cursor_id, ':s3', l_num_rows);
192: dbms_sql.close_cursor(l_cursor_id);
193: ELSE
194: l_num_rows := p_input_num_rows;
195: END IF;

Line 192: dbms_sql.close_cursor(l_cursor_id);

188: dbms_sql.bind_variable(l_cursor_id, ':s3', l_num_rows);
189: l_dummy := dbms_sql.execute(l_cursor_id);
190:
191: dbms_sql.variable_value(l_cursor_id, ':s3', l_num_rows);
192: dbms_sql.close_cursor(l_cursor_id);
193: ELSE
194: l_num_rows := p_input_num_rows;
195: END IF;
196: