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

Line 162: l_cur_get_inv := dbms_sql.open_cursor;

158:
159: l_select_cl := l_select_cl || l_where_cl || l_order_by_cl;
160: --dbms_output.put_line('Select Clause > ' || l_select_cl);
161:
162: l_cur_get_inv := dbms_sql.open_cursor;
163:
164: dbms_sql.parse(l_cur_get_inv, l_select_cl, dbms_sql.native);
165:
166: FOR i IN 1..l_trx_id_tbl.count LOOP

Line 164: dbms_sql.parse(l_cur_get_inv, l_select_cl, dbms_sql.native);

160: --dbms_output.put_line('Select Clause > ' || l_select_cl);
161:
162: l_cur_get_inv := dbms_sql.open_cursor;
163:
164: dbms_sql.parse(l_cur_get_inv, l_select_cl, dbms_sql.native);
165:
166: FOR i IN 1..l_trx_id_tbl.count LOOP
167: --dbms_output.put_line('i > ' || i);
168: dbms_sql.bind_variable(l_cur_get_inv, ':x' || i, l_trx_id_tbl(i));

Line 168: dbms_sql.bind_variable(l_cur_get_inv, ':x' || i, l_trx_id_tbl(i));

164: dbms_sql.parse(l_cur_get_inv, l_select_cl, dbms_sql.native);
165:
166: FOR i IN 1..l_trx_id_tbl.count LOOP
167: --dbms_output.put_line('i > ' || i);
168: dbms_sql.bind_variable(l_cur_get_inv, ':x' || i, l_trx_id_tbl(i));
169: END LOOP;
170:
171: l_inv_id_tbl(1) := null;
172: l_inv_num_tbl(1) := null;

Line 183: dbms_sql.define_column(l_cur_get_inv, 1, l_inv_id_tbl(1));

179: l_inv_date_tbl(1) := null;
180: l_inv_currency_tbl(1) := null;
181: l_fun_remaining_amt_tbl(1) := null;
182:
183: dbms_sql.define_column(l_cur_get_inv, 1, l_inv_id_tbl(1));
184: dbms_sql.define_column(l_cur_get_inv, 2, l_inv_num_tbl(1), 30);
185: dbms_sql.define_column(l_cur_get_inv, 3, l_inv_status_tbl(1), 80);
186: dbms_sql.define_column(l_cur_get_inv, 4, l_inv_class_tbl(1), 80);
187: dbms_sql.define_column(l_cur_get_inv, 5, l_inv_status_code_tbl(1), 30);

Line 184: dbms_sql.define_column(l_cur_get_inv, 2, l_inv_num_tbl(1), 30);

180: l_inv_currency_tbl(1) := null;
181: l_fun_remaining_amt_tbl(1) := null;
182:
183: dbms_sql.define_column(l_cur_get_inv, 1, l_inv_id_tbl(1));
184: dbms_sql.define_column(l_cur_get_inv, 2, l_inv_num_tbl(1), 30);
185: dbms_sql.define_column(l_cur_get_inv, 3, l_inv_status_tbl(1), 80);
186: dbms_sql.define_column(l_cur_get_inv, 4, l_inv_class_tbl(1), 80);
187: dbms_sql.define_column(l_cur_get_inv, 5, l_inv_status_code_tbl(1), 30);
188: dbms_sql.define_column(l_cur_get_inv, 6, l_inv_class_code_tbl(1), 20);

Line 185: dbms_sql.define_column(l_cur_get_inv, 3, l_inv_status_tbl(1), 80);

181: l_fun_remaining_amt_tbl(1) := null;
182:
183: dbms_sql.define_column(l_cur_get_inv, 1, l_inv_id_tbl(1));
184: dbms_sql.define_column(l_cur_get_inv, 2, l_inv_num_tbl(1), 30);
185: dbms_sql.define_column(l_cur_get_inv, 3, l_inv_status_tbl(1), 80);
186: dbms_sql.define_column(l_cur_get_inv, 4, l_inv_class_tbl(1), 80);
187: dbms_sql.define_column(l_cur_get_inv, 5, l_inv_status_code_tbl(1), 30);
188: dbms_sql.define_column(l_cur_get_inv, 6, l_inv_class_code_tbl(1), 20);
189: dbms_sql.define_column(l_cur_get_inv, 7, l_remaining_amt_tbl(1));

