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

Line 192: l_cursor := dbms_sql.open_cursor;

188: null;
189:
190: END IF;
191:
192: l_cursor := dbms_sql.open_cursor;
193: dbms_sql.parse(l_cursor,l_sql_statement,dbms_sql.v7);
194:
195: dbms_sql.bind_variable(l_cursor,'p_upd_ship',p_upd_ship);
196:

Line 193: dbms_sql.parse(l_cursor,l_sql_statement,dbms_sql.v7);

189:
190: END IF;
191:
192: l_cursor := dbms_sql.open_cursor;
193: dbms_sql.parse(l_cursor,l_sql_statement,dbms_sql.v7);
194:
195: dbms_sql.bind_variable(l_cursor,'p_upd_ship',p_upd_ship);
196:
197: IF (p_departure_id IS NOT NULL) THEN

Line 195: dbms_sql.bind_variable(l_cursor,'p_upd_ship',p_upd_ship);

191:
192: l_cursor := dbms_sql.open_cursor;
193: dbms_sql.parse(l_cursor,l_sql_statement,dbms_sql.v7);
194:
195: dbms_sql.bind_variable(l_cursor,'p_upd_ship',p_upd_ship);
196:
197: IF (p_departure_id IS NOT NULL) THEN
198: dbms_sql.bind_variable(l_cursor,'p_departure_id',p_departure_id);
199: END IF;

Line 198: dbms_sql.bind_variable(l_cursor,'p_departure_id',p_departure_id);

194:
195: dbms_sql.bind_variable(l_cursor,'p_upd_ship',p_upd_ship);
196:
197: IF (p_departure_id IS NOT NULL) THEN
198: dbms_sql.bind_variable(l_cursor,'p_departure_id',p_departure_id);
199: END IF;
200:
201: IF (p_delivery_id IS NOT NULL) THEN
202: dbms_sql.bind_variable(l_cursor,'p_delivery_id',p_delivery_id);

Line 202: dbms_sql.bind_variable(l_cursor,'p_delivery_id',p_delivery_id);

198: dbms_sql.bind_variable(l_cursor,'p_departure_id',p_departure_id);
199: END IF;
200:
201: IF (p_delivery_id IS NOT NULL) THEN
202: dbms_sql.bind_variable(l_cursor,'p_delivery_id',p_delivery_id);
203: END IF;
204:
205: IF (p_order_line IS NOT NULL) THEN
206: dbms_sql.bind_variable(l_cursor,'p_order_line',p_order_line);

Line 206: dbms_sql.bind_variable(l_cursor,'p_order_line',p_order_line);

202: dbms_sql.bind_variable(l_cursor,'p_delivery_id',p_delivery_id);
203: END IF;
204:
205: IF (p_order_line IS NOT NULL) THEN
206: dbms_sql.bind_variable(l_cursor,'p_order_line',p_order_line);
207: END IF;
208:
209: IF (p_asn IS NOT NULL) THEN
210: dbms_sql.bind_variable(l_cursor,'p_asn',p_asn);

Line 210: dbms_sql.bind_variable(l_cursor,'p_asn',p_asn);

206: dbms_sql.bind_variable(l_cursor,'p_order_line',p_order_line);
207: END IF;
208:
209: IF (p_asn IS NOT NULL) THEN
210: dbms_sql.bind_variable(l_cursor,'p_asn',p_asn);
211: END IF;
212:
213: dbms_sql.define_column(l_cursor,1,l_f_dep_id);
214: dbms_sql.define_column(l_cursor,2,l_f_del_id);

Line 213: dbms_sql.define_column(l_cursor,1,l_f_dep_id);

