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 1280: l_sql_p := DBMS_SQL.OPEN_CURSOR;

1276: 'and inventory_item_id = :b_item_id ' ||
1277: 'and CURRENT_organization_id = :b_org_id ' ;
1278: END IF;
1279:
1280: l_sql_p := DBMS_SQL.OPEN_CURSOR;
1281:
1282: DBMS_SQL.PARSE( l_sql_p, l_sel_stmt , DBMS_SQL.NATIVE );
1283:
1284: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_org_id', p_organization_id);

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

1278: END IF;
1279:
1280: l_sql_p := DBMS_SQL.OPEN_CURSOR;
1281:
1282: DBMS_SQL.PARSE( l_sql_p, l_sel_stmt , DBMS_SQL.NATIVE );
1283:
1284: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_org_id', p_organization_id);
1285: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_item_id', p_inventory_item_id);
1286:

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

1280: l_sql_p := DBMS_SQL.OPEN_CURSOR;
1281:
1282: DBMS_SQL.PARSE( l_sql_p, l_sel_stmt , DBMS_SQL.NATIVE );
1283:
1284: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_org_id', p_organization_id);
1285: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_item_id', p_inventory_item_id);
1286:
1287: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1288: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_lot_number', p_lot_serial_number);

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

1281:
1282: DBMS_SQL.PARSE( l_sql_p, l_sel_stmt , DBMS_SQL.NATIVE );
1283:
1284: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_org_id', p_organization_id);
1285: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_item_id', p_inventory_item_id);
1286:
1287: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1288: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_lot_number', p_lot_serial_number);
1289: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN

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

1284: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_org_id', p_organization_id);
1285: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_item_id', p_inventory_item_id);
1286:
1287: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1288: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_lot_number', p_lot_serial_number);
1289: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN
1290: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_serial_number', p_lot_serial_number);
1291: END IF;
1292:

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

1286:
1287: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1288: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_lot_number', p_lot_serial_number);
1289: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN
1290: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_serial_number', p_lot_serial_number);
1291: END IF;
1292:
1293: l_colnum := 0;
1294: --dbms_output.put_line ('Count(): ' || l_column_attributes.count());

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

1301: l_column_attributes(y).column_length := 10;
1302: ELSIF UPPER(l_column_attributes(y).column_type) = 'NUMBER' THEN
1303: l_column_attributes(y).column_length := 38;
1304: END IF;
1305: DBMS_SQL.DEFINE_COLUMN(l_sql_p, l_colnum, l_column_attributes(y).column_value,
1306: l_column_attributes(y).column_length);
1307: END LOOP;
1308:
1309: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);

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

1305: DBMS_SQL.DEFINE_COLUMN(l_sql_p, l_colnum, l_column_attributes(y).column_value,
1306: l_column_attributes(y).column_length);
1307: END LOOP;
1308:
1309: l_rows_processed := DBMS_SQL.EXECUTE(l_sql_p);
1310: IF (l_debug=1) THEN
1311: debug('l_rows_processes = ' || l_rows_processed, l_module_name, l_debug_level);
1312: END IF;
1313:

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

1312: END IF;
1313:
1314: --Unnecessary loop
1315: --LOOP
1316: IF (DBMS_SQL.FETCH_ROWS(l_sql_p) > 0 ) THEN
1317: l_colnum := 0;
1318: FOR y in 1..l_column_idx -1 --8232936
1319: LOOP
1320: l_colnum := l_colnum + 1;

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

1317: l_colnum := 0;
1318: FOR y in 1..l_column_idx -1 --8232936
1319: LOOP
1320: l_colnum := l_colnum + 1;
1321: DBMS_SQL.COLUMN_VALUE(l_sql_p, l_colnum, l_column_attributes(y).column_value);
1322: END LOOP;
1323: ELSE
1324: IF (l_debug=1) THEN
1325: debug('in the else part of dbms_sql.fetch_rows ' , l_module_name, l_debug_level);

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

1321: DBMS_SQL.COLUMN_VALUE(l_sql_p, l_colnum, l_column_attributes(y).column_value);
1322: END LOOP;
1323: ELSE
1324: IF (l_debug=1) THEN
1325: debug('in the else part of dbms_sql.fetch_rows ' , l_module_name, l_debug_level);
1326: END IF;
1327: --dbms_sql.close_cursor(l_sql_p);
1328: --EXIT;
1329: /* we do'nt care, if no record is found */

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

1323: ELSE
1324: IF (l_debug=1) THEN
1325: debug('in the else part of dbms_sql.fetch_rows ' , l_module_name, l_debug_level);
1326: END IF;
1327: --dbms_sql.close_cursor(l_sql_p);
1328: --EXIT;
1329: /* we do'nt care, if no record is found */
1330: END IF;
1331: --EXIT;

Line 1334: dbms_sql.close_cursor(l_sql_p);