Line 186: dbms_sql.define_column(l_cur_get_inv, 4, l_inv_class_tbl(1), 80);

182:
183: dbms_sql.define_column(l_cur_get_inv, 1, l_inv_id_tbl(1));
184: dbms_sql.define_column(l_cur_get_inv, 2, l_inv_num_tbl(1), 30);
185: dbms_sql.define_column(l_cur_get_inv, 3, l_inv_status_tbl(1), 80);
186: dbms_sql.define_column(l_cur_get_inv, 4, l_inv_class_tbl(1), 80);
187: dbms_sql.define_column(l_cur_get_inv, 5, l_inv_status_code_tbl(1), 30);
188: dbms_sql.define_column(l_cur_get_inv, 6, l_inv_class_code_tbl(1), 20);
189: dbms_sql.define_column(l_cur_get_inv, 7, l_remaining_amt_tbl(1));
190: dbms_sql.define_column(l_cur_get_inv, 8, l_original_amt_tbl(1));

Line 187: dbms_sql.define_column(l_cur_get_inv, 5, l_inv_status_code_tbl(1), 30);

183: dbms_sql.define_column(l_cur_get_inv, 1, l_inv_id_tbl(1));
184: dbms_sql.define_column(l_cur_get_inv, 2, l_inv_num_tbl(1), 30);
185: dbms_sql.define_column(l_cur_get_inv, 3, l_inv_status_tbl(1), 80);
186: dbms_sql.define_column(l_cur_get_inv, 4, l_inv_class_tbl(1), 80);
187: dbms_sql.define_column(l_cur_get_inv, 5, l_inv_status_code_tbl(1), 30);
188: dbms_sql.define_column(l_cur_get_inv, 6, l_inv_class_code_tbl(1), 20);
189: dbms_sql.define_column(l_cur_get_inv, 7, l_remaining_amt_tbl(1));
190: dbms_sql.define_column(l_cur_get_inv, 8, l_original_amt_tbl(1));
191: dbms_sql.define_column(l_cur_get_inv, 9, l_inv_date_tbl(1));

Line 188: dbms_sql.define_column(l_cur_get_inv, 6, l_inv_class_code_tbl(1), 20);

184: dbms_sql.define_column(l_cur_get_inv, 2, l_inv_num_tbl(1), 30);
185: dbms_sql.define_column(l_cur_get_inv, 3, l_inv_status_tbl(1), 80);
186: dbms_sql.define_column(l_cur_get_inv, 4, l_inv_class_tbl(1), 80);
187: dbms_sql.define_column(l_cur_get_inv, 5, l_inv_status_code_tbl(1), 30);
188: dbms_sql.define_column(l_cur_get_inv, 6, l_inv_class_code_tbl(1), 20);
189: dbms_sql.define_column(l_cur_get_inv, 7, l_remaining_amt_tbl(1));
190: dbms_sql.define_column(l_cur_get_inv, 8, l_original_amt_tbl(1));
191: dbms_sql.define_column(l_cur_get_inv, 9, l_inv_date_tbl(1));
192: dbms_sql.define_column(l_cur_get_inv, 10, l_inv_currency_tbl(1), 15);

Line 189: dbms_sql.define_column(l_cur_get_inv, 7, l_remaining_amt_tbl(1));