209: IF (p_asn IS NOT NULL) THEN
210: dbms_sql.bind_variable(l_cursor,'p_asn',p_asn);
211: END IF;
212:
213: dbms_sql.define_column(l_cursor,1,l_f_dep_id);
214: dbms_sql.define_column(l_cursor,2,l_f_del_id);
215: dbms_sql.define_column(l_cursor,3,l_f_asn);
216: dbms_sql.define_column(l_cursor,4,l_f_pick_line_id);
217: dbms_sql.define_column(l_cursor,5,l_f_line_id);

Line 214: dbms_sql.define_column(l_cursor,2,l_f_del_id);

210: dbms_sql.bind_variable(l_cursor,'p_asn',p_asn);
211: END IF;
212:
213: dbms_sql.define_column(l_cursor,1,l_f_dep_id);
214: dbms_sql.define_column(l_cursor,2,l_f_del_id);
215: dbms_sql.define_column(l_cursor,3,l_f_asn);
216: dbms_sql.define_column(l_cursor,4,l_f_pick_line_id);
217: dbms_sql.define_column(l_cursor,5,l_f_line_id);
218: dbms_sql.define_column(l_cursor,6,l_f_comp_code,1000);

Line 215: dbms_sql.define_column(l_cursor,3,l_f_asn);

211: END IF;
212:
213: dbms_sql.define_column(l_cursor,1,l_f_dep_id);
214: dbms_sql.define_column(l_cursor,2,l_f_del_id);
215: dbms_sql.define_column(l_cursor,3,l_f_asn);
216: dbms_sql.define_column(l_cursor,4,l_f_pick_line_id);
217: dbms_sql.define_column(l_cursor,5,l_f_line_id);
218: dbms_sql.define_column(l_cursor,6,l_f_comp_code,1000);
219: dbms_sql.define_column(l_cursor,7,l_f_comp_ratio);

Line 216: dbms_sql.define_column(l_cursor,4,l_f_pick_line_id);

212:
213: dbms_sql.define_column(l_cursor,1,l_f_dep_id);
214: dbms_sql.define_column(l_cursor,2,l_f_del_id);
215: dbms_sql.define_column(l_cursor,3,l_f_asn);
216: dbms_sql.define_column(l_cursor,4,l_f_pick_line_id);
217: dbms_sql.define_column(l_cursor,5,l_f_line_id);
218: dbms_sql.define_column(l_cursor,6,l_f_comp_code,1000);
219: dbms_sql.define_column(l_cursor,7,l_f_comp_ratio);
220: dbms_sql.define_column(l_cursor,8,l_f_comp_seq_id);

Line 217: dbms_sql.define_column(l_cursor,5,l_f_line_id);

213: dbms_sql.define_column(l_cursor,1,l_f_dep_id);
214: dbms_sql.define_column(l_cursor,2,l_f_del_id);
215: dbms_sql.define_column(l_cursor,3,l_f_asn);
216: dbms_sql.define_column(l_cursor,4,l_f_pick_line_id);
217: dbms_sql.define_column(l_cursor,5,l_f_line_id);
218: dbms_sql.define_column(l_cursor,6,l_f_comp_code,1000);
219: dbms_sql.define_column(l_cursor,7,l_f_comp_ratio);
220: dbms_sql.define_column(l_cursor,8,l_f_comp_seq_id);
221: dbms_sql.define_column(l_cursor,9,l_f_unit_code,30);

Line 218: dbms_sql.define_column(l_cursor,6,l_f_comp_code,1000);

214: dbms_sql.define_column(l_cursor,2,l_f_del_id);
215: dbms_sql.define_column(l_cursor,3,l_f_asn);
216: dbms_sql.define_column(l_cursor,4,l_f_pick_line_id);
217: dbms_sql.define_column(l_cursor,5,l_f_line_id);
218: dbms_sql.define_column(l_cursor,6,l_f_comp_code,1000);
219: dbms_sql.define_column(l_cursor,7,l_f_comp_ratio);
220: dbms_sql.define_column(l_cursor,8,l_f_comp_seq_id);
221: dbms_sql.define_column(l_cursor,9,l_f_unit_code,30);
222: dbms_sql.define_column(l_cursor,10,l_f_warehouse_id);

