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

Line 337: l_update_cur := DBMS_SQL.OPEN_CURSOR;

333: ' WHERE current_organization_id=:org_id AND inventory_item_id=:item_id AND serial_number=:lot_serial';
334: END IF;
335:
336: -- Open dynamic SQL cursor
337: l_update_cur := DBMS_SQL.OPEN_CURSOR;
338: -- Parse statement
339: DBMS_SQL.PARSE(l_update_cur, l_update_stmt, DBMS_SQL.v7);
340: -- Bind variables
341: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':attr_category', p_attribute_category);

Line 339: DBMS_SQL.PARSE(l_update_cur, l_update_stmt, DBMS_SQL.v7);

335:
336: -- Open dynamic SQL cursor
337: l_update_cur := DBMS_SQL.OPEN_CURSOR;
338: -- Parse statement
339: DBMS_SQL.PARSE(l_update_cur, l_update_stmt, DBMS_SQL.v7);
340: -- Bind variables
341: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':attr_category', p_attribute_category);
342: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':org_id', p_organization_id);
343: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':item_id', p_inventory_item_id);

Line 341: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':attr_category', p_attribute_category);

337: l_update_cur := DBMS_SQL.OPEN_CURSOR;
338: -- Parse statement
339: DBMS_SQL.PARSE(l_update_cur, l_update_stmt, DBMS_SQL.v7);
340: -- Bind variables
341: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':attr_category', p_attribute_category);
342: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':org_id', p_organization_id);
343: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':item_id', p_inventory_item_id);
344: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':lot_serial', p_lot_serial_number);
345: -- Execute statement

Line 342: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':org_id', p_organization_id);

338: -- Parse statement
339: DBMS_SQL.PARSE(l_update_cur, l_update_stmt, DBMS_SQL.v7);
340: -- Bind variables
341: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':attr_category', p_attribute_category);
342: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':org_id', p_organization_id);
343: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':item_id', p_inventory_item_id);
344: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':lot_serial', p_lot_serial_number);
345: -- Execute statement
346: l_rowupdated := DBMS_SQL.EXECUTE(l_update_cur);

Line 343: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':item_id', p_inventory_item_id);

339: DBMS_SQL.PARSE(l_update_cur, l_update_stmt, DBMS_SQL.v7);
340: -- Bind variables
341: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':attr_category', p_attribute_category);
342: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':org_id', p_organization_id);
343: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':item_id', p_inventory_item_id);
344: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':lot_serial', p_lot_serial_number);
345: -- Execute statement
346: l_rowupdated := DBMS_SQL.EXECUTE(l_update_cur);
347:

Line 344: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':lot_serial', p_lot_serial_number);

340: -- Bind variables
341: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':attr_category', p_attribute_category);
342: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':org_id', p_organization_id);
343: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':item_id', p_inventory_item_id);
344: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':lot_serial', p_lot_serial_number);
345: -- Execute statement
346: l_rowupdated := DBMS_SQL.EXECUTE(l_update_cur);
347:
348: IF l_rowupdated >= 1 THEN

Line 346: l_rowupdated := DBMS_SQL.EXECUTE(l_update_cur);

342: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':org_id', p_organization_id);
343: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':item_id', p_inventory_item_id);
344: DBMS_SQL.BIND_VARIABLE(l_update_cur, ':lot_serial', p_lot_serial_number);
345: -- Execute statement
346: l_rowupdated := DBMS_SQL.EXECUTE(l_update_cur);
347:
348: IF l_rowupdated >= 1 THEN
349: x_update_count := l_rowupdated;
350: ELSE

Line 359: DBMS_SQL.CLOSE_CURSOR(l_update_cur);

355: RAISE fnd_api.g_exc_error;
356: END IF;
357:
358: -- Close the cursor
359: DBMS_SQL.CLOSE_CURSOR(l_update_cur);
360:
361: EXCEPTION
362: WHEN others THEN
363: DBMS_SQL.CLOSE_CURSOR(l_update_cur);

Line 363: DBMS_SQL.CLOSE_CURSOR(l_update_cur);

359: DBMS_SQL.CLOSE_CURSOR(l_update_cur);
360:
361: EXCEPTION
362: WHEN others THEN
363: DBMS_SQL.CLOSE_CURSOR(l_update_cur);
364: IF (l_debug = 1) THEN
365: trace('Error in update lot/serial '|| p_lot_serial_number
366: || ',org:'||p_organization_id ||',item:'||p_inventory_item_id);
367: END IF;