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

Line 300: X_Cursor := dbms_sql.open_cursor;

296:
297: X_Stmt := X_Stmt || ' )) ';
298: X_Stmt := X_Stmt || ' ORDER BY sopls.picking_header_id DESC';
299: X_Stmt_Num := 40;
300: X_Cursor := dbms_sql.open_cursor;
301: X_Stmt_Num := 50;
302: dbms_sql.parse(X_Cursor,X_Stmt,dbms_sql.v7);
303: X_Stmt_Num := 60;
304: if check_org then

Line 302: dbms_sql.parse(X_Cursor,X_Stmt,dbms_sql.v7);

298: X_Stmt := X_Stmt || ' ORDER BY sopls.picking_header_id DESC';
299: X_Stmt_Num := 40;
300: X_Cursor := dbms_sql.open_cursor;
301: X_Stmt_Num := 50;
302: dbms_sql.parse(X_Cursor,X_Stmt,dbms_sql.v7);
303: X_Stmt_Num := 60;
304: if check_org then
305: dbms_sql.bind_variable (X_Cursor,'X_warehouse_id',X_warehouse_id);
306: end if;

Line 305: dbms_sql.bind_variable (X_Cursor,'X_warehouse_id',X_warehouse_id);

301: X_Stmt_Num := 50;
302: dbms_sql.parse(X_Cursor,X_Stmt,dbms_sql.v7);
303: X_Stmt_Num := 60;
304: if check_org then
305: dbms_sql.bind_variable (X_Cursor,'X_warehouse_id',X_warehouse_id);
306: end if;
307: X_Stmt_Num := 61;
308: if check_item then
309: dbms_sql.bind_variable (X_Cursor,'X_item_id',X_item_id);

Line 309: dbms_sql.bind_variable (X_Cursor,'X_item_id',X_item_id);

305: dbms_sql.bind_variable (X_Cursor,'X_warehouse_id',X_warehouse_id);
306: end if;
307: X_Stmt_Num := 61;
308: if check_item then
309: dbms_sql.bind_variable (X_Cursor,'X_item_id',X_item_id);
310: end if;
311: X_Stmt_Num := 62;
312: dbms_sql.bind_variable (X_Cursor,'x_sn',X_sn);
313: X_Stmt_Num := 65;

Line 312: dbms_sql.bind_variable (X_Cursor,'x_sn',X_sn);

308: if check_item then
309: dbms_sql.bind_variable (X_Cursor,'X_item_id',X_item_id);
310: end if;
311: X_Stmt_Num := 62;
312: dbms_sql.bind_variable (X_Cursor,'x_sn',X_sn);
313: X_Stmt_Num := 65;
314: dbms_sql.bind_variable (X_Cursor,'X_line_detail_id',X_line_detail_id);
315: X_Stmt_Num := 80;
316: X_Rows := dbms_sql.execute(X_Cursor);

Line 314: dbms_sql.bind_variable (X_Cursor,'X_line_detail_id',X_line_detail_id);

310: end if;
311: X_Stmt_Num := 62;
312: dbms_sql.bind_variable (X_Cursor,'x_sn',X_sn);
313: X_Stmt_Num := 65;
314: dbms_sql.bind_variable (X_Cursor,'X_line_detail_id',X_line_detail_id);
315: X_Stmt_Num := 80;
316: X_Rows := dbms_sql.execute(X_Cursor);
317: X_Stmt_Num := 90;
318: X_Rows := dbms_sql.fetch_rows(X_Cursor);

Line 316: X_Rows := dbms_sql.execute(X_Cursor);

312: dbms_sql.bind_variable (X_Cursor,'x_sn',X_sn);
313: X_Stmt_Num := 65;
314: dbms_sql.bind_variable (X_Cursor,'X_line_detail_id',X_line_detail_id);
315: X_Stmt_Num := 80;
316: X_Rows := dbms_sql.execute(X_Cursor);
317: X_Stmt_Num := 90;
318: X_Rows := dbms_sql.fetch_rows(X_Cursor);
319: X_Stmt_Num := 110;
320: if X_Rows <> 0 THEN

Line 318: X_Rows := dbms_sql.fetch_rows(X_Cursor);

314: dbms_sql.bind_variable (X_Cursor,'X_line_detail_id',X_line_detail_id);
315: X_Stmt_Num := 80;
316: X_Rows := dbms_sql.execute(X_Cursor);
317: X_Stmt_Num := 90;
318: X_Rows := dbms_sql.fetch_rows(X_Cursor);
319: X_Stmt_Num := 110;
320: if X_Rows <> 0 THEN
321: X_error_code := -1;
322: Return;

Line 325: if dbms_sql.is_open(X_Cursor) then

321: X_error_code := -1;
322: Return;
323: end if;
324: X_stmt_Num := 120;
325: if dbms_sql.is_open(X_Cursor) then
326: dbms_sql.close_cursor(X_Cursor);
327: end if;
328: end if;
329:

Line 326: dbms_sql.close_cursor(X_Cursor);

322: Return;
323: end if;
324: X_stmt_Num := 120;
325: if dbms_sql.is_open(X_Cursor) then
326: dbms_sql.close_cursor(X_Cursor);
327: end if;
328: end if;
329:
330: EXCEPTION