Line 219: dbms_sql.define_column(l_cursor,7,l_f_comp_ratio);

215: dbms_sql.define_column(l_cursor,3,l_f_asn);
216: dbms_sql.define_column(l_cursor,4,l_f_pick_line_id);
217: dbms_sql.define_column(l_cursor,5,l_f_line_id);
218: dbms_sql.define_column(l_cursor,6,l_f_comp_code,1000);
219: dbms_sql.define_column(l_cursor,7,l_f_comp_ratio);
220: dbms_sql.define_column(l_cursor,8,l_f_comp_seq_id);
221: dbms_sql.define_column(l_cursor,9,l_f_unit_code,30);
222: dbms_sql.define_column(l_cursor,10,l_f_warehouse_id);
223: dbms_sql.define_column(l_cursor,11,l_f_item_id);

Line 220: dbms_sql.define_column(l_cursor,8,l_f_comp_seq_id);

216: dbms_sql.define_column(l_cursor,4,l_f_pick_line_id);
217: dbms_sql.define_column(l_cursor,5,l_f_line_id);
218: dbms_sql.define_column(l_cursor,6,l_f_comp_code,1000);
219: dbms_sql.define_column(l_cursor,7,l_f_comp_ratio);
220: dbms_sql.define_column(l_cursor,8,l_f_comp_seq_id);
221: dbms_sql.define_column(l_cursor,9,l_f_unit_code,30);
222: dbms_sql.define_column(l_cursor,10,l_f_warehouse_id);
223: dbms_sql.define_column(l_cursor,11,l_f_item_id);
224: dbms_sql.define_column(l_cursor,12,l_f_cust_item_id);

Line 221: dbms_sql.define_column(l_cursor,9,l_f_unit_code,30);

217: dbms_sql.define_column(l_cursor,5,l_f_line_id);
218: dbms_sql.define_column(l_cursor,6,l_f_comp_code,1000);
219: dbms_sql.define_column(l_cursor,7,l_f_comp_ratio);
220: dbms_sql.define_column(l_cursor,8,l_f_comp_seq_id);
221: dbms_sql.define_column(l_cursor,9,l_f_unit_code,30);
222: dbms_sql.define_column(l_cursor,10,l_f_warehouse_id);
223: dbms_sql.define_column(l_cursor,11,l_f_item_id);
224: dbms_sql.define_column(l_cursor,12,l_f_cust_item_id);
225: dbms_sql.define_column(l_cursor,13,l_f_ship_to_contact_id);

Line 222: dbms_sql.define_column(l_cursor,10,l_f_warehouse_id);

218: dbms_sql.define_column(l_cursor,6,l_f_comp_code,1000);
219: dbms_sql.define_column(l_cursor,7,l_f_comp_ratio);
220: dbms_sql.define_column(l_cursor,8,l_f_comp_seq_id);
221: dbms_sql.define_column(l_cursor,9,l_f_unit_code,30);
222: dbms_sql.define_column(l_cursor,10,l_f_warehouse_id);
223: dbms_sql.define_column(l_cursor,11,l_f_item_id);
224: dbms_sql.define_column(l_cursor,12,l_f_cust_item_id);
225: dbms_sql.define_column(l_cursor,13,l_f_ship_to_contact_id);
226: dbms_sql.define_column(l_cursor,14,l_f_shipped_qty);

Line 223: dbms_sql.define_column(l_cursor,11,l_f_item_id);

219: dbms_sql.define_column(l_cursor,7,l_f_comp_ratio);
220: dbms_sql.define_column(l_cursor,8,l_f_comp_seq_id);
221: dbms_sql.define_column(l_cursor,9,l_f_unit_code,30);
222: dbms_sql.define_column(l_cursor,10,l_f_warehouse_id);
223: dbms_sql.define_column(l_cursor,11,l_f_item_id);
224: dbms_sql.define_column(l_cursor,12,l_f_cust_item_id);
225: dbms_sql.define_column(l_cursor,13,l_f_ship_to_contact_id);
226: dbms_sql.define_column(l_cursor,14,l_f_shipped_qty);
227:

Line 224: dbms_sql.define_column(l_cursor,12,l_f_cust_item_id);

220: dbms_sql.define_column(l_cursor,8,l_f_comp_seq_id);
221: dbms_sql.define_column(l_cursor,9,l_f_unit_code,30);
222: dbms_sql.define_column(l_cursor,10,l_f_warehouse_id);
223: dbms_sql.define_column(l_cursor,11,l_f_item_id);
224: dbms_sql.define_column(l_cursor,12,l_f_cust_item_id);
225: dbms_sql.define_column(l_cursor,13,l_f_ship_to_contact_id);
226: dbms_sql.define_column(l_cursor,14,l_f_shipped_qty);
227:
228: l_records_fetched := dbms_sql.execute(l_cursor);

Line 225: dbms_sql.define_column(l_cursor,13,l_f_ship_to_contact_id);

221: dbms_sql.define_column(l_cursor,9,l_f_unit_code,30);
222: dbms_sql.define_column(l_cursor,10,l_f_warehouse_id);
223: dbms_sql.define_column(l_cursor,11,l_f_item_id);
224: dbms_sql.define_column(l_cursor,12,l_f_cust_item_id);
225: dbms_sql.define_column(l_cursor,13,l_f_ship_to_contact_id);
226: dbms_sql.define_column(l_cursor,14,l_f_shipped_qty);
227:
228: l_records_fetched := dbms_sql.execute(l_cursor);
229:

Line 226: dbms_sql.define_column(l_cursor,14,l_f_shipped_qty);

222: dbms_sql.define_column(l_cursor,10,l_f_warehouse_id);
223: dbms_sql.define_column(l_cursor,11,l_f_item_id);
224: dbms_sql.define_column(l_cursor,12,l_f_cust_item_id);
225: dbms_sql.define_column(l_cursor,13,l_f_ship_to_contact_id);
226: dbms_sql.define_column(l_cursor,14,l_f_shipped_qty);
227:
228: l_records_fetched := dbms_sql.execute(l_cursor);
229:
230: WHILE (dbms_sql.fetch_rows(l_cursor) > 0) LOOP

Line 228: l_records_fetched := dbms_sql.execute(l_cursor);

224: dbms_sql.define_column(l_cursor,12,l_f_cust_item_id);
225: dbms_sql.define_column(l_cursor,13,l_f_ship_to_contact_id);
226: dbms_sql.define_column(l_cursor,14,l_f_shipped_qty);
227:
228: l_records_fetched := dbms_sql.execute(l_cursor);
229:
230: WHILE (dbms_sql.fetch_rows(l_cursor) > 0) LOOP
231:
232: dbms_sql.column_value(l_cursor,1,l_f_dep_id);

Line 230: WHILE (dbms_sql.fetch_rows(l_cursor) > 0) LOOP

226: dbms_sql.define_column(l_cursor,14,l_f_shipped_qty);
227:
228: l_records_fetched := dbms_sql.execute(l_cursor);
229:
230: WHILE (dbms_sql.fetch_rows(l_cursor) > 0) LOOP
231:
232: dbms_sql.column_value(l_cursor,1,l_f_dep_id);
233: dbms_sql.column_value(l_cursor,2,l_f_del_id);
234: dbms_sql.column_value(l_cursor,3,l_f_asn);

Line 232: dbms_sql.column_value(l_cursor,1,l_f_dep_id);