185: dbms_sql.define_column(l_cur_get_inv, 3, l_inv_status_tbl(1), 80);
186: dbms_sql.define_column(l_cur_get_inv, 4, l_inv_class_tbl(1), 80);
187: dbms_sql.define_column(l_cur_get_inv, 5, l_inv_status_code_tbl(1), 30);
188: dbms_sql.define_column(l_cur_get_inv, 6, l_inv_class_code_tbl(1), 20);
189: dbms_sql.define_column(l_cur_get_inv, 7, l_remaining_amt_tbl(1));
190: dbms_sql.define_column(l_cur_get_inv, 8, l_original_amt_tbl(1));
191: dbms_sql.define_column(l_cur_get_inv, 9, l_inv_date_tbl(1));
192: dbms_sql.define_column(l_cur_get_inv, 10, l_inv_currency_tbl(1), 15);
193: dbms_sql.define_column(l_cur_get_inv, 11, l_fun_remaining_amt_tbl(1));

Line 190: dbms_sql.define_column(l_cur_get_inv, 8, l_original_amt_tbl(1));

186: dbms_sql.define_column(l_cur_get_inv, 4, l_inv_class_tbl(1), 80);
187: dbms_sql.define_column(l_cur_get_inv, 5, l_inv_status_code_tbl(1), 30);
188: dbms_sql.define_column(l_cur_get_inv, 6, l_inv_class_code_tbl(1), 20);
189: dbms_sql.define_column(l_cur_get_inv, 7, l_remaining_amt_tbl(1));
190: dbms_sql.define_column(l_cur_get_inv, 8, l_original_amt_tbl(1));
191: dbms_sql.define_column(l_cur_get_inv, 9, l_inv_date_tbl(1));
192: dbms_sql.define_column(l_cur_get_inv, 10, l_inv_currency_tbl(1), 15);
193: dbms_sql.define_column(l_cur_get_inv, 11, l_fun_remaining_amt_tbl(1));
194:

Line 191: dbms_sql.define_column(l_cur_get_inv, 9, l_inv_date_tbl(1));

187: dbms_sql.define_column(l_cur_get_inv, 5, l_inv_status_code_tbl(1), 30);
188: dbms_sql.define_column(l_cur_get_inv, 6, l_inv_class_code_tbl(1), 20);
189: dbms_sql.define_column(l_cur_get_inv, 7, l_remaining_amt_tbl(1));
190: dbms_sql.define_column(l_cur_get_inv, 8, l_original_amt_tbl(1));
191: dbms_sql.define_column(l_cur_get_inv, 9, l_inv_date_tbl(1));
192: dbms_sql.define_column(l_cur_get_inv, 10, l_inv_currency_tbl(1), 15);
193: dbms_sql.define_column(l_cur_get_inv, 11, l_fun_remaining_amt_tbl(1));
194:
195: l_rows_processed := dbms_sql.execute(l_cur_get_inv);

Line 192: dbms_sql.define_column(l_cur_get_inv, 10, l_inv_currency_tbl(1), 15);

188: dbms_sql.define_column(l_cur_get_inv, 6, l_inv_class_code_tbl(1), 20);
189: dbms_sql.define_column(l_cur_get_inv, 7, l_remaining_amt_tbl(1));
190: dbms_sql.define_column(l_cur_get_inv, 8, l_original_amt_tbl(1));
191: dbms_sql.define_column(l_cur_get_inv, 9, l_inv_date_tbl(1));
192: dbms_sql.define_column(l_cur_get_inv, 10, l_inv_currency_tbl(1), 15);
193: dbms_sql.define_column(l_cur_get_inv, 11, l_fun_remaining_amt_tbl(1));
194:
195: l_rows_processed := dbms_sql.execute(l_cur_get_inv);
196:

Line 193: dbms_sql.define_column(l_cur_get_inv, 11, l_fun_remaining_amt_tbl(1));

189: dbms_sql.define_column(l_cur_get_inv, 7, l_remaining_amt_tbl(1));
190: dbms_sql.define_column(l_cur_get_inv, 8, l_original_amt_tbl(1));
191: dbms_sql.define_column(l_cur_get_inv, 9, l_inv_date_tbl(1));
192: dbms_sql.define_column(l_cur_get_inv, 10, l_inv_currency_tbl(1), 15);
193: dbms_sql.define_column(l_cur_get_inv, 11, l_fun_remaining_amt_tbl(1));
194:
195: l_rows_processed := dbms_sql.execute(l_cur_get_inv);
196:
197: --dbms_output.put_line ('l_rows_processed > ' || l_rows_processed);

