DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 4243: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;

4239: l_primary_uom_code VARCHAR2(3);
4240: l_primary_qty NUMBER;
4241: l_uom_conv_ratio NUMBER;
4242: l_serial_number VARCHAR2(30);
4243: l_msnt_rec mtl_serial_numbers_temp%ROWTYPE;
4244: l_serial_number_count NUMBER;
4245: l_label_status VARCHAR2(500);
4246: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4247:

Line 4475: INSERT INTO mtl_serial_numbers_temp

4471:
4472: CLOSE l_curs_serial_number;
4473: l_progress := '47';
4474: FORALL i IN 1 .. l_msnt_transaction_temp_id.COUNT
4475: INSERT INTO mtl_serial_numbers_temp
4476: (
4477: transaction_temp_id
4478: , last_update_date
4479: , last_updated_by