228: l_records_fetched := dbms_sql.execute(l_cursor);
229:
230: WHILE (dbms_sql.fetch_rows(l_cursor) > 0) LOOP
231:
232: dbms_sql.column_value(l_cursor,1,l_f_dep_id);
233: dbms_sql.column_value(l_cursor,2,l_f_del_id);
234: dbms_sql.column_value(l_cursor,3,l_f_asn);
235: dbms_sql.column_value(l_cursor,4,l_f_pick_line_id);
236: dbms_sql.column_value(l_cursor,5,l_f_line_id);

Line 233: dbms_sql.column_value(l_cursor,2,l_f_del_id);

229:
230: WHILE (dbms_sql.fetch_rows(l_cursor) > 0) LOOP
231:
232: dbms_sql.column_value(l_cursor,1,l_f_dep_id);
233: dbms_sql.column_value(l_cursor,2,l_f_del_id);
234: dbms_sql.column_value(l_cursor,3,l_f_asn);
235: dbms_sql.column_value(l_cursor,4,l_f_pick_line_id);
236: dbms_sql.column_value(l_cursor,5,l_f_line_id);
237: dbms_sql.column_value(l_cursor,6,l_f_comp_code);

Line 234: dbms_sql.column_value(l_cursor,3,l_f_asn);

230: WHILE (dbms_sql.fetch_rows(l_cursor) > 0) LOOP
231:
232: dbms_sql.column_value(l_cursor,1,l_f_dep_id);
233: dbms_sql.column_value(l_cursor,2,l_f_del_id);
234: dbms_sql.column_value(l_cursor,3,l_f_asn);
235: dbms_sql.column_value(l_cursor,4,l_f_pick_line_id);
236: dbms_sql.column_value(l_cursor,5,l_f_line_id);
237: dbms_sql.column_value(l_cursor,6,l_f_comp_code);
238: dbms_sql.column_value(l_cursor,7,l_f_comp_ratio);

Line 235: dbms_sql.column_value(l_cursor,4,l_f_pick_line_id);

231:
232: dbms_sql.column_value(l_cursor,1,l_f_dep_id);
233: dbms_sql.column_value(l_cursor,2,l_f_del_id);
234: dbms_sql.column_value(l_cursor,3,l_f_asn);
235: dbms_sql.column_value(l_cursor,4,l_f_pick_line_id);
236: dbms_sql.column_value(l_cursor,5,l_f_line_id);
237: dbms_sql.column_value(l_cursor,6,l_f_comp_code);
238: dbms_sql.column_value(l_cursor,7,l_f_comp_ratio);
239: dbms_sql.column_value(l_cursor,8,l_f_comp_seq_id);

Line 236: dbms_sql.column_value(l_cursor,5,l_f_line_id);

232: dbms_sql.column_value(l_cursor,1,l_f_dep_id);
233: dbms_sql.column_value(l_cursor,2,l_f_del_id);
234: dbms_sql.column_value(l_cursor,3,l_f_asn);
235: dbms_sql.column_value(l_cursor,4,l_f_pick_line_id);
236: dbms_sql.column_value(l_cursor,5,l_f_line_id);
237: dbms_sql.column_value(l_cursor,6,l_f_comp_code);
238: dbms_sql.column_value(l_cursor,7,l_f_comp_ratio);
239: dbms_sql.column_value(l_cursor,8,l_f_comp_seq_id);
240: dbms_sql.column_value(l_cursor,9,l_f_unit_code);

Line 237: dbms_sql.column_value(l_cursor,6,l_f_comp_code);

233: dbms_sql.column_value(l_cursor,2,l_f_del_id);
234: dbms_sql.column_value(l_cursor,3,l_f_asn);
235: dbms_sql.column_value(l_cursor,4,l_f_pick_line_id);
236: dbms_sql.column_value(l_cursor,5,l_f_line_id);
237: dbms_sql.column_value(l_cursor,6,l_f_comp_code);
238: dbms_sql.column_value(l_cursor,7,l_f_comp_ratio);
239: dbms_sql.column_value(l_cursor,8,l_f_comp_seq_id);
240: dbms_sql.column_value(l_cursor,9,l_f_unit_code);
241: dbms_sql.column_value(l_cursor,10,l_f_warehouse_id);

