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

Line 1258: l_cursor := dbms_sql.open_cursor ;

1254: BEGIN
1255: x_return_status := fnd_api.g_ret_sts_success ;
1256: --
1257: --inv_sql_binding_pvt.showsql(g_stmt);
1258: l_cursor := dbms_sql.open_cursor ;
1259: dbms_sql.parse(l_cursor, g_stmt, dbms_sql.v7);
1260: -- bind input variables
1261: inv_sql_binding_pvt.bindvars(l_cursor);
1262: -- now define the output variables

Line 1259: dbms_sql.parse(l_cursor, g_stmt, dbms_sql.v7);

1255: x_return_status := fnd_api.g_ret_sts_success ;
1256: --
1257: --inv_sql_binding_pvt.showsql(g_stmt);
1258: l_cursor := dbms_sql.open_cursor ;
1259: dbms_sql.parse(l_cursor, g_stmt, dbms_sql.v7);
1260: -- bind input variables
1261: inv_sql_binding_pvt.bindvars(l_cursor);
1262: -- now define the output variables
1263: dbms_sql.define_column(l_cursor, 1, l_revision, 3);

Line 1263: dbms_sql.define_column(l_cursor, 1, l_revision, 3);

1259: dbms_sql.parse(l_cursor, g_stmt, dbms_sql.v7);
1260: -- bind input variables
1261: inv_sql_binding_pvt.bindvars(l_cursor);
1262: -- now define the output variables
1263: dbms_sql.define_column(l_cursor, 1, l_revision, 3);
1264: dbms_sql.define_column(l_cursor, 2, l_lot_number, 30);
1265: dbms_sql.define_column(l_cursor, 3, l_lot_expiration_date);
1266: dbms_sql.define_column(l_cursor, 4, l_from_subinventory, 10);
1267: dbms_sql.define_column(l_cursor, 5, l_from_locator_id);

Line 1264: dbms_sql.define_column(l_cursor, 2, l_lot_number, 30);

1260: -- bind input variables
1261: inv_sql_binding_pvt.bindvars(l_cursor);
1262: -- now define the output variables
1263: dbms_sql.define_column(l_cursor, 1, l_revision, 3);
1264: dbms_sql.define_column(l_cursor, 2, l_lot_number, 30);
1265: dbms_sql.define_column(l_cursor, 3, l_lot_expiration_date);
1266: dbms_sql.define_column(l_cursor, 4, l_from_subinventory, 10);
1267: dbms_sql.define_column(l_cursor, 5, l_from_locator_id);
1268: dbms_sql.define_column(l_cursor, 6, l_from_cost_group_id);

Line 1265: dbms_sql.define_column(l_cursor, 3, l_lot_expiration_date);

1261: inv_sql_binding_pvt.bindvars(l_cursor);
1262: -- now define the output variables
1263: dbms_sql.define_column(l_cursor, 1, l_revision, 3);
1264: dbms_sql.define_column(l_cursor, 2, l_lot_number, 30);
1265: dbms_sql.define_column(l_cursor, 3, l_lot_expiration_date);
1266: dbms_sql.define_column(l_cursor, 4, l_from_subinventory, 10);
1267: dbms_sql.define_column(l_cursor, 5, l_from_locator_id);
1268: dbms_sql.define_column(l_cursor, 6, l_from_cost_group_id);
1269: --

Line 1266: dbms_sql.define_column(l_cursor, 4, l_from_subinventory, 10);

1262: -- now define the output variables
1263: dbms_sql.define_column(l_cursor, 1, l_revision, 3);
1264: dbms_sql.define_column(l_cursor, 2, l_lot_number, 30);
1265: dbms_sql.define_column(l_cursor, 3, l_lot_expiration_date);
1266: dbms_sql.define_column(l_cursor, 4, l_from_subinventory, 10);
1267: dbms_sql.define_column(l_cursor, 5, l_from_locator_id);
1268: dbms_sql.define_column(l_cursor, 6, l_from_cost_group_id);
1269: --
1270: l_discard := dbms_sql.execute(l_cursor);

Line 1267: dbms_sql.define_column(l_cursor, 5, l_from_locator_id);

1263: dbms_sql.define_column(l_cursor, 1, l_revision, 3);
1264: dbms_sql.define_column(l_cursor, 2, l_lot_number, 30);
1265: dbms_sql.define_column(l_cursor, 3, l_lot_expiration_date);
1266: dbms_sql.define_column(l_cursor, 4, l_from_subinventory, 10);
1267: dbms_sql.define_column(l_cursor, 5, l_from_locator_id);
1268: dbms_sql.define_column(l_cursor, 6, l_from_cost_group_id);
1269: --
1270: l_discard := dbms_sql.execute(l_cursor);
1271: --

Line 1268: dbms_sql.define_column(l_cursor, 6, l_from_cost_group_id);

1264: dbms_sql.define_column(l_cursor, 2, l_lot_number, 30);
1265: dbms_sql.define_column(l_cursor, 3, l_lot_expiration_date);
1266: dbms_sql.define_column(l_cursor, 4, l_from_subinventory, 10);
1267: dbms_sql.define_column(l_cursor, 5, l_from_locator_id);
1268: dbms_sql.define_column(l_cursor, 6, l_from_cost_group_id);
1269: --
1270: l_discard := dbms_sql.execute(l_cursor);
1271: --
1272: -- set the qty that has to be detailed

Line 1270: l_discard := dbms_sql.execute(l_cursor);