Line 195: l_rows_processed := dbms_sql.execute(l_cur_get_inv);

191: dbms_sql.define_column(l_cur_get_inv, 9, l_inv_date_tbl(1));
192: dbms_sql.define_column(l_cur_get_inv, 10, l_inv_currency_tbl(1), 15);
193: dbms_sql.define_column(l_cur_get_inv, 11, l_fun_remaining_amt_tbl(1));
194:
195: l_rows_processed := dbms_sql.execute(l_cur_get_inv);
196:
197: --dbms_output.put_line ('l_rows_processed > ' || l_rows_processed);
198: l_idx := 0;
199: LOOP

Line 202: l_rows_processed := dbms_sql.fetch_rows(l_cur_get_inv);

198: l_idx := 0;
199: LOOP
200: l_idx := l_idx + 1;
201:
202: l_rows_processed := dbms_sql.fetch_rows(l_cur_get_inv);
203: --dbms_output.put_line ('l_rows_processed > ' || l_rows_processed);
204: IF l_rows_processed <= 0 THEN
205: EXIT;
206: END IF;

Line 208: dbms_sql.column_value(l_cur_get_inv, 1, l_inv_id_tbl(l_idx));

204: IF l_rows_processed <= 0 THEN
205: EXIT;
206: END IF;
207:
208: dbms_sql.column_value(l_cur_get_inv, 1, l_inv_id_tbl(l_idx));
209: dbms_sql.column_value(l_cur_get_inv, 2, l_inv_num_tbl(l_idx));
210: dbms_sql.column_value(l_cur_get_inv, 3, l_inv_status_tbl(l_idx));
211: dbms_sql.column_value(l_cur_get_inv, 4, l_inv_class_tbl(l_idx));
212: dbms_sql.column_value(l_cur_get_inv, 5, l_inv_status_code_tbl(l_idx));

Line 209: dbms_sql.column_value(l_cur_get_inv, 2, l_inv_num_tbl(l_idx));

205: EXIT;
206: END IF;
207:
208: dbms_sql.column_value(l_cur_get_inv, 1, l_inv_id_tbl(l_idx));
209: dbms_sql.column_value(l_cur_get_inv, 2, l_inv_num_tbl(l_idx));
210: dbms_sql.column_value(l_cur_get_inv, 3, l_inv_status_tbl(l_idx));
211: dbms_sql.column_value(l_cur_get_inv, 4, l_inv_class_tbl(l_idx));
212: dbms_sql.column_value(l_cur_get_inv, 5, l_inv_status_code_tbl(l_idx));
213: dbms_sql.column_value(l_cur_get_inv, 6, l_inv_class_code_tbl(l_idx));

Line 210: dbms_sql.column_value(l_cur_get_inv, 3, l_inv_status_tbl(l_idx));

206: END IF;
207:
208: dbms_sql.column_value(l_cur_get_inv, 1, l_inv_id_tbl(l_idx));
209: dbms_sql.column_value(l_cur_get_inv, 2, l_inv_num_tbl(l_idx));
210: dbms_sql.column_value(l_cur_get_inv, 3, l_inv_status_tbl(l_idx));
211: dbms_sql.column_value(l_cur_get_inv, 4, l_inv_class_tbl(l_idx));
212: dbms_sql.column_value(l_cur_get_inv, 5, l_inv_status_code_tbl(l_idx));
213: dbms_sql.column_value(l_cur_get_inv, 6, l_inv_class_code_tbl(l_idx));
214: dbms_sql.column_value(l_cur_get_inv, 7, l_remaining_amt_tbl(l_idx));

Line 211: dbms_sql.column_value(l_cur_get_inv, 4, l_inv_class_tbl(l_idx));