1330: END IF;
1331: --EXIT;
1332: --END LOOP;
1333:
1334: dbms_sql.close_cursor(l_sql_p);
1335:
1336: END IF; -- IF l_rec_index > 0 THEN
1337:
1338: -- Bug 8315483 commented if l_get_default condition

Line 2188: l_cursor_handle := dbms_sql.open_cursor;

2184: ' WHERE organization_id = :org_id ' ||
2185: ' AND inventory_item_id = :item_id ' ||
2186: ' AND lot_number = :lot ' || l_where_clause;
2187:
2188: l_cursor_handle := dbms_sql.open_cursor;
2189: dbms_sql.parse(l_cursor_handle, l_where_clause, dbms_sql.native);
2190: dbms_sql.bind_variable(l_cursor_handle, ':org_id', p_organization_id);
2191: dbms_sql.bind_variable(l_cursor_handle, ':item_id', p_inventory_item_id);
2192: dbms_sql.bind_variable(l_cursor_handle, ':lot', p_lot_number);

Line 2189: dbms_sql.parse(l_cursor_handle, l_where_clause, dbms_sql.native);

2185: ' AND inventory_item_id = :item_id ' ||
2186: ' AND lot_number = :lot ' || l_where_clause;
2187:
2188: l_cursor_handle := dbms_sql.open_cursor;
2189: dbms_sql.parse(l_cursor_handle, l_where_clause, dbms_sql.native);
2190: dbms_sql.bind_variable(l_cursor_handle, ':org_id', p_organization_id);
2191: dbms_sql.bind_variable(l_cursor_handle, ':item_id', p_inventory_item_id);
2192: dbms_sql.bind_variable(l_cursor_handle, ':lot', p_lot_number);
2193:

Line 2190: dbms_sql.bind_variable(l_cursor_handle, ':org_id', p_organization_id);

2186: ' AND lot_number = :lot ' || l_where_clause;
2187:
2188: l_cursor_handle := dbms_sql.open_cursor;
2189: dbms_sql.parse(l_cursor_handle, l_where_clause, dbms_sql.native);
2190: dbms_sql.bind_variable(l_cursor_handle, ':org_id', p_organization_id);
2191: dbms_sql.bind_variable(l_cursor_handle, ':item_id', p_inventory_item_id);
2192: dbms_sql.bind_variable(l_cursor_handle, ':lot', p_lot_number);
2193:
2194: l_rows_affected := dbms_sql.execute(l_cursor_handle);

Line 2191: dbms_sql.bind_variable(l_cursor_handle, ':item_id', p_inventory_item_id);

2187:
2188: l_cursor_handle := dbms_sql.open_cursor;
2189: dbms_sql.parse(l_cursor_handle, l_where_clause, dbms_sql.native);
2190: dbms_sql.bind_variable(l_cursor_handle, ':org_id', p_organization_id);
2191: dbms_sql.bind_variable(l_cursor_handle, ':item_id', p_inventory_item_id);
2192: dbms_sql.bind_variable(l_cursor_handle, ':lot', p_lot_number);
2193:
2194: l_rows_affected := dbms_sql.execute(l_cursor_handle);
2195:

Line 2192: dbms_sql.bind_variable(l_cursor_handle, ':lot', p_lot_number);

2188: l_cursor_handle := dbms_sql.open_cursor;
2189: dbms_sql.parse(l_cursor_handle, l_where_clause, dbms_sql.native);
2190: dbms_sql.bind_variable(l_cursor_handle, ':org_id', p_organization_id);
2191: dbms_sql.bind_variable(l_cursor_handle, ':item_id', p_inventory_item_id);
2192: dbms_sql.bind_variable(l_cursor_handle, ':lot', p_lot_number);
2193:
2194: l_rows_affected := dbms_sql.execute(l_cursor_handle);
2195:
2196: IF dbms_sql.fetch_rows(l_cursor_handle) <= 0 then

Line 2194: l_rows_affected := dbms_sql.execute(l_cursor_handle);

2190: dbms_sql.bind_variable(l_cursor_handle, ':org_id', p_organization_id);
2191: dbms_sql.bind_variable(l_cursor_handle, ':item_id', p_inventory_item_id);
2192: dbms_sql.bind_variable(l_cursor_handle, ':lot', p_lot_number);
2193:
2194: l_rows_affected := dbms_sql.execute(l_cursor_handle);
2195:
2196: IF dbms_sql.fetch_rows(l_cursor_handle) <= 0 then
2197: l_lot_att_required := TRUE;
2198: END IF;

Line 2196: IF dbms_sql.fetch_rows(l_cursor_handle) <= 0 then

2192: dbms_sql.bind_variable(l_cursor_handle, ':lot', p_lot_number);
2193:
2194: l_rows_affected := dbms_sql.execute(l_cursor_handle);
2195:
2196: IF dbms_sql.fetch_rows(l_cursor_handle) <= 0 then
2197: l_lot_att_required := TRUE;
2198: END IF;
2199:
2200: END IF;