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

Line 1217: l_sql_p := DBMS_SQL.OPEN_CURSOR;

1213: 'and inventory_item_id = :b_item_id ' ||
1214: 'and CURRENT_organization_id = :b_org_id ' ;
1215: END IF;
1216:
1217: l_sql_p := DBMS_SQL.OPEN_CURSOR;
1218:
1219: DBMS_SQL.PARSE( l_sql_p, l_sel_stmt , DBMS_SQL.NATIVE );
1220:
1221:

Line 1219: DBMS_SQL.PARSE( l_sql_p, l_sel_stmt , DBMS_SQL.NATIVE );

1215: END IF;
1216:
1217: l_sql_p := DBMS_SQL.OPEN_CURSOR;
1218:
1219: DBMS_SQL.PARSE( l_sql_p, l_sel_stmt , DBMS_SQL.NATIVE );
1220:
1221:
1222: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_org_id', p_organization_id);
1223: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_item_id', p_inventory_item_id);

Line 1222: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_org_id', p_organization_id);

1218:
1219: DBMS_SQL.PARSE( l_sql_p, l_sel_stmt , DBMS_SQL.NATIVE );
1220:
1221:
1222: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_org_id', p_organization_id);
1223: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_item_id', p_inventory_item_id);
1224:
1225: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1226: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_lot_number', p_lot_serial_number);

Line 1223: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_item_id', p_inventory_item_id);

1219: DBMS_SQL.PARSE( l_sql_p, l_sel_stmt , DBMS_SQL.NATIVE );
1220:
1221:
1222: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_org_id', p_organization_id);
1223: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_item_id', p_inventory_item_id);
1224:
1225: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1226: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_lot_number', p_lot_serial_number);
1227: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN

Line 1226: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_lot_number', p_lot_serial_number);

1222: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_org_id', p_organization_id);
1223: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_item_id', p_inventory_item_id);
1224:
1225: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1226: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_lot_number', p_lot_serial_number);
1227: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN
1228: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_serial_number', p_lot_serial_number);
1229: END IF;
1230:

Line 1228: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_serial_number', p_lot_serial_number);

1224:
1225: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1226: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_lot_number', p_lot_serial_number);
1227: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN
1228: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_serial_number', p_lot_serial_number);
1229: END IF;
1230:
1231: l_colnum := 0;
1232: --dbms_output.put_line ('Count(): ' || l_column_attributes.count());

Line 1243: DBMS_SQL.DEFINE_COLUMN(l_sql_p, l_colnum, l_column_attributes(y).column_value,

1239: l_column_attributes(y).column_length := 10;
1240: ELSIF UPPER(l_column_attributes(y).column_type) = 'NUMBER' THEN
1241: l_column_attributes(y).column_length := 38;
1242: END IF;
1243: DBMS_SQL.DEFINE_COLUMN(l_sql_p, l_colnum, l_column_attributes(y).column_value,
1244: l_column_attributes(y).column_length);
1245:
1246: END LOOP;
1247:

Line 1248: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);

1244: l_column_attributes(y).column_length);
1245:
1246: END LOOP;
1247:
1248: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);
1249: IF (l_debug=1) THEN
1250: debug('l_rows_processes = ' || l_rows_processed, l_module_name, l_debug_level);
1251: END IF;
1252:

Line 1254: IF (DBMS_SQL.FETCH_ROWS(l_sql_p) > 0 ) THEN

1250: debug('l_rows_processes = ' || l_rows_processed, l_module_name, l_debug_level);
1251: END IF;
1252:
1253: LOOP
1254: IF (DBMS_SQL.FETCH_ROWS(l_sql_p) > 0 ) THEN
1255: l_colnum := 0;
1256: FOR y in 1..l_column_attributes.count() -1
1257: LOOP
1258: l_colnum := l_colnum + 1;

Line 1259: DBMS_SQL.COLUMN_VALUE(l_sql_p, l_colnum, l_column_attributes(y).column_value);

1255: l_colnum := 0;
1256: FOR y in 1..l_column_attributes.count() -1
1257: LOOP
1258: l_colnum := l_colnum + 1;
1259: DBMS_SQL.COLUMN_VALUE(l_sql_p, l_colnum, l_column_attributes(y).column_value);
1260: END LOOP;
1261: ELSE
1262: IF (l_debug=1) THEN
1263: debug('in the else part of dbms_sql.fetch_rows ' , l_module_name, l_debug_level);

Line 1263: debug('in the else part of dbms_sql.fetch_rows ' , l_module_name, l_debug_level);

1259: DBMS_SQL.COLUMN_VALUE(l_sql_p, l_colnum, l_column_attributes(y).column_value);
1260: END LOOP;
1261: ELSE
1262: IF (l_debug=1) THEN
1263: debug('in the else part of dbms_sql.fetch_rows ' , l_module_name, l_debug_level);
1264: END IF;
1265:
1266: --dbms_sql.close_cursor(l_sql_p);
1267: EXIT;

Line 1266: --dbms_sql.close_cursor(l_sql_p);

1262: IF (l_debug=1) THEN
1263: debug('in the else part of dbms_sql.fetch_rows ' , l_module_name, l_debug_level);
1264: END IF;
1265:
1266: --dbms_sql.close_cursor(l_sql_p);
1267: EXIT;
1268: /* we do'nt care, if no record is found */
1269: END IF;
1270: EXIT;

Line 1273: dbms_sql.close_cursor(l_sql_p);

1269: END IF;
1270: EXIT;
1271: END LOOP;
1272:
1273: dbms_sql.close_cursor(l_sql_p);
1274:
1275:
1276: IF(l_get_Default = FALSE) THEN
1277: FOR x in 1.. l_rec_index LOOP