1266: dbms_sql.define_column(l_cursor, 4, l_from_subinventory, 10);
1267: dbms_sql.define_column(l_cursor, 5, l_from_locator_id);
1268: dbms_sql.define_column(l_cursor, 6, l_from_cost_group_id);
1269: --
1270: l_discard := dbms_sql.execute(l_cursor);
1271: --
1272: -- set the qty that has to be detailed
1273: l_qty_to_detail := p_pp_temp_rec.primary_quantity ;
1274: --

Line 1327: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN

1323:
1324: LOOP
1325: -- when no more rows to fetch, then exit
1326: --
1327: IF dbms_sql.fetch_rows(l_cursor) = 0 THEN
1328: EXIT ;
1329: END IF;
1330: --
1331: -- now retrieve the rows one at a time

Line 1333: dbms_sql.column_value(l_cursor, 1, l_revision);

1329: END IF;
1330: --
1331: -- now retrieve the rows one at a time
1332: --
1333: dbms_sql.column_value(l_cursor, 1, l_revision);
1334: dbms_sql.column_value(l_cursor, 2, l_lot_number);
1335: dbms_sql.column_value(l_cursor, 3, l_lot_expiration_date);
1336: dbms_sql.column_value(l_cursor, 4, l_from_subinventory);
1337: dbms_sql.column_value(l_cursor, 5, l_from_locator_id);

Line 1334: dbms_sql.column_value(l_cursor, 2, l_lot_number);

1330: --
1331: -- now retrieve the rows one at a time
1332: --
1333: dbms_sql.column_value(l_cursor, 1, l_revision);
1334: dbms_sql.column_value(l_cursor, 2, l_lot_number);
1335: dbms_sql.column_value(l_cursor, 3, l_lot_expiration_date);
1336: dbms_sql.column_value(l_cursor, 4, l_from_subinventory);
1337: dbms_sql.column_value(l_cursor, 5, l_from_locator_id);
1338: dbms_sql.column_value(l_cursor, 6, l_from_cost_group_id);

Line 1335: dbms_sql.column_value(l_cursor, 3, l_lot_expiration_date);

1331: -- now retrieve the rows one at a time
1332: --
1333: dbms_sql.column_value(l_cursor, 1, l_revision);
1334: dbms_sql.column_value(l_cursor, 2, l_lot_number);
1335: dbms_sql.column_value(l_cursor, 3, l_lot_expiration_date);
1336: dbms_sql.column_value(l_cursor, 4, l_from_subinventory);
1337: dbms_sql.column_value(l_cursor, 5, l_from_locator_id);
1338: dbms_sql.column_value(l_cursor, 6, l_from_cost_group_id);
1339: --

Line 1336: dbms_sql.column_value(l_cursor, 4, l_from_subinventory);

1332: --
1333: dbms_sql.column_value(l_cursor, 1, l_revision);
1334: dbms_sql.column_value(l_cursor, 2, l_lot_number);
1335: dbms_sql.column_value(l_cursor, 3, l_lot_expiration_date);
1336: dbms_sql.column_value(l_cursor, 4, l_from_subinventory);
1337: dbms_sql.column_value(l_cursor, 5, l_from_locator_id);
1338: dbms_sql.column_value(l_cursor, 6, l_from_cost_group_id);
1339: --
1340: -- Some initializations

Line 1337: dbms_sql.column_value(l_cursor, 5, l_from_locator_id);

1333: dbms_sql.column_value(l_cursor, 1, l_revision);
1334: dbms_sql.column_value(l_cursor, 2, l_lot_number);
1335: dbms_sql.column_value(l_cursor, 3, l_lot_expiration_date);
1336: dbms_sql.column_value(l_cursor, 4, l_from_subinventory);
1337: dbms_sql.column_value(l_cursor, 5, l_from_locator_id);
1338: dbms_sql.column_value(l_cursor, 6, l_from_cost_group_id);
1339: --
1340: -- Some initializations
1341: --

Line 1338: dbms_sql.column_value(l_cursor, 6, l_from_cost_group_id);

1334: dbms_sql.column_value(l_cursor, 2, l_lot_number);
1335: dbms_sql.column_value(l_cursor, 3, l_lot_expiration_date);
1336: dbms_sql.column_value(l_cursor, 4, l_from_subinventory);
1337: dbms_sql.column_value(l_cursor, 5, l_from_locator_id);
1338: dbms_sql.column_value(l_cursor, 6, l_from_cost_group_id);
1339: --
1340: -- Some initializations
1341: --
1342: use_this_row := true;

Line 1586: dbms_sql.close_cursor(l_cursor);

1582: EXIT WHEN l_qty_to_detail = 0;
1583: END LOOP;
1584: --
1585: -- close cursor now
1586: dbms_sql.close_cursor(l_cursor);
1587: --
1588: --
1589: EXCEPTION
1590: WHEN fnd_api.g_exc_error THEN

Line 1592: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1588: --
1589: EXCEPTION
1590: WHEN fnd_api.g_exc_error THEN
1591: x_return_status := fnd_api.g_ret_sts_error ;
1592: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1593: --
1594: WHEN fnd_api.g_exc_unexpected_error THEN
1595: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1596: DBMS_SQL.CLOSE_CURSOR(l_cursor);

Line 1596: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1592: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1593: --
1594: WHEN fnd_api.g_exc_unexpected_error THEN
1595: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1596: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1597: --
1598: WHEN OTHERS THEN
1599: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1600: --

Line 1599: DBMS_SQL.CLOSE_CURSOR(l_cursor);

1595: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1596: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1597: --
1598: WHEN OTHERS THEN
1599: DBMS_SQL.CLOSE_CURSOR(l_cursor);
1600: --
1601: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1602: --
1603: IF (fnd_msg_pub.check_msg_level