207:
208: dbms_sql.column_value(l_cur_get_inv, 1, l_inv_id_tbl(l_idx));
209: dbms_sql.column_value(l_cur_get_inv, 2, l_inv_num_tbl(l_idx));
210: dbms_sql.column_value(l_cur_get_inv, 3, l_inv_status_tbl(l_idx));
211: dbms_sql.column_value(l_cur_get_inv, 4, l_inv_class_tbl(l_idx));
212: dbms_sql.column_value(l_cur_get_inv, 5, l_inv_status_code_tbl(l_idx));
213: dbms_sql.column_value(l_cur_get_inv, 6, l_inv_class_code_tbl(l_idx));
214: dbms_sql.column_value(l_cur_get_inv, 7, l_remaining_amt_tbl(l_idx));
215: dbms_sql.column_value(l_cur_get_inv, 8, l_original_amt_tbl(l_idx));

Line 212: dbms_sql.column_value(l_cur_get_inv, 5, l_inv_status_code_tbl(l_idx));

208: dbms_sql.column_value(l_cur_get_inv, 1, l_inv_id_tbl(l_idx));
209: dbms_sql.column_value(l_cur_get_inv, 2, l_inv_num_tbl(l_idx));
210: dbms_sql.column_value(l_cur_get_inv, 3, l_inv_status_tbl(l_idx));
211: dbms_sql.column_value(l_cur_get_inv, 4, l_inv_class_tbl(l_idx));
212: dbms_sql.column_value(l_cur_get_inv, 5, l_inv_status_code_tbl(l_idx));
213: dbms_sql.column_value(l_cur_get_inv, 6, l_inv_class_code_tbl(l_idx));
214: dbms_sql.column_value(l_cur_get_inv, 7, l_remaining_amt_tbl(l_idx));
215: dbms_sql.column_value(l_cur_get_inv, 8, l_original_amt_tbl(l_idx));
216: dbms_sql.column_value(l_cur_get_inv, 9, l_inv_date_tbl(l_idx));

Line 213: dbms_sql.column_value(l_cur_get_inv, 6, l_inv_class_code_tbl(l_idx));

209: dbms_sql.column_value(l_cur_get_inv, 2, l_inv_num_tbl(l_idx));
210: dbms_sql.column_value(l_cur_get_inv, 3, l_inv_status_tbl(l_idx));
211: dbms_sql.column_value(l_cur_get_inv, 4, l_inv_class_tbl(l_idx));
212: dbms_sql.column_value(l_cur_get_inv, 5, l_inv_status_code_tbl(l_idx));
213: dbms_sql.column_value(l_cur_get_inv, 6, l_inv_class_code_tbl(l_idx));
214: dbms_sql.column_value(l_cur_get_inv, 7, l_remaining_amt_tbl(l_idx));
215: dbms_sql.column_value(l_cur_get_inv, 8, l_original_amt_tbl(l_idx));
216: dbms_sql.column_value(l_cur_get_inv, 9, l_inv_date_tbl(l_idx));
217: dbms_sql.column_value(l_cur_get_inv, 10, l_inv_currency_tbl(l_idx));

Line 214: dbms_sql.column_value(l_cur_get_inv, 7, l_remaining_amt_tbl(l_idx));

210: dbms_sql.column_value(l_cur_get_inv, 3, l_inv_status_tbl(l_idx));
211: dbms_sql.column_value(l_cur_get_inv, 4, l_inv_class_tbl(l_idx));
212: dbms_sql.column_value(l_cur_get_inv, 5, l_inv_status_code_tbl(l_idx));
213: dbms_sql.column_value(l_cur_get_inv, 6, l_inv_class_code_tbl(l_idx));
214: dbms_sql.column_value(l_cur_get_inv, 7, l_remaining_amt_tbl(l_idx));
215: dbms_sql.column_value(l_cur_get_inv, 8, l_original_amt_tbl(l_idx));
216: dbms_sql.column_value(l_cur_get_inv, 9, l_inv_date_tbl(l_idx));
217: dbms_sql.column_value(l_cur_get_inv, 10, l_inv_currency_tbl(l_idx));
218: dbms_sql.column_value(l_cur_get_inv, 11, l_fun_remaining_amt_tbl(l_idx));