Line 238: dbms_sql.column_value(l_cursor,7,l_f_comp_ratio);

234: dbms_sql.column_value(l_cursor,3,l_f_asn);
235: dbms_sql.column_value(l_cursor,4,l_f_pick_line_id);
236: dbms_sql.column_value(l_cursor,5,l_f_line_id);
237: dbms_sql.column_value(l_cursor,6,l_f_comp_code);
238: dbms_sql.column_value(l_cursor,7,l_f_comp_ratio);
239: dbms_sql.column_value(l_cursor,8,l_f_comp_seq_id);
240: dbms_sql.column_value(l_cursor,9,l_f_unit_code);
241: dbms_sql.column_value(l_cursor,10,l_f_warehouse_id);
242: dbms_sql.column_value(l_cursor,11,l_f_item_id);

Line 239: dbms_sql.column_value(l_cursor,8,l_f_comp_seq_id);

235: dbms_sql.column_value(l_cursor,4,l_f_pick_line_id);
236: dbms_sql.column_value(l_cursor,5,l_f_line_id);
237: dbms_sql.column_value(l_cursor,6,l_f_comp_code);
238: dbms_sql.column_value(l_cursor,7,l_f_comp_ratio);
239: dbms_sql.column_value(l_cursor,8,l_f_comp_seq_id);
240: dbms_sql.column_value(l_cursor,9,l_f_unit_code);
241: dbms_sql.column_value(l_cursor,10,l_f_warehouse_id);
242: dbms_sql.column_value(l_cursor,11,l_f_item_id);
243: dbms_sql.column_value(l_cursor,12,l_f_cust_item_id);

Line 240: dbms_sql.column_value(l_cursor,9,l_f_unit_code);

236: dbms_sql.column_value(l_cursor,5,l_f_line_id);
237: dbms_sql.column_value(l_cursor,6,l_f_comp_code);
238: dbms_sql.column_value(l_cursor,7,l_f_comp_ratio);
239: dbms_sql.column_value(l_cursor,8,l_f_comp_seq_id);
240: dbms_sql.column_value(l_cursor,9,l_f_unit_code);
241: dbms_sql.column_value(l_cursor,10,l_f_warehouse_id);
242: dbms_sql.column_value(l_cursor,11,l_f_item_id);
243: dbms_sql.column_value(l_cursor,12,l_f_cust_item_id);
244: dbms_sql.column_value(l_cursor,13,l_f_ship_to_contact_id);

Line 241: dbms_sql.column_value(l_cursor,10,l_f_warehouse_id);

237: dbms_sql.column_value(l_cursor,6,l_f_comp_code);
238: dbms_sql.column_value(l_cursor,7,l_f_comp_ratio);
239: dbms_sql.column_value(l_cursor,8,l_f_comp_seq_id);
240: dbms_sql.column_value(l_cursor,9,l_f_unit_code);
241: dbms_sql.column_value(l_cursor,10,l_f_warehouse_id);
242: dbms_sql.column_value(l_cursor,11,l_f_item_id);
243: dbms_sql.column_value(l_cursor,12,l_f_cust_item_id);
244: dbms_sql.column_value(l_cursor,13,l_f_ship_to_contact_id);
245: dbms_sql.column_value(l_cursor,14,l_f_shipped_qty);

Line 242: dbms_sql.column_value(l_cursor,11,l_f_item_id);

238: dbms_sql.column_value(l_cursor,7,l_f_comp_ratio);
239: dbms_sql.column_value(l_cursor,8,l_f_comp_seq_id);
240: dbms_sql.column_value(l_cursor,9,l_f_unit_code);
241: dbms_sql.column_value(l_cursor,10,l_f_warehouse_id);
242: dbms_sql.column_value(l_cursor,11,l_f_item_id);
243: dbms_sql.column_value(l_cursor,12,l_f_cust_item_id);
244: dbms_sql.column_value(l_cursor,13,l_f_ship_to_contact_id);
245: dbms_sql.column_value(l_cursor,14,l_f_shipped_qty);
246:

Line 243: dbms_sql.column_value(l_cursor,12,l_f_cust_item_id);

239: dbms_sql.column_value(l_cursor,8,l_f_comp_seq_id);
240: dbms_sql.column_value(l_cursor,9,l_f_unit_code);
241: dbms_sql.column_value(l_cursor,10,l_f_warehouse_id);
242: dbms_sql.column_value(l_cursor,11,l_f_item_id);
243: dbms_sql.column_value(l_cursor,12,l_f_cust_item_id);
244: dbms_sql.column_value(l_cursor,13,l_f_ship_to_contact_id);
245: dbms_sql.column_value(l_cursor,14,l_f_shipped_qty);
246:
247: OPEN SHIPPED_QUANTITIES (l_f_asn, l_f_pick_line_id);

Line 244: dbms_sql.column_value(l_cursor,13,l_f_ship_to_contact_id);

240: dbms_sql.column_value(l_cursor,9,l_f_unit_code);
241: dbms_sql.column_value(l_cursor,10,l_f_warehouse_id);
242: dbms_sql.column_value(l_cursor,11,l_f_item_id);
243: dbms_sql.column_value(l_cursor,12,l_f_cust_item_id);
244: dbms_sql.column_value(l_cursor,13,l_f_ship_to_contact_id);
245: dbms_sql.column_value(l_cursor,14,l_f_shipped_qty);
246:
247: OPEN SHIPPED_QUANTITIES (l_f_asn, l_f_pick_line_id);
248: FETCH SHIPPED_QUANTITIES INTO l_shipped_td, l_already_shipped;

Line 245: dbms_sql.column_value(l_cursor,14,l_f_shipped_qty);

241: dbms_sql.column_value(l_cursor,10,l_f_warehouse_id);
242: dbms_sql.column_value(l_cursor,11,l_f_item_id);
243: dbms_sql.column_value(l_cursor,12,l_f_cust_item_id);
244: dbms_sql.column_value(l_cursor,13,l_f_ship_to_contact_id);
245: dbms_sql.column_value(l_cursor,14,l_f_shipped_qty);
246:
247: OPEN SHIPPED_QUANTITIES (l_f_asn, l_f_pick_line_id);
248: FETCH SHIPPED_QUANTITIES INTO l_shipped_td, l_already_shipped;
249: CLOSE SHIPPED_QUANTITIES;

Line 314: dbms_sql.close_cursor(l_cursor);

310: l_dep_id := l_f_dep_id;
311:
312: END LOOP;
313:
314: dbms_sql.close_cursor(l_cursor);
315:
316: -- Update any detail, line and header attributes
317: -- Index on the INVENTORY_ITEM_ID for SO_LINE_DETAILS table is turned off
318: -- deliberately to make sure the index on LINE_ID is used.

Line 475: IF dbms_sql.is_open(l_cursor) THEN

471: EXCEPTION WHEN OTHERS THEN
472:
473: -- Check if cursor for picking lines is open and if it is close it
474:
475: IF dbms_sql.is_open(l_cursor) THEN
476: dbms_sql.close_cursor(l_cursor);
477: END IF;
478:
479: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');

Line 476: dbms_sql.close_cursor(l_cursor);

472:
473: -- Check if cursor for picking lines is open and if it is close it
474:
475: IF dbms_sql.is_open(l_cursor) THEN
476: dbms_sql.close_cursor(l_cursor);
477: END IF;
478:
479: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
480: FND_MESSAGE.Set_Token('PACKAGE','WSH_REPORT_QUANTITIES.populate_temp_table');