Line 215: dbms_sql.column_value(l_cur_get_inv, 8, l_original_amt_tbl(l_idx));

211: dbms_sql.column_value(l_cur_get_inv, 4, l_inv_class_tbl(l_idx));
212: dbms_sql.column_value(l_cur_get_inv, 5, l_inv_status_code_tbl(l_idx));
213: dbms_sql.column_value(l_cur_get_inv, 6, l_inv_class_code_tbl(l_idx));
214: dbms_sql.column_value(l_cur_get_inv, 7, l_remaining_amt_tbl(l_idx));
215: dbms_sql.column_value(l_cur_get_inv, 8, l_original_amt_tbl(l_idx));
216: dbms_sql.column_value(l_cur_get_inv, 9, l_inv_date_tbl(l_idx));
217: dbms_sql.column_value(l_cur_get_inv, 10, l_inv_currency_tbl(l_idx));
218: dbms_sql.column_value(l_cur_get_inv, 11, l_fun_remaining_amt_tbl(l_idx));
219:

Line 216: dbms_sql.column_value(l_cur_get_inv, 9, l_inv_date_tbl(l_idx));

212: dbms_sql.column_value(l_cur_get_inv, 5, l_inv_status_code_tbl(l_idx));
213: dbms_sql.column_value(l_cur_get_inv, 6, l_inv_class_code_tbl(l_idx));
214: dbms_sql.column_value(l_cur_get_inv, 7, l_remaining_amt_tbl(l_idx));
215: dbms_sql.column_value(l_cur_get_inv, 8, l_original_amt_tbl(l_idx));
216: dbms_sql.column_value(l_cur_get_inv, 9, l_inv_date_tbl(l_idx));
217: dbms_sql.column_value(l_cur_get_inv, 10, l_inv_currency_tbl(l_idx));
218: dbms_sql.column_value(l_cur_get_inv, 11, l_fun_remaining_amt_tbl(l_idx));
219:
220: --dbms_output.put_line(l_inv_num_tbl(l_idx));

Line 217: dbms_sql.column_value(l_cur_get_inv, 10, l_inv_currency_tbl(l_idx));

213: dbms_sql.column_value(l_cur_get_inv, 6, l_inv_class_code_tbl(l_idx));
214: dbms_sql.column_value(l_cur_get_inv, 7, l_remaining_amt_tbl(l_idx));
215: dbms_sql.column_value(l_cur_get_inv, 8, l_original_amt_tbl(l_idx));
216: dbms_sql.column_value(l_cur_get_inv, 9, l_inv_date_tbl(l_idx));
217: dbms_sql.column_value(l_cur_get_inv, 10, l_inv_currency_tbl(l_idx));
218: dbms_sql.column_value(l_cur_get_inv, 11, l_fun_remaining_amt_tbl(l_idx));
219:
220: --dbms_output.put_line(l_inv_num_tbl(l_idx));
221: END LOOP;

Line 218: dbms_sql.column_value(l_cur_get_inv, 11, l_fun_remaining_amt_tbl(l_idx));

214: dbms_sql.column_value(l_cur_get_inv, 7, l_remaining_amt_tbl(l_idx));
215: dbms_sql.column_value(l_cur_get_inv, 8, l_original_amt_tbl(l_idx));
216: dbms_sql.column_value(l_cur_get_inv, 9, l_inv_date_tbl(l_idx));
217: dbms_sql.column_value(l_cur_get_inv, 10, l_inv_currency_tbl(l_idx));
218: dbms_sql.column_value(l_cur_get_inv, 11, l_fun_remaining_amt_tbl(l_idx));
219:
220: --dbms_output.put_line(l_inv_num_tbl(l_idx));
221: END LOOP;
222:

Line 223: dbms_sql.close_cursor(l_cur_get_inv);

219:
220: --dbms_output.put_line(l_inv_num_tbl(l_idx));
221: END LOOP;
222:
223: dbms_sql.close_cursor(l_cur_get_inv);
224:
225:
226: x_invoice_id_t := l_inv_id_tbl;
227: x_invoice_number_t := l_inv_num